Find & Select in Excel

How to Copy Visible Cells Only in Excel

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, in the Editing group,… read more »

Advanced Find Features in Excel

This chapter teaches how to incorporate special characters with find option. A question mark (?) matches exactly one character. For example, F?rrari will find Ferrari, Forrari, Farrari, etc. An asterisk (*) matches a series of zero or more characters. For example, F*rrari will find Ferrari, Foorrari, Faaaaaarrari, etc. To access some more advanced find features in Excel, execute the… read more »

Delete Blank Rows at Once in Excel

When you have empty rows cluttering your spreadsheet and you need to tighten it up, easy and fast? Removing blank rows is the first thing you should do! This example teaches you how to delete blank rows or rows that contain blank cells. 1. On the Home tab, in the Editing group, click Find & Select. 2…. read more »

Quickly Highlight Cells Containing Different Content in a Row

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… read more »

Find, Select, Replace and Go To Special in Excel

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 tab,… read more »