Project Window Sheet order

  • Thread starter Thread starter rob nobel
  • Start date Start date
R

rob nobel

Is there a way to get the sheet numbers in numerical order in the project
window? If not, how does Excel determine the order as they don't appear in
the order of the sheet tabs either.
Rob
 
A worksheet has two names--the codename and the worksheet name (visible on the
worksheet tab).

The project explorer sorts by codename of those objects.

You can rename the codenames (F4 to show the properties when you've selected the
object)--and just type over the (name) property.
 
???.
My sheets code names are in the following order...
Sheet1
Sheet10
Sheet11
Sheet12
Sheet13
Sheet14
Sheet15
Sheet2
Sheet3, etc.
They look out of order to me. I can understand that 10 might come after the
1 as sorting quite often has this problem unless you preceed numbers with a
0 where necessary, but why 2 after 15??
Rob
 
because they are just characters and 1 comes before 2 and
space comes before zero. You get the same sort if you
sort a column of text with those same values.


rob nobel said:
???.
My sheets code names are in the following order...
Sheet1
Sheet10
Sheet11
Sheet12
Sheet13
Sheet14
Sheet15
Sheet2
Sheet3, etc.
They look out of order to me. I can understand that 10 might come after the
1 as sorting quite often has this problem unless you preceed numbers with a
0 where necessary, but why 2 after 15??
Rob
Click to expand...
 
Now that I can understand!
Seems a bit silly of MS not to get that better in the project window.
Rob

David McRitchie said:
because they are just characters and 1 comes before 2 and
space comes before zero. You get the same sort if you
sort a column of text with those same values.
Click to expand...
 
Back
Top