ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Smaller worksheet (https://www.excelbanter.com/new-users-excel/197505-smaller-worksheet.html)

david[_2_]

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

Lars-Åke Aspelin[_2_]

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


Ken Wright

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




david[_2_]

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


All times are GMT +1. The time now is 01:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com