| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 : Is there any active row bar to aid data entry ?
Dear Sir,
Can I have a light color bar at the active row to assist data entry under Excel 2002 ? Let consider the folowing worksheet: A B C D E 1 A114 xxx 2 A126 xxx ________________________________ 3 B135 xxx Light color bar -- ________________________________ 4 B246 xxx 5 C554 xxx 6 C412 xxx 7 D412 xxx 8 F411 xxx 9 G788 xxx 10 H891 xxx 11 J663 xxx 12 M258 xxx Can I customized a light color bar to highlight row A3: C3 when I am doing the data entry at cell C3 ? This bar would move up and down as I move the cursor. It also lengthen or shorten when the cursor is move right or left. I need this sopecial feature could assist me to readi the content in each cell in column A correctly before data is key in at several columns to its left. Thanks Low -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 : Is there any active row bar to aid data entry ?
See he http://www.mcgimpsey.com/excel/highlightrow.html
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Mr. Low" wrote: Dear Sir, Can I have a light color bar at the active row to assist data entry under Excel 2002 ? Let consider the folowing worksheet: A B C D E 1 A114 xxx 2 A126 xxx ________________________________ 3 B135 xxx Light color bar -- ________________________________ 4 B246 xxx 5 C554 xxx 6 C412 xxx 7 D412 xxx 8 F411 xxx 9 G788 xxx 10 H891 xxx 11 J663 xxx 12 M258 xxx Can I customized a light color bar to highlight row A3: C3 when I am doing the data entry at cell C3 ? This bar would move up and down as I move the cursor. It also lengthen or shorten when the cursor is move right or left. I need this sopecial feature could assist me to readi the content in each cell in column A correctly before data is key in at several columns to its left. Thanks Low -- A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 : Is there any active row bar to aid data entry ?
Incidentally, the notes at the link indicate that the macro is slow, but it
works instantaneously for me.... Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Dave F" wrote: See he http://www.mcgimpsey.com/excel/highlightrow.html Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Mr. Low" wrote: Dear Sir, Can I have a light color bar at the active row to assist data entry under Excel 2002 ? Let consider the folowing worksheet: A B C D E 1 A114 xxx 2 A126 xxx ________________________________ 3 B135 xxx Light color bar -- ________________________________ 4 B246 xxx 5 C554 xxx 6 C412 xxx 7 D412 xxx 8 F411 xxx 9 G788 xxx 10 H891 xxx 11 J663 xxx 12 M258 xxx Can I customized a light color bar to highlight row A3: C3 when I am doing the data entry at cell C3 ? This bar would move up and down as I move the cursor. It also lengthen or shorten when the cursor is move right or left. I need this sopecial feature could assist me to readi the content in each cell in column A correctly before data is key in at several columns to its left. Thanks Low -- A36B58K641 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 : Is there any active row bar to aid data entry ?
Thanks
-- A36B58K641 "Dave F" wrote: Incidentally, the notes at the link indicate that the macro is slow, but it works instantaneously for me.... Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Dave F" wrote: See he http://www.mcgimpsey.com/excel/highlightrow.html Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Mr. Low" wrote: Dear Sir, Can I have a light color bar at the active row to assist data entry under Excel 2002 ? Let consider the folowing worksheet: A B C D E 1 A114 xxx 2 A126 xxx ________________________________ 3 B135 xxx Light color bar -- ________________________________ 4 B246 xxx 5 C554 xxx 6 C412 xxx 7 D412 xxx 8 F411 xxx 9 G788 xxx 10 H891 xxx 11 J663 xxx 12 M258 xxx Can I customized a light color bar to highlight row A3: C3 when I am doing the data entry at cell C3 ? This bar would move up and down as I move the cursor. It also lengthen or shorten when the cursor is move right or left. I need this sopecial feature could assist me to readi the content in each cell in column A correctly before data is key in at several columns to its left. Thanks Low -- A36B58K641 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching Data in Excel 2002 | Excel Worksheet Functions | |||
| enable automatic refresh | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
| Importing xml Data into Excel 2002 | Excel Discussion (Misc queries) | |||
Linear Mode
