When you need to apply a small tweak to the document, it must not require much time to Lock up columns release. This sort of simple activity does not have to require extra training or running through manuals to understand it. With the right document modifying instrument, you will not spend more time than is needed for such a quick edit. Use DocHub to simplify your modifying process regardless if you are a skilled user or if it is the first time making use of an online editor service. This instrument will take minutes to learn how to Lock up columns release. The sole thing needed to get more effective with editing is a DocHub account.
A simple document editor like DocHub can help you optimize the time you need to dedicate to document modifying no matter your previous experience with this kind of instruments. Create an account now and boost your efficiency immediately with DocHub!
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 lets 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 the first column it will only freeze the a column and nothing else so for this what we will have to use is a custom option how to use this you place your cursor let me highlight t