Automatically naming sheets?

Futile Crush

New Member
Joined
Oct 3, 2009
Messages
45
Hey again guys. I want to make a spreadsheet with many sheets, but I want to condense the size of the sheets, instead just numbering them. Is there any way I can manually specify that every time I create a new sheet, I want it to go up in numbers? I can't use VBA, so don't try and give me a VBA answer please.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
I would like to try and help, but I don't have a clue as to what you want. What do you mean by "condense the size of the sheets"? How about some examples? (Why no VBA?)

lenze
 
Upvote 0
I would like to try and help, but I don't have a clue as to what you want. What do you mean by "condense the size of the sheets"? How about some examples? (Why no VBA?)

lenze

Why no VBA? Because I'm about as good with VBA as a fish is with a bicycle, to put it bluntly. I wouldn't understand it to be able to use it.

Anyway, I just meant making the names on the sheets smaller (from "Sheet1" to "1", for example.)
 
Upvote 0
If that's what you mean, I am reasonably sure it can not be done without VBA.
Sorry
lenze
P.S. No better way to learn VBA than to play with it
 
Upvote 0

Forum statistics

Threads
1,214,975
Messages
6,122,538
Members
449,088
Latest member
RandomExceller01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top