Showing tag results for Microsoft Excel

Hey, Scripting Guy! How can I specify the number of decimal places to be displayed in an Excel spreadsheet?-- JS Hey, JS. Yes, it is Presidents Day here in the US, a day on which schools, banks, and government offices are all closed. Fortunately, though, the Scripting Guys are open and ready for business. Why are the Scripting Guys open and read...

Hey, Scripting Guy! How can I configure Office Excel to autosave every 5 minutes?-- KK Hey, KK. You know, that’s a good question. As it turns out, the autosave capability in Microsoft Excel – hey, wait a minute: do you realize what day it is? Today is the first day of the 2007 Winter Scripting Games; why in the world are you reading ...

Hey, Scripting Guy! How can I save an Office Excel chart as a picture?-- JB Hey, JB. You know, yesterday was a good day for the Scripting Guy who writes this column. If the phone rings at the Scripting House and if it’s for the Scripting Guy who writes this column, well, it’s never really for the Scripting Guy who writes this column;...

Hey, Scripting Guy! In an Office Excel spreadsheet, how can I change the color of the text if the value in column B minus the value in column A is greater than or equal to 10?-- EP Hey, EP. You know, before the Scripting Guy who writes this column started writing this column, he vowed that Hey, Scripting Guy! would have a laser-like focus on hel...

Hey, Scripting Guy! How can I convert an Office Excel spreadsheet to XML?-- KE Hey, KE. We apologize in advance if today’s column seems a little rushed; at the moment, we’re sitting in an office, surrounded by boxes and packing crates and waiting for the movers to come in and clear everything out. And no, the Scripting Guy who writes...