0
CLick on the cell you want to protect then go to tools and protection. In the protection drop down go toallow users to edit ranges then you can click new. In new you then select the areas that people can edit and then click protect. This will then protect the sheet and not allow any areas which are locked to be edited.
What else can I help you with?
What is an active work sheet?
An active sheet is the worksheet you currently are accessing.
What will be printed when you click the OK button Excel 2010?
Normally the whole set of data in the worksheet or the current chart sheet or the selected print area if one has been set.
What is print area in Excel?
It is a part of a document that has been selected in order to be printed. On a spreadsheet there may be a section of the sheet that a user wants to print, so they select it and make it the print area. When they go to print, just that section will be printed.
What does ctrl plus R do in Microsoft Excel?
If you have a range of cells selected which includes more than column, it copies what is in the first column to the right. So whatever is in the first cell on each row in the area selected, is copied across that row within the area selected.
Can you print just a selected section of an Excel document if you would like?
Yes you can. You can use what is known as a Print Area. You select it, specify it as a print area in the print settings and then you can print just that area.
When you use mouse in selecting a cell in excel sheet it doest Not quit?
If you mean that when you click in another part of the sheet it selects all the area between that and does that no matter where you click, just press the F8 key.
For Excel where is the copy area?
There is no copy area in Excel, but Windows has a clipboard where you can copy stuff.
How can I count the number of times the same word appears in an excel sheet?
You can try this.Go to the Formulas ribbon.Select the fx tool. [The 'Insert Function' window will appear.]Enter "count" (without the quotes) in the top blank and click Go. [A list will appear.]Choose "Count If" from the list and click OK. [A window will appear.]Highlight/select the area of the spreadsheet you want to search. [The range of the area you selected should appear in the Range box.]Change to (click in) the Criteria box.Type the word you want to search for and click OK.The cell should show the number of times the word appears in the area of the spreadsheet you selected.
Why are sandbags used when an area floods?
Sandbags are used to create a wall wich has a water tight seal to keep the water out and protect selected areas.
What does clicking and dragging top of chart do in Excel?
It allows you to move the chart. Depending on where you click exactly, you can pick up the chart and then drag it to a new location. This only works if you are in an embedded chart. It does not do anything on a chart sheet. You can also move the plot area within the chart area on both an embedded chart or a chart on a chart sheet, when you click at the top or on any part on the plot area.
What is a chart area in Excel?
Excel does not have a specific chart area. You might be referring to the area within a chart where you can change the legend and other information. You will find chart tools on the Insert tab of the Excel 2007 ribbon.
Why would it be important to 'protect' formula area of a spreadsheet?
Protecting the formula area stops the user (as opposed to the designer!) from making accidental changes to the formulae. It helps to make the sheet more 'foolproof'.
