Excel spreadsheet

C

Crofton

Version: 2008

Could you please help. I am trying to create a spreadsheet that can be shared. The problem is I want to make it so that some of the cells/columns can be changed by any user but some I want to be able to lock as they will contain formulas that I do not want them to be able to change.
Unfortunately I have tried going by the 'HELP' section within excel and no matter what I try, I can only either protect the whole sheet/workbook so nobody but myself can alter it or have to leave it unprotected.
Within the older style excel you were able to do this, how can it be done now.
Your help would be much appreciated and thank you in advance for your prompt response.
 
J

JE McGimpsey

Version: 2008

Could you please help. I am trying to create a spreadsheet that can be
shared. The problem is I want to make it so that some of the cells/columns
can be changed by any user but some I want to be able to lock as they will
contain formulas that I do not want them to be able to change.
Unfortunately I have tried going by the 'HELP' section within excel and no
matter what I try, I can only either protect the whole sheet/workbook so
nobody but myself can alter it or have to leave it unprotected.
Within the older style excel you were able to do this, how can it be done
now.
Click to expand...

Same was as in all other versions. By default, cells are locked (when
the sheet is protected), so:

- Select the cells that should be user modifiable
- Choose Format/Cells/Protection and uncheck the Locked checkbox
- Choose Tools/Protection/Protect Sheet, and protect for contents.
 
C

Crofton

Hey Mr McGimpsey

Many thanks for that, I have done as you explained and am now able to continue with the worksheet in question - I really appreciate your help.
 
T

tdraper07

I WANT TO PRINT A SPREADSHEET SH 1 SH 2 BACK TO BACK AND I NEED TO SHOW THE NUMBERS IN THE CELLS UPSIDE DOWN. IT'S A MATH WORKSHEET FOR 6TH GRADERS.
 
J

Jessie

How do I change the vertical axis to list out my A cell information? Help I'm new to excel- thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Excel - Wich Function should I use? 1
Embed the same Excel multiple times 0
Excel does not accept text format! 0
Word macro that can call cells out of Excel for a find and replace 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
How to modify and updte specific styles for specific paragraphs across the document 0
Need help modifying code 0

Top