ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to number lines (rows) on both sides of spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/138136-how-number-lines-rows-both-sides-spreadsheet.html)

crb.e4xplor

How to number lines (rows) on both sides of spreadsheet
 
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

How to number lines (rows) on both sides of spreadsheet
 
On Apr 6, 12:44 pm, crb.e4xplor
wrote:
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

How to number lines (rows) on both sides of spreadsheet
 
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

How to number lines (rows) on both sides of spreadsheet
 
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



On Fri, 6 Apr 2007 09:44:06 -0700, crb.e4xplor
wrote:

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?



Dave F

How to number lines (rows) on both sides of spreadsheet
 
=ROW(A1) and filled down will do this.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Gord Dibben" wrote:

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



On Fri, 6 Apr 2007 09:44:06 -0700, crb.e4xplor
wrote:

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?




crb.e4xplor[_2_]

How to number lines (rows) on both sides of spreadsheet
 
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
"Gord Dibben" wrote:

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



On Fri, 6 Apr 2007 09:44:06 -0700, crb.e4xplor
wrote:

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?




JLatham

How to number lines (rows) on both sides of spreadsheet
 
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


"crb.e4xplor" wrote:

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
"Gord Dibben" wrote:

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



On Fri, 6 Apr 2007 09:44:06 -0700, crb.e4xplor
wrote:

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?





All times are GMT +1. The time now is 03:54 PM.

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