Get Microsoft Office help creating blank and template MS Excel 2013 spreadsheets, opening existing ones, and converting files.
Video: Creating and Opening WorkbooksWatch the video (2:13).
Excel files are called workbooks. Whenever you start a new project in Excel, you'll need to create a new workbook. There are several ways to start working with a workbook in Excel 2013. You can choose to create a new workbook—either with a blank workbook or a predesigned template—or open an existing workbook.
To create a new blank workbook:
- Select the File tab. Backstage view will appear.
Clicking the File tab
- Select New, then click Blank workbook.
Creating a new workbook
- A new blank workbook will appear.
To open an existing workbook:
In addition to creating new workbooks, you'll often need to open a workbook that was previously saved. To learn more about saving workbooks, visit our lesson on Saving and Sharing Workbooks.
- Navigate to Backstage view, then click Open.
Opening a file
- Select Computer, then click Browse. Alternatively, you can choose OneDrive (previously known as SkyDrive) to open files stored on your OneDrive.
Opening a workbook
- The Open dialog box will appear. Locate and select your workbook, then click Open.
Opening a workbook
If you've opened the desired workbook recently, you can browse your Recent Workbooks rather than search for the file.
To pin a workbook:
If you frequently work with the same workbook, you can pin it to Backstage view for faster access.
- Navigate to Backstage view, then click Open. Your recently edited workbooks will appear.
Viewing recently edited workbooks
- Hover the mouse over the workbook you want to pin. A pushpin icon will appear next to the workbook. Click the pushpin icon.
Pinning a workbook
- The workbook will stay in Recent Workbooks. To unpin a workbook, simply click the pushpin icon again.
You can also pin folders to Backstage view for faster access. From Backstage view, click Open, then locate the folder you want to pin and click the pushpin icon.
Pinning a folder to Backstage view