When you use Excel to edit data, you may need to select a range of cells surrounding the active cell in a worksheet. You may also want to just select the filled cells that are not empty in the range. This article will tell you some methods of how to select a range of cells that meet your needs in an excel worksheet easily and quickly.
1. How To Select Current Range Cells.
1.1 What Are Current Range Cell & Isolated Cell?
- The current range cells are excel cells which are a block of continuous cells.
- The current range cell’s edges are the first empty rows and columns (or the entire worksheet borders) around the selected cell.
- If a cell is surrounded by empty rows and columns, then this cell is an isolated cell.
1.2 How To Select The Current Range Cells?
- Select one cell in the current range cells.
- Then press Ctrl + A to select the current range cells.
- Press Ctrl + A again, and it will select all cells in the current worksheet.
- If you focus on an isolated cell that means all the cells around it are empty cells.
- Then when you press the Ctrl + A key, it will select the entire worksheet cells also.
2. How To Select Not Empty Excel Cells Only In A Range.
- First, select a range of Excel cells, if you want to do this on the entire worksheet, then you should select the entire worksheet.
- Then click Home —> Find & Select —> Find in Excel ribbon Home tab, Editing group.
- Then it will open the Find and Replace dialog.
- Input the character string ( * for match all not empty string) in the Find what input text box.
- Click the Find All button, then it will list all the search results in the result list below the Find All button.
- Press Ctrl + A to select all the search results in the list.
- Click the Close button to close the Find and Replace dialog.
- Now you will find the matched cells are all selected in the selected range.
