Excel Basics

How to Move One Cell Down Using Excel VBA (4 Methods)

The dataset represents the sales of various salespersons in different regions. Method 1 – Using VBA to Move One Cell Down from an Active ...

How to Make Subtotal and Grand Total in Excel (4 Methods)

Consider the dataset as shown in the following screenshot. Here, the sales report contains Product Items, States, Price, Quantity, and Sales. We'll ...

How to Use SUBTOTAL in Excel with Filters (With Quick Steps)

This article will demonstrate how to use the SUBTOTAL function in Excel with filters. Excel SUBTOTAL Function: Overview Objective: The ...

How to Enable Vertical Side-by-Side View in Excel – 4 Methods

Method 1 - Enable Vertical Side-by-Side View of 2 Worksheets in the Same Excel Workbook This is the first sample dataset. This is the dataset ...

How to Group Rows with Same Value in Excel (6 Useful Ways)

In this article, we demonstrate multiple ways to group rows with same value using Excel features and formulas. Suppose we have an organized dataset ...

How to Sort Data by Value in Excel (5 Easy Methods)

The Excel Sort option allows us to customize the order of worksheet data. We can sort data alphabetically, numerically, date-wise, etc. Let’s explore ...

How to Remove Sort by Color in Excel (With Easy Steps)

Step 1 - Add an Extra ‘Index’ Column Enter a 1 in a blank cell of the Index column to the right of the data set. Drag the Fill Handle to the ...

[Fixed!] Keyboard Arrow Keys Not Working in Excel (7 Fixes)

Solution 1 - Turn Off the Scroll Lock One of the most common reasons for arrow keys not working properly is that the Scroll Lock is turned on. You ...

How to Remove Space between Rows in Excel: 5 Methods

Method 1 - Remove Space between Rows Using Wrap Text Select the cells that have space between rows; you see the Wrap Text option is enabled from ...

How to Move Merged Cells in Excel – 3 Methods

This is the sample dataset. Method 1 - Using the Paste Special Command to Move Merged Cells Steps Move B5:E9 to the empty range ...

How to Fix Excel Cells Not Being Able to Move: 5 Solutions

Solution 1 – Disabling Scroll Lock in Excel Steps: Right-click on the Status bar at the bottom of the worksheet. Select Scroll Lock to turn ...

Move and Size with Cells in Excel (3 Examples)

In this article, we will describe how to move and size objects with cells in Excel using the Move and size with cells property. Checking this option ...

How to Move Highlighted Cells in Excel (5 Ways)

We'll use the data of 10 employees of a company. Their names and salaries are in columns B and C. We will highlight the entities that are in the ...

Move One Cell to Right Using VBA in Excel: 3 Methods

Method 1 - Move One Cell to Right Using Range Property Steps: Open the Developer tab. You can open it by pressing Alt+F11, or you can customize ...

How to Create Collapsible Rows in Excel (4 Methods)

The following Item Price List table shows the Month, Item, and Price columns. We will collapse the rows of this table. Method 1 - Creating ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo