Editing xls is fast and straightforward using DocHub. Skip installing software to your PC and make changes using our drag and drop document editor in a few fast steps. DocHub is more than just a PDF editor. Users praise it for its ease of use and robust features that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and send records for completion to other people. All of this, combined with a competitive cost, makes DocHub the ideal decision to bind typesetting in xls files with ease.
Make your next tasks even easier by converting your documents into reusable templates. Don't worry about the security of your data, as we securely keep them in the DocHub cloud.
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 letamp;#39;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 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 high