• Skip to primary navigation
  • Skip to main content
  • Skip to footer
Analysing Data

Analysing Data

Analyze, automate, integrate

  • Home
  • Services
    • Statistic Analysis
    • Excel Jobs
  • Blog
  • About
  • Newsletter
  • Contact

Create SpreadSheets and Books in Excel

June 11, 2020 By Javier Rodríguez Leave a Comment

In this post I would like to describe how to create a spreadsheet or workbook in Excel step by step. After starting the program, the first screen that appears is the following:

To create a new spreadsheet, select the “Blank book” option, after which our empty sheet will appear, as shown below:

By default the name of the sheet is “Sheet1”, if you want to change it, you just have to right-click on the name (bottom left of the screen) and select the “Rename” option.

If what we want is to create a book (set of spreadsheets), we must create new sheets. To create a new sheet, click on the “+” symbol located at the bottom of the screen, just to the right of the sheet name.

Automatically a new spreadsheet will appear with the default name “Sheet2” (also editable with the option that we have described just before).


Finally, to save this book (or spreadsheet if there is only one) there are several options:

  • Click the save symbol (a floppy disk) in the upper left
  • Keyboard shortcut: Ctrl – g
  • File Menu -> Save

In any case, the following window will appear, where after clicking Browse (in addition to saving the sheet on our computer, there is the option to save it in OneDrive), we can choose the location and name of our final file.

Filed Under: Uncategorized

Leave a Reply Cancel reply

You must be logged in to post a comment.

 

  • Facebook
  • Instagram
  • Twitter

Copyright © 2021 · ANALYSING DATA