MS EXCEL TUTORIAL: HOW TO FREEZE MULTIPLE ROWS AND COLUMNS
1 year ago
53
When you are working on a large set of data, and you want to retain the top row header, or the left column header when you scroll down or to the right, freeze panes function is the answer.
You can keep an area of a worksheet visible while you scroll to another area by using the Freeze Panes Excel function under the View tab. With this, you can lock specific rows and columns in place. Just go to the cell below the rows and to the right of the columns you want to keep visible when you scroll and click Freeze Panes.
This video also includes a keyboard shortcut for you to be able to do it swiftly.
Title: How to Freeze Multiple Rows and Columns
#freezepanes #freezemultiplerows #freezemultiplecolumns #keyboardshortcut #exceltip
Loading comments...
-
1:56
Excel Plus Studio
1 year agoMS EXCEL TUTORIAL: HOW TO FREEZE MULTIPLE ROWS AND COLUMNS
36 -
0:58
DansTechSolutions
1 year agoFix Column Widths and Row Heights FAST in Excel!
-
2:42
Code Boxx
7 months ago4 Ways To Freeze Rows & Columns Of HTML Tables
6 -
1:15
Excel Plus Studio
1 year agoMS EXCEL TUTORIAL: HOW TO NAVIGATE THE WORKSHEET QUICKLY
20 -
1:49
Nerdalific
3 years agoExcel: How to Insert, Delete or Move columns and rows in Excel / Tutorial
1 -
1:58
Mark's Excel Tips
1 year agoHow To Lock Specific Cells In Excel
5 -
4:49
Nursnicky
1 year agoWhat these Excel Controllers do.....For Beginners
1 -
0:49
Excel Plus Studio
1 year agoEXCEL AUTO-FIT: THE FASTEST WAY TO ADJUST ROWS AND COLUMNS
6 -
1:43
Excel Plus Studio
1 year agoTEXT TO COLUMNS EXCEL FUNCTION - THE ULTIMATE GUIDE
12 -
0:23
Mighty Excel
3 years agoBasic Excel Tips Trick (Select Non Adjacent Cell) Part 3 #Excel #Learn
59