How do you change multiple sheet numbers at one time?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hey Guys,
I want to be able to re arrange my sheet numbers without "sheet number is already in use" error pops up. This does pop up because i am changing to a number that already exists but i am going to change that one afterwards.
is there away to change all the all the numbers first before it loading in.
at the moment i have to go change all the numbers to random ones first before i then go and change to the numbers i want.
For example, i want to change the order of my section sheets numbered 10-14. the moment i change number 10 to 14 it says sheet number already in use.
my current solution is changing all the numbers of each view first to something like x10, x11, x12, x13, x14 and then going back and putting the order I want.
this is annoying, this is a two step process when it should be one.
is there a way to do this that i dont know about?