| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How To Select Blank Cells within a worksheet
How would I select blank cells within a worksheet?
Somebody told me the steps are Edit Go to Special (under the menu option) But when I did this all of the Blank cells were not selected, but most were. Thank you for any help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How To Select Blank Cells within a worksheet
You might want to try this variation:
Click in an area where your data is, then F5 (same as Edit | GoTo) then click Special then click Current Region. Then F5 again, Special, Blanks. Hope this helps. Pete On Jul 11, 6:46 pm, Roxanne wrote: How would I select blank cells within a worksheet? Somebody told me the steps are Edit Go to Special (under the menu option) But when I did this all of the Blank cells were not selected, but most were. Thank you for any help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How To Select Blank Cells within a worksheet
Roxanne
That command will select blank cells only in the used range of the sheet, not the entire sheet. Gord Dibben MS Excel MVP On Wed, 11 Jul 2007 10:46:02 -0700, Roxanne wrote: How would I select blank cells within a worksheet? Somebody told me the steps are Edit Go to Special (under the menu option) But when I did this all of the Blank cells were not selected, but most were. Thank you for any help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How To Select Blank Cells within a worksheet
Thank you very much! "Gord Dibben" wrote: Roxanne That command will select blank cells only in the used range of the sheet, not the entire sheet. Gord Dibben MS Excel MVP On Wed, 11 Jul 2007 10:46:02 -0700, Roxanne wrote: How would I select blank cells within a worksheet? Somebody told me the steps are Edit Go to Special (under the menu option) But when I did this all of the Blank cells were not selected, but most were. Thank you for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exporting a worksheet with blank/empty cells | Excel Discussion (Misc queries) | |||
| Select NON blank cells | New Users to Excel | |||
| need a macro select all cells in a worksheet? | Excel Discussion (Misc queries) | |||
| Want macro to select & copy cells from a different worksheet | Excel Discussion (Misc queries) | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
Linear Mode
