Re: Tab key



> press the tab key twice!

funny! and certainly the quickest to implement.

If the poster wants to prevent someone from typing
into a column accidentally they could leave such columns
protected, unprotect the others, and use *** protection.

Another solution would be to use an Event macro to
move the active cell one to the right after activating a cell in
the column to be skipped over, or to move the active cell two cells to
the right after changing a cell in a particular column.
http://www.mvps.org/dmcritchie/excel/event.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Umlas" <Excel_Trickster@xxxxxxx> wrote in message news:eyfIfS9pFHA.2416@xxxxxxxxxxxxxxxxxxxxxxx
> press the tab key twice!
>
> "mireillea" <mireillea@xxxxxxxxxxxxxxxxxx> wrote in message
> news:e7eIQI9pFHA.2696@xxxxxxxxxxxxxxxxxxxxxxx
> > Hi,
> > How to move 2 cells to the right by pressing the Tab key.
> > Thanks
> >
>
>


.