Tag Archive: excel vba cell

Jan
16
2012

Handy Excel Macros > Automate Excel Text Formatting

Excel_logo

When working with the Microsoft office documents or spreadsheets we end up doing the formatting so manually every time. Let us take a real time case. I am need to create a spreadsheet with about 100 titles and 500 entries and i need to copy them from various web pages and e-mails. I want all …

Continue reading »

Jan
15
2012

Assigning Excel 2007 Macros to Buttons / Trigger VBA Macros from Buttons

Excel macros are excellent time savers. It is a good idea to assign some keyboard shortcuts to trigger them quickly to make the most of them. Alternatively we can trigger them from buttons as well as well (if you find it difficult to remember too many keyboard short cuts). In this post I am going …

Continue reading »