Changing the Number of sheets opened by default on new excel workbooks via Group Policy

A user suggested we default our Excel 2010 workstations to open 1 sheet when opening a new document instead of 3 which is default.

This is accomplished via this setting in Excel 2010

excel optionsAnd via this registry key

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options]

“DefSheets”=dword:00000001

Changing the last number as appropriate.

So Group Policy to enable this company wide is as simple as

gpoAs with any GPO or registry changes, you should apply this to a test group first before rolling out across the entire domain.

That all being said and done, There is not a good reason to do this as the size difference is minimal. Although maybe you will find this useful.

1sheet_vs_3sheets

 

 

 

 

Leave a Reply

Your email address will not be published.

Name *
Email *
Website

Protected by WP Anti Spam