| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greyed out area on the spreadhseet
On various occasions, I receive an xl file where I can only view very few
columns & rows, all other are blocked ( solid grey area ). My question how I can make all columns & rows visible, secondly how it was done in the first place ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Greyed out area on the spreadhseet
hello,
- check if the ws is protected. - check if the column and rows are hide - check on view if page break preview are checked hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "zen" escreveu: On various occasions, I receive an xl file where I can only view very few columns & rows, all other are blocked ( solid grey area ). My question how I can make all columns & rows visible, secondly how it was done in the first place ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Greyed out area on the spreadhseet
Maybe the grey area is just colored grey.
Uncolor them. Maybe that area is just Hidden. CTRL + a to select all then FormatColumnUnhide Gord Dibben MS Excel MVP On Wed, 18 Jun 2008 10:46:00 -0700, zen wrote: On various occasions, I receive an xl file where I can only view very few columns & rows, all other are blocked ( solid grey area ). My question how I can make all columns & rows visible, secondly how it was done in the first place ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Greyed out area on the spreadhseet
You know i tried evrything but nothing really worked. The worksheet i have has the first row and the first column completely grey, i cannot see the gridlines or anything. Anymore suggestions ? "zen" wrote: On various occasions, I receive an xl file where I can only view very few columns & rows, all other are blocked ( solid grey area ). My question how I can make all columns & rows visible, secondly how it was done in the first place ? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Greyed out area on the spreadhseet
Tell us what you tried.
You had several suggestions. What does nothing "really" worked mean? Did anything "partly" or "sort of" work? Gord On Thu, 19 Jun 2008 10:56:02 -0700, zen wrote: You know i tried evrything but nothing really worked. The worksheet i have has the first row and the first column completely grey, i cannot see the gridlines or anything. Anymore suggestions ? "zen" wrote: On various occasions, I receive an xl file where I can only view very few columns & rows, all other are blocked ( solid grey area ). My question how I can make all columns & rows visible, secondly how it was done in the first place ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reset Bottom of an Excel spreadhseet | New Users to Excel | |||
| 2 copies of my spreadhseet open! | Excel Worksheet Functions | |||
| how to put the subtotal of the sum and count in one spreadhseet? | Excel Worksheet Functions | |||
| subtotal of sum and count in one spreadhseet? | Excel Worksheet Functions | |||
| Can't print graph with spreadhseet information | Charts and Charting in Excel | |||
Linear Mode
