Excel 2010

Creating and opening workbooks

Video:Creating Workbooks in Excel 2010

Watch the video (1:36).

Excel files are called workbooks. Each workbook holds one or more worksheets (also known as spreadsheets).

To create a new, blank workbook:

1. Click the File tab. This takes you to Backstage view.
2. Select New.
3. Select Blank workbook under Available Templates. It will be highlighted by default.
4. Click Create. A new, blank workbook appears in the Excel window.
   Creating a new workbook

To save time, you can create your document from a template, which you can select under Available Templates. We will talk more about this in a later lesson.

To open an existing workbook:

1. Click the File tab. This takes you to Backstage view.
2. Select Open. The Open dialog box appears.
   Opening a workbook
3. Select your desired workbook, then click Open.
   
   

If you have opened the existing workbook recently, it may be easier to choose Recent from the File tab instead of Open to search for your workbook.

Opening a recent workbook