I have a question for anyone that is an Excel wiz?

Question

I use excel for my small business to keep records of my $$$. I have set up the coloms and cells along with the title and words and such. I want to save them so that I can enter data at anytime in permited cells but I want to make certain cells with empl names, days or titles protected. Protected so that if by accident I click on that cell ..I won't mess up the words or anything in it. Does anyone know how I can do this or If it is possible. NO RUDE COMMENTS PLEASE....RUDE PEOPLE NEED TO GO GET A LIFE....To all kind responses I want to say thanks

Answer 1

select the column or space you want to protect... then right click on it and chose format, you can protect... the spaces...

Answer 2

Excel offers many ways to protect your data.

Cell protection
Every cell has two key properties: locked and hidden. A locked cell can't be changed, and the contents of a hidden cell don't appear in the formula bar when the cell is selected. By default, every cell is locked and not hidden. Locked and hidden attributes have no effect unless the worksheet is protected.

To change these attributes, select the appropriate cell or a range and then choose Format, Cells. In the Format Cells dialog box, click the Protection tab and select Locked or Hidden. Unlock cells that accept user input, and lock formula cells and other cells that should stay unchanged (such as titles). To prevent others from seeing your formulas, lock and hide the formula cells--the results of the formulas will be visible, but the formulas will not.

To protect a sheet, choose Tools, Protection, Protect Sheet to bring up the Protect Sheet dialog, and make sure Contents is checked. You can enter a password to prevent others from unprotecting the sheet. Locked cells in a protected sheet cannot be edited, and other worksheet changes are disabled. For example, no one can insert rows or columns, change column width, or create embedded charts.

If you only need a few locked I would select them all first, Ctrl A, then go to format, cells, protection and uncheck locked, then select the cells you want to lock and go to format cells and check locked, the go to tools, protection, and protect sheet, enter a password if you want, now the cells that you locked can not be edited

some links below give you additional info on using this feature in excel.

Answer 3

Excel offers many ways to protect your data.

Cell protection
Every cell has two key properties: locked and hidden. A locked cell can't be changed, and the contents of a hidden cell don't appear in the formula bar when the cell is selected. By default, every cell is locked and not hidden. Locked and hidden attributes have no effect unless the worksheet is protected.

To change these attributes, select the appropriate cell or a range and then choose Format, Cells. In the Format Cells dialog box, click the Protection tab and select Locked or Hidden. Unlock cells that accept user input, and lock formula cells and other cells that should stay unchanged (such as titles). To prevent others from seeing your formulas, lock and hide the formula cells--the results of the formulas will be visible, but the formulas will not.

To protect a sheet, choose Tools, Protection, Protect Sheet to bring up the Protect Sheet dialog, and make sure Contents is checked. You can enter a password to prevent others from unprotecting the sheet. Locked cells in a protected sheet cannot be edited, and other worksheet changes are disabled. For example, no one can insert rows or columns, change column width, or create embedded charts.

If you only need a few locked I would select them all first, Ctrl A, then go to format, cells, protection and uncheck locked, then select the cells you want to lock and go to format cells and check locked, the go to tools, protection, and protect sheet, enter a password if you want, now the cells that you locked can not be edited

some links below give you additional info on using this feature in excel.

Answer 4

Select the entire worksheet by clicking the Select All button (the gray rectangle directly above the row number for row 1 and to the left of column letter A).
Click Cells on the Format menu, click the Protection tab, and then clear the Locked check box.
This unlocks all the cells on the worksheet

Note If the Cells command is not available, parts of the worksheet may already be locked. On the Tools menu, point to Protection, and then click Unprotect Sheet.

Select just the cells you want to lock and repeat step 2, but this time select the Locked check box.
On the Tools menu, point to Protection, click Protect Sheet, and then click OK.

Answer 5

Select the entire worksheet by clicking the Select All button (the gray rectangle directly above the row number for row 1 and to the left of column letter A).
Click Cells on the Format menu, click the Protection tab, and then clear the Locked check box.
This unlocks all the cells on the worksheet

Note If the Cells command is not available, parts of the worksheet may already be locked. On the Tools menu, point to Protection, and then click Unprotect Sheet.

Select just the cells you want to lock and repeat step 2, but this time select the Locked check box.
On the Tools menu, point to Protection, click Protect Sheet, and then click OK.

Answer 6

If it is in the form of a table with top and left headings. Then keep the cell pointer at top left corner of the table (not in the headings, but in the data part. Say for ex: in B2 Cell if, A-Column and 1st row are having headings. Then select freeeze panes. This will allow you to scroll through the records.

Secondly, select protect sheet from Tools->Protection. Then tweak with the options.

The procedure goes like this:
1. Select Tools->Protection->Allow Users to edit ranges
Select the range, users, and permissions on the area that can be edited.
Then protect remaining worksheet.

You can also think of using Data->Forms feature.

Answer 7

i can provide you with an Excel formulation, yet you want to attend to to position in the variety of cells you're operating with. My assumptions: each and every row of the worksheet incorporates the student call interior the first cellular, and the try ratings in each and every next cellular to the right interior of a similar row. So, you've were given Mary Smith fifty six seventy 8 89 sixty seven etc Robert Jones seventy 8 seventy 9 40 3 ninety etc So enable's say actual right here: The row containing a student's records is R the first column in row R that incorporates a score is M The very last column in row R that incorporates a score is N To sum the ratings of any student in row R, use SUM(RM:RN) to stumble on the bottom score of any student in row R, use MIN(RM:RN) So, summing the ratings of the student in row R and dropping the bottom is SUM(RM:RN) - MIN(RM:RN) To ordinary those ratings, you should comprehend what percentage ratings there are entire, then subtract a million (because you're dropping the bottom score) i'd use the COUNTA function, which only determines the kind of non-sparkling cells in a range, and use a similar variety as above: COUNTA(RM:RN) - a million Now, this may artwork provided that all and sundry the students have a similar form of ratings, however the formulation might want to be: =(SUM(RM:RN) - MIN(RM:RN))/(COUNTA(RM:RN) - a million) If my assumption about your worksheet setup isn't maximum magnificent, then of route this formulation isn't both, yet you should take care of to regulate it as needed.

Answer 8

Open up excel and in the help box type in "protect Cells"

I can't tell you off hand because I don't have excel on this computer but I know it's under the Tools > protection tab

Answer 9

Right-click on the cell, select Format, then click on the Protection tab.

Answer 10

well, i can answer the first part of your question, for the second one, i don't think there is such a command in Excel -there is one in Word.
to save the titles and stuff, you just have to create a Macro, it's under Tools--> Macro-->Record new macro. it's very easy, you just have to launch the command and start recording just like you were recreating your sheet from the beginning, then save your macro, you can give it a shortcut if you want.

Answer 11

What you can do is if you have a 'protect' or 'unprotect' function in your toolbar, protect the basic layout you want, and then just fill in the info. where you need to. You may need to save it every time or else enter a passcode to enter where your info is stored, but it will not only ensure security for business purposes, but it minimizes the chances of info. "accidentally" getting deleted and what not. It's a pain in the butt to have to go through and fill out one of those things every time you need it.