Excel Worksheet

Contents:
Select/Create a WorksheetRename a Worksheet  |  Insert a Worksheet | Copy a WorksheetMove a Worksheet |  Switch a WorksheetChange Background Color  | Hide & Unhide a Worksheet Delete a Worksheet

When you open an new workbook or start excel application, it will create 3 new blank worksheets. This section will explain you how to create/insert/delete/move/copy/rename a  worksheet.

Select/Create a Worksheet

1.  Automatically created by creating a new workbook

You may find there is always an opened worksheet used for users entering or editing data in Excel operating process. In this case, a new worksheet can be opened with creating a new workbook.

2. Create a new worksheet from current workbook

If you want to create a new worksheet other than your current one, directly click ‘Add’ button near ‘Sheet1’.

Add button

Rename a Worksheet

You can rename a worksheet via the following two ways:

#1  double click on ‘Sheet1’ -> ‘Sheet1’ is selected and marked with blue background -> Rename a worksheet

Select Sheet1

#2  Click ‘Home’ -> Cells -> Format -> Rename sheet (Notes here if worksheet is displayed in full screen, ignore ‘Cells’ step)

Rename Sheet in Cells

Insert a Worksheet

Right click on ‘Sheet1’ -> Insert Sheet (or just click ‘+’)

Insert Sheet

Copy a Worksheet

Click on sheet you want to copy (Sheet5 for example) -> Move or Copy -> Select Sheet5 -> Check on ‘Create a copy’ option -> Click ‘OK’.

x
How to Highlight Every Other Row Using Conditional Formatting in Excel

Step1: Select ‘Move or Copy

Move or Copy

Step2: Select Sheet5, check on ‘Create a copy’, click ‘Ok

Select Sheet5 in Copy

Step3: Sheet5 (2) is added.

Copy Sheet5 (2)

Move a Worksheet

The below will show you how to move a worksheet via 2 ways:

#1 Drag and move worksheet to the proper position, then release your mouse.

Step1: Drag

Darg Sheet1

Step2: Move and Release

Move Sheet1
Move Sheet1 between Sheet2 and Sheet3

#2 Click on sheet you want to move (Sheet5 for example) -> Move or Copy -> Select Sheet you want to move before (Sheet1 for example) -> Click ‘OK’. This method is often used for multiple sheets exist in one workbook.

Step1: Select Sheet1 in ‘before sheet

Select Sheet1 in Move

Step2: Sheet5 is moved before Sheet1

Move Sheet5 before Sheet1

Switch a Worksheet

If multiple worksheets list in Excel, how can we select the one we want quickly?
Right click on ‘right arrow’ near ‘Sheet1’ to see all sheets, then select sheet.

Right click arrow to see all sheets

Change Background Color

Sometimes we can set different colors to distinguish different worksheets or group worksheets.
Right click on ‘Sheet1’ -> Tab Color -> Select Color, below example is changed to Red color.

Tab Color

Hide & Unhide a Worksheet

Hide

1. Right click ‘Sheet’ -> ‘Hide’, the current workbook (a worksheet exactly) is hidden. Notes here, if only one worksheet exists, Excel doesn’t allow to hide the worksheet.

Hide worksheet

Unhide

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

Unhide

 Unhide Screen

Unhide screen

Delete a Worksheet

1. Right click on ‘Sheet1’ -> Delete.

Delete a worksheet

If you already edit worksheet without saving, below message will pop up when clicking ‘Delete’ for confirm

Summary

Almost all worksheets operations can be done in Sheet navigator, but you can also operate worksheets in Home->Cells->Formats, details see ‘Rename a Worksheet’ method #2.

 

Related Posts

Delete Rows Based on Cell Value
remove rows based on values3

This post will guide you how to use the Find & Replace feature to delete or remove all rows based on certain cell value in Microsoft Excel. Or how to delete all rows that contain certain value with VBA code ...

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 ...

Sidebar