how do i undo greyed out areas in a sheet

G

Guest

I suddenly see that parts of my sheet has been greyed out without me having
consciously done it. How do I make sheet printable again?
 
G

Guest

Hi
It sounds like you are in Page Break Preview. To switch it back go to View
and click on Normal.

Andy.
 
G

Guest

If 'greyed out' means that rows and/or columns are now hidden, you can click
in the little box above the row numbers (this selects all cells in the
sheet), then press

Ctrl-Shift-9 (unhides all rows)

followed by

Ctrl-Shift-0 (unhides all columns)
 

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

The Sheet-Rename feature is greyed-out in my Excel 2003 workbook.. 1
External Data Toolbar permanently greyed out. 7
Series fill only copying and fill series greyed out 1
Unprotect a Shared Workbook - Option is Greyed Out 1
separate Undo for each sheet in a workbook 3
Unprotecting worksheets 2
functions greyed out/not working 2
trying to draw a text box, but options are grey 1

Top