Excel Workbook

Contents:
Create a new workbookOpen an existing workbookSave a workbookRecover WorkbookHide & Unhide a workbook | Close workbook |Save The Current Workbook In 97-2003 Format

I will show you some basic functions about Workbook operating. Include Create a workbook, Open a workbook, Save a workbook, Recover a workbook, Hide & Unhide a workbook, Close a workbook.

Create a new workbook

If you want to create a new workbook, you can follow the below two ways :

#1 Click ‘Customize Quick Access Toolbar’ arrow -> check on ‘New’ (then ‘New’ button is shown on toolbar) -> Click ‘New’.

Customize Quick Access Toolbar

File button

#2 Click ‘File’ button -> Click ‘New’ -> Double click on ‘blank workbook’.

create new workbook file
New blank workbook

Open an existing workbook

You can open an existing workbook via the below 3 ways:

#1 Find your workbook -> double click on it.

#2 Click ‘File’ -> Click ‘Open’ -> Click Computer and find the existing workbook you want to open on your PC -> Click ‘Open’.

Opem an existing workbook 2

#3  Through the history function: click ‘Recent’, the latest opened/edit workbook will be shown at the right window.

Opem an existing workbook 1

Save a workbook

you can save a workbook directly  via save button or save the current workbook to another location or file name(save as…).

1. Save

Directly click ‘Save’ button (current workbook will not disappear and just be saved in background)
Save workbook

Or Click ‘File’ -> ‘Save’ (save in background).

Opem an existing workbook 2

2. Save as

Click ‘File’ -> ‘Save As’-> ’Computer’, then enter the workbook name, select proper path, then save current workbook.

Opem an existing workbook 2

3. Save with password

Step1# Click ‘File’ -> ‘Options’ -> ‘Info’ -> ‘Protect Workbook’, select ‘Encrypt with Password’.

Encript with password

Step2# Enter ‘Password’ and ‘Reenter Password’, then click ‘OK’.

Password Dialog

Step3# Restart workbook. You must enter password to open Book1.

Enter Password

Step4# Auto save a workbook (incase of power down, system crash…)
Click ‘File’ -> ‘Options’, select Save, check on ‘Save AutoRecover information every X minutes’ and ‘Keep the last autosaved version if I close without saving’ (details see below section ‘Recover Workbook’).

excel auto save

Recover Workbook

This function is related to auto save function.

1. Recover workbook

Click ‘File’ -> ‘Info’ -> ‘Versions’, recent auto backup versions will be loaded (there are no previous versions of this file in below sample).

Recover Workbook

Notes: if workbook is shutdown by power down or system crash, restart Excel will automatically load Document Recover task window, user can select the original or the latest backup version.

2. Recover unsaved workbook

Close current workbook without saving (maybe you want to click ‘yes’ but actually click ‘no’)

#1  Click ‘File’ -> ‘Info’ -> ‘Versions’ -> ‘Manage Versions’ -> ‘Recover unsaved workbook’, unsaved workbook will be listed.

Recover Unsaved Workbooks

#2 Click ‘File’ -> Open -> ‘Recent Workbooks’, ‘Recover Unsaved Workbooks’ button is listed at the right window.

Recover Unsaved Workbooks2

Hide & Unhide a workbook

1. Hide

Right click ‘Sheet’ -> ‘Hide’, the current workbook (a worksheet exactly) is hidden.

Hide wordbook

Notes: If only one worksheet exists, Excel doesn’t allow to hide the worksheet.

x
How to Replace # Errors with Zero or Any Specific Value in Excel

2. Unhide

Same way, click ‘Sheet’ (any one is ok) -> ‘Unhide’, select the one you want to unhide, then click ‘OK

.Unhide workbook

Unhide sheet1

Close workbook

1. Quit Excel

Click ‘Close’ button on the right top corner or <Alt+F4> KEY Combination.

Close workbook

2. Quit Workbook

Click ‘File’ -> ’Close’ or <Ctrl+W> Combination, then no workbook shows.

Close sheet1 but stay in excel

More Reading:

MS Excel: How To Save The Current Workbook In 97-2003 Format

Related Posts

How to Add Prefix or suffix to Cell
add prefix to cell113

This post will guide you how to add common prefix or suffix to all cells or the range of cells in your worksheet in Excel. How do I add the same prefix or suffix to a range of cells without ...

Quickly Insert Multiple Rows or Columns in Excel
insert multiple rows or columns13

This post will guide you how to quickly insert multiple rows or columns in your Microsoft worksheet. You will see that how to add new multiple rows or columns with shortcut or insert feature, or insert copied cells in excel. ...

Split Excel workbook into separate Files
split workbook into separate file3

This post will guide you how to split a large workbook to separate files and each worksheet should be saved as a single file. How do I split the whole workbook into several excel worksheets or single excel file. Assuming ...

How to Get the List of File Names From a Folder
get list of file names from a folder11

This post will teach you how to get the list of file names in a given directory to a worksheet in Excel. You will learn that how to use Excel to view Files and Folders in your worksheet by get ...

Find Duplicate Values in Two Columns
find duplicate cells in two columns111

This tutorial will show you how to find duplicate values in two given columns in Excel. Or How to compare two columns and find duplicate entries in Microsoft Excel worksheet. And you will learn two methods to compare columns so ...

Remove Leading and Trailing Spaces
remove leading and trailing spaces112

In this tutorial you will learn that how to remove leading or trailing spaces from a text string in a cell in Excel. This post will guide you how to delete leading or trailing spaces of all cells in a ...

Generate Random Passwords
generate random passwords5

This post will teach you how to quickly generate a random password with Formula in Excel. You can combine a series of worksheet functions to create a complex formula to generate a random password in Microsoft Excel. Generate Random Password ...

Sort by Second or Third character in a Column
sort string by second character13

This post will guide you how to sort text string by second or third character in a Column in Excel. You may be want to sort a string in a Cell by the Second or last character in excel, how ...

Copy a Cell to Clipboard with Single Click
copy a cell to clipboard3

This post will teach you how to use the Excel VBA macro code to copy a Cell to clipboard with only single click in Excel. How do I automatically copy the content of cell to Clipboard while clicking on the ...

How to Convert Positive Numbers to Negative
change positive to negative 112

This tutorial will teach you how to change positive numbers to negative with Paste special multiply operation in excel. How to convert positive number to negative or how to reverse the number signs with VBA code in Excel. Convert Positive ...

Sidebar