View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daregreatly daregreatly is offline
external usenet poster
 
Posts: 4
Default 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 ""