Excel Basics

How to Move Cells without Replacing in Excel (3 Methods)

There are several ways to move cells in Excel without replacing them. Among them, we will show you 3 simple, easy, and effective methods. How ...

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

[Fixed!] Rows and Columns Are Both Numbers in Excel

Usually, the rows are labeled in numbers and the columns in letters in our Excel worksheets. But, there are some instances where this setting can get ...

How to Rearrange Rows in Excel (4 Ways)

Sometimes, while working in Microsoft Excel we may feel the need to rearrange rows according to our convenience. Suppose, we have a dataset like the ...

How to Make a Bulleted List in Excel (9 Methods)

In Microsoft Word, it is easy to make a bulleted list with just a single click. But in Excel is it possible? Yes, it is. Today in this article, I am ...

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

How to Lock Rows in Excel When Scrolling (4 Easy Methods)

Imagine you have the following dataset containing sales made by employees in different years. If you try to scroll down through the data, then ...

How to Hide Rows Based on Cell Value with Conditional Formatting in Excel: 2 Methods

Method 1 - Changing Text Color to Hide Rows Based on Cell Value with Conditional Formatting Steps: Select the cell range B5:D10. From the ...

Group Rows with Plus Sign on Top in Excel

Sometimes, when we group rows in Excel, the plus sign that appears as an outline can be confusing to use. We can change this by moving it on top for ...

How to Insert a Column if Greyed-out in Excel (9 Solutions)

Solution 1 - Change Microsoft Excel AppData with Windows Run Feature Steps: Close the Excel file. Press the Windows key + R to enter the Run ...

How to Print Selected Area in Excel on One Page (3 Methods)

Method 1 - Using File Tab to Print Selected Area in Excel on One Page Steps: Select the area that you need to print. We have selected B4:F12. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo