Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet
Suppose I have a worksheet with 5 columns by 3 rows ( The number of rows and
columns to use). Can the cursor be configured to move to the next row automatically once the last row of the immediate column has an entered value? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet
Select the data-entry rectangle of interest. Use the tab key to enter
values. The cursor will "wrap" within the highlighted area. You can also set the cursor to move to the right after hitting enter, if it currently moves downward. On Jul 10, 10:58 pm, bluesun wrote: Suppose I have a worksheet with 5 columns by 3 rows ( The number of rows and columns to use). Can the cursor be configured to move to the next row automatically once the last row of the immediate column has an entered value? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet
Hi Hilberg, thanks for your feedback. Can the "wrap" be set like a rule, so
that it could not be disturbed by mouse click or function key. "D Hilberg" wrote: Select the data-entry rectangle of interest. Use the tab key to enter values. The cursor will "wrap" within the highlighted area. You can also set the cursor to move to the right after hitting enter, if it currently moves downward. On Jul 10, 10:58 pm, bluesun wrote: Suppose I have a worksheet with 5 columns by 3 rows ( The number of rows and columns to use). Can the cursor be configured to move to the next row automatically once the last row of the immediate column has an entered value? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet
You could consider using VBA, more specifically, a SelectionChange Event.
That traps where the cursor is going. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "bluesun" wrote: Hi Hilberg, thanks for your feedback. Can the "wrap" be set like a rule, so that it could not be disturbed by mouse click or function key. "D Hilberg" wrote: Select the data-entry rectangle of interest. Use the tab key to enter values. The cursor will "wrap" within the highlighted area. You can also set the cursor to move to the right after hitting enter, if it currently moves downward. On Jul 10, 10:58 pm, bluesun wrote: Suppose I have a worksheet with 5 columns by 3 rows ( The number of rows and columns to use). Can the cursor be configured to move to the next row automatically once the last row of the immediate column has an entered value? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet
A couple of methods.
Start in A1 and Tab your way across to E1. ENTER key out of E1 and go to A2. Method 2................. Select the cells and FormatCellsProtection Unlock these cells then protect the worksheet with "select locked cells" disabled. You can move only across using the Tab key oir ENTER key if set to move right. When you get to column E and hit Tab or ENTER you will go to A2. Gord Dibben MS Excel MVP On Tue, 10 Jul 2007 19:58:02 -0700, bluesun wrote: Suppose I have a worksheet with 5 columns by 3 rows ( The number of rows and columns to use). Can the cursor be configured to move to the next row automatically once the last row of the immediate column has an entered value? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions |