How to Move and Copy a Worksheet

Right Click │Ribbon Command To copy and move a worksheet including data and format to a new worksheet or a new workbook will significantly save your time. For example, you created a worksheet with data in tables for one company, and you need to apply the same format to 10 other companies. Step 1: [...]

How to Sort Worksheets Alphanumerically in a Workbook

When working with a large database that contains many worksheets, it will be helpful to sort worksheets alphanumerically. Unfortunately, Excel 2016 does not provide a direct way to sort worksheets. The following is a macro which we can borrow to perform the task. Step 1: Click anywhere in the workbook, then press "ALT [...]

How to Move a Worksheet

It is common to move a worksheet to a new location when you work with a large database. To move your worksheet, please follow the steps below: Step 1: Click the worksheet name that you need to move, then hold your mouse; Step 2: Drag the worksheet to the location you need to [...]

How to Change Hide or Unhide a Worksheet

Hide a Worksheet │Unhide a Worksheet 1. To Hide a Worksheet? You can hide the worksheets that you do not want show up. To hide a worksheet: Step 1: Move your mouse on the worksheet name that you need to hide; Step 2: Right click, and select "Hide" from the dialog box; [...]

How to Change Tab Color Worksheet

Suppose you have a large workbook which contains multiple worksheets. To have different colors for each of data category will make your work much easier. To change worksheet Tab color: Step 1: Right click on the worksheet Tab you need to change, select "Tab Color" in the color dialog box; Step 2: Select [...]

How to Rename a Worksheet

Right Click │Ribbon Command Even the name of a worksheet can have 31 characters (including spaces) as the maximum, it is always good to use concise names to well organize your worksheets. Step 1: To rename a worksheet, double click or right click on the worksheet name, then select "Rename"; Step 2: [...]

How to Delete One or More Worksheets

One Worksheet │Adjacent Worksheets │Worksheets Not Adjacent 1. How to Delete One Worksheet? Step 1: Move your mouse on any of the worksheet name, then right click; Step 2: In the new window, click "Delete" and the worksheet will be deleted. 2. How to Delete Multiple Worksheets that are Adjacent? To [...]

How to Insert a New Worksheet

To insert a new worksheet, simply click the plus sign after the worksheet name. Another method is to use right click: Step 1: Right click on the worksheet name, then click "Insert" in the new window; Step 2: In the "Insert" window, click "Worksheet"; Step 3: Click OK at the bottom, a new [...]

How to Check If Cell Contains Special Content

Count Cells with Text How to Count Cells that Contain a Value How to Count Cells that are Space How to Count Cells that are Blank How to Count Cells that Contain Text How to Count Cells that Contain No Text How to Count Cells that Contain a Text String How to Count Cells that [...]

How to Extract Text

Extract Text from Left How to Extract Text from Left How to Extract the First Word How to Extract the First Two Words How to Extract the First Three Words How to Extract the First Four Words Extract Text from Right How to Extract Text from Right How to Extract the Last Word How to [...]