When it is enabled, it exists in the Excel ribbon, along with all the other Excel tabs. The ‘Developer’ tab is built-in but hidden by default. The Developer tab is a feature that gives you quick access to certain advanced features and allows you to perform certain advanced tasks in Excel (such as interactive controls to VBA programming).
#Add developer tab excel for mac how to#
#Add developer tab excel for mac windows#
Hopefully this little summary with pictures is a help to those of you who, like me, get frustrated with Excel for making things so different between Windows and Mac. The first time you use the Excel 2011 Ribbon Home Tab can be a trying experience if you’ve just come over from Excel 2010 or 2007. The Format As Table icon in Excel 2010 is located on the Tables Tab in the Table Styles Group in Excel 2011. In Excel 2010 the Styles Group mostly corresponds to the Format Group in Excel 2011. This is a lot easier than hunting them each time. In Excel 2011 you can find Sort and Filter on the Data menu, and Find can be found on the Edit menu but all of these are less than optimal because they take you away from the Home tab and require more clicks on the mouse or taps on the trackpad than are necessary.Īs you can see in the Editing Group picture above, I’ve added AutoSum, Sort, and Filter icons to the Standard Toolbar to make these functions only one click away. The Find & Select icon is not on the Excel 2011 Ribbon but located on the right side above the toolbar in a different format: the Search in Sheet box, which has a drop-down button that will bring up options for Advanced Search and Replace. Sort & Filter exists as two separate icons in Excel 2011 and are located on the Data Tab in the Sort & Filter Group with an icon for Sort and one for Filter. AutoSum is located on the Formulas Tab in the Function Group. The Fill and Clear icons can be found in the Edit Group. The Editing Group items are a mixed bag that can be hard to find in Excel 2011 unless you add some toolbar icons to the Standard Toolbar. The other items in the Clipboard group - Cut, Copy, Format Painter - don’t have a counterpart in the Excel 2011 Ribbon, but rather you can find them on the Standard Toolbar. Luckily the Paste icon is located in the same position on the Excel 2011 Home tab, but in the Edit Group. The Clipboard Groupįrom left to right, the Paste icon is the first thing you see on the Excel 2010 Home tab. Note: The Themes Group in Excel 2011 doesn’t exist on the Home Tab in Excel 2010, but can be found on the Page Layout Tab. I’ll review each item on the Excel 2010 Clipboard and Editing Groups, which have items located on the Edit Group and elsewhere in Excel 2011, and finish up with the Styles Group that relates to the Format Group. The Alignment and Cells Groups have the same items, and although there is some variation in the underlying drop-down options I won’t cover them in this post. The Font and Number Groups have the same items so there’s no need to review them. The Excel 2011 Home Tab has the following Groups: Edit, Font, Alignment, Number, Format, Cells, Themes. The Excel 2010 Home Tab has the following Groups: Clipboard, Font, Alignment, Number, Styles, Cells, and Editing. In Excel 2011 the Groups appear at the top, which I prefer.
In Excel 2010 the Groups are shown at the bottom of the Ribbon. Note: The Ribbons in Excel 20 (Windows) are interchangeable, but I’ll only refer to 2010 below.Įach Ribbon Tab in Excel is organized by Groups. I’ve even got some nifty pictures to speed along that understanding. I’ll review each hard-to-find item on the Ribbon’s Home Tab in Excel 2010 (Windows) and let you know where they are located in Excel 2011 (Mac).
0 kommentar(er)
