transgasra.blogg.se - How to lock certain cells in excel 2010

#How to lock certain cells in excel 2010 how to
#How to lock certain cells in excel 2010 password
#How to lock certain cells in excel 2010 mac
#How to lock certain cells in excel 2010 windows

Things get slightly more complicated if you want to freeze more than one row or column.

#How to lock certain cells in excel 2010 mac

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. If you wanted to freeze the first column, you would then go back and choose that option. When you click the Freeze Panes button, you can choose Freeze Top Row from the expanded Freeze Panes options. 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) Note that these steps also apply to freezing columns: You have two options for freezing panes in Excel.

#How to lock certain cells in excel 2010 windows

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.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,.

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 example actually has 85 rows of data (the table carries on down further than this screenshot shows):.

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. Why you might need to freeze rows or columns in your spreadsheet

#How to lock certain cells in excel 2010 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. Subscribe to get more articles like this oneĭid you find this article helpful? If you would like to receive new articles, join our email list.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.

Click Unprotect Sheet on the Review tab in the Ribbon.

Display the worksheet you want to unprotect.

Unprotecting the sheet and unlocking cells You will be unable to enter or change data or formulas in the locked cells. Passwords are case sensitive and you should keep a copy of your passwords.

#How to lock certain cells in excel 2010 password

Enter a password (you will need to set a password if you don’t want others to be able to unprotect the sheet).

Be sure to scroll down to see all of the available options.

Check or uncheck the desired options (it’s usually best to leave the first two checked).

In the Changes group, click Protect Sheet.

Display the worksheet you want to protect.

The second step in this strategy is to protect the sheet using the Review tab on the Ribbon: Locking remaining cells by protecting the worksheet Nothing will appear to occur until you protect the sheet.

Right-click the selected cell(s) and choose Format Cells or press Ctrl + 1.

The first step in this process is to unlock cells where you want to allow users to make changes to the data or formula:

Recommended article: 10 Excel Data Entry Tricks and Shortcuts Every User Should Knowĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > Unlocking specific cells

First, unlock the cells where you want to allow users to make changes to the data or formula and then lock or protect the remaining cells in the worksheet. It’s easy to lock and protect cells in Excel to protect data or formulas. Easily Lock and Protect Cells in Microsoft Excelīy Avantix Learning Team | Updated January 24, 2021Īpplies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows)