How to create CREATING WORKBOOKS in Excel 2016

There are three ways to create a new Microsoft Excel workbook. You can open a new, blank workbook when you launch Excel or by using the File tab to access Backstage view. You can open an existing Excel workbook, enter new or additional data, and save the file with a new name, thus creating a new workbook. You can also use a template to create a new workbook. A template is a model that has already been set up to display certain kinds of data, such as sales reports, invoices, and so on.

Creating a Workbook from Scratch

To create a new workbook, launch Excel and select a blank workbook or another type of template. If you are working in Excel and want to begin a new workbook, click the File tab, click New, and then click Blank workbook. Worksheets often include text that describes the content of the worksheet. In this exercise, you create two Excel workbooks: one with a company address and one with a quick phone message.

1. Click Blank workbook. If you have just launched Excel, Book1 – Excel appears in the title bar at the top of the window. A blank workbook opens with A1 as the active cell.

2. In cell A1, type your work name. This entry is the primary title for the worksheet. Note that as you type, the text appears in the cell and in the formula bar. See the definition of the formula bar in the “Editing a Cell’s Contents” section, later in this lesson.

3. Press Enter. The text is entered into cell A1, but appears as if it flows into cell B1.
4. In cell A2, type Your name and then press Enter.
5. In cell A3, type Address and then press Enter.
6. Sometimes you need a quick work area to complete another task while you are in the  middle of a workbook. You can open another workbook as a scratch area. Click the File
tab, and in the left pane, click New. The different templates available appear
7. In the Backstage view, click Blank workbook. A second Excel workbook opens and
Book2 appears in the title bar.
8. In cell A1, type Phone Calls and then press Enter.
9. In cell A2, type Angro bangro flight 725 arriving 4:30 apm and then press Enter.
10. Click the File tab to open Backstage view. In the left pane, click Close to close the Phone
Calls workbook. In the message box, click Don’t Save.

Leave a Reply

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