skipping cells

[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...

 

[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

 

[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...

Gord Dibben MS Excel MVP