setting up a bill

  • Thread starter Thread starter Megan
  • Start date Start date
M

Megan

I made a bill for tenants at a an apartment complex and I
have to enter their apt #, amount owing, and late fees.
How do I make it so the cursor only jumps between those
three cells? This would make entering data so much
quicker and I wouldn't mess up other things on the
worksheet! HELP!!
 
Hi Megan

if you select those cells,
choose format / cells from the menu
choose protection tab & untick locked & click Ok
now choose
tools / protection / protect sheet and click Ok
you will be able to TAB between the three cells and not change anything else
on the worksheet.

If you need to change anything else, just unprotect it, make your changes &
protect it again.

Cheers
JulieD
 
Back
Top