This is usually very useful when data values are to be compared with the rest of them as you can free certain rows and navigate to a particular row situated too much below and ease.įreezing of rows in Excel is thus done to keep certain rows visible while everything else on the worksheet scrolls. To do this we are left with the alternative of freezing the row that we want to keep visible at all times during scrolling activity. IF we needed to view the rest of the data we would have to scroll down the worksheet using the vertical scroll bars at the sides of the excel document.ĭoing this scrolls all the content from the first row to the rows that we intend to arrive at.įor example we might wish to have the top most rows to have headers of different columns and restrict these column headers from scrolling for better visualization of data. Each worksheet can contain too much data that even flows beyond on page.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |