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.

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.

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.

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

"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.

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.
--
David Biddulph

"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.

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

"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.