You want to print the same column headings for each of the pages. Let’s say you have a big excel file where the excel file contains more than 1 page. How to lock certain cells in excel 2010 how to#Read More: How to Multiply Columns, Cells, Rows, & Numbers in Excel Print frozen panes Note: Unfreeze span will unfreeze all the freezing of the excel sheet. If you want to freeze the top row only, click on the Freeze Spans under the View option at the top.If you want to freeze the first column only, click on the Freeze Spans under the View option at the top.If you want to unfreeze it just go to the view option again and under the Freeze Spans click on the Unfreeze Spans.After scrolling the excel sheet you will see only the headings of your columns will remain in the same position. On the View option at the top click on the Freeze Spans.We select A4 The freezing will happen in the upper and lower side of the A4 cell.Just click any cells in row 4 as your headings are in row 3.Let’s say you want to freeze your data so that it will show only the column’s heading.How to freeze rows and columns in excelįreezing is not a lock option but when there is big data that you are analyzing and you want to work in a specific location of your excel file freezing the data is an effective way of doing that. How to lock certain cells in excel 2010 code#Note: Unlocking the cells after applying the VBA code follows the same unlocking method explained earlier.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |