How do I tab to areas on spreadsheet?

M

mark1989

I'm creating a NFL Football schedule that consists of all 17 weeks o
the regular season. Instead of using the "down-arrow" to scroll dow
and have to find the certain week, can I set tabs on the worksheet fo
each week? If so, how do I perform the function?

Thanks,

Mar
 
J

JC

You can unlock the cells you want your tabs set to and
then protect the sheet. When you hit the tab key it will
take you to that cell. If you want to edit other cells
you would need to unprotect the cell. After your edits
you could reprotect and your tabs would work again.
JC
 
D

Don

Mark,

Scroll to the view that you want for the first
week....Click on View/Options/Add....name that
view..i.e...First Week....click OK...do this for each of
the weeks or views involved. When you want to go to a
particular view...click on View/Options...select the view
you desire and click "Show"...it'll take you right to
that view.

Hope this helps you out.

Don
 

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

Top