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 ""
|