How to number lines (rows) on both sides of spreadsheet

[Guest]

I WOULD LIKE TO HAVE THE LINE (ROW) NUMBERS THAT APEAR ON LEFT SIDE TO BE
MIRRORED ON THE RIGHT SIDE OF THE SPREASDSHEET AS WELL; IS THERE A WAY TO DO
THIS?

 

[daregreatly]

I WOULD LIKE TO HAVE THE LINE (ROW) NUMBERS THAT APEAR ON LEFT SIDE TO BE
MIRRORED ON THE RIGHT SIDE OF THE SPREASDSHEET AS WELL; IS THERE A WAY TO DO
THIS?

select a cell that is on the right side of your sheet.
type =
click the left (numbered) in the same row
hit enter

you can copy amd paset this cell down as low as you like
or you can use the box drag feature to quickly do the same

if you copy this lower than the last value on the left.. and the zeros
are a problem..?
you may want to use =IF(ISBLANK( left ),"",left) where left is the
left cell name (eg C9)
it makes those corresponding cells contain an empty string ""

 

[daregreatly]

perhaps you mean the numbers given by excel... within the program?
not generated by you in a column..?

then i do not know if this is possible

 

[Gord Dibben]

No.

What benefit would be derived from having this possible?

Perhaps there is another method of achieving a similar view.


Gord Dibben MS Excel MVP

 

[Guest]

=ROW(A1) and filled down will do this.

Dave

 

[Guest]

Just looking to have row designation on that side of a spreadsheet that is
anywhere from 28 to 36 columns wide usally expanded to the width of two or
more 17" screens; so I have to shrink down to eye straining levels or page
over to properly complete the update process that I do.

I reference a lot of the column information as it is interelated to future
or past column cells in same spreadsheet. Freezing the columns at certain
working stages works for an early input section of the spreadsheet, but there
is still times when I find myself getting slightly disoriented. This is also
caused because i am usually toggling between two or three different
spreadsheets(previous update periods) at a given time during a twice weekly
update process. Content programming, and the related tie in data to make it
come to life as a story, is a cryptic explanation of what the business
application is that has me looking for this attribute/functionality.

I appreciate the request for further information; after the difinitive no.

Regards...Chris

 

[Guest]

Then, besides the possible of option of occassionally sticking in a column
with the
=ROW() formula in them, you might also look at Chip Pearson's
row-highlighter add-in: http://www.cpearson.com/Excel/RowLiner.htm