#1   Report Post  
mak
 
Posts: n/a
Default 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

  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM
How do I determine automatically that a sheet is empty? [email protected] Excel Worksheet Functions 4 May 9th 05 08:15 PM
Windows XP Excell - sheet 1 / shhet 2 / sheet 3... Jacques Poulin Excel Discussion (Misc queries) 1 February 25th 05 02:09 AM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM
Function to automatically insert a new sheet as a result of data entry? Mark Mulik Excel Worksheet Functions 2 November 28th 04 02:21 AM


All times are GMT +1. The time now is 09:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"