Easy Excel 🔰 automatic borders

← Easy Excel time saving technique (@ oharu _ work)

Thank you for watching 😊

🎙️ Sound Ali Recommended

[Time saving] Don't draw borders manually anymore!

Magic that automatically completes the 🧙‍♀️

Write a border, Hit a number... That work.

Would you like to end it today?

By using "conditional formatting,"

You can make an automated sheet where a border appears at the moment of input!

💡 Video Supplement

In the video, settings are added from "Continuation of already entered table (line 11)."

If you want to set your own table, just remember the following rules!

① Select all below from the "first row" where you want to add data from now on

② Match the number in the formula to the number of the "first line"

(Example: If you want to set from line 6, change to = $B6 < > "")

⚠️.

Please be sure to enter the symbol (< > "") in the formula with [half-width]. If it is full-width, an error will occur.

🚀 "Table function" also automatically borders

Windows: Ctrl + T

Mac: Command + T

Save it and try using it tomorrow 🙌

* It may not work depending on the version or specification

Next time, we will make your daily life easier.

i will deliver it, so please save it and look back

*********************************************

Make some free time /

Mac 17 years | Windows 3 years

We are sending the struggle story of Excel de beginner 🔰.

Please like and follow me if you like

▶️ _ work

Please feel free to DM and comment

********************************************* "

Excel Time Shortening Easy Excel Excel beginner # excel _ time