Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
TL
 
Posts: n/a
Default

Thank you, this also worked.

"Gord Dibben" wrote:

Select columns O through IV and FormatCellsProtectionLocked.

Select Columns A through N and format as unlocked.

ToolsProtectionProtect Sheet.

The Tab key will move across to N then back to A one column down.

Alternative with no protection........

Starting in column A, use the Tab key until you want to leave N then hit ENTER
key to return to column A one row down.


Gord Dibben Excel MVP

On Mon, 8 Aug 2005 09:42:17 -0700, "TL" wrote:

Thank you for your help, however there are too many columns to hide after
colun N and I am not familiar with running macros. Is there an easier way to
stop the tab from going past the margins of my invoice?

"TL" wrote:

I have an invoice created in excel that I would like to be able to tab over
no further than the end of the invoice(column N) and then return to column A.
Howeer, the tab continues past the column and I don't know how to lock it.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"