View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KKal KKal is offline
external usenet poster
 
Posts: 1
Default gray area in spreadsheet

Try to unfreeze the window panes WINDOW|UNFREEZE PANES

Or to edit formula in cell, you can use CTRL-G, then type in the reference
for the cell...eg. A1 or B1...to get to cell.

"twototango" wrote:

no, its like nothing exists. looks like print area set then everything else
removed. cleared print area and still nothing comes back. formula in cell
show reference to cell outside of displayed range. i can't get to that cell
to change formula.

"FSt1" wrote:

hi
then check for color.
if the areas are not hidden then you should be able to click in dark areas
and get a curser outline. can't do that with hidden areas. high light the
areas and set back color to no color.

regards
FSt1

"twototango" wrote:

Rows and columns are not hidden.

"FSt1" wrote:

hi
check to see if rows and columns are hidden.
on the menu bar...
formatrowunhide
formatcolumnunhide.

Regards
FSt1
"twototango" wrote:

I need to view columns and rows in an exiting spreadsheet that only has the
range of A1:I24. The rest of the area is gray with no column or row
references. I removed page breaks, am viewing in normal mode, removed print
area and I still cannot view the rest of the worksheet. Any ideas?