This Excel tutorial explains how to freeze panes to keep the top row visible when scrolling in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Office 2011 for Mac is full of useful features, including the autorecovery tool in Excel. Although crashes in Excel for Mac 2011 are extremely rare, it doesn’t hurt to make sure Excel 2011 is backing up your changes as you work. Voiceover Hi, I'm Dennis Taylor and I'm happy to present Excel 2011 for the Mac: Mastering Formulas and Functions. For many Excel users, the central focus of what they do is writing formulas and functions. If you really want to take advantage of Excel's power, you need exposure to its many functions. I'll start off by showing you some great shortcuts for building formulas and functions.
Question: In Microsoft Excel 2011 for Mac, I have a spreadsheet with column headings. I need a way to scroll down the rows, but still see the column headings that are contained in the top row. How can I do this?
Question: In Microsoft Excel 2011 for Mac, I've created a pivot table and now I need to change the data source. How do I change the data source for an existing pivot table? Answer: Click somewhere in the pivot table and the PivotTable tab should appear in the toolbar at the top of the screen. Select the PivotTable tab, click on the Options button and select Change Source from the popup menu. Easily generate barcodes in Microsoft Excel for Mac 2004 or 2011 with this add-in. The add-in changes the selected data to a barcode when applied. In Excel, the add-in dynamically converts selected.
Answer: If you need to see the column headings even after scrolling, you could try freezing the top row in Excel.
To freeze the top row, open your Excel spreadsheet.
Select the Layout tab from the toolbar at the top of the screen. Click on the Freeze Panes button and click on the Freeze Top Row option in the popup menu.
Now when you scroll down, you should still continue to see the column headings.
Excel For Mac 2011 Freeze Top Row
Excel 2011 Download
This Excel tutorial explains how to change the data source for a pivot table in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: In Microsoft Excel 2011 for Mac, I've created a pivot table and now I need to change the data source. How do I change the data source for an existing pivot table?
Excel For Mac 2011
Answer:Click somewhere in the pivot table and the PivotTable tab should appear in the toolbar at the top of the screen. Select the PivotTable tab, click on the Options button and select Change Source from the popup menu.
When the Change PivotTable Data Source window appears, change the Location value to reflect the new data source for your pivot table. Click on the OK button.
Excel For Mac 2011 Update
Now when you return to your pivot table, it should display information from the new data source.