![Freeze pains excel 2011 mac](https://knopkazmeya.com/4.png)
![freeze pains excel 2011 mac freeze pains excel 2011 mac](https://asiannew884.weebly.com/uploads/1/2/5/6/125699111/166891665.jpg)
- #Freeze pains excel 2011 mac how to
- #Freeze pains excel 2011 mac for mac
- #Freeze pains excel 2011 mac windows
Even if the OS were not the lastest, Win MS Office works in computers in multiple Windows Operating Systems-VISTA, XP, 2003/4, Win 7. I am a computer super user so please, let's move on to talk about the problem with Xcel for mac, not macintosh's operating system. When you are working with a large spreadsheet in Microsoft Excel, it's easy to find yourself scrolling down or across and losing track of where you are.Everything is updated-trust me-that was the first thing I did.
#Freeze pains excel 2011 mac how to
This lesson explains how to freeze rows and columns (officially known as "Freeze Panes") in Excel 2010 for Windows and Excel 2011 for Mac.
#Freeze pains excel 2011 mac for mac
Why you might need to freeze rows or columns in your spreadsheet #Excel for mac resize rows how to The worksheet contains daily data that reports the sales for each person in your sales team, broken down by products sold: Imagine you have a spreadsheet that contains sales data for January.
![freeze pains excel 2011 mac freeze pains excel 2011 mac](https://michelpoudrier.com/images/other/3/how-enable-freeze-694C47.gif)
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.The proces for doing this is slightly different between Excel 2010 for Windows and Excel 2011 for Mac, so I've covered both here: 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. Note that these steps also apply to freezing columns: You have two options for freezing panes in Excel. To freeze just one row, click the View menu, and find the Freeze Panes button (if you're using Excel 2011 for Mac, click the Layout menu to find the Freeze Panes button) When you click the Freeze Panes button, you can choose Freeze Top Row from the expanded Freeze Panes options. If you wanted to freeze the first column, you would then go back and choose that option.
![freeze pains excel 2011 mac freeze pains excel 2011 mac](https://michelpoudrier.com/images/other/465/how-freeze-more-6F5565.png)
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: The screenshot below is from Excel 2010 for Windows. 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. To freeze the heading row of the table, you will have to freeze the first five rows in the worksheet. To do this, click in the cell A6 (i.e the first row that should not be frozen) and choose the first option in the Freeze Panes drop-down menu (it's also called Freeze Panes). When you do this, not much will appear to change. All you'll see is a line stretching across the screen, almost like a border along the bottom of row 5 (which is the last row to be frozen in our example). you wanted rows 1-5 and column A to be frozen): The screenshot shows what Freeze Panes looks like if you had clicked B6 before clicking Freeze Panes (i.e. Unfreezing panes is, fortunately, fairly simple: As you can see, the first five rows have stayed put, and the other rows have disappeared underneath them as I've scrolled down the screen: Here's what the sales data table looks like if you scroll down.
![Freeze pains excel 2011 mac](https://knopkazmeya.com/4.png)