Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
gray area in spreadsheet
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
gray area in spreadsheet
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
gray area in spreadsheet
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
gray area in spreadsheet
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
gray area in spreadsheet
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
gray area in spreadsheet
hi
rows and columns are hard coded into excel, you cannot increase or decrease them. so it has to be one or the other. hidden or colored. if you have a formula that is referencing a cell out side the white area, the dark area is either hidden or colored. if you cannot click into the dark area, then it's hidden. after reading my first post i think i left out a step. high light the sheet then do formatcolumnunhide. high light the sheet by clicking the small square between the a column header and 1 row header. Regards FSt1 "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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding area codes only to phone numbers missing an area code | Excel Discussion (Misc queries) | |||
Gray area at spreadsheet | New Users to Excel | |||
Gray area on spreadsheet | Excel Discussion (Misc queries) | |||
Eliminate area ranges on a spreadsheet | Excel Discussion (Misc queries) | |||
Why I get gray area in sheet tab of page setup? can't resize area. | Excel Discussion (Misc queries) |