Search Box

This example teaches you how to create your own search box in Excel. If you are in a hurry, simply download the Excel file. This is what the spreadsheet looks like. If you enter a search query into cell B2, Excel searches through column E and the results appear in column B. To create this […]

Copy Visible Cells Only

By default, Excel copies both visible and hidden cells. However, it is possible to copy visible cells only. In this example, row 2 is hidden. When you copy/paste this range, this is the result: To copy visible cells only, execute the following easy steps. 1. Select the range A1:A4. 2. On the Home tab, click […]

Row Differences

This example teaches you how to quickly highlight cells whose contents are different from the comparison cell in each row. 1. To select the range A1:C15, click on cell A1 and drag it to cell C15. Note: because we selected the range A1:C15 by clicking on cell A1 first, cell A1 is the active cell […]

Delete Blank Rows

This example teaches you how to delete blank rows or rows that contain blank cells. 1. On the Home tab, click Find & Select, Go To Special… 2. Select Blanks and click OK. Excel selects the blank cells. 3. On the Home tab, click Delete, Delete Sheet Rows Result:

Find Features

o access some more advanced find features in Excel, execute the following steps. 1. Click on Options in the ‘Find and Replace’ dialog box. 2. Type the text you want to find. For example, type Ferrari. 3. Select Workbook from the Within drop-down list to find occurrences across all the worksheets. 4. Checking “Match case” […]

Find & Select

You can use Excel’s Find and Replace feature to quickly find specific text and replace it with other text. You can use Excel’s Go To Special feature to quickly select all cells with formulas, comments, conditional formatting, constants, data validation, etc. Find To quickly find specific text, execute the following steps. 1. On the Home […]