Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to add Trendline to a chart in Excel
  • How to create dynamic reference table name in Excel
  • How to Use Solver Tool in Excel
  • Conditional Formatting Data bars Examples in Excel
  • Add Outline to Data in Excel

References

  • How to use Excel FORMULATEXT function
  • Basic INDEX MATCH approximate in Excel
  • Left Lookup in Excel
  • How to get relative row numbers in a range in Excel
  • How to use Excel MMULT Function

Data Validations

  • Excel Data validation exists in list
  • Excel Data validation unique values only
  • Excel Data validation with conditional list
  • Excel Data validation date in next 30 days
  • Excel Data validation no punctuation

Creating and Opening an existing file in Excel

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 reference named range different sheet 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:   List worksheet index numbers 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:   View Multiple Workbooks at The Same Time 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:

MDETERM function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Identify Duplicate Values vs Remove Duplicates 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

Logical Functions

  • Nested IF function example in Excel
  • SWITCH function example in Excel
  • How to use Excel FALSE Function
  • Check multiple cells are equal in Excel
  • XOR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Convert Excel time to decimal minutes
  • DATEDIF function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate next scheduled event in Excel
  • Basic timesheet formula with breaks in Excel
  • Display the current date and time in Excel

Grouping

  • Running count group by n size in Excel
  • Categorize text with keywords in Excel
  • Group arbitrary text values in Excel
  • Group numbers with VLOOKUP in Excel
  • Map text to numbers in Excel

General

  • Currency vs Accounting Format in Excel
  • How to Delete Cells, Row and Rows in Excel
  • Check if range contains a value not in another range in Excel
  • Transpose: Switch ‘Rows to Columns’ or ‘Columns to Rows’ in Excel
  • How to calculate percent of students absent in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning