ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i undo greyed out areas in a sheet (https://www.excelbanter.com/excel-discussion-misc-queries/74346-how-do-i-undo-greyed-out-areas-sheet.html)

lc_craze

how do i undo greyed out areas in a sheet
 
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?


how do i undo greyed out areas in a sheet
 
Hi
It sounds like you are in Page Break Preview. To switch it back go to View
and click on Normal.

Andy.

"lc_craze" wrote in message
...
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?




Duke Carey

how do i undo greyed out areas in a sheet
 
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)


"lc_craze" wrote:

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?


bpeltzer

how do i undo greyed out areas in a sheet
 
File Print Area Clear Print Area

"lc_craze" wrote:

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?



All times are GMT +1. The time now is 11:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com