| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I SHOW ONLY THE CELLS USED IN THE WORKSHEET INSTEAD OF THE.
When I write a worksheet, can I get excel to only show the cells used in the
worksheet instead of the whole horizontal and vertical lines of unused cells? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I SHOW ONLY THE CELLS USED IN THE WORKSHEET INSTEAD OF THE.
DanW
The easiest way is to "Hide" them. Select the first row you want to hide, press "Shift then ctrl then the right arrow. This should select all columns to the right of you project. Right click and select "Hide" (or gotoformatcloumnhide) Do the same thing with the rows but of course make the proper adjustments in the instructions. Mike Rogers "DanW" wrote: When I write a worksheet, can I get excel to only show the cells used in the worksheet instead of the whole horizontal and vertical lines of unused cells? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I SHOW ONLY THE CELLS USED IN THE WORKSHEET INSTEAD OF THE.
DanW
Boy !!!! I made that difficult!!! Select the first COLUMN you want to hide. then I think you can figure it out from there!! Sorry....<bg Mike Rogers "DanW" wrote: When I write a worksheet, can I get excel to only show the cells used in the worksheet instead of the whole horizontal and vertical lines of unused cells? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show the query name in the worksheet over the data cells | Excel Discussion (Misc queries) | |||
| how can I filter a worksheet to only show cells with certain terms in them? | Excel Discussion (Misc queries) | |||
| Shaded cells on a worksheet but do not show up on printed copy? | Excel Worksheet Functions | |||
| I want to show all comments on cells in one cell in the worksheet | Excel Worksheet Functions | |||
| How do I show protected cells in an EXCEL worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
