Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get address of first cell in range in Excel
  • How to use Excel OFFSET function
  • How to use Excel INDIRECT Function
  • Vlookup Examples in Excel
  • How to get last row in mixed data with blanks in Excel

Data Analysis Examples

  • How to create Gauge Chart in Excel
  • Get column index in Excel Table
  • Reverse List in Excel
  • How to count table rows in Excel
  • How to Create Thermometer Chart in Excel

Data Validation Examples

  • Excel Data validation no punctuation
  • Excel Data validation whole percentage only
  • Excel Data validation must begin with
  • Excel Data validation allow weekday only
  • Prevent invalid data entering in specific cells

Creating and Opening an existing file in Excel Workbook

by

A workbook is another word for your Excel file as referred by Microsoft.. And, also a workbook comprises of several worksheets depending on the user.

When you start Excel, click Blank workbook to create an Excel workbook from scratch.

Open an Existing Workbook

To open a workbook you’ve created in the past, execute the following steps.

1. On the File tab, click Open.

Worked Example:   How to check worksheet name exists in Excel

2. Recent shows you a list of your recently used workbooks. You can quickly open a workbook from here.

3. Click Browse to open a workbook that is not on the list.

How to Create a New Workbook in Excel

Sometimes you want to start all over again. To create a new workbook, execute the following steps.

Worked Example:   How to get sheet name only in Excel

1. On the File tab, click New.

2. Click Blank workbook.

Close a Workbook

To close a workbook (and Excel), click the upper right X. If you have multiple workbooks open, clicking the upper right X closes the active workbook.

Turn off the Start screen

When you start Excel, it shows a start screen that lists recently used Excel files and templates. To skip the start screen and always start with a blank workbook, execute the following steps.

Worked Example:   AutoRecover file that was never saved in Excel

1. On the File tab, click Options.

2. Uncheck ‘Show the Start screen when this application starts’.

3. Click OK.

Ensure you hit Ctrl+S on your keyboard to save changes made in workbook.

Post navigation

Previous Post:

Simple Excel Formulas and Functions

Next Post:

Select, Insert, Rename, Move, Delete Worksheets in Excel

Leave a Reply Cancel reply

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

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to calculate Number of Instances in Excel
  • How to strip numeric characters from cell in Excel
  • REPLACE, REPLACEB functions: Description, Usage, Syntax, Examples and Explanation
  • How to extract last two words from text string in Excel
  • How to extract domain name from URL in Excel
  • How to show last updated date stamp in Excel
  • How to join date and text together in Excel
  • WEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • Convert date string to date time in Excel
  • Convert decimal minutes to Excel time
  • MIRR function: Description, Usage, Syntax, Examples and Explanation
  • Future value vs. Present value examples in Excel
  • Calculate cumulative loan interest in Excel
  • YIELD function: Description, Usage, Syntax, Examples and Explanation
  • PRICEMAT function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles