Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Autofill Sheet tabs in Excel
Name: seawatch Date: January 2, 2005 at 12:16:54 Pacific OS: Win2k Pro CPU/Ram: 1ghz 328
Comment:
I there a way to do a fill on the sheet tabs at the bottom of work book?
Name: Bryco Date: January 2, 2005 at 14:45:13 Pacific
Reply:
Yes.
I just used the free ASAP Utilities to do that for the first time as I suspected it could.
See the "Screenshots" page and then look under "Sheets" for +! Add sheets (with names defined in selected cells)
I did have to format the cells as Text and then I input Jan1, Jan2 and dragged it down 20 cells.
Selected the option in ASAP and it worked just fine.
Otherwise I know of no other method besides doing it manually.
Regards, Bryan
0
Response Number 2
Name: seawatch Date: January 2, 2005 at 15:31:33 Pacific
Reply:
Beautiful!
Just what I wanted. Thanks Bryan. You ride to the rescue again.
Larry
0
Response Number 3
Name: seawatch Date: January 2, 2005 at 15:45:31 Pacific
Reply:
I haven't used ASAP much, although I had downloaded it earlier.
I just have to ask, how did you know to format the cells to text first?
Larry
0
Response Number 4
Name: Bryco Date: January 3, 2005 at 02:25:56 Pacific
Reply:
Because when I tried to do it per your example I input Jan1 and it reformatted itself to the date format of 01-Jan and that was not what you requested.
That date format shows in the formula bar as 01/01/2005 and that is not a valid format for Sheet names whereas it contains the special character of "/" within it.
Hence, text format instead of date format.
Regards, Bryan
0
Response Number 5
Name: seawatch Date: January 3, 2005 at 03:43:48 Pacific
Reply:
Yes, that's what happened to me the first time I tried it.
Summary: the reason being in my spreadhseet i hide the sheet tabs along the bottom, as it has to be designed for "dumb user" as the college calls them. it has to all be made as simple as it can, so i want the...
Summary: Hi, I used to be able to right click on the MS Excel Sheet1,Sheet2,Sheet3 tabs and get the menu "Insert+Delete+Rename ..etc". All of a sudden, If I do a right click on the Sheets tab, there's nothing ...
0 
