skipping cells

J

just1creation

i would like a certain cell not recognized even if i click on that cell.
i don't want anything in that cell, just to be blank. say i was on A1
and when i press enter i would like to skip to A3...
 
B

baxybaxy

easy

insert a hyperlink in to the cell

you can format the cell in white text to hide the hyperlink if neede
and protect if you have t
 
G

Gord Dibben

You can give the range a name and ENTER your way through the cells in the order
you wish.

See Bob Phillips's site for methods of naming a range.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Don't be put off by the title "Tab to selected cells". There is a method of
using the ENTER key.


Gord Dibben MS Excel MVP

i would like a certain cell not recognized even if i click on that cell.
i don't want anything in that cell, just to be blank. say i was on A1
and when i press enter i would like to skip to A3...
Click to expand...

Gord Dibben MS Excel MVP
 
Top