Re: Tab key
- From: "David McRitchie" <dmcritchie_xlmvp@xxxxxxxxxxx>
- Date: Tue, 23 Aug 2005 10:41:36 -0400
> 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
> >
>
>
.
- References:
- Tab key
- From: mireillea
- Re: Tab key
- From: Bob Umlas
- Tab key
- Prev by Date: Re: counting characters in a cell
- Next by Date: SEARCH AND REPLACE
- Previous by thread: Re: Tab key
- Next by thread: getting first few characters of a cell in another one
- Index(es):