ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   change standard column width (https://www.excelbanter.com/setting-up-configuration-excel/62177-change-standard-column-width.html)

change standard column width

change standard column width
 
i want to change the standard column width from 8.43 to another value when i
open any xls file.
i mean that the setting to be saved in exel program not in the xls file

Dave Peterson

change standard column width
 
You can create a couple of templates (*.xlt in excel speak) that can be used as
the basis for new workbooks (and new worksheets in existing workbooks).

The first one is named book.xlt (file|saveas|Template (*.xlt)).

This is stored in your XLStart folder. When you click the New icon on the
standard toolbar, you'll get a new workbook based on this template.

The second one is named sheet.xlt and is saved in the same location (XLStart
folder).

When you add a new worksheet to an existing workbook, you'll get a worksheet
based on this template.

(When I did mine, I really created a single sheet workbook and saved it as
book.xlt, then I just copied that book.xlt to sheet.xlt--all within my XLStart
folder.)

change standard column width wrote:

i want to change the standard column width from 8.43 to another value when i
open any xls file.
i mean that the setting to be saved in exel program not in the xls file


--

Dave Peterson


All times are GMT +1. The time now is 07:38 PM.

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