Excel For Mac 2011



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).

Cells, rows, and columns in Excel 2011 for Mac work just like a table in Word or PowerPoint, but have many more capabilities. Adding rows and columns is almost as easy as pressing a button: Inserting a cell: Select a cell (or multiple cells) and then choose Insert→Cells from the menu bar. This hands-on Microsoft Excel 2011 For Mac course shows you how to effectively use the many features and functions of MS Excel. You will learn to leverage the power of the most important features Excel 2011 has to offer the Apple user, whether you're working in an all-Mac office or needing to coordinate with PC counterparts.

See solution in other versions of Excel:

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?

Excel For Mac 2011

Answer: If you need to see the column headings even after scrolling, you could try freezing the top row in Excel.

NOTE: Freezing panes only works when you are in Normal View.

Excel For Mac 2011 Data Analysis

File browser android for mac. 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.

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:

Excel For Mac 2011 Recover Unsaved File

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 Freeze Top Row

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.

Excel For Mac 2011 Update

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.

Now when you return to your pivot table, it should display information from the new data source.