unlock

How to Freeze Multiple Rows and or Columns in Excel using Freeze Panes

0:00
↔️ ↕️

Timecodes:

hi welcome to Excel tosh.com today we

are going to learn how to use free spins

wherein you can freeze your required

number of columns and rows and not just

the first row and first column so let's

say we have this data set of sales but

if you observe the first row has total

total of quantity and total of the total

sales and the data starts from the third

row what is most important about any

record is the order number and the order

date so the objective is whenever you

scroll down you want your headers to be

seen which are marked in red and

whenever if you scroll to the right side

you want the first two columns to always

be seen in the freeze panes option if

you use the second option which is free

stop row it will always freeze only the

first row and it will not freeze the

headers let P unfreeze it if I freeze


Related queries:


how to unlock filter in excel 2010
how to open filter in excel
how to get filter in excel
how to unprotect filter in excel
how to get filter in excel using keyboard
how to unlock filter option in excel
how to unlock data filter in excel
how to unlock filter mode in excel
how to unlock locked filter in excel