Excel Basics Archives - Page 55 of 176

Excel Sheet Not Visible When Opened: 6 Methods

Jul 3, 2024

Method 1 - Hidden Excel Sheets Not Visible When Opened Steps: Go to the View tab in the ribbon. From the Window group select the ...

Excel Sheet Not Visible When Opened: 6 Methods

How to Unhide Multiple Sheets in Excel (4 Ways)

Nov 11, 2025

You might want to hide several worksheets while using Excel to work with data that is dispersed across several worksheets. The amount of complexity ...

How to Unhide Multiple Sheets in Excel (4 Ways)

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