## 2 Easy Ways to Transpose Data in Excel

If you want to transpose data in Excel to convert rows to columns or the inverse, then Excel has already made it easier for you to do it. Transposing vertical data to horizontal data or horizontal data to vertical data can be done using two methods. This article is a step-by-step guide to transpose data …

## Merge Cells in Excel [Easy Step-by-Step]

It is easy to Merge Cells in Excel. This article is an easy-to-understand, detailed, and step-by-step guide to merging cells in Microsoft Excel.   Also read: How to add borders to cells in Excel Steps to Merge Cells in Excel  Let’s get started with learning different types of merging for cells in a sheet.   First, we …

## How to shade alternate rows in Excel?

You can shade alternate rows to make the data in your worksheet easier to scan and soothing to the eyes. This is also known as color banding. In this article, we will learn how to shade every other row in Excel. Also read: Select non-adjacent cells in Excel Here’s the step to step guide to …

## How to Calculate the Square Root in Excel?

In this tutorial, we will learn 3 easy ways to calculate the square root of a number in Excel. It will be a very common calculation that you’ll perform very often if you work with large mathematical datasets of any kind. So let’s get started. Different Ways to Calculate the Square Root in Excel There …

## How to randomize a list in Excel?

In this article, we’ll learn to randomize a list in Excel. Although there is no native function to perform random sort in Excel, an inbuilt function RAND, which is used to generate random numbers, can be utilized to randomize a list. The RAND function takes no arguments. Steps to Randomize a List in Excel Let …

## [Step-by-Step Guide] How to Clear Formatting in Excel?

It is common to keep editing or discard a few changes made to your sheets while working in Excel and the program is designed to make your tasks more convenient for you. This article is a step-by-step guide to learn clear formatting tools in excel.  Steps to Clear Formatting in Excel Let’s get started with …

## How to Convert Excel to PDF?

Let’s learn how we can convert Excel to PDF in an easy step-by-step manner. Often one needs to share Excel files with others over the Internet. Sharing as PDF is one of the widely-used and most reliable ways of sharing documents as the document format is maintained and it works on almost any operating system …

## How to square a number in Excel?

In this article, we’ll learn how to square a number in excel. Squaring a number simply means multiplying a number by itself, or raising it to the power of 2. In Excel, there are three easy ways in which you can square a number. To understand how to quickly square a number, we consider the …

## How to Generate Random Numbers in Excel?

You may need to generate random numbers for a variety of purposes. In this tutorial, we will learn how to generate random numbers in Excel. There are two in-built functions in Excel to generate random numbers: RAND and RANDBETWEEN. Let’s look into how we can use these two functions. Generate random numbers using RAND RAND function returns …

## Convert Excel to Google Sheets [Step-by-Step]

In this article, we’ll learn to convert Excel to Google Sheets. Are you a Google Sheets user and received an Excel file but you also don’t want to come out of your comfort zone and want to open the same file in Google Sheets? Let’s get started with this complete tutorial on converting Excel files …