Hiding Cells

[McNiwram]

How do you hide cells without having to hide the entire
column or rows?

 

[Norman Harker]

Hi McNiwram!

You can hide the contents by formatting the font the same color as the
background. You can hide formulas in the formula bar by using:

Format > Cells > Protection
Place check against "Hidden"
OK
Note that this doesn't come into effect until the worksheet is protected
using the Tools menu.

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[McNiwram]

Thanks Norman but I actually know that already. In fact,
that's how I've been doing it. To rephrase my original
question...

In excel, we can hide an entire column or row thus hiding
all the cells in those areas. If I had a group of
information in a worksheet and they were grouped by tables
(perhaps separated by a row each), how can I hide columns
in group A (top table) without affecting group B (just
below it).

2 tables:

 

[Lady Layla]

You can't.

: Thanks Norman but I actually know that already. In fact,
: that's how I've been doing it. To rephrase my original
: question...
:
: In excel, we can hide an entire column or row thus hiding
: all the cells in those areas. If I had a group of
: information in a worksheet and they were grouped by tables
: (perhaps separated by a row each), how can I hide columns
: in group A (top table) without affecting group B (just
: below it).
:
: 2 tables:
: ------------------------------------------------
: | | | | | | |
: ------------------------------------------------
:
: ------------------------------------------------
: | | | | | | |
: ------------------------------------------------
:
: 2 tables with top table cells shorter (because I want to
: hide columns):
:
: ----------------------------------------
: | | | | | |
: ----------------------------------------
:
: -------------------------------------------------
: | | | | | | |
: --------------------------------------------------
: