Tab key

  • Thread starter Thread starter mireillea
  • Start date Start date
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 sheet 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
 
Back
Top