Creating and Opening Workbooks
How to open and create workbooks in office 2013
Excel files are called workbooks. At whatever point you begin another undertaking in Excel, you’ll require creating a new exercise manual. There are a few approaches to begin working with an exercise manual in Excel 2013. You can pick to create another exercise manual—either with a blank workbook or a predesigned template—or open an existing workbook.
To make another clear exercise manual: Excel 2013
- Select the File tab. The backstage view will appear.
- Select New, then click Blank workbook.
- A new blank workbook will appear.
To open an existing workbook: Excel 2013
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.
- Select Computer, then click Browse. Alternatively, you can choose OneDrive (previously known as SkyDrive) to open files stored on your OneDrive.
- The Open dialog box will appear. Locate and select your workbook, then click Open.
If you’ve opened the desired workbook recently, you can browse your Recent Workbooks rather than search for the file.
To pin a workbook: Excel 2013
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.
- Hover the mouse over the workbook you want to pin. A pushpin icon will appear next to the workbook. Click the pushpin icon.
- 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 the Backstage view, click Open, then locate the folder you want to pin and click the pushpin icon.
Using templates: Excel 2013
A template is a predesigned spreadsheet you can use to create a new workbook quickly. Templates often include custom formatting and predefined formulas, so they can save you a lot of time and effort when starting a new project.
To create a new workbook from a template:
- Click the File tab to access Backstage view.
- Select New. Several templates will appear below the Blank workbook option.
- Select a template to review it.
- A preview of the template will appear, along with additional information on how the template can be used.
- Click Create to use the selected template.
- A new workbook will appear with the selected template.
You can also browse templates by category or use the search bar to find something more specific.
It’s important to note that not all templates are created by Microsoft. Many are created by third-party providers and even individual users, so some templates may work better than others.
Sometimes you may need to work with workbooks that were created in earlier versions of Microsoft Excel, such as Excel 2003 or Excel 2000. When you open these types of workbooks, they will appear in Compatibility mode.
Compatibility mode disables certain features, so you’ll only be able to access commands found in the program that was used to create the workbook. For example, if you open a workbook created in Excel 2003, you can only use tabs and commands found in Excel 2003.
In the image below, you can see that the workbook is in Compatibility mode. This will disable some Excel 2013 features, such as sparklines and slicers.
In order to exit Compatibility mode, you’ll need to convert the workbook to the current version type. However, if you’re collaborating with others who only have access to an earlier version of Excel, it’s best to leave the workbook in Compatibility mode so the format will not change.
To read more about Office Products visit Office.com/setup.