Clickable Cell Area

W

Worzel Gummidge

I am designing a spreadsheet to be used by multiple users.

Now, parts of the spreadsheet are just background areas, title etc.... What
I want is for the users not to be able to click in these areas, therefore
not being allowed to edit them.

Is there a way to select part of a spreadsheet that is only clickable in?
ie. highlight all the cells with the data in and choose options so that only
this area is inputtable (if that makes sense?)
 
P

Pete_UK

You can protect certain cells. To start off with, highlight all the
cells in the worksheet (click the intersection between the row and
column identifiers) and Format | Cells | Protection (tab) and click
Locked if it is not already, then OK (You might also want to click Hide
here - this will hide any formulae and show the values returned from
those formulae).

Then select the cells that you want Users to be able to edit and then
Format | Cells | Protection (tab) and unclick Locked.

Finally, Tools | Protection | Protect Sheet, and here you can give a
(memorable) password if you wish.

Your Users will be able to click into the locked cells, but they won't
be able to change any values or formats etc.

Hope this helps.

Pete
 
Top