How can I set the tab to improve navigation in Excel?

S

stefanie

I've got a big database in which I sometimes have to enter data in a series
of columns, but sometimes I skip over those columns altogether. Is there a
way to design it so that I can tab directly to the columns I need if I'm not
going to be working in one place. For example, could I set it to
automatically jump to AB2 if I were in F1 but didn't need to mess with the
stuff in between?

Thanks
 
D

Dave Peterson

Could you just (temporarily) hide the columns you don't want to see.

Remember to show them before you close the file--don't scare your co-workers!
 

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