When you are interested in viewing the sales in February, move the columns near the first column where the products are listed. When you move the spreadsheet across columns, the first column is hidden. Now scroll, and you will find that the row header remains constant, and you can see what each cell relates to. Go to View, and in the Window group, select Freeze Panes, and then select, Freeze Top Row. This is where freezing the row comes in handy. You need to scroll up to the row header to understand that it is the sales figure for the product Computer Case in February. When you look at a value, say $125, you may not understand what that is and the parameter it is referring to. When you is scroll down, the row header is hidden, and only the values are visible. In the example above, the spreadsheet has the columns Product, Branch, Salesperson, and Sales. Select the option View → Freeze Panes → Freeze Top Row to freeze the top row, and the option View → Freeze Panes → Freeze First Column to freeze the first column. The column or row you need remains on the screen. The Excel Freeze Panes option means you can keep one section readable at all times. You can lock the first row and the first column so that the headers remain, which makes data readable. To improve readability, you need to keep an area of a worksheet visible while you scroll or move the worksheet left or right. When you scroll down or move sideways, the row header and the first column are hidden, sometimes making it difficult to view the data you need. An Excel spreadsheet has data that extends to many rows and columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |