The Excel Start screen in the backstage view gives you various options whenever you run Excel (without additionally opening an existing workbook file).

By selecting the Blank Workbook template, you may create a new workbook (with the generic filename Book1) with a single completely blank worksheet (with the generic worksheet name Sheet1).

Opening a new workbook based on one of the other templates presented in the Start screen or accessible on the new screen by clicking the Find More in New link or new button in its navigation pane.

If you choose the Blank Workbook design, you may start setting out and developing your new spreadsheet in the blank worksheet. If you choose one of the other created templates, you may begin by modifying the workbook file’s design and adding data into your new spreadsheet.

Use a template as a guide

If you can locate one that matches the look of the spreadsheet you want to create, spreadsheet templates are the way to go. When you first open Excel and then choose the new option in the navigation bar, you’ll see many options. (See diagram.) Budgets and timetables are among the templates available on the new screen in the backstage view, as are sales reports, invoices, profit and loss statements, and calendars.

If none of the templates on the new screen meet your needs, you may search for others. Charts, Business, Lists, Personal, Small Business, Industry, Finance-Management, Calculator, and Calculator are all linked on this screen.

The New screen presents your options in that category when you press one of these links. The initial section of the new screen that comes when you pick the Financial Management link in the Selected Searches is shown in the diagram below. Financial planners, logs, calculators, trackers, and lists, to mention a few, are among the template options in this area, as seen in this diagram.

By admin