worksheet

Spell Check in Excel Change Spell-checking Options In this lesson, we will go over how to check the spelling of text, add words to the dictionary, and change spell-checking options. To spell check in Excel, follow the steps below. 1. Open a workbook that has cells with misspelled words. 2. Click “Spelling” on the Review […]

Get Sheet Name in Excel In Excel, there is no singular function that can supply you with the excel sheet name. However, we can combine three separate functions to get the sheet name. These functions are- CELL, FIND, and MID functions. Let’s do it step by step. 1. Write the CELL function in any cell.

View Multiple Worksheets in Excel To view multiple worksheets at a time, follow the steps below. 1. Open a workbook. 2. Click “New Window” on the View tab. Excel opens another copy of the same workbook. 3. Now, click “Arrange All” on the View tab. 4. Select any orientation you like from the dialog box.

Consolidate Data in Excel Consolidation in Excel is a powerful way to do some simple mathematical operations from two or more worksheets from either a workbook or separate workbooks. To show how to consolidate data in Excel, let’s calculate the sum from three individual Excel files by following the steps below. 1. First of all,

Group Excel Worksheets In Excel, grouping worksheets will enable the user to add or delete data in multiple worksheets at the same time. Follow the steps below to group worksheets. 1. Hold down CTRL and click the sheets from the sheet tab that you like to group together. For instance, we click Sheet1 and Sheet2.

Excel Freeze Panes Unfreeze Panes | Freeze First Column | Freeze Rows | Freeze Columns | Freeze Cells | Add Button When you work with a large table of data in Excel, the freeze panes allows you to freeze rows or columns for better visibility. In other words, you can keep one part of the

Split Excel Worksheet You split worksheet in Excel to view different parts by using the split menu. You are going to need this when the worksheet is long. Below are the steps. 1. Select a cell that you like to split. For instance, we select cell A5. 2. Click “Split” on the View tab. 3.

Excel Zoom You can Zoom in and out in Excel by using zoom in the status bar and using the View tab. 1. To zoom in/out of your worksheet, click the plus or minus sign on the status bar. The bar shows the percentage number so that you can magnify the worksheet to your likings.

Excel Worksheet Insert | Rename | Move | Delete | Copy An Excel worksheet refers to the collection of cells where you enter, edit, and analyze the data. One or more worksheets can form a workbook. In this lesson, we are going to show common operations involving worksheets. Select a Worksheet Excel automatically selects a