Excel Basics

How to Reverse a String in Excel: 3 Suitable Ways

Method 1 - Using MID and CONCATENATE Functions to Reverse a String in Excel Steps: Enter the following formula in cell C4: ...

How to Move Data from a Row to a Column in Excel (4 Easy Ways)

Below, we have a sample dataset for these methods. Method 1 - Using Paste Special Command to Move Data from Row to Column in Excel Steps: ...

How to Reverse Column Order in Excel: 4 Useful Methods

Method 1 - Use Sort Feature to Reverse Column Order in Excel Steps: Select the Helper Column. Go to the Data On the Sort and Filter ...

How to Take Log of Negative Numbers in Excel: 3 Ways

The logarithm function provides an imaginary number as a result for negative numbers and isn't defined for them in Excel. You'll need to go around ...

What to Do If CTRL C Is Not Working in Excel (8 Solutions)

4 Major Reasons Why CTRL C Might Not Be Working in Excel Hardware problem can create the issue. The keyboard can malfunction so that CTRL C ...

How to Select Specific Rows in Excel Formula (4 Easy Ways)

Looking for ways to know how to select specific rows in the Excel formula? Sometimes, we want to select specific rows in Excel that contain formulas ...

How to Update Excel Links (Manually/Automatically)

We'll use the following datasets to demonstrate how you can update links inside and between sheets. ⏷Update Links Automatically ⏷Update ...

How to Create Tabs Within Tabs in Excel (With Simple Steps)

  Watch Video – Create Tabs Within Tabs in Excel Steps to Create Tabs Within Tabs in Excel In this tutorial, we will create ...

How to Go to the End of Excel Sheet (2 Quick Methods)

While working in Microsoft Excel we often use shortcuts to finish tasks in time. Although at the time of working on a worksheet we need to move to ...

How to Move Up and Down in Excel (5 Easy Ways)

To shift a row upwards using the Shift key and mouse, we first choose a row and then place it in the upper position. You will notice that the ...

[Fixed!] Cut and Paste Not Working in Excel

Need to learn how to solve if Cut and Paste not working in Excel? If you are looking for such unique tricks, you’ve come to the right place. The most ...

[Fixed!] Excel Update Links Manually Greyed Out

In our everyday usage of Excel, it is very common to use multiple ones at a time. It is also very common to link them together and update them on a ...

How to Skip to Next Cell If a Cell Is Blank in Excel (5 Easy Ways)

Consider the following dataset containing a list of Ids, Products, and their corresponding Sales values. In the Product ID column and Product column, ...

How to Select Highlighted Cells in Excel (4 Easy Methods)

Below is a dataset with information on a company's Customer Name, Product ID, and Price. We highlighted the cells with similar product ID numbers and ...

Difference Between Delete and Clear Contents in Excel

Need to learn what is the difference between Delete and Clear Contents in Excel? Delete and Clear Contents both are very essential features in Excel. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo