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...
-
15:16
NC Dirt Hunter
1 hour agoA good day Metal Detecting Civil War relics on an OLD plantation. #history #civilwar
5722 -
9:45
Dr. Nick Zyrowski
10 hours agoHow To Do One Meal A Day Diet - This Is How I Eat
5821 -
10:05
Hannah Barron
15 hours agoCan't Cook? No Problem...Southern Banana Pudding!
2.94K13 -
10:05
Tactical Advisor
17 hours agoNew PSA Sabre Pistol 308! (FIRST LOOK)
1.01K -
4:35
SeasonofMist
3 days agoGREEN CARNATION - Time in a Bottle (Jim Croce cover)
343 -
4:02:27
SNEAKO
10 hours agoSNEAKO X ADIN HALLOWEEN STREAM!
63.9K17 -
4:43:52
Akademiks
11 hours agoCharleston White got SH*T in Chiraq?? Drake and Metro went to 21 Savage party? Kendrick Promoting?
152K7 -
38:52
Stephen Gardner
2 days ago🔴Global Agenda EXPOSED: Trump & RFK Jr. Reveal the Real 2024 Threat!
168K367 -
3:02:54
vivafrei
22 hours agoEp. 233: DoD to Use LETHAL Force? Bannon Denied First Step Act? Kamala Insults Christians & MORE!
203K314 -
1:33:38
Josh Pate's College Football Show
13 hours ago $31.39 earnedWeek 8 Reaction Show: UGA Stuffs Texas | Tennessee Beats Alabama | USC Is Done | Chaos Season Here
73.5K8