Hi-Have several columns across, one being a date column. I have a BOGO (buy
one get one free program). The date column is left blank until that item is
shipped and when it is shipped, I enter the date.
It is getting rather bulky and I would like to "hide" the dates that appear
there but want to check them upon occasion.
What is the best way for me to do this (keeping in mind I am a newbie) and
need instructions as well.
Thanks!

You could select the column then Right click and select Hide

"Terri" wrote:

Hi-Have several columns across, one being a date column. I have a BOGO (buy
one get one free program). The date column is left blank until that item is
shipped and when it is shipped, I enter the date.
It is getting rather bulky and I would like to "hide" the dates that appear
there but want to check them upon occasion.
What is the best way for me to do this (keeping in mind I am a newbie) and
need instructions as well.
Thanks!

Terri

Just to add to Arnie's suggestion, if you need to "unhide" them you will
select the columns on both sides of the hiden one (ones), right click and
select "unhide" from the drop down menu.

Mike Rogers

"Terri" wrote:

Hi-Have several columns across, one being a date column. I have a BOGO (buy
one get one free program). The date column is left blank until that item is
shipped and when it is shipped, I enter the date.
It is getting rather bulky and I would like to "hide" the dates that appear
there but want to check them upon occasion.
What is the best way for me to do this (keeping in mind I am a newbie) and
need instructions as well.
Thanks!

Can't do that because some I want hidden in that column and some I don't.
The ones with dates are to be hidden and the ones with blanks are not to be
hidden!

"Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message
...
Terri

Just to add to Arnie's suggestion, if you need to "unhide" them you will
select the columns on both sides of the hiden one (ones), right click and
select "unhide" from the drop down menu.

Mike Rogers

"Terri" wrote:

Hi-Have several columns across, one being a date column. I have a BOGO
(buy
one get one free program). The date column is left blank until that item
is
shipped and when it is shipped, I enter the date.
It is getting rather bulky and I would like to "hide" the dates that
appear
there but want to check them upon occasion.
What is the best way for me to do this (keeping in mind I am a newbie)
and
need instructions as well.
Thanks!

You cannot hide just some cells in a column or row.

You can hide entire columns or rows.

Maybe hide the rows where the dates appear?

That would hide the entire row, of course.


Gord Dibben MS Excel MVP

On Thu, 21 Feb 2008 12:13:29 -0500, "Terri" wrote:

Can't do that because some I want hidden in that column and some I don't.
The ones with dates are to be hidden and the ones with blanks are not to be
hidden!

"Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message
...
Terri

Just to add to Arnie's suggestion, if you need to "unhide" them you will
select the columns on both sides of the hiden one (ones), right click and
select "unhide" from the drop down menu.

Mike Rogers

"Terri" wrote:

Hi-Have several columns across, one being a date column. I have a BOGO
(buy
one get one free program). The date column is left blank until that item
is
shipped and when it is shipped, I enter the date.
It is getting rather bulky and I would like to "hide" the dates that
appear
there but want to check them upon occasion.
What is the best way for me to do this (keeping in mind I am a newbie)
and
need instructions as well.
Thanks!

Hi Terri,

Maybe Conditional Formatting will do it for you.

Say your dates are in F2 down.
Highlight F2 to say F100 or however far down you need.
Go to FormatConditional Formatting.
Select 'Formula is' from the dropdown
Put this formula in the next box
=$F$1=1
Click on the Format button and set the font color to white.
OK out and OK again.

Now if you put a 1 in F1 all of your dates will be hidden
Delete the 1 to view them again.
If the dates are hidden and you put a new date in
it will hide as soon as you hit enter.

HTH
Martin




"Terri" wrote in message
...
Can't do that because some I want hidden in that column and some I don't.
The ones with dates are to be hidden and the ones with blanks are not to
be hidden!

"Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message
...
Terri

Just to add to Arnie's suggestion, if you need to "unhide" them you will
select the columns on both sides of the hiden one (ones), right click and
select "unhide" from the drop down menu.

Mike Rogers

"Terri" wrote:

Hi-Have several columns across, one being a date column. I have a BOGO
(buy
one get one free program). The date column is left blank until that item
is
shipped and when it is shipped, I enter the date.
It is getting rather bulky and I would like to "hide" the dates that
appear
there but want to check them upon occasion.
What is the best way for me to do this (keeping in mind I am a newbie)
and
need instructions as well.
Thanks!

Ok - If I hide the row, is there any way to UNHIDE ALL or do I have to go to
each one separately and unhide them.


"MartinW" wrote in message
...
Hi Terri,

Maybe Conditional Formatting will do it for you.

Say your dates are in F2 down.
Highlight F2 to say F100 or however far down you need.
Go to FormatConditional Formatting.
Select 'Formula is' from the dropdown
Put this formula in the next box
=$F$1=1
Click on the Format button and set the font color to white.
OK out and OK again.

