XLSX Files

Fisher1975

Board Regular
Joined
Jan 12, 2012
Messages
74
Hi

Does anyone know how I can get excel to open this file as a standard when I select a 'New' workbook?

I want the extended rows and columns associated with this format
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

NewOrderFac33

Well-known Member
Joined
Sep 26, 2011
Messages
1,252
I'm using Excel 2010 and if I do New then Save As, .xlsx is the default format.

What version of Excel are you using?
 

Snakehips

Well-known Member
Joined
May 17, 2009
Messages
5,059
Office Version
  1. 2013
Platform
  1. Windows
Fisher1975,

Try Excel Options >> Save >> Save Workbooks >> Save workbooks in this format:

and select your required default from the topdown list.

Hope that helps.

***Edit Sorry, you are saying open not save!! ***
(Back to bed methinks..)
 
Last edited:

NewOrderFac33

Well-known Member
Joined
Sep 26, 2011
Messages
1,252
Snakehips,

Worry not, I never knew that you could change the default SaveAs filetype - respect!

Pete
 

Fisher1975

Board Regular
Joined
Jan 12, 2012
Messages
74
Im using Excel 2007, Pete, how many rows do you have if you open a new file in 2010?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,045
Messages
5,526,447
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top