>Maybe your new job will spring for you to buy my Excel ebooks? LOL (if they are too cheap, let me know and I will email them to you for free...as a thanks for all you've done for this group) HA! Thanks so much for that offer. But I do have Excel books, videos, courses up the wazoo...I've gotten them with OFFICE stuff I get. I just never used THOSE.<g> Time to dust them off and give 'em a go. >And another tip for you Dian.... Thanks! First I have to learn what HE DID to put this mess together. THEN I'll figure out how to make it much better!<g> Dian D. Chapman Technical Consultant, Microsoft MVP & Instructor Free Tutorials: www.mousetrax.com/techtrax Free Word Tips & Tricks eBook: www.mousetrax.com/books.html Learn VBA the easy way, thru video! www.mousetrax.com/techcourses.html -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Linda F. Johnson Sent: Friday, October 31, 2003 6:05 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Excel Newbie Q<g> And another tip for you Dian....if you click on multiple sheet tabs using the ctrl & shift keys to select more than one at a time, the sheets will be "grouped"....so then, whatever typing or formatting you do on one sheet, is done on ALL of them at the same time...so if you made 50 sheets, you could add all the stuff you want for your template...like column headers, formulas, etc...THEN save it as a template and you can use it over and over every year. Maybe your new job will spring for you to buy my Excel ebooks? LOL (if they are too cheap, let me know and I will email them to you for free...as a thanks for all you've done for this group) Linda F. Johnson, M.A., MOS Linda's Computer Stop http://personal-computer-tutor.com Free e-Books, Newsletter, and tutorials -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Green Sent: Friday, October 31, 2003 6:56 PM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Excel Newbie Q<g> Hi Dian, BTW I like the new format "signature". Would putting week numbers on the tabs save a bit of space down there on the left? I think I'd also set up a whole years full of worksheets and use that as a copy/template with at least one summary sheet. That gets around copying a worksheet every week... It's already there. There will probably be a maximum number of clients a week to bill... 200? :-) So the sheet can have fixed ranges "for now". ow many lines does the original worksheet have? Use the same or more. In Exel 2000... ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************