If you freeze the header row in "Normal" view and then try to switch to "Page Layout" view a warning pops up saying that you will lose the freeze. Hi, thanks a lot for the detailed steps! I can confirm these steps will work in Excel for Mac I know how disheartening it is when someone reads something useful on a website or blog and then just leaves. So I thought I would take a quick moment and leave a comment letting you know that this is just what I needed to help me with my Excel spreadsheet.
Thanks so much for taking the time to post this and share with the internet!
Many Thanks! I've looked for this solution a lot of time! More Info Search for a lesson. Similar lessons Scale your Excel spreadsheet to fit your screen.
Print header rows at the top of every page in Excel for Mac. Print an Excel spreadsheet with header rows at the top of every page. Scale your spreadsheet to fit on one page when printing from Excel. Join our mailing list Get smarter in just five minutes! Join our mailing list it's free! I want to learn more about: Microsoft Excel. Microsoft Word. Google Analytics.
Google Adwords. Facebook Marketing.
I have a spreadsheet on which I want to do the following: if I enter a number in a cell in Col A I want the adjacent cell in Col B to return a date which is today plus 21 days. The email address entered is already associated to an account. So same date just for last year? For instance, you may want to scroll through your worksheet while keeping headings visible, or you may want to look at how totals at the end change as you enter new variables at the top of the spreadsheet. If you enter this function in a cell, the cell will always display the current date. Notebooks Speciality level out of ten: 0. Loading page content.
Skip to main content. Search form Search. Freeze or lock rows and columns in an Excel worksheet. Why you might need to freeze rows or columns in your spreadsheet Imagine you have a spreadsheet that contains sales data for January. The worksheet contains daily data that reports the sales for each person in your sales team, broken down by products sold: This example actually has 85 rows of data the table carries on down further than this screenshot shows : Once you scroll down, however, the heading row disappears off the top of the screen, and you can no longer be sure what each column contains: This is a simple example, but it's not hard to imagine that with a lot more columns and rows, the problem would get considerably more complex, To solve the problem, you can freeze or lock the heading rows so that they don't disappear off the top of the screen as you scroll down the worksheet.
The proces for doing this is slightly different between Excel for Windows and Excel for Mac, so I've covered both here: How to freeze rows and columns You have two options for freezing panes in Excel. If you wanted to freeze the first column, you would then go back and choose that option. The screenshot below is from Excel for Windows. In the Mac version of Excel the options are the same, but you don't get the explanations of each option that you see here: Things get slightly more complicated if you want to freeze more than one row or column.
If you look at the first screenshot in this lesson, you'll see that the first row doesn't actually contain the headings for the sales data table - it contains the title of this worksheet. Our readers get a lot of value out of the comments and answers on our lessons and spam hurts that experience. Our spam filter is pretty good at stopping bots from posting spam, and our admins are quick to delete spam that does get through.
We know that bots don't read messages like this, but there are people out there who manually post spam. I repeat - we delete all spam, and if we see repeated posts from a given IP address, we'll block the IP address. So don't waste your time, or ours. Add a comment to this lesson. We are PC users, but sometimes working with data on the MAC is annoying as the commands are different.
Freeze Frames on the MAC is located on the right hand corner and sometimes may be a little small but the icon is exactly the same as pictured above. Thanks FiveMinuteLessons, as you just made the life of one small business much easier. I use 'Excel for Mac '.
I understand the use of freezing panes. How do I sort a column AND still retain the 1 heading 'row' intact at the top and not be included in the sort? NB: I need to globally select the WHOLE column - as I have hundreds and hundreds of rows and I don't want to have to selectively select the data in the column ie by leaving out the heading. I am unable to get the above solutions working in Excel for Mac. Solution will be greatly appreciated. Hi LR.
I know your pain I have an Excel spreadsheet that does this to me as well. Not sure if it's a Mac thing, but it's an old Excel for Windows spreadsheet that I transferred to the Mac. Oddly, I don't have that problem if I create a new table in the Mac version. Three ways to do what you want:. I hope that helps! Hello David Works great - thanks.
A few other tips for other people: 1.
Make sure there are no empty cells in the heading row. Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday. First, change to Autofit to Window by following these steps: Select the table and right-click it.
Scroll to Autofit and then select AutoFit to Window. Editor's Picks. Transgender employees in tech: Why this "progressive" industry has more work to do. Python is eating the world: How one developer's side project became the hottest programming language on the planet. How iRobot used data science, cloud, and DevOps to design its next-gen smart home robots.
Beyond the PC: Lenovo's ambitious plan for the future of computing.