Making Invoice templetes in excel
I assume this works for 2007, haven't seen it yet.
Select each cell where you want to input data and using Format - Cells -
Protection un-check the locked box.
Protect your worksheets making sure 'allow users to select locked cells' is
unchecked.
Pressing Tab or Enter will now jump between your un-locked cells.
Please avoid posting in multiple groups.
Was this helpful?
"Askia" wrote:
hello, family
new to excel 2007; how do i lock the cells so the text will not change, but
the empty cell can add text. its for an invoice, would like to set the
worksheet up so brokers can type in the field and when they press enter the
cursor automatically moves to the next text entry field
|