Category Archives: 2010

Excel 2010: the big macro turn on!

Not what it may sound like, but instead a quick guide to making sure you can run your macros in Excel 2010.

Macros are disabled by default in Office 2010 (Word 2010, Excel 2010, PowerPoint 2010, etc) for enhanced security. Enabling Macros is easy but Microsoft Office team has hidden it deeper inside Options. Continue reading

Excel: moving from menu to ribbon, pt. II

I did say, in the post Excel: moving from menu to ribbon, that getting a friendly developer to write a custom menu set-up for you to replicate the old 2003 menu is not the way to go. Irrespective, I consider myself both friendly and a developer so we do actually have an add-in available, for those who’d like to disregard my previous advice. Continue reading

Excel: moving from menu to ribbon

For users of Excel the change from the familiar old menu bar, in Excel 2003 and earlier, to the new ribbon, in Excel 2007 or 2010, things can be a bit of a shock. Things aren’t where you expect, some may not even be in a place you consider sensible. But, now you’ve upgraded, let’s look at a way to deal with this. Continue reading

Excel: Defined Names

A Defined Name is a text descriptor created by the user/developer to describe content, meaning or use of a cell or range of cells, a constant, or a formula. Once defined this can be used in place of cell addresses or other content and makes formulae much easier to understand and/or maintain.  Continue reading