Excel Basics Archives - Page 103 of 176

How to Create a Correlation Heatmap in Excel – Quick Steps

Aug 8, 2024

The dataset contains students' marks in different Exams. Step 1 - Enable the Data Analysis Tool In the Data tab, enable Data ...

How to Create a Correlation Heatmap in Excel – Quick Steps

How to Import Data into Excel from Another Excel File (2 Ways)

Jul 3, 2024

We've included a sample data set with a workbook named Subtotal Pivot Table in the image below. This worksheet's data will be imported into another ...

How to Import Data into Excel from Another Excel File (2 Ways)

How to Move Cells using the Keyboard in Excel – 3 Methods

Aug 11, 2024

The dataset showcases students’ Names, Departments, Id No., and Grade. Method 1 - Using the Copy-Paste Method with the Keyboard to Move ...

How to Move Cells using the Keyboard in Excel – 3 Methods

How to Create a Risk Heat Map in Excel (3 Easy Methods)

Jul 18, 2024

Method 1 - Applying Conditional Formatting to Create a Risk Heat Map in Excel We have a dataset showing math, chemistry, and physics scores. We are ...

How to Create a Risk Heat Map in Excel (3 Easy Methods)

How to Separate Date and Time in Excel without a Formula – 3 Methods

Aug 13, 2024

This is an overview: The sample dataset contains date and time in the same cell. Method 1 - Using the Text to Columns Wizard to ...

How to Separate Date and Time in Excel without a Formula – 3 Methods

How to Make Geographic Heat Map in Excel (2 Easy Ways)

Apr 23, 2024

Method 1 - Using Built-in Maps Chart to Make Geographic Heat Map in Excel Case 1.1 Creating Heat Map of States For a demonstration ...

How to Make Geographic Heat Map in Excel (2 Easy Ways)

How to Recover Previous Version of Excel File (4 Easy Ways)

Jul 3, 2024

We'll use a simple dataset to show how to recover a previous version of a file. The name of the workbook is Recover Previous Version of Excel ...

How to Recover Previous Version of Excel File (4 Easy Ways)

How to Show Ribbon in Excel (5 Quick & Simple Ways)

Nov 11, 2025

This article illustrates 5 easy ways to show the ribbon in Excel. You may accidentally hide the ribbon in Excel. If you are wondering about how to ...

How to Show Ribbon in Excel (5 Quick & Simple Ways)

How to Show Toolbar in Excel: 4 Simple Ways

May 14, 2024

Method 1 - Show Toolbar Using Control Buttons Steps: The ribbon menu toolbar on a given Excel sheet is hidden at the moment. That means there ...

How to Show Toolbar in Excel: 4 Simple Ways

Is There Any Way to Increase the Excel Row Limit?

Jul 7, 2024

Each workbook in Excel has a limit on the number of rows and columns of data it allows. Tip: Hold the CTRL+Down Arrow key simultaneously to ...

Is There Any Way to Increase the Excel Row Limit?

How to Fill Blank Cells with Color in Excel – 5 Methods

Aug 10, 2024

This is the sample dataset. There are several blank cells in the dataset. Method 1 - Using the Go to Special Command to Fill Blank ...

How to Fill Blank Cells with Color in Excel – 5 Methods

How to Fill Blank Cells in Excel with ‘Go To Special’ (3 Examples)

Jun 17, 2024

Method 1 – Filling in Blank Cells with Previous Cell Values Steps: Select the entire range where you have blank cells. Go to ...

How to Fill Blank Cells in Excel with ‘Go To Special’ (3 Examples)

How to Fill Blank Cells with Value from Left in Excel (4 Suitable Ways)

Nov 11, 2025

At times, you can work in a dataset that has empty cells and you need to take the exact value from the left cell. In that case, you can do it ...

How to Fill Blank Cells with Value from Left in Excel (4 Suitable Ways)

How to Add Strikethrough in Excel Toolbar (3 Easy Ways)

Nov 11, 2025

Strikethrough is a special character. It is mainly used to format the cells. When a person applies the strikethrough on any cell, a line appears ...

How to Add Strikethrough in Excel Toolbar (3 Easy Ways)

How to Remove a Formula When Filtered in Excel (3 Ways)

Jul 1, 2024

Method 1 - Use the Delete Button to Remove a Filtered Formula with Values in Excel STEPS: Select the whole data range B4:E12. Go to ...