BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andy Brown on 30 June 2011
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Showing the Developer Tab on the Ribbon in Excel 2010
Since I've just spent an irritating few minutes trying to find this out, I thought I'd share the answer!
What is the Developer Ribbon?
The Developer tab on the ribbon in Excel allows you to record and run macros in Visual Basic:
Part of the Developer Ribbon in Excel 2010
The only problem is, this tab isn't visible by default. So if your copy of Excel 2010 doesn't look like the diagram above, here's how to change it!
The way you do this is different in Excel 2007 - see this blog for instructions.
Displaying the Developer Tab on the Ribbon
To display the Developer tab, first choose to customise the ribbon:
Right-click on the Quick Access toolbar at the top left corner of Excel, and choose to customise the ribbon as shown here
You can now tick to display the Developer tab:
Tick the box to display the Developer tab (note that you have much more control over what to display than in Excel 2007)
You should now see the Developer tab on the ribbon!