![]() The worksheet contains daily data that reports the sales for each person in your sales team, broken down by products sold: This example actually has 85 rows of data the table carries on down further than this screenshot shows: Once you scroll down, however, the heading row disappears off the top of the screen, and you can no longer be sure what each column contains: This is a simple example, but it's not hard to imagine that with a lot more columns and rows, the problem would get considerably more complex, To solve the problem, you can freeze or lock the heading rows so that they don't disappear off the top of the screen as you scroll down the worksheet. Why you might need to freeze rows or columns in your spreadsheet Imagine you have a spreadsheet that contains sales data for January. Freeze or lock rows and columns in an Excel worksheet. Freeze or lock rows and columns in an Excel worksheet
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |