How to lock cells in excel 2010 mac

Worked for me. What a ridiculous thing to have to do. Could NOT figure out how to freeze the panes I wanted to Hi there, Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two. Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US. Here's a link to this great service Good luck!


  • How to Lock Cells in Excel [Mac, Windows] | Excel Tutorial.
  • How to Freeze Panes in Excel for Mac.
  • barra mac para windows 7 ultimate.
  • osirix dicom viewer for mac free download.

Posted on Jan 02, Click "Add" to insert your video. Aug 27, Microsoft Excel for PC. Feb 01, Microsoft Excel for PC. Feb 10, Apple Mac Pro Desktop. Dec 26, Microsoft Office Professional Full Apple iTunes. Apple MacBook Air. Answer questions. Have a manual for Apple Mac Pro Desktops? Want Answer 0 Clicking this will make more experts see the question and we will remind you when it gets answered.

More Print this page Share this page. You can't post conmments that contain an email address. Comment Anonymously. Helpful 75 Not Helpful 1 Comment Flag. Helpful 48 Not Helpful 1 Comment Flag. Helpful 18 Not Helpful 3 Comments Flag. Angela Black Oct 05, Instant Repair Help over the Phone 6ya. Helpful 2. Add Your Answer Tips for a great answer: - Answer the question.

Tell us some more! Your answer needs to include more details to help people. You can't post answers that contain an email address. Please enter a valid email address. The email address entered is already associated to an account.

Login to post Please use English characters only. Tip: The max point reward for answering a question is Video Photos Link. Close Save changes. Include an image. It's worth a thousand words. If so, try this video tutorial: How to Freeze Pane in Excel on mac.

The back space button or the shift left button do not respond? You've probably "frozen" your pane. When you ac You didn't say which version of Excel your're using, but in Excel , you can either freeze the Row 1, Column A, or any number of rows and columns based on which cell is selected i. Click on "Unfreeze Panes. Freeze a Row in Microsoft Excel Microsoft Excel can freeze, or lock, a top row as you scroll down the worksheet. For example, you may need to keep the top row of column titles visible at all times.

The "View" tab on the command ribbon contains the "Freeze Panes" button in the "Window" group. Open the Excel worksheet. Click the top row heading. The row heading displays a number just left of the first column of cells. The selected row appears shaded. Click the "View" tab on the command ribbon.

Toggle absolute and relative references

Click the "Freeze Panes" button in the "Window" group. A list of options appears. Click the "Freeze Top Row" option. A black horizontal line appears on the worksheet. Make sure heading row consists of only ONE row. Thanks again LR. I did not see it mentioned in the lesson and was frustrated when the freeze did not work but I was working in "Page Layout" view and when I switched to "Normal" view it worked just fine. 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.

Question Info

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!

To unlock cells

Skip to main content. Search form Search. Freeze or lock rows and columns in an Excel worksheet. Microsoft Excel. 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.

How to Lock a Number in Excel on Mac : Apple Devices & Other Tech Tips

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.

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. When you do this, not much will appear to change.


  • Add Your Answer.
  • painter 12 mac system requirements.
  • time tracking for freelancers mac;

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. The screenshot shows what Freeze Panes looks like if you had clicked B6 before clicking Freeze Panes i. 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: How to unfreeze panes in Excel Unfreezing panes is, fortunately, fairly simple: In Excel for Windows, choose the View menu, click the Freeze Panes button. The first option, which was Freeze Panes, is now Unfreeze Panes.

Click that option and the frozen rows will be unfrozen. In Excel for Mac, choose the Layout menu and choose Unfreeze Panes for some reason, it's a separate option which only becomes available once you have frozen panes.

need to lock a cell, in Excel used key F4, what to use in Excel - Microsoft Community

Want to learn more? Try these lessons: Scale your Excel spreadsheet to fit your screen.

Search form

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. Our Comment Policy. Comments on this lesson We are PC users, but sometimes working with data on the MAC is annoying as the commands are different.

follow url Hi LR I know your pain