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.