How to freeze columns in excel 2011 mac

In the screen shown in your example, B4 would be the cell to click on first.

Can't Freeze Rows In Excel For Mac 2011

Thanks, Billy. Your instructions are very clear and accurate. Thanks for your service to the computer-user world that we all co-habitat! Awesome post! But what impressed me the most was your bio: Broken vessel.

Why Can't I Freeze Panes in Excel for Mac? (2011)

I have Excel for Mac. Do i need an upgrade?


  • How to Freeze Panes in Excel for Mac.
  • interior design tools for mac free!
  • IT Services;
  • Freeze First Column and Row in Excel?
  • All replies;

Thank you! This has been annoying me for days! This not working for me. Grab the bar on the far right side and drag down Step 2: Drag until the top bar to below the cells you want frozen at the top Step 3: Grab the bar on the bottom right and drag to the right.

Freeze the top row

Share this: Thanks, Janice! To freeze multiple rows starting with row 1 , select the row below the last row you want frozen and click Freeze Panes. To freeze multiple columns, select the column to the right of the last column you want frozen and click Freeze Panes.

Say you want to freeze the top four rows and leftmost three columns. You'd select cell D5, and then on the View tab, click Freeze Panes. Any time you freeze rows and columns, the border below the last frozen row and to the right of the last frozen column appears a little thicker here, below row 4 and to the right of column C.

Want to unfreeze a row, column, or both?

Freeze First Column and Row in Excel

On the View tab, click Unfreeze Panes. Expand your Office skills. Get new features first. Was this information helpful? Yes No.

MS Excel for Mac: Freeze first row and first column

Any other feedback? How can we improve it?

Send No thanks.