Hints and tips home » Excel hints and tips » Select blank cells automatically
Select blank cells automatically
Get Excel to find any blank (empty) cells in a region for you by:
1. Selecting the appropriate region from your spreadsheet.
2. On the menu bar, go to Edit - Go to.
3. Click the 'Special' button, then select Blanks and click OK.
Added by Amanda on 23rd November 2006
More Excel hints and tips, like:
- Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines
- How to apply the same formatting and data to multiple sheets at the same time in Excel 2010
- Recently used file list
|
» Forum post: MS Project |



Course updates

