Sheet
 

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.

Not within Excel :-(

--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"Monty" wrote in message
...
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.

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Andy Wiggins" o m wrote in message ...
Not within Excel :-(

--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"Monty" wrote in message
...
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.

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)

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.