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?

This is a metter of individual sytle. I would begine by looking at some
template to see what you like and adapt them:

http://office.microsoft.com/en-us/te...595491033.aspx
--
Gary''s Student - gsnu200832


"willem" wrote:

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?

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

"Gary''s Student" wrote:

This is a metter of individual sytle. I would begine by looking at some
template to see what you like and adapt them:

http://office.microsoft.com/en-us/te...595491033.aspx
--
Gary''s Student - gsnu200832


"willem" wrote:

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?

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.
--
Gary''s Student - gsnu200832


"willem" wrote:

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

"Gary''s Student" wrote:

This is a metter of individual sytle. I would begine by looking at some
template to see what you like and adapt them:

http://office.microsoft.com/en-us/te...595491033.aspx
--
Gary''s Student - gsnu200832


"willem" wrote:

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?

On Feb 10, 1:08*pm, willem wrote:
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





"Gary''s Student" wrote:
This is a metter of individual sytle. *I would begine by looking at some
template to see what you like and adapt them:

http://office.microsoft.com/en-us/te...595491033.aspx
--
Gary''s Student - gsnu200832

"willem" wrote:

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?

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.