ExcelHub - Learn Excel Easily

Excel Tip #027 Find And Replace Cell Colors It is common for Excel users to apply background colors to cells, such as green to indicate for positive, red to indicate warning etc. But how to remove the green fill color from hundreds of cells throughout the workbook without having to do them one by one. Steps to Find cells with a specific Fill color      1) Press CTRL+F to open the Find dialog       2) If you don't see the Format button, click the Options>> button       3) Click the Format... button       4) Click each of the tabs (Number, Alignment, Font, Border, Fill and Protection) and, if the Clear button isn't 'grayed out', click it to clear any formatting from the search criteria       5) Click the Fill tab and choose the color you wish to find     6) Click the Find All button. All of the cells with the Fill color you selected will be listed at the bottom of the Find an...

Excel Tip #022 Search Backwards in Excel Sometimes we take some things for granted in Excel and assume that everyone else knows too. Here's a tip which lot of Excel users don't know about it. Many Excel users know that the quickest way to find something in a large worksheet is to use Excel's Find command. On the Home tab, in the Editing group, click Find & Select , then Find or, preferrably, use the keyboard shortcut CTRL+F instead. Each time you click Find Next you will be taken to the next matching cell, starting from the active cell and going down the sheet until you finally come to the last one. But what if you want to find the 'last' matching value in a sheet and there are dozens or even hundreds of matching values? You don't want to click through each one until you finally reach the end. Here's a simple trick that will save you some time. Select a cell below the range you want to search ( CTRL+END is a shortcut you can use to quick...