3 Time Saving Shorts in Excel | Freeze Header | Add Border | Move Columns #exceltips #exceltech

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

Видео 3 Time Saving Shorts in Excel | Freeze Header | Add Border | Move Columns #exceltips #exceltech канала Engineering Facts Official