how do i undo greyed out areas in a sheet

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Hi
It sounds like you are in Page Break Preview. To switch it back go to View
and click on Normal.

Andy.
 
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

separate Undo for each sheet in a workbook 3
The Sheet-Rename feature is greyed-out in my Excel 2003 workbook.. 1
External Data Toolbar permanently greyed out. 7
Chart Area Expansion 3
trying to draw a text box, but options are grey 1
Series fill only copying and fill series greyed out 1
I want to print comments and the section is greyed out 2
UNDO - not available 3

Back
Top