Creating and Opening Workbooks
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: (Ctrl+N)
File tab>New> Blank workbook
You will also open MS Excel then click Blank workbook
To open an existing workbook: (Ctrl+O)
In addition to creating new workbooks, you'll often need to open a workbook that was previously saved.
File tab>Open>Browse>Select Workbook>Open
To pin a workbook:
If you frequently work with the same workbook, you can pin it to backstage view for quick access.
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 quick access. From Backstage view, click Open, then locate the folder you wish to pin and click the pushpin icon.
Saving Workbooks
Whenever you create a new workbook in Excel, you'll need to know how to save it in order to access and edit it later. As with previous versions of Excel, you can save files locally to your computer.
Save and Save As
Excel offers two ways to save a file: Save and Save As. These options work in similar ways, with a few important differences:
Save (Ctrl+S): When you create or edit a workbook, you'll use the Save command to save your changes. You'll use this command most of the time. When you save a file, you'll only need to choose a file name and location the first time. After that, you can just click the Save command to save it with the same name and location.
Save As (F12): You'll use this command to create a copy of a workbook while keeping the original. When you use Save As, you'll need to choose a different name and/or location for the copied version.
Using Undo & Redo
If you want to go back “one step” click on undo command located on Quick access toolbar.
If you want to go forward “one step” (when you go back) click on Redo command located on Quick access toolbar.
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: (Ctrl+N)
File tab>New> Blank workbook
You will also open MS Excel then click Blank workbook
To open an existing workbook: (Ctrl+O)
In addition to creating new workbooks, you'll often need to open a workbook that was previously saved.
File tab>Open>Browse>Select Workbook>Open
To pin a workbook:
If you frequently work with the same workbook, you can pin it to backstage view for quick access.
Navigate to Backstage view and then click Open.Your recently edited workbooks will appear.
Hover the mouse over the workbook you wish to pin. A pushpin icon will appear next to the workbook. Click the pushpin icon.
You can also pin folders to Backstage view for quick access. From Backstage view, click Open, then locate the folder you wish to pin and click the pushpin icon.
Saving Workbooks
Whenever you create a new workbook in Excel, you'll need to know how to save it in order to access and edit it later. As with previous versions of Excel, you can save files locally to your computer.
Save and Save As
Excel offers two ways to save a file: Save and Save As. These options work in similar ways, with a few important differences:
Save (Ctrl+S): When you create or edit a workbook, you'll use the Save command to save your changes. You'll use this command most of the time. When you save a file, you'll only need to choose a file name and location the first time. After that, you can just click the Save command to save it with the same name and location.
Save As (F12): You'll use this command to create a copy of a workbook while keeping the original. When you use Save As, you'll need to choose a different name and/or location for the copied version.
Using Undo & Redo
If you want to go back “one step” click on undo command located on Quick access toolbar.
If you want to go forward “one step” (when you go back) click on Redo command located on Quick access toolbar.
No comments:
Post a Comment