To find cells with certain formatting, press the Ctrl + F shortcut to open the Find and Replace dialog, click Options, then click the Format button in the upper right corner, and define your selections in Excel Find Format dialog box. Excel 2010's Find and Replace feature can be a powerful tool. Use Find and Replace to search for — and optionally replace — text or values in a worksheet.
Almond said I just converted from Excel 2010 to 2013, and the rest of my group (we all work in the same files) is still in 2010. It seems that a lot of things (such as comments and formatting styles) are no longer working correctly.
One thing I use all the time is Find and Replace within formulas to change references to workbooks, tabs, etc. To ensure an exact match, I do this by copying the the reference I want to change from a formula and pasting it in to the Find and Replace box, but I’m now getting the “We can’t find what you’re looking for” message. I have the cells with the offending text selected. I have the “Look in: Formulas” option set.
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.