how to freeze title rows in excel for mac

Required fields are marked Comment Name Email This site uses Akismet to reduce spam.

This can be handy for header sections so that you can see your headers no matter where you scroll to in the spreadsheet.

Freezing a Row Select the row below the row you want to freeze.

To select a row, you need to select the entire row on the left side.

With the row selected, click on the View tab at the top, select Freeze Panes and youll see several different options you can choose: Freeze Panes will freeze all rows above your selected row.

Freeze Top Row will freeze only the top row no matter what row you currently have selected.

Note: If you dont see the Freeze Panes option, it might be because you already have panes frozen.

Freezing a Column To freeze a column, or a set of columns, you need to select the column to the right of the column(s) you want to freeze.

With the column selected, click on the View tab at the top, select Freeze Panes and youll see several different options you can choose: Freeze Panes will freeze all columns to the left of your selected column.

Freeze First Column will freeze only the left most column no matter what column you currently have selected.

For example, if you wanted to freeze column A and row 1, you would select cell B2 since its below and to the right of these columns and rows.

With the proper cell selected, select the View tab at the top and click on the Freeze Panes button, and select the Freeze Panes option in the drop-down.

Unfreeze Panes To unfreeze your panes at any time, just click on the View tab and click the Freeze Panes button, then select Unfreeze Panes.

You Might Also Like Excel 2016: Unhide Rows or Columns Hide and Unhide Rows and Columns in Google Sheets How to Erase Multiple Excel Rows Simultaneously Word 2016 2013: Divide Page Into Columns How to Add a PDF to Excel Excel: Add Watermark Excel: Shade Every Other Row Excel: Make Header Row Filed Under: Office Tagged With: Excel 2016, Excel 2019, Office 365 Reader Interactions Comments Alison M says August 29, 2020 at 10:45 am Did not help; sorry.

In a large spreadsheet, the row you wish to place at the top (i.e.

For example, you want to collapse previous years figures and have the current year start at the top.

But you still want to be able to page or scroll up into last year if you need to.

That is what I need help with, yet no-one seems to consider the possibility.

One used to be able to do with with Excel 2003 and Im assuming its still possible, somehow.

SLM says November 8, 2019 at 12:09 pm Excellent, thank you for this tip on freezing BOTH row column R says December 6, 2018 at 4:27 pm I am having the same problem I type and Excel just Freezes the Cells so nothing can be entered and then under the view there is no unfreeze button P8Ss Poor Software.

William Marchesani says November 17, 2018 at 2:55 pm Absolutely NOT.

I should have never used a computer like device to track my workout.

Did this help Let us know Cancel reply Your email address will not be published.

How To Freeze Title Rows In Excel For Mac