MS EXCEL TUTORIAL: HOW TO FREEZE MULTIPLE ROWS AND COLUMNS
1 year ago
36
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...
-
2:14
Howard Lutnick
2 hours agoLaunching the FMX Futures Exchange
16.1K1 -
LIVE
WeAreChange
2 hours agoUS Sends Troops To Middle East As Region On Brink Of ALL-OUT War
2,377 watching -
46:37
Kimberly Guilfoyle
6 hours agoOne Kama-Lie After Another, Interviews with Betty Cardenas & Phil Kerpen | Ep. 160
30K29 -
1:22:35
Redacted News
4 hours agoHigh Alert! Israel Readies FULL SCALE Invasion of Lebanon, Putin Warns Use of Nukes | Redacted
92.1K192 -
51:01
Candace Show Podcast
3 hours agoLeBron James Is TOO Quiet About Diddy | Candace Ep 70
77.6K198 -
LIVE
Akademiks
2 hours agoYo Gotti Brother put a 100K hit on Young Dolph. 1 Shooter is SNTICHING on Everything! Diddy Update
4,655 watching -
1:20:30
Lee Camp
5 hours agoLIVE: Israel Collapse Coming / Wage Theft Shocking / Former CIA Head Admits Truth
36.5K -
20:49
Freakin' Reviews
1 day agoTesting and Ranking 5 Gadgets Under $20!
25.7K4 -
7:48
Fore Play Golf
1 day agoWill the PGA Tour-PIF Deal EVER Happen?
38.6K7 -
28:04
The Black and Jewish Podcast with Ashira Solomon
2 months agoEp. 1: Black People and Jewish People
41.6K33