Excel Basics Archives - Page 55 of 176

How to Put Excel Tabs on Top of Worksheet (2 Easy Ways)

Jul 23, 2024

Here's a GIF overview of how to access worksheets from the Quick Access Toolbar (QAT) which are added in QAT using VBA code. Method 1 - ...

How to Put Excel Tabs on Top of Worksheet (2 Easy Ways)

How to View All Sheets in Excel at Once (5 Easy Ways)

Jun 18, 2024

Method 1 - Viewing Two Sheets from the Same Workbook Side by Side Steps: Click on the View tab. In the Window group, click on New Window. ...

How to View All Sheets in Excel at Once (5 Easy Ways)

Conditional Formatting with More than 3 Icon Sets in Excel

Nov 11, 2025

The article will show you how to use Conditional Formatting Icon Sets more than 3 in Excel. Normally we use Icon Sets to emphasize the significance ...

How to Create Tabs Automatically in Excel (3 Cases)

Jul 15, 2024

Opening new tabs one by one and naming them in Excel is tedious and time-consuming. But we can create tabs automatically using VBA codes. ...

How to Create Tabs Automatically in Excel (3 Cases)

4 Easy Ways to Change Indent in Excel

Nov 11, 2025

Excel has three default horizontal alignments for a cell: left, right, and center. But you can change the position of a value horizontally based on ...

How to Undo and Redo in Excel (2 Suitable Ways)

Nov 11, 2025

Sometimes we mistakenly perform an action in Excel and we need to undo it. Again we need to redo an action sometimes. These can be easily done in ...

How to Undo and Redo in Excel (2 Suitable Ways)

How to Stop Cell Mirroring in Excel (5 Easy Ways)

Jul 3, 2024

Method 1 - Ungrouping Worksheets When multiple sheets in the workbook are grouped, entering data into any cell will input the same data into the ...

How to Stop Cell Mirroring in Excel (5 Easy Ways)

How to Insert Tab in Excel Cell (4 Easy Ways)

Apr 26, 2024

Let's use the following dataset to illustrate the methods of inserting a tab in a cell. Method 1 - Adding Spaces Manually Steps: ...

How to Insert Tab in Excel Cell (4 Easy Ways)

How to Create Table of Contents for Tabs in Excel: 6 Methods

Aug 6, 2024

Method 1 - Using Context Menu to Create Table of Contents for Tabs in Excel Steps Write down all the spreadsheet tabs where you want to add ...

How to Create Table of Contents for Tabs in Excel: 6 Methods

Using an Excel Formula If the Cell Contains a Negative Number – 6 Examples

Aug 7, 2024

The following dataset showcases Item, and Expense/Income. Example 1 - Use the COUNTIF Function If the Cell Contains a Negative Number ...

Using an Excel Formula If the Cell Contains a Negative Number – 6 Examples

How to Zoom Out in Excel (7 Quick Methods)

Aug 2, 2024

Method 1 - Zoom Out Using the Excel Status Bar We have a dataset (B4:E9) in an Excel worksheet. The zooming of the window is 100%. Click ...

How to Zoom Out in Excel (7 Quick Methods)

How to Create Multiple Sheets with the Same Format in Excel (4 Methods)

Jul 26, 2024

Dataset Overview We have the following dataset. Now, we want to create more datasets with the same format. Method 1 - Copy Excel ...

How to Create Multiple Sheets with the Same Format in Excel (4 Methods)

How to Create Multiple Worksheets from a List of Cell Values: 5 Easy Ways

May 19, 2024

Method 1 - Using Excel Pivot Table Steps Select the range of cells B5:B9. Insert tab, select the drop-down arrow of the PivotTable > From ...

How to Create Multiple Worksheets from a List of Cell Values: 5 Easy Ways

How to Create a Structured Reference in Excel (with Easy Steps)

Nov 11, 2025

While working in Microsoft Excel you will find a structured reference inside an Excel table at the time of applying formulas. This is very helpful ...

How to Create a Structured Reference in Excel (with Easy Steps)

How to Insert a Footer in Excel (2 Suitable Ways)

Nov 11, 2025

Headers and footers are used in Excel Sheets to show some information at the top and bottom respectively of each sheet. When we print the Excel file ...