If you want to apply a small tweak to the document, it must not take long to Lock up columns resolution. This type of simple activity does not have to require additional training or running through guides to learn it. Using the appropriate document modifying tool, you will not take more time than is necessary for such a quick edit. Use DocHub to simplify your modifying process whether you are an experienced user or if it is your first time using a web-based editor service. This tool will require minutes to figure out how to Lock up columns resolution. The sole thing required to get more productive with editing is a DocHub account.
A simple document editor like DocHub can help you optimize the amount of time you need to devote to document modifying no matter your prior knowledge about this kind of resources. Make an account now and improve your productivity instantly 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