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...
-
LIVE
Donald Trump Jr.
6 hours agoInside the Pentagon’s Hunt for UFOs, Plus Why Woke is Going Broke,Interviews with Michael Seifert & Lue Elizondo | TRIGGERED Ep.176
6,092 watching -
LIVE
The Jimmy Dore Show
50 minutes agoIsraeli News Program Says Netanyahu Tanked Hostage Deal! 741 Deep State Reps Endorse Kamala!
9,094 watching -
2:14
Howard Lutnick
2 hours agoLaunching the FMX Futures Exchange
16.1K1 -
LIVE
WeAreChange
1 hour agoUS Sends Troops To Middle East As Region On Brink Of ALL-OUT War
1,937 watching -
46:37
Kimberly Guilfoyle
5 hours agoOne Kama-Lie After Another, Interviews with Betty Cardenas & Phil Kerpen | Ep. 160
30K26 -
1:22:35
Redacted News
3 hours agoHigh Alert! Israel Readies FULL SCALE Invasion of Lebanon, Putin Warns Use of Nukes | Redacted
67.6K166 -
51:01
Candace Show Podcast
3 hours agoLeBron James Is TOO Quiet About Diddy | Candace Ep 70
77.6K168 -
LIVE
Akademiks
2 hours agoYo Gotti Brother put a 100K hit on Young Dolph. 1 Shooter is SNTICHING on Everything! Diddy Update
4,204 watching -
1:20:30
Lee Camp
5 hours agoLIVE: Israel Collapse Coming / Wage Theft Shocking / Former CIA Head Admits Truth
21.1K -
20:49
Freakin' Reviews
1 day agoTesting and Ranking 5 Gadgets Under $20!
25.7K4