Sheet

M

Monty

Is there anyway you can change the format of the workbook and have the
numbers along the bottom and the sheet numbers down the right side.
 
D

David McRitchie

Hi Monty,
I'm assuming you still want the columns on the left because
this is English and not Chinese or Hebrew.

If you want to mirror the row number down another column
which could be your rightmost column or one before a horizontal
page break you could use the formula =ROW()
and you would event enter and shade the column gray.

To mirror the column letters on another row.
=MID(CELL("ADDRESS",A1),2,LEN(CELL("address",A1))-3)
starting from column A and use fill-handle to copy to the right.
 
D

David McRitchie

here is a correction ......

Actually so that you can copy the formula to any row
=MID(CELL("ADDRESS",A$1),2,LEN(CELL("address",A$1))-3)
 
Top