Hiding Cells

N

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
M

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:
 
L

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):
:
: ----------------------------------------
: | | | | | |
: ----------------------------------------
:
: -------------------------------------------------
: | | | | | | |
: --------------------------------------------------
:
 
Top