Microsoft Excel

Learn How To Create Workbook And Open Existing

create workbook

Learn How To Create Workbook And

Open Existing

How to create a new blank workbook:

  1. Select the File tab. The backstage view will appear.
    shot of Excel one
  2. Click on New, then click Blank workbook.
    shot of Excel 2013 two
  3. You will get a new blank workbook.

How to open an existing workbook:

  1. Navigate to Backstage view, then click Open.
    shot of Excel 2013 three
  2. Select Computer, then click Browse. Alternatively, you can choose OneDrive (previously known as SkyDrive) to open files stored on your OneDrive.
    shot of Excel 2013 four
  3. The Open dialog box will appear. Locate and select your workbook, then click Open.
    shot of Excel 2013 five

If you’ve opened the desired workbook recently, you can browse your Recent Workbooks rather than search for the file.

shot of Excel 2013 six

To pin a workbook:

If you frequently work with the same workbook, you can pin it to Backstage view for faster access.

  1. Navigate to Backstage view, then click Open. Your recently edited workbooks will appear.
    shot of Excel 2013 seven
  2. Hover the mouse over the workbook you want to pin. A pushpin icon willarrow appear next to the workbook. Click the pushpin icon.
    shot of Excel 2013 eight
  3. The workbook will stay in Recent Workbooks. To unpin a workbook, simply click the pushpin icon again.
    shot of Excel 2013 nine

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.

shot of Excel 2013 ten

Using templates

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:

  1. Click the File tab to access Backstage view.
    shot of Excel 2013 eleven
  2. Select New. Several templates will appear below the Blank workbook option.
  3. Select a template to review it.
    shot of Excel 2013 twelve
  4. preview of the template will appear, along with additional information on how the template can be used.
  5. Click Create to use the selected template.
    Shot of Excel 2013 thirteen
  6. 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.

Shot of Excel 2013 fourteen

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.

Compatibility mode

At times you may need to work with exercise manuals that were made in before renditions of Microsoft Excel, for example, Excel 2003 or Excel 2000. When you open these kinds of exercise manuals, they will show up in Compatibility mode.

Similarity mode disables certain highlights, so you’ll just have the capacity to get to charges found in the program that was utilized to make the exercise manual. For instance, on the off chance that you open an exercise manual made in Excel 2003, you can just utilize tabs and summons found in Excel 2003.

And In the picture beneath, you can see that the exercise manual is in Compatibility mode. This will cripple some Excel 2013 highlights, for example, sparklines and slicers.

shot of Excel 2013 sixteen

Hence, With a specific end goal to leave Compatibility mode, you’ll require converting the exercise manual to the present variant compose. Be that as it may, in case you’re teaming up with other people who just approach a prior rendition of Excel, Create Workbook it’s best to leave the exercise manual in Compatibility mode so the arrangement won’t change.

To convert a workbook:

As a result you want access to all of the Excel 2013 features, you can convert the workbook to the 2013 file format.

Note that converting a file may cause some changes to the original layout of the workbook.

  1. Click the File tab to access Backstage view.
    shot of Excel seventeen
  2. Locate and select Convert command.
    shot of Excel 2013 eighteen
  3. The Save As dialog box will appear. Select the location where you want to save the workbook, enter a file name for the presentation, and click Save.
    Shot of Excel 2013 twenty
  4. The workbook will be converted to the newest file type.

To know more about this Excel Article you can also visit: Officecomsetup

Leave a Reply

Your email address will not be published. Required fields are marked *