Now if you put a 1 in F1 all of your dates will be hidden
Delete the 1 to view them again.
If the dates are hidden and you put a new date in
it will hide as soon as you hit enter.

HTH
Martin




"Terri" wrote in message
...
Can't do that because some I want hidden in that column and some I don't.
The ones with dates are to be hidden and the ones with blanks are not to
be hidden!

"Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message
...
Terri

Just to add to Arnie's suggestion, if you need to "unhide" them you will
select the columns on both sides of the hiden one (ones), right click
and
select "unhide" from the drop down menu.

Mike Rogers

"Terri" wrote:

Hi-Have several columns across, one being a date column. I have a BOGO
(buy
one get one free program). The date column is left blank until that
item is
shipped and when it is shipped, I enter the date.
It is getting rather bulky and I would like to "hide" the dates that
appear
there but want to check them upon occasion.
What is the best way for me to do this (keeping in mind I am a newbie)
and
need instructions as well.
Thanks!

Hi Terry
See sample attached to the link below, you have a sample of a Conditional
Formatting & Data list

http://www.savefile.com/projects/808607562


"Terri" wrote in message
...
Ok - If I hide the row, is there any way to UNHIDE ALL or do I have to go
to each one separately and unhide them.


"MartinW" wrote in message
...
Hi Terri,

Maybe Conditional Formatting will do it for you.

Say your dates are in F2 down.
Highlight F2 to say F100 or however far down you need.
Go to FormatConditional Formatting.
Select 'Formula is' from the dropdown
Put this formula in the next box
=$F$1=1
Click on the Format button and set the font color to white.
OK out and OK again.

Now if you put a 1 in F1 all of your dates will be hidden
Delete the 1 to view them again.
If the dates are hidden and you put a new date in
it will hide as soon as you hit enter.

HTH
Martin




"Terri" wrote in message
...
Can't do that because some I want hidden in that column and some I
don't. The ones with dates are to be hidden and the ones with blanks are
not to be hidden!

"Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message
...
Terri

Just to add to Arnie's suggestion, if you need to "unhide" them you
will
select the columns on both sides of the hiden one (ones), right click
and
select "unhide" from the drop down menu.

Mike Rogers

"Terri" wrote:

Hi-Have several columns across, one being a date column. I have a BOGO
(buy
one get one free program). The date column is left blank until that
item is
shipped and when it is shipped, I enter the date.
It is getting rather bulky and I would like to "hide" the dates that
appear
there but want to check them upon occasion.
What is the best way for me to do this (keeping in mind I am a newbie)
and
need instructions as well.
Thanks!

Do you want to hide the rows or just CF to make them look blank?

CF will not hide rows.

You need event code or a macro to hide rows automatically by value.

Alternatively you could use autofilter to hide non-blank rows.

There are several ways to do this but your original post said your sheet was
getting bulky and wanted the cells with dates hidden.

You can't hide just some cells in a row or column.

Entire rows and columns must be hidden.

If you do hide them, hit CTRL + a(twice in 2003) and FormatRowUnhide.

Maybe make a couple of custom views..........one with hidden rows and one with
unhidden rows.


Gord Dibben MS Excel MVP

On Fri, 22 Feb 2008 07:34:04 -0500, "Terri" wrote:

Ok - If I hide the row, is there any way to UNHIDE ALL or do I have to go to
each one separately and unhide them.


"MartinW" wrote in message
...
Hi Terri,

Maybe Conditional Formatting will do it for you.

Say your dates are in F2 down.
Highlight F2 to say F100 or however far down you need.
Go to FormatConditional Formatting.
Select 'Formula is' from the dropdown
Put this formula in the next box
=$F$1=1
Click on the Format button and set the font color to white.
OK out and OK again.

Now if you put a 1 in F1 all of your dates will be hidden
Delete the 1 to view them again.
If the dates are hidden and you put a new date in
it will hide as soon as you hit enter.

HTH
Martin




"Terri" wrote in message
...
Can't do that because some I want hidden in that column and some I don't.
The ones with dates are to be hidden and the ones with blanks are not to
be hidden!

"Mike Rogers" <Mike060349@NoxSpamxAOLDOTcom wrote in message
...
Terri

Just to add to Arnie's suggestion, if you need to "unhide" them you will
select the columns on both sides of the hiden one (ones), right click
and
select "unhide" from the drop down menu.

Mike Rogers

"Terri" wrote:

Hi-Have several columns across, one being a date column. I have a BOGO
(buy
one get one free program). The date column is left blank until that
item is
shipped and when it is shipped, I enter the date.
It is getting rather bulky and I would like to "hide" the dates that
appear
there but want to check them upon occasion.
What is the best way for me to do this (keeping in mind I am a newbie)
and
need instructions as well.
Thanks!