Latest Blog Posts

How to Make a Numbered List in Excel (8 Methods)

  Dataset Overview We have a dataset that contains information about 10 different students. Student names and their identification numbers are ...

How to Color Alternate Rows in Excel (8 Ways)

For decorating a dataset, you can color alternate rows in Excel. In this article, you will get to know several easiest and shortest methods to do ...

How to Move Rows in Excel (4 Simple & Quick Methods)

A lot of times, we have to move the rows in Excel datasheets to meet certain requirements. This article will show you the simple methods to Move Rows ...

How to Use VBA Len Function in Excel (4 Examples)

In this article, I will describe the details of the VBA Len function along with some examples. Likewise, excel LEN function, VBA Len returns the ...

How to Remove Duplicate Names in Excel (6 Simple Methods)

The following dataset contains the names of some salesmen, their state addresses, sales amounts in dollars, and target achievements. ...

How to Unmerge Cells in Excel (7 Easy Methods)

In this article, we will show you different methods to unmerge cells in Excel. To make our work easy we often merge two or more cells. Merging does ...

How to Fix Hidden Rows in Excel (4 Effective Solutions)

Dataset Overview Let’s delve into various solutions to address the issue of being unable to unhide rows in Excel. For our demonstration, we’ll work ...

How to Print Gridlines in Excel (2 Ways)

By default gridlines of a worksheet do not appear when we print it. But gridlines, rows, and column headings could be very useful to go through the ...

Repeat Text in Excel Automatically (5 Easiest Ways)

Here we have an Excel sheet with the monthly purchases of 4 people in January, where cell B4 represents Name, cell C4 represents Month, and cell D4 ...

How to Extract Month from Date in Excel (5 Quick Ways)

The following dataset contains some Product IDs, Sales, and Dates in columns B, C, and D. We want to extract the months from the Date column. ...

How to Change & Restore Default Row Height in Excel

Method 1 - Changing Default Row Height There are two methods to change the default row height. 1.1. Changing Default Row Height by Altering ...

How to Freeze Top Row in Excel (4 Easy Methods)

This article shows you how to freeze top rows in Excel in 4 different ways. You can freeze the top row in just two clicks by following one of the ...

How to Link Excel Workbooks – 4 Methods

You have sales data of different salesmen in the “Sales Data” sheet of the “Reference Workbook” workbook. To extract “Yearly Sales” from the ...

How to Remove Year from Date in Excel (5 Easy Ways)

There are a couple of ways to remove year from date in Excel. Functions such as TEXT offer a format to enter. MONTH and DAY functions extract month ...

How to Display Print Preview in Excel: 3 VBA Macros

Method 1 - VBA Macro to Display Print Preview for the Active Sheet Right-click on the sheet title. Select View Code from the context menu. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo