Create a new theme color. On the Design tab, click the arrow under Variants, and point to Colors. Click Customize Colors. Click a color box that you want to change. For example, Accent 1. Click a new color in the Colors dialog box.
Mar 30, 2017 - Office 2016 for Mac allows you to change the Color Theme between a few. Will apply to all Office 2016 for Mac apps including Word, Excel,. In Microsoft Excel for Mac 2011 (14.0.0) how can I modify the enter/return key to edit in cell instead of moving the selection down? I know that in Preferences > Edit you can uncheck the box that says 'After pressing RETURN, move selection [Down/Right/Up/Left]' which at least makes it a little less annoying, but this behaviour is still not productive.
Repeat steps 3 and 4 for each color you want to change. Close the Colors dialog box. In the Name box, type a name for your custom theme color, and then click Save. The theme color is applied to the current presentation. Apply your new theme color to a new document.
On the Design tab, click the arrow under Variants, point to Colors, and then click the name of the theme color you created. Delete a custom theme color. In the Mac OS X Finder, find your custom theme color in /Users/ Username/Library/Application Support/Microsoft/Office/User Templates/My Themes/Theme Colors. Drag the file with your custom theme color — for example, Custom 1.xml — to the Trash. Do any of the following: Create a new theme color. On the Themes tab, under Theme Options, click Colors, and then click Create Theme Colors. Click a color that you want to change, and then click Change Color.
Click a color that you want, and then click OK. Repeat steps 2 and 3 for each color that you want to change. In the Name box, type a name for your custom theme color, and then click Apply to All.
The theme color is applied to the current presentation. Apply your new theme color to a new document.
On the Themes tab, under Theme Options, click Colors, and then click the theme color that you created. Delete a custom theme color. In the Mac OS X Finder, find your custom theme color in /Users/ Username/Library/Application Support/Microsoft/Office/User Templates/My Themes/Theme Colors.
Drag the file with your custom theme color — for example, Custom 1.xml — to the Trash.
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). I’ve even got some nifty pictures to speed along that understanding. Note: The Ribbons in Excel 2010 and 2007 (Windows) are interchangeable, but I’ll only refer to 2010 below. Each Ribbon Tab in Excel is organized by Groups. In Excel 2010 the Groups are shown at the bottom of the Ribbon. In Excel 2011 the Groups appear at the top, which I prefer. The Excel 2010 Home Tab The Excel 2010 Home Tab has the following Groups: Clipboard, Font, Alignment, Number, Styles, Cells, and Editing.
The Excel 2011 Home Tab The Excel 2011 Home Tab has the following Groups: Edit, Font, Alignment, Number, Format, Cells, Themes. Similar Items on Both Home Tabs The Font and Number Groups have the same items so there’s no need to review them. 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. Items You Have to Hunt For in Excel 2011 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.
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. The Clipboard Group From left to right, the Paste icon is the first thing you see on the Excel 2010 Home tab. It resides in the Clipboard Group. Luckily the Paste icon is located in the same position on the Excel 2011 Home tab, but in the Edit Group. 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. The Editing 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 Fill and Clear icons can be found in the Edit Group. AutoSum is located on the Tab in the Function Group. 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. 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 Search and Replace. 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.
As 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. This is a lot easier than hunting them each time. The Styles Group In Excel 2010 the Styles Group mostly corresponds to the Format Group in Excel 2011.
![For For](/uploads/1/2/5/4/125429890/434812065.png)
The Format As Table icon in Excel 2010 is located on the Tables Tab in the Table Styles Group in Excel 2011. Summary 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. 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. 26 thoughts on “ Ribbon Home Tab Comparison – Excel 2010 Windows and 2011 Mac”. Emily Hi quick Q if you have a minute – Is the styles group a special add-in you have to activate somehow?
I cannot for the life of me figure out why I cannot see the “styles” group on the home tab – I have tried adding “customize ribbon” buttons for the buttons that Should be on the styles tab, and I don’t even see the buttons (eg conditional formatting, format as table etc) as options! Any thoughts would be most helpful, thanks very much!. Post author The Styles group on the Home tab of the Excel 2010 Ribbon is standard. If it’s missing then choose File Options and click Customize Ribbon in the Left Pane. In the right-side box click the plus sign for Home and see if there is a Styles group in the list. If so, then it’s on the Home tab.
If not, then select All Tabs from the left-side drop-down list for “Choose commands from:” Then look for Styles and add it to the right-side box with the Add button. If it’s truly gone you might have to uninstall Excel 2010 and re-install.
You may have had a glitch on the install. Ethan Pasternack Here’s another quick question – I always used to be able to find/replace within a selection, but now I can’t – only within the sheet or workbook. I have Office Mac 2011, but past versions I’ve used in the past year (the timeframe I remember being able to perform this function) include Mac 2008 and PC 2010. Did they move this feature somewhere else, or did they remove it in 2011 Mac?
I can’t find anybody mentioning it in google searches, but I can’t be the only person who wants to be able to find/replace inside a selection Thanks for any help you can offer!