setting up a bill

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!!
 
J

JulieD

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems with setting up a billing budjet 1
Array formula lock-up 1
how to count my paydays before the due-date of a bill? 11
insert two formulas one cell 1
Calculating Paid and unpaid bills. 2
Let me explain my problem... (Roommate Accounting) 2
Excel base year add up escalation problem.... 1
How do I make the cursor move down 8 cells each time i press enter 3

Top