M
McNiwram
How do you hide cells without having to hide the entire
column or rows?
column or rows?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
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.
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:
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):
:
: ----------------------------------------
: | | | | | |
: ----------------------------------------
:
: -------------------------------------------------
: | | | | | | |
: --------------------------------------------------
:
: 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):
:
: ----------------------------------------
: | | | | | |
: ----------------------------------------
:
: -------------------------------------------------
: | | | | | | |
: --------------------------------------------------
: