Excel Basics

How to Make a Table in Excel with Lines (with Easy Steps)

If you are searching for the solution or some special tricks to make a table in Excel with lines then you have landed in the right place. There are ...

How to Lock the Zoom in Excel Using VBA – 7 Steps

 Step 1 - Open the VBA Window Press ALT+F11 to open the VBA window. Select Insert >> Module. Step 2 - Create the Sub ...

How to Create New Sheets for Each Row in Excel (4 Easy Methods)

Watch Video – Create New Sheets for Each Row in Excel Suppose you have the following dataset: Method 1 - Using an Excel Pivot ...

How to Use HLOOKUP with Structured Reference in Excel

What Is a Structured Reference? A structured reference is a term that refers to using a table name in an Excel formula in lieu of a usual cell ...

How to Create Multiple Sheets in Excel with Different Names (3 Methods)

  Watch Video – Create Multiple Sheets with Different Names in Excel The sample dataset has 3 different titles for 3 sheets. ...

How to Insert Sheet from Another File in Excel (3 Easy Ways)

To explain the methods shown in this tutorial, we will use two Excel files. The name of the first workbook is Insert Sheet from Another File, and the ...

2 Effective Ways to Indent Bullet Points in Excel Cell

Indenting bullet points in Excel cells enhances data clarity by creating a visual hierarchy. This helps in presenting information in a structured ...

How to Fix Watermark in Excel (2 Useful Methods)

If you are looking for how to fix a watermark in Excel, then you are in the right place. In our practical life, we often need to use Excel for ...

How to Redo in an Excel Sheet (2 Quick Ways)

Microsoft Excel provides us with numerous system features to perform operations in the blink of an eye! There are a lot of Excel functions that are ...

How to Create Table of Contents in Excel (6 Suitable Ways)

We will use a sample dataset, which has 2 Columns, Product and Sales, across 5 worksheets, Dataset, Sales of January, Sales of February, Sales of ...

Find and Replace Tab Character in Excel (2 Suitable Ways)

We have 5 cells that have the tab character inside. We want to find and replace these tab characters. Method 1 - Using the Find and ...

How to Use Drawing Tools in Excel (2 Easy Methods)

Method 1 - Using the Drawing Tools from the Insert Tab We'll draw a simple flow chart. Steps: Choose “Shapes” from the “Insert” option. ...

How to Fix If Undo and Redo in Excel Are Not Working (3 Simple Solutions)

  Solution 1 – Open Excel in Safe Mode STEPS: Go to the Windows search bar. Enter Excel.exe /Safe. You’ll get the application, as ...

How to Zoom in When Zoom Slider Is Not Working in Excel

Looking for ways to know how to zoom when the zoom slider is not working in Excel? Sometimes, we may find that the zoom slider is not added or is not ...

How to Zoom in on a Map Chart in Excel (5 Methods)

Dataset Method 1 - Zooming in on a Map Chart in Excel Using Paste Special In this method, we’ll utilize the Paste Special feature to zoom ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo