Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab order
Is there a way of setting the tab order in a spreadsheet ie: I want to
tab from Column C through each column to column U, although the input then continues from column Z to column AQ I want to operate between C & U so that it does not jump to column Z, (Columns V,W,X,and Y are protected to record results of formulas ). Once I have recorded the information in the above columns I will then be moving to columns Z through to column AQ and need to stay within these columns. I hope that this is clear. Thanks, jambun |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab order
Hi,
There is nothing built-in to Excel to do this you could write code, but of course you will have to nail down exactly what you want to happen. For example, if a cell in the first range is missed would you be allowed to move to second region. Do you fill in a row or how many rows in the first region before you can move to the second region. Once in the second region can you move back to the first region, if so when. When you've entered data in both regions, what then. Cheers, Shane Devenshire " wrote: Is there a way of setting the tab order in a spreadsheet ie: I want to tab from Column C through each column to column U, although the input then continues from column Z to column AQ I want to operate between C & U so that it does not jump to column Z, (Columns V,W,X,and Y are protected to record results of formulas ). Once I have recorded the information in the above columns I will then be moving to columns Z through to column AQ and need to stay within these columns. I hope that this is clear. Thanks, jambun |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab order
Hi Jambun,
For all practical purposes, why don't you just hide the columns that you don't want to use, your question will be solved. Like in your first case only open columns c to u, and hide all others. when done, open all the columns then hide all others except columns z to aq ans o on. No macros ....ho headache ........just joking -- Kind Regards, Satti Charvak Only an Excel Enthusiast " wrote: Is there a way of setting the tab order in a spreadsheet ie: I want to tab from Column C through each column to column U, although the input then continues from column Z to column AQ I want to operate between C & U so that it does not jump to column Z, (Columns V,W,X,and Y are protected to record results of formulas ). Once I have recorded the information in the above columns I will then be moving to columns Z through to column AQ and need to stay within these columns. I hope that this is clear. Thanks, jambun |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tab order
On Wed, 26 Nov 2008 22:12:01 -0800, Shane Devenshire
wrote: Shane, The first set of columns record the scores of each hole of Golf for day one,each row is for a different player. So I tab across each hole and enter the score, then go down to the row needed to enter the next players score. The next set of columns are for day 2's score. The problem I have is that when I get to hole 18 on Day 1 by tabbing across the row, if I tab again I end up on day 2's columns and need to scroll back to day 1 to enter the next player. There are ways to overcome this problem ie: by having the days on separate sheets and combining the scores for count back an another sheet but I am trying to make it easier for someone that is not sure of what is happening. Hope this makes sense Thanks Jambun Hi, There is nothing built-in to Excel to do this you could write code, but of course you will have to nail down exactly what you want to happen. For example, if a cell in the first range is missed would you be allowed to move to second region. Do you fill in a row or how many rows in the first region before you can move to the second region. Once in the second region can you move back to the first region, if so when. When you've entered data in both regions, what then. Cheers, Shane Devenshire " wrote: Is there a way of setting the tab order in a spreadsheet ie: I want to tab from Column C through each column to column U, although the input then continues from column Z to column AQ I want to operate between C & U so that it does not jump to column Z, (Columns V,W,X,and Y are protected to record results of formulas ). Once I have recorded the information in the above columns I will then be moving to columns Z through to column AQ and need to stay within these columns. I hope that this is clear. Thanks, jambun |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a feeling the order of my formula is out of order....HELP! | Excel Discussion (Misc queries) | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
Series order conflicts with line order | Charts and Charting in Excel | |||
I want a purchase order that includes page number (if to be order. | New Users to Excel | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |