![]() ![]() My month headers are in the first column, column A, and my column headers are in row four. ![]() This workbook contains a single worksheet and in it I have monthly revenue data for eight calendar years. My sample file is the Freeze workbook and you can find it in the Chapter04 folder of your Exercise Files collection. But what do you do if you need to use data in two different parts of the worksheet at the same time? Or what do you do if you have a data list and you want to keep the headers on the screen regardless of how far you scroll? In this movie, I will show you how to handle those situations by splitting the worksheet into separate units and freezing columns and rows. Excel worksheets can contain a lot of data.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |