Excel Basics

How to Group Rows in Excel – 5 Easy Methods

The dataset showcases data of a company that operates in 3 regions and sells 3 different products- TV, Heater, and Fan. Method 1 - Grouping ...

How to Sort and Ignore Blanks – 4 Methods

The following data table has blank rows. Before applying the sort command, hide the rows first. Method 1 - Hide Blank Rows to Sort ...

How to Freeze Top Two Rows in Excel (4 ways)

To put the concept of freezing the top two rows into practice, here's a sample data set of people's basic information: Last Names, Ages, Occupations, ...

How to Center the Print Area in Excel – 4 Methods

The dataset contains the salary statements of the sales representatives. Method 1 - Using Keyboard Shortcuts to Center the Print Area in ...

How to Set Print Area in Excel (5 Methods)

In the sample dataset we only want to print a portion of the content.     Method 1 - Set Print Area From Page Layout Tab ...

Hide Rows in Excel Using Shortcuts, Commands and VBA

Method 1 - Use Format Menu to Hide Rows Click on the row number of a row >> Drag down the cursor or hold the SHIFT key to select ...

How to Apply Custom Freeze Panes in Excel (3 Easy Ways)

In this article, we will demonstrate how to use custom freeze panes in Excel. We can easily lock the first row or column from the ‘Freeze Panes’ ...

How to Sort by Name in Excel (3 Examples)

Example 1 - Use Sort & Filter Group to Sort Columns by Name To sort names alphabetically. 1.1 Sort a Column by Name Step 1: Select the ...

How to Fix If Flash Fill Not Recognizing a Pattern in Excel

  Excel Flash Fill Excel Flash Fill is a feature or tool that analyzes entries when users enter them and fills the data after recognizing a ...

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 ...

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 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 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. ...

How to Sort Drop Down Lists in Excel – 5 Easy Methods

  Method 1 - Applying the SORT Function to Arrange and Create a Drop-Down List The sample dataset (B4:C13) contains fruit names in random ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo