Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a fairly large Excel work sheet, in which I have to traverse left and
right as well as up and down a number of times, from a selected cell. In order to ensure that I return back to the same cell from which I started my traversals always, I need to note down the row and column numbers of the starting cell everytime, before starting my traversals, so that I can return to the same cell without straying away. For this purpose, I would like to note down the row and column nos., which task can be made easy if the row and column number bars of the selected cell can be highlighted with a bright color, enabling me to note down those numbers readily. Is there any way by which this task can be performed in Excel 2003? Thanks for everybody, who provide me an answer for this query. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Sep 5, 5:36*pm, arasan77
wrote: I have a fairly large Excel work sheet, in which I have to traverse left and right as well as up and down a number of times, from a selected cell. In order to ensure that I return back to the same cell from which I started my traversals always, I need to note down the row and column numbers of the starting cell everytime, before starting my traversals, so that I can return to the same cell without straying away. For this purpose, I would like to note down the row and column nos., which task can be made easy if the row and column number bars of the selected cell can be highlighted with a bright color, enabling me to note down those numbers readily. Is there any way by which this task can be performed in Excel 2003? Thanks for everybody, who provide me an answer for this query. edit goto special ok ok or a lot quicker press <altEGS <enter<enter greetings from new zealand |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Sep 5, 6:49*pm, bill kuunders wrote:
On Sep 5, 5:36*pm, arasan77 wrote: I have a fairly large Excel work sheet, in which I have to traverse left and right as well as up and down a number of times, from a selected cell. In order to ensure that I return back to the same cell from which I started my traversals always, I need to note down the row and column numbers of the starting cell everytime, before starting my traversals, so that I can return to the same cell without straying away. For this purpose, I would like to note down the row and column nos., which task can be made easy if the row and column number bars of the selected cell can be highlighted with a bright color, enabling me to note down those numbers readily. Is there any way by which this task can be performed in Excel 2003? Thanks for everybody, who provide me an answer for this query. edit goto special ok ok or a lot quicker press <altEGS <enter<enter greetings from new zealand But then again if you get around by clicking or selecting other cells this wouldn't work. To get the lines go to http://cpearson.com/excel/rowliner.htm for an add-in Bill Kuunders |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Coloring the row and column numbering bars in Exce2003 | Excel Worksheet Functions | |||
Coloring individual points/bars | Charts and Charting in Excel | |||
Conditional coloring of columns in column chart | Excel Discussion (Misc queries) | |||
Excel column chart with a 2ndary y axis w/o bars overplotting? | Charts and Charting in Excel | |||
coloring the sides of 3d bars in a different color than the front? | Charts and Charting in Excel |