ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Coloring the row and column numbering bars in Excel 2003€ (https://www.excelbanter.com/excel-worksheet-functions/241777-coloring-row-column-numbering-bars-excel-2003%E2%80%8F.html)

arasan77

Coloring the row and column numbering bars in Excel 2003€
 
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.

bill kuunders

Coloring the row and column numbering bars in Excel 2003€
 
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

bill kuunders

Coloring the row and column numbering bars in Excel 2003€
 
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


All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com