Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Smaller worksheet
Good day,
I am working with Excel 2003. When opening a new worksheet, it has more row & columns then I require for a sheet I am creating. I would like to reduce the size of the worksheet to 14 columns and 150 rows. What would be the best way to do this. Thanks David |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Smaller worksheet
On Mon, 04 Aug 2008 11:51:21 GMT, david wrote:
Good day, I am working with Excel 2003. When opening a new worksheet, it has more row & columns then I require for a sheet I am creating. I would like to reduce the size of the worksheet to 14 columns and 150 rows. What would be the best way to do this. Thanks David The only way I can think of is to hide the rows and columns that you are not using. First mark all rows from 150 to 65536, then right click and Hide The do the similar operation for the columns to the right of column N. Hope this helps / Lars-Åke |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Smaller worksheet
You can hide them using Format Columns/Rows / Hide but not delete them.
Regards Ken.................. "david" wrote in message news:Z2Clk.3784$%b7.129@edtnps82... Good day, I am working with Excel 2003. When opening a new worksheet, it has more row & columns then I require for a sheet I am creating. I would like to reduce the size of the worksheet to 14 columns and 150 rows. What would be the best way to do this. Thanks David |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Smaller worksheet
Ken Wright wrote:
You can hide them using Format Columns/Rows / Hide but not delete them. Regards Ken.................. "david" wrote in message news:Z2Clk.3784$%b7.129@edtnps82... Good day, I am working with Excel 2003. When opening a new worksheet, it has more row & columns then I require for a sheet I am creating. I would like to reduce the size of the worksheet to 14 columns and 150 rows. What would be the best way to do this. Thanks David Thanks for the suggestions, I will try them out to see which works for my application. David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is my worksheet smaller with a blue border and movable? | Excel Discussion (Misc queries) | |||
Why does worksheet print smaller? | Excel Discussion (Misc queries) | |||
Creating smaller files from one worksheet | Excel Discussion (Misc queries) | |||
How do I size a worksheet ? ( make smaller ) | Excel Discussion (Misc queries) | |||
How to split worksheet to make smaller | Excel Worksheet Functions |