3 Time Saving Shorts in Excel | Freeze Header | Add Border | Move Columns
In this video i will show you 3 magical shortcuts in excel which helps you in your daily life.
Freeze Top Row: Freezes the top row only. Using Keyboard Shortcuts
Alt + W + F + R: Freezes the top row.
Alt + W + F + C: Freezes the first column.
Alt + W + F + F: Freezes both the top row and the first column.
Alt + W + F + R: Freezes the top row.
Alt + W + F + C: Freezes the first column.
Alt + W + F + F: Freezes both the top row and the first column.
Keyboard shortcuts in Excel to add borders to your cells:
Outline Border (All Sides) : Alt + H + B + A
Here are shortcuts for adding borders to individual sides:
Top Border: Alt + H + B + P
Bottom Border: Alt + H + B + O
Left Border: Alt + H + B + L
Right Border: Alt + H + B + R