How to freeze header in excel 2011 mac

You can freeze as many as you want, as long as you always start with the top row and the first column. 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? On the View tab, click Unfreeze Panes. Expand your Office skills. Get new features first.

Questions and answers

Was this information helpful? Yes No.

Any other feedback? How can we improve it?

1. How to print row and column headers of Excel spreadsheets on every page!
2. Helpful answers.
3. Search form;
4. Question Info.
5. You are here.
6. Freeze or lock rows and columns in an Excel worksheet. Learn Microsoft Excel | Five Minute Lessons.
7. Can't Freeze Rows In Excel For Mac - Microsoft Community.

Can we be less bossy in marking such questions which add value and mind our own business? Some people here are very fussy and dogmatic about what is off topic.

• the way sharebeast mac miller;
• your mac lacks quartz extreme acceleration which is required for video output.
• google chrome portable mac os.
• easeus mac photo recovery free 5.5.1.
• minecraft full version free with multiplayer mac.
• Space Details.

I think this is a very useful question. Kyle Kyle 7, 9 37 I thought that it was only for one or the other, thanks: Why is this so non-intuitive?



This is one instance where Google sheets has a much better method. Thanks for that.

How to Control Auto Formatting in Excel - ITS Knowledge Base - Bethel Confluence

It's been 8 years since MS changed many features and added "ribbons" to Office and I still cannot get used to them. This doesn't work on Office for Mac, it only freezes Column A Fallback is to use splits. I always gave up freezing both row and column thinking it's just either side Linked 0. Related Hot Network Questions.