make spreadsheet look professional

W

willem

I want a certain spreadsheet to look good.
Block the whole layout and only allow users to fill out certain cells.
What is the most simple way to do so?
 
W

willem

In particular I have calculations for channel flows, the user can fill out
certain values and it returns it's capacity of the channel. I wonder if it
was possible to block calculation cells and only make the input cells
accesible for the user. How should i do this?

W
 
G

Gary''s Student

Use Protection

Begin by unprotecting the worksheet and workbook and unlocking all the
cells. Then lock the cells with the formula. Then protect the worksheet.
 
R

Rasoul Khoshravan

In particular I have calculations for channel flows, the user can fill out
certain values and it returns it's capacity of the channel. I wonder if it
was possible to block calculation cells and only make the input cells
accesible for the user. How should i do this?

W
Click to expand...

By default all cells are protect.
Select all cells in the ws
Go to: Format| Cells, Protection tab, untick the "Locked" OK
Choose those cells you want to protect
Return to previous step and lock those selected cells
In order to make those cells locked to be effective you have to
protect the worksheet
Go to: Data| Protect Sheet, if you want, type a password otherwise
leave it blank. click OK
Now your sheet is protected and locked cells or locked.
 
Top