Excel Notebook

  
-->

Represents a Microsoft Excel workbook.

  1. The Workbook object is a member of the Workbooks collection. The Workbooks collection contains all the Workbook objects currently open in Microsoft Excel. The ThisWorkbook property of the Application object returns the workbook where the Visual Basic code is running. In most cases, this is the same as the active workbook.
  2. Microsoft Excel is one of the most versatile and useful programs in the Office suite. It doesn’t matter if you need Excel templates for budgeting the next fiscal year, tracking your business inventory, planning out meals, or creating a fantasy football draft sheet, there are plenty of Microsoft Excel templates for you.

Remarks

Microsoft Excel For Laptop free download - Microsoft Excel, Microsoft Excel 2007, Microsoft Office Excel 2010, and many more programs.

The Workbook object is a member of the Workbooks collection. The Workbooks collection contains all the Workbook objects currently open in Microsoft Excel.

The ThisWorkbook property of the Application object returns the workbook where the Visual Basic code is running. In most cases, this is the same as the active workbook. However, if the Visual Basic code is part of an add-in, the ThisWorkbook property won't return the active workbook. In this case, the active workbook is the workbook calling the add-in, whereas the ThisWorkbook property returns the add-in workbook.

If you are creating an add-in from your Visual Basic code, you should use the ThisWorkbook property to qualify any statement that must be run on the workbook that you compile into the add-in.

Example

Use Workbooks (index), where index is the workbook name or index number, to return a single Workbook object. The following example activates workbook one.

The index number denotes the order in which the workbooks were opened or created. Workbooks(1) is the first workbook created, and Workbooks(Workbooks.Count) is the last one created. Activating a workbook doesn't change its index number. All workbooks are included in the index count, even if they are hidden.


The Name property returns the workbook name. You cannot set the name by using this property; if you need to change the name, use the SaveAs method to save the workbook under a different name.

The following example activates Sheet1 in the workbook named Cogs.xls (the workbook must already be open in Microsoft Excel).


The ActiveWorkbook property of the Application object returns the workbook that's currently active. The following example sets the name of the author for the active workbook.


This example emails a worksheet tab from the active workbook by using a specified email address and subject. To run this code, the active worksheet must contain the email address in cell A1, the subject in cell B1, and the name of the worksheet to send in cell C1.

Events

Methods

Properties

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

You’ve probably created hundreds of new workbooks in Excel. Maybe even thousands.

Notebook

And you might understandably think that you know everything there is to know about creating new workbooks.

But there are a few new things to learn yet.

We’ll take a look at the basics, and then go from there.

*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.

Creating a new blank workbook

Excel Notebook Paper Template

This is probably what you’ve done in the past. And it’s incredibly simple.

When you open Excel, you’ll see a window asking what you want to do:

To open a blank workbook,double-click Blank workbook, and you’re good to go. That’s all there is to it.

Excel Notebooks

If you already have a workbook open, click the File tab from the left side of the Ribbon, then select New from the left sidebar.

Again, double-click on Blank workbook.

Pro tip: new blank workbook keyboard shortcut

If you open a lot of new workbooks, you may want to get used to the keyboard shortcut for opening a new blank workbook: Ctrl + N.

This shortcut won’t give you any of the options we discuss below, but if all you need is a blank spreadsheet, that’ll do the trick.

Pro tip 2: changing the default number of worksheets

When you open a new blank workbook, Excel puts a single worksheet in it by default. But you can change that.

Go to File > Options > General, and find the When creating new workbooks section.

From there, change the Include this many sheets: dropdown to your preferred number of sheets.

Creating a new workbook from a template

Excel connects to online databases with thousands of useful templates. And with a couple clicks, you have access to them all.

Excel notebook pdf

When you open a new workbook or click File > New, you’ll see a list of templates available.

These include staples like cash flow analysis, profit-loss statement, wedding budget, and Gantt chart project planner. Just scroll through them to see more!

To open a new workbook with one of the templates, double-click it.

The real power of this screen, though, is the search bar. Click into the search bar and type anything, from “project management” (check out our templates!) to “video game tracker,” and you’ll get results.

Even if you can’t find exactly what you’re looking for, you should be able to find something close. And you can always modify that to fit your needs.

Jupyter Notebook Excel

Using another workbook as a template

If you can’t find a template that you like, or you’ve spent a lot of time and effort coming up with a custom spreadsheet that you need to reuse, Excel has you covered.

Excel binary workbook

You can turn a saved workbook into a template for a new one.

To do this, click File > Open > Browse, and browse to the worksheet you want to use as the basis for your new workbook.

Then click the arrow next to the Open button:

Click Open as Copy, and you’ll have a new workbook that looks exactly like the old one.

You can also do this by right-clicking on any spreadsheet in the Open window and selecting Open a Copy:

Pro tip: save a bare-bones copy

If you’ve created a workbook that you think you’ll use again, you can save yourself some time. Save a new copy of that workbook, then delete the data that you won’t reuse.

Keep column headers, formulas, and anything else that will be the same in each iteration. Just get rid of the stuff you won’t need next time.

Now, when you open a copy of that spreadsheet, it’ll be like opening a template.

Start efficiently

Everything in Excel starts with creating a new workbook.

So if you can make that process more efficient, you’re well on your way to becoming an Excel expert.

And with these three different methods of making new workbooks, you know all there is to know!

So next time you’re starting an Excel project, think about how you can most efficiently start it. You might be able to save some time!