Showing tag results for Excel spreadsheet

Hey, Scripting Guy! How can I change the footer in an Excel spreadsheet?-- JA Hey, JA. Ah, a trick question, huh? As it turns out, there’s no such thing as the footer in Excel; instead, Excel has three different footers: the left footer, the center footer, and the right footer. And here’s a script that can change all three of them:Set objExcel =...

Hey, Scripting Guy! How can I add additional worksheets to an Excel workbook? By default you get 3 worksheets, but I have a scenario in which I need a workbook that has 12 worksheets.-- AA Hey, AA. You know, a couple years ago one the Scripting Guys helped put together an Excel spreadsheet for one of the local youth baseball leagues. Because the...

Hey, Scripting Guy! How can I sort worksheets in a workbook?-- FS Hey, FS. How can you sort worksheets in a workbook? Well, to tell you the truth, not as easily as we had hoped you could sort worksheets in a workbook. This doesn’t mean it can’t be done; it just means that the process is a tiny bit convoluted. Because of that, don’t feel bad if y...

Hey, Scripting Guy! How can I copy column C of one worksheet to column A of a second worksheet?-- JP Hey, JP. Well, that’s easy: you just open Excel, highlight column C, press Ctrl+C, put the cursor in column A1 of the second worksheet, and then press Ctrl+V. There you go, and thanks for your question. Oh, right: you wanted to know how to do thi...

Hey, Scripting Guy! How can I open an Excel workbook and retrieve the names of all the worksheets?-- JG Hey, JG. It’s the first day back after a three-day weekend, and this morning all the Scripting Guys stumbled into the office and just stared blankly into space. (All in all, pretty much business as usual.) Eventually one of us spoke up and sai...