Latest Blog Posts

How to Insert a Date Picker in Excel (With Step-by-Step Procedure)

Download the Practice Workbook Insert Date Picker.xlsm Why Is Date Picker Useful in Excel? Here's an example of a date picker in ...

How to Use ‘Column Index Number’ Effectively in Excel VLOOKUP

Brief Description of the VLOOKUP Function In the below example, there is a movie dataset. Here, we used the VLOOKUP formula to extract data. ...

VBA to Merge Cells in Excel (9 Methods)

In Excel, to merge multiple cells or ranges into one singular cell using VBA, the Range.Merge method is used. Range.Merge Method in Excel ...

How to Print Sheet on One Page in Excel (9 Easy Ways)

In this article, we present 9 different techniques and tricks to print an Excel sheet on one page. Method 1 - Adjusting the Column Width or Row ...

How to Unhide Rows in Excel Using Shortcuts (3 Methods)

Dataset Overview Our dataset to demonstrate these methods, is a list of students with their hometowns and departments. The 5th, 7th, 8th, 10th, ...

Auto Row Height Not Working in Excel (2 Quick Solutions)

A quick guide to solve the problem when the Auto Row Height command is not working properly in Excel. You will learn two quick methods with sharp ...

How to Turn On/Off Scroll Lock in Excel

Step 1. Check the Status Bar in Excel The status bar in Excel provides useful information about the active worksheet. We can customize the status ...

How to Group Rows by Cell Value in Excel (3 Simple Ways)

Consider this dataset: Year, States, Items, Sales Channel, and Sales Unit. Let's say you want to summarize the total units sold at the states and ...

How to Fill Blanks in Excel – 4 Methods

  Method 1 - Fill Blanks using the ‘Go To Special’ Dialog Box The sample dataset contains employees' information: Department, Age, and Working ...

Print to PDF in Excel VBA with the ExportAsFixedFormat Statement: 5 Examples

Method 1 - Print to PDF in Excel VBA with No Name or Path Specified We have a worksheet with the book records of a bookshop called Marin Bookstore. ...

How to Add Rows and Columns in Excel (3 Methods)

Method 1 - Using Keyboard Shortcut You can use keyboard shortcuts to add adjacent & non-adjacent columns or rows in Excel. Here are 4 cases ...

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 Print Landscape in Excel (3 Easy Methods)

In this tutorial, we will cover how to print landscape in Excel. When we print something from an Excel worksheet by default, Microsoft Excel prints ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo