To access some more advanced find features in Excel, execute the following steps. Click on Options in the 'Find and Replace' dialog box. Type the text you want to find. For example, type Ferrari. Select Workbook from the Within drop-down list to find occurrences across all the worksheets.
By Before you can enter your worksheet data in Microsoft Office Excel 2010, you must know how to select cells in a worksheet. The cell cursor is a black border that surrounds the active cell (sometimes called the current cell) in a worksheet.
![Find and select excel vba Find and select excel vba](/uploads/1/2/5/3/125350506/526295476.png)
The Name box at the left end of the Formula bar displays the cell address — the active cell location. Columns display letters from A to XFD and rows display numbers from 1 to 1048576. A cell address is the intersection of a column and a row, such as D23 or AB205. Move the cell cursor to an adjacent cell by pressing the arrow keys.
![Find and select duplicates excel Find and select duplicates excel](/uploads/1/2/5/3/125350506/226687238.jpg)
You also can press the Enter key to move down one cell or the Tab key to move one cell to the right. Click the mouse pointer on any cell to move the cell cursor to that cell. Type the cell address in the Name box and press Enter. Press Ctrl+Home to jump to cell A1.
Press Ctrl+End to jump to the lower-right cell of the worksheet. Use the Go To feature to quickly jump to a specified cell in the worksheet. Press F5 to display the Go To dialog box, type the cell address (such as G213) in the Reference box, and click OK. Specify a cell address in the Go To dialog box. Selecting multiple cells You may want to select multiple cells in a worksheet (sometimes called a range of cells) in order to confine data entry to those cells or to format all of the selected cells at one time. Use any of these methods to select multiple cells in a worksheet:. To select a single entire column, click a column heading — that is, the letter or letters that indicate the column.
To select multiple columns, drag across multiple column headings. To select a single entire row, click the row number.
To select multiple rows, drag across multiple row numbers. To select sequential cells, click the first cell, hold down the Shift key, and click the last cell you want. Optionally, click and drag the mouse over a group of cells to select a sequential area.