Excel Basics

How to Auto Fit Row Height in Excel (5 Useful Ways)

Consider a dataset where some rows have excessively large row heights, while others have very small ones, such as the image below. It looks ...

How to Remove Last Digit in Excel (6 Quick Methods)

Let's use the following dataset of some random data to explain how to remove last digits. How to Remove Last Digit in Excel: 6 Quick ...

How to Convert Text to Hyperlink in Excel (5 Methods)

Method 1 - Activate Automatic Hyperlinks Option to Convert Text to Hyperlink in Excel In the following dataset, we can see the URLs of 5 companies. ...

How to Multiply Rows in Excel (4 Easy Ways)

Method 1 - Basic Ways to Multiply Rows in Excel Multiply a Row by a Cell Select the appropriate cell (C6 in this example) and type the ...

How to Auto Sort Table in Excel (5 Methods)

Excel features a variety of useful tools for automatically sorting tables. In this article, we'll discuss how to use the SORT, SORTBY, VLOOKUP and ...

How to Merge Cells Using Excel Formula (8 Formulas)

Formula 1 - Merging Multiple Cells Using the Merge & Center Feature in Excel The dataset has a text “Merge and Center in Excel” in cell B2. We ...

How to Show Percentages in an Excel Pie Chart: 3 Methods

Below, we have the population percentages by major ethnic groups in Southern California. We have created a pie chart using this data and added ...

Cannot Insert Column in Excel (All Possible Causes with Solutions)

We'll use the following dataset to try to insert a new column to add some additional data. We will show you why you can't insert a column in this ...

How to Remove Both Duplicates in Excel – 5 Methods

After merging data from two worksheets, the dataset contains identical entries or both duplicates: Method 1- Using a Helper Column to ...

How to Multiply Two Columns in Excel (5 Easiest Methods)

We'll use a sample dataset as an example to help you understand how to multiply columns. We are given Names of some Items in column B, Prices in ...

How to Use Multiply Sign in Excel (Including 3 Alternatives)

How to Use the Multiply Sign (*, the Asterisk) for Multiplication in Excel We will use Asterisk (*) to multiply the quantity and unit price for each ...

How to Undo Sort in Excel (3 Easy Methods)

Method 1 - Use Ctrl + Z to Undo a Sort in Excel Press Ctrl + Z immediately after sorting your data. The Undo shortcut will instantly undo a ...

How to Remove Table Functionality in Excel: 3 Methods

Method 1 - Use the Convert to Range Command to Remove Table Functionality Steps: Click any data on your table. Go to Table Design > ...

How to Print and Fit Content to One Page in Excel (10 Methods)

Dataset Overview To achieve this, we’ll work with a Comprehensive Employee Dataset that includes columns for Employee ID, Full Name, Department, Job ...

How to Calculate Total Row and Column in Excel: 4 Methods

Method 1 - Use the SUM Function to Calculate Total Row and Column in Excel 1.1 Calculate Total Row Steps: Learn how to calculate row values ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo