tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities
Share this page:

MS Excel: Freeze panes in Excel 2011 for Mac

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. How can I do this?

Answer: If you need to see the column headings even after scrolling, you could try freezing the top row in Excel. To do this, 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.

Microsoft Excel

Now when you scroll down, you should still continue to see the column headings.

Microsoft Excel