Skip to main content

Creating a New and Opening Existing Workbooks in MS Excel 2016

All the files that you create in MS Excel are known as workbooks. In order to create a new project in MS Excel you need to create a new workbook. In order to create a new workbook you can either opt for a blank workbook or go for a predesigned template. You can also open an existing workbook. You can also learn about some Keyboard Shorcuts used in Windows 10.

Creating a New Blank Workbooks

In order to create a new blank workbook you need to follow these simple steps.
  • 1st of all you need to select File tab. After selecting the File tab a Backstage view will appear.
  • Now in this view you have to select New and after that you have to click on Blank workbook option.
  • Once you click on Blank workbook option a new blank workbook will be created.

Opening an Existing Workbooks

Apart from creating new workbooks you can also open a workbook that has been saved previously. In order to open an existing workbook you need to follow these simple steps.
  • 1st of all you need to click File and then navigate the Backstage View.
  • Now you need to click Open option.
  • After clicking Open option you will be guided to a new window from where you need to select Computer and then click Browse.
  • Now after clicking the Browse option Open dialog box will be opened.
  • In the Open dialog box you need to locate the workbook and then select and open it.
  • This will open the existing workbook.

Creating a New Workbook from a Template

In order to create a new workbook from a predesigned template you need to follow these simple steps.
  • 1st of all you have to click the File tab and then access the Backstage view.
  • In the Backstage view you need to click on New option.
  • After this you will notice that several templates will appear below the Blank workbook option.
  • Now you need to select the template of your choice.
  • Once you select the template you will see the preview of the template along with some added information.
  • Now click on create option for using the selected template.

Comments

Popular posts from this blog

How to remove ?i=1 suffix from a URL

At the point when you first open your site, you may see the additional characters like ?i=1 toward the finish of your URL. This article clarifies more about what causes it, and what can be done. What causes the ?i=1 suffix? This additional URL boundary is brought about by a security framework we use to ensure your site. This security framework guarantees that your site must be gotten to through normal internet browsers. What does the ?i=1 suffix do? The ?i=1 suffix is a counter. At the point when you first burden your site, some Javascript will be sent to your program to check it can execute the code and store a treat. The page will at that point reload with the ?=1 addition. On the following solicitation, the worker checks if your program has the security framework treat. If not, your program will get another security challenge to set the treat once more, and be diverted to a URL with suffix ?i=2. In the event that the counter hits 3 and your program despite...

Keyboard Shortcuts for Windows 10

 Hitting different key combinations instead of rolling over the mouse across the screen saves much of your precious time. These key combinations are called keyboard shortcuts and, in this tutorial, we are going to learn various different keyboard shortcuts in Windows 10 which has got loads of such combinations. Windows 10 has got many new features and for launching them there are various different keyboard shortcuts. Keyboard shortcuts can also be used for navigating around your operating system and also for organizing the layout of your desktop. Listed below are some of the useful keyboard shortcuts. New Shortcuts in Windows 10 Windows Key + I : Opens Windows settings. Windows Key + Ctrl+ D : Creates a virtual desktop. Windows Key + F1 : Opens Edge and Searches. Windows Key + Ctrl + F4 : Closes virtual desktop currently selected. Windows Key + A : Opens notifications of Windows 10. Windows Key + Ctrl + Left/Right : Switches between virtual desktops. Windows Key + Print Screen Key ...