Create a new Excel workbook
How to create a new excel file (workbook) using Excel, VBA and Shortcut methods
File tab > New > Click on Blank workbook
1. Select the File tab. |
2. Click New. |
3. Click on Blank workbook. |
Sub Create_New_Workbook()
'create a new excel workbook
Workbooks.Add
Workbooks.Add
End Sub
WINDOWS SHORTCUT
Ctrl
N
NOTES
The shortcut will create a new Excel file (workbook).
EXPLANATION
This tutorial explains and provides step by step instructions on how to create a new Excel workbook using Excel, VBA and Shortcut methods.
This tutorial explains and provides step by step instructions on how to create a new Excel workbook using Excel, VBA and Shortcut methods.
Excel Method: This tutorial provides one Excel method that can be applied to create a new Excel workbook. The method shows how to access the blank workbook function through the File tab, which is a three step process.
VBA Method: This tutorial provides one VBA method that can be applied to create a new Excel workbook.
Shortcut Method: The Shortcut in this tutorial will instantly create a new Excel file (workbook).
RELATED TOPICS
Related Topic | Description | Related Topic and Description |
---|---|---|
Open an Excel workbook | How to open a single workbook using Excel, VBA and Shortcut methods | |
Close an Excel workbook | How to close a single workbook using Excel, VBA and Shortcut methods | |
Save an Excel workbook | How to save a workbook using Excel, VBA and Shortcut methods | |
Open an Excel workbook as Read-Only | How to open a single workbook as Read-Only using Excel and VBA methods | |
Save and close an Excel workbook | How to save and close a workbook using VBA |