If you look at the first screenshot in this lesson, you'll see that the first row doesn't actually contain the headings for the sales data table - it contains the title of this worksheet. Things get slightly more complicated if you want to freeze more than one row or column. In the Mac version of Excel the options are the same, but you don't get the explanations of each option that you see here: The screenshot below is from Excel 2010 for Windows. If you wanted to freeze the first column, you would then go back and choose that option. When you click the Freeze Panes button, you can choose Freeze Top Row from the expanded Freeze Panes options. To freeze just one row, click the View menu, and find the Freeze Panes button (if you're using Excel 2011 for Mac, click the Layout menu to find the Freeze Panes button) Note that these steps also apply to freezing columns: You have two options for freezing panes in Excel. The proces for doing this is slightly different between Excel 2010 for Windows and Excel 2011 for Mac, so I've covered both here:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |