Creating an Excel Spreadsheet/Workbook
Creating a workbook/Spreadsheet in Excel
Each new document you open in Excel is called a workbook. Within each workbook, you create a worksheet, which you'll see as a tab at the bottom of the screen. By default, a new worksheet is called Sheet1, but you can right-click on it and choose Rename to give it the name you'd like.
Open Excel.
Select Blank workbook. Or, press Ctrl+N.
To manually enter data:
Select an empty cell, such as A1, and then type text or a number.
Press Enter or Tab to move to the next cell.
To fill data in a series:
Enter the beginning of the series in two cells: such as Apr and May; or 2020 and 2021.
Select the two cells containing the series, and then drag the fill handle across or down the cells.
Dont forget to save progress. To save the file, click the File menu at the top-left corner, and then select Save As. Depending on your version of Excel, you'll usually have the option to save the file to your computer or OneDrive.
Creating a New Workbook Using A Template
Excel connects to an online database full of thousands of useful templates. When you open a new workbook or click File > New, you’ll see a list of templates available. To open a new workbook with one of the templates, double-click it.
You can also use the search box to locate templates. Click into the search bar and type anything you want to search for.