Excel Basics

[Fix] Excel Sort by Date Not Working (2 Causes with Solutions)

Sort by Date is not working in your Excel worksheet? Here in this article, we will discuss two fixes to this. Excel Sort by Date Not Working: ...

How to Move Rows Up in Excel (2 Quick Methods)

In this article, we will illustrate the process of how to move rows up in Excel. While working with a dataset a lot of times we have to move any ...

How to Group Rows in Excel with Expand or Collapse (5 Methods)

While making a report for a large dataset the report reader can want to see the summary instead of detailed rows and can want to expand specific ...

How to Calculate Percentage above Average in Excel (3 Easy Ways)

In this article, we will learn how to calculate the percentage above average in Excel. Sometimes, we need to calculate the average and find the ...

Unhide All Rows Not Working in Excel (5 Issues & Solutions)

In many cases, you have to unhide unnecessary rows to make particular rows more presentable. Unfortunately, you may get troubled if unhiding all rows ...

How to Print Page Number in Excel (5 Easy Ways)

When you print an Excel sheet, you may want to print the sheet with page numbers. In this article, I’ll introduce you to 5 easy ways to print the ...

How to Combine Multiple Workbooks to One Workbook in Excel (6 Ways)

Combining multiple workbooks into one master workbook can be quite intimidating. Depending on the contents and the number of worksheets in each of ...

How to Freeze Selected Panes in Excel (4 Suitable Examples)

Freezing panes is an excellent feature Excel offers that keeps certain rows or columns visible while scrolling through the spreadsheet. When a ...

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

In Microsoft Excel, many essential tools create a great user experience. One of them is the Date Picker. With this tool, you can insert any date and ...

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

Sometimes you may want to see the whole dataset on one page but just for one or two extra columns or rows, you have to deal with multiple pages. If ...

Shortcut to Unhide Rows in Excel (3 Different Methods)

While working, we need to unhide rows in Excel frequently. To know whether the rows are hidden or not carefully check the row numbers if some numbers ...

How to Turn On/Off Scroll Lock in Excel (2 Ways)

The Scroll Lock feature in Excel allows us to control the way of navigation through the worksheet. In this article, we’ll learn how to check the ...

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 Down Blanks in Excel (4 Quick Methods)

In this article, we will learn to fill down blanks in Excel worksheets. Sometimes, we need to download data in Excel from other sources and it may ...

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

To add rows or columns in Excel: Select the number of rows or columns you want to add by dragging the mouse. Press the CTRL and Plus (+) keys ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo