ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sheet #'s (https://www.excelbanter.com/excel-discussion-misc-queries/41350-sheet-s.html)

mak

Sheet #'s
 
Hi!

My question is: Is there anyway to re-number sheet numbers, for example if
you move your original sheets around and use the footer to print page of
pages they become out of sequence?

Thank you in advance€¦
Mark


Jim Rech

This is no "rename sheets in sequence" feature in Excel. You can of course
right click the tabs of the sheets you want to rename and pick Rename. If
there were a lot of sheets it might be worth writing a macro to do this, but
if the renaming would take only a few minutes it would be quicker to do it
manually..

--
Jim
"mak" wrote in message
...
Hi!

My question is: Is there anyway to re-number sheet numbers, for example
if
you move your original sheets around and use the footer to print page of
page's they become out of sequence?

Thank you in advance.
Mark





All times are GMT +1. The time now is 05:00 PM.

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