In which case record a macro to do what I said.
--
David Biddulph

"dford" wrote in message
...
I would like to create a macro that says: If cell A3, A5, A7, and A10 are
blank, then hide those rows. Cell A1, A2, A4, A6, A8, and A9 COULD be
blank
but don't do anything with them.

"David Biddulph" wrote:

I'm sorry, I don't understand. How are you selecting them, other than
the
means by which I suggested?

"dford" wrote in message
...
The only problem is I don't want to do this manually. I want to hide
the
rows
of only some blank cells in the column. Others in the same column can
be
blank but I don't want to hide them. I only want to hide the rows of
cells
in
the column that I have selected and they are blank.

"David Biddulph" wrote:

Hold down the control key while you select the group of rows, then
right-click/ Hide.

"dford" wrote in message
...
I understand what you are saying. However I don't want to hide the
rows
of
all the blank cells. Just selected ones.

"JLatham" wrote:

One way would be to use data filtering - click the 'A' column
indicator
at
the top of the column, then from the menu bar, choose
Data | Filtering | Auto Filter
then use the drop-down list that will appear as part of the first
cell
and
look for the entry that says "Non Blanks" - click that and all rows
with
empty cells in column A will be hidden. To get them back either
turn
Auto
Filtering off, or choose [All] from the drop down.

Another way is to again choose column A and then use
Edit | Find and click the [Special] button and choose the [Blanks]
option.
After those are chosen, use Format | Rows | Hide and again the rows
with
blanks in column A will be hidden. To get them back from this
setup,
choose
any column (but A would seem the logical choice) and Format | Rows
|
Unhide.

Hope this helps some.

"dford" wrote:

How can I hide rows of cells that are blank. Example cell A3, A5,
A7,
A10 are
blank. I want to hide those rows. There are othere cells in
Column A
that are
blank but I dont want to hide those rows.