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 DigMinecraft
Share this page:

MS Excel: Freeze panes to see first row and first column in Excel 2010

See solution in other versions of Excel:

Question: In Microsoft Excel 2010, I have a spreadsheet with column headings. I need to freeze the first row and also freeze the first column. That way, I can see the first row and first column at all times. How can I do this?

Answer: If you need to see the first column (column A) and first row (row 1) even after scrolling, you could try freezing the pane in Excel. To do this, open your Excel spreadsheet.

Select cell B2. Then select the View tab from the toolbar at the top of the screen and click on the Freeze Panes button in the Windows group. Then click on the Freeze Panes option in the popup menu.

Microsoft Excel

Now when you scroll, you should still continue to see the row 1 and column A.

Microsoft Excel