Hide/unhide

B

Bjorn

Hi,

How does hide/hide work in Excell for e.g. rows ?

When I hide some rows, how can I see where in my sheet hidden rows are ? Is here a marker indicating
hidden rows ?

And can I also unhide row per row, or does "unhide" work for the entire sheet ?

Some help would be nice.

Thxs.
 
B

Bob Phillips

The rows are identifiable by looking at the row numbers along the left, and
see which if any are missing.

You can hide a single row, select the row and goto Format>Row>hide.

HTH

Bob
 
G

Gord Dibben

In addition, if you have several rows hidden and wish to unhide just one of
these..............

Say rows 4 through 12 are hidden.

Type a cell address like A9 in the namebox and hit ENTER then Format>Row>Unhide.

Only that row will be unhidden.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expand and collapse rows 7
rows won't unhide 5
Unable to unhide hidden columns 3
Unhide rows? 1
Hide Print Unhide 1
Hide Unhide Button 4
How to unhide rows....when they won't unhide 7
Row/Column unhide shortcut keys not working in excel 2007 1

Top