Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format spreadsheet so that it only has a few rows and columns
I have seen an EXCEL 2007 spreadsheet that only has rows 2 - 6 and columns A
- F. If you use the arrows it doesn't go anywhere at all except within those boundaries. The other parts of the screen past these boundaries are in the default MS window colour of blue and there are no gridlines. How can I duplicate this effect? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format spreadsheet so that it only has a few rows and columns
Hide the rows and columns you don't want to use.
To select columns select the one to right of your desired used range. CTRL + SHIFT + RightArrow selects all. Right-click and "Hide" Same for rows below your desired range. CTRL + SHIFT + DownArrow Gord Dibben MS Excel MVP On Tue, 22 Dec 2009 15:32:01 -0800, ogerriz wrote: I have seen an EXCEL 2007 spreadsheet that only has rows 2 - 6 and columns A - F. If you use the arrows it doesn't go anywhere at all except within those boundaries. The other parts of the screen past these boundaries are in the default MS window colour of blue and there are no gridlines. How can I duplicate this effect? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format spreadsheet so that it only has a few rows and columns
hi
guessing but it sounds like your speadsheet has hidden rows and columns. select and hide all columns to the left of your data area. select and hide all rows below your data area. that should do it. regards FSt1 "ogerriz" wrote: I have seen an EXCEL 2007 spreadsheet that only has rows 2 - 6 and columns A - F. If you use the arrows it doesn't go anywhere at all except within those boundaries. The other parts of the screen past these boundaries are in the default MS window colour of blue and there are no gridlines. How can I duplicate this effect? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format spreadsheet so that it only has a few rows and columns
Thanks that did it - sorry for the stupid question but if I want to bring
back all those hidden rows and columns what do I do? I tried going to the space between column A & row 1 then right-clicking but UNHIDE doesn't seem to come up. "FSt1" wrote: hi guessing but it sounds like your speadsheet has hidden rows and columns. select and hide all columns to the left of your data area. select and hide all rows below your data area. that should do it. regards FSt1 "ogerriz" wrote: I have seen an EXCEL 2007 spreadsheet that only has rows 2 - 6 and columns A - F. If you use the arrows it doesn't go anywhere at all except within those boundaries. The other parts of the screen past these boundaries are in the default MS window colour of blue and there are no gridlines. How can I duplicate this effect? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format spreadsheet so that it only has a few rows and columns
hi
if you don't know then no question is stupid. asking questions is how we learn. to unhide..... 2003..... select the sheet ie click the small square in the upper left where column A & row 1 meet. then on the menu barformatcolumnsunhide do the same for rows. 2007.... select the sheet..see above... home tabFormathide&unhidecolumns do the same for rows. that should do it. Regards FSt1 "ogerriz" wrote: Thanks that did it - sorry for the stupid question but if I want to bring back all those hidden rows and columns what do I do? I tried going to the space between column A & row 1 then right-clicking but UNHIDE doesn't seem to come up. "FSt1" wrote: hi guessing but it sounds like your speadsheet has hidden rows and columns. select and hide all columns to the left of your data area. select and hide all rows below your data area. that should do it. regards FSt1 "ogerriz" wrote: I have seen an EXCEL 2007 spreadsheet that only has rows 2 - 6 and columns A - F. If you use the arrows it doesn't go anywhere at all except within those boundaries. The other parts of the screen past these boundaries are in the default MS window colour of blue and there are no gridlines. How can I duplicate this effect? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Columns to rows in a spreadsheet | Excel Discussion (Misc queries) | |||
Can I format columns to move across a spreadsheet? | Excel Discussion (Misc queries) | |||
rotate rows and columns in a spreadsheet | Excel Discussion (Misc queries) | |||
How do I get to print my spreadsheet (8 columns x 100 rows) on an. | Excel Discussion (Misc queries) | |||
Using PROPER for Columns, rows or ENTIRE spreadsheet | Excel Worksheet Functions |