Showing tag results for Microsoft Excel

Hey, Scripting Guy! How can I import a fixed-width file into Microsoft Excel?-- JP Hey, JP. We have a confession to make here, something we’re terribly ashamed of: for a moment - just for a moment, mind you - we doubted Microsoft Excel. Yes, we know: how could we do such a thing? All we can say is that we made a mistake, and we’re sorry. For som...

Hey, Scripting Guy! How can I add a hyperlink to an Excel spreadsheet?-- J B-N Hey, J B-N. To begin with, we’d like to point out that we’re well aware of all the recent media scandals involving such prestigious organizations as The New York Times. As you know, many of those scandals revolve around writers who didn’t actually do the work they cla...

Hey, Scripting Guy! How can I build an array from a column of data in Excel?-- AH Hey, AH. Obviously none of the Scripting Guys has any need to go on a diet (perish the thought!), but we do know that one time-honored dieting strategy is the theory of tiny bites: instead of gulping down your food in a few huge swallows, you nibble at it with scor...

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 center text in an Excel cell?-- MV Hey, MV. You know, every now and then we get asked a question and we think to ourselves, “Wow, how many times do you suppose we’ve answered this question?” And, of course, when we go to double-check we find out that we’ve never answered that question; instead, it just seems like we...