excel macros tips and tricks

How to make MS Excel macros to run across all sheets

By Violeta | Published: April 30, 2007

MS Excel macros can boost your productivity, saving you a lot of the time you spend on doing boring tasks, such as formatting or printing. If you didn’t know by now, find out how you can use a macro across all worksheets: After you choose Tools, Macros, Record New Macro, in the dialog box, at [...]

Posted in Microsoft Office | Also tagged macros, microsoft excel, productivity | 5 Comments

How to assign a toolbar button to a macro in MS Excel

By Violeta | Published: September 28, 2006

Do you know what a macro is? Or how to make a MS Excel macro? Have you ever made a macro? If you had, it means you use it frequently, this is why you made it, isn’t it? It must be boring though, every time you want to run it, to go to the main [...]

Posted in Microsoft Office, Tutorials | Also tagged add macro in excel, excel, macros, microsoft excel, productivity | 2 Comments

How to use macros in MS Excel

By Violeta | Published: August 25, 2006

It happens many times that we have to accomplish boring repetitive tasks in MS Excel, such as formatting cells in lots of tables, to make them look more professional, in order to print, let’s say, a report for a client. Those tasks, although easy to do, require a lot of time to complete. Repetitive tasks [...]