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...
-
1:11:38
TheMonicaCrowleyPodcast
15 hours agoThe Monica Crowley Podcast: Obama’s Grip Slips
2.66K6 -
31:38
Science & Futurism with Isaac Arthur
22 hours ago $0.03 earnedSelf-Repairing Machines
1.4K2 -
44:07
Degenerate Jay
1 day ago $0.03 earnedHugh Jackman's Wolverine Made Me A Better Person
4983 -
19:31
GameLeap RAID Shadow Legends
17 hours ago#1 BEST RARE Champion EVERY FACTION (Build for Faction Wars) - Raid: Shadow Legends Guide
11 -
1:21:48
Fresh and Fit
8 hours agoCastle Club Q&A Panel With Destiny & Andrew Wilson
56.5K84 -
2:23:11
Laura Loomer
11 hours agoEP62: HAMAS FOR HARRIS: Democrats Destroy D.C. Monuments as DNC Crowns Kamala
79.1K150 -
1:11:51
The Charlie Kirk Show
11 hours agoTHOUGHTCRIME Ep. 52 — How Do You Say Kamala? What’s Wrong With DEI? Did the Race Just Reset?
137K103 -
1:33:01
Kim Iversen
13 hours agoBiden’s Not Dead (Or Is He?), Trump Wasn't Shot? AIPAC Isn't Foreign?
109K264 -
2:05:16
Glenn Greenwald
14 hours agoWhat Really Happened To Joe?; Kamala's Revealing Personnel Choices with Moe Tkacik; Interview with The Young Turks' Cenk Uygur | SYSTEM UPDATE #304
131K221 -
1:42:08
Roseanne Barr
15 hours agoDid they kill Biden's clone? | The Roseanne Barr Podcast #58
135K332