Excel Basics

2 Easy Ways to Indent Twice the Data in Excel

Indenting twice the data refers to adding a double gap at the start of a cell's content. Indentation makes it easier to read and understand long ...

How to Remove Unwanted Objects in Excel (4 Quick Methods)

The sample dataset below includes company logos (images). We will remove the logos from the worksheet using 4 different methods. Methods 1 ...

3 Easy Ways to Remove Indent in Excel

Removing indentation in Excel is necessary when you have to deal with a lot of misaligned lines. You may need to remove all the misaligned lines ...

How to Add Trend Arrows in Excel – 3 Methods

The following dataset contains year-to-year growth rates of some companies.   Method 1 - Add Trend Arrows with the Conditional ...

How to Create Multiple Sheets in Excel at Once (3 Methods)

Watch Video – Create Multiple Sheets in Excel at Once   Method 1 - Click the "New sheet" Button Multiple Times to Create ...

How to Create Table of Contents in Excel with Page Numbers: 3 Easy Methods

Method 1 - Use Link to Create Table of Contents with Page Numbers Step 1: Insert Page Numbers in Individual Worksheets Insert page numbers in the ...

How to Extend Print Area in Excel (5 Suitable Ways)

Sometimes, we have to deal with large datasets and we try to print the whole dataset on a single page in Microsoft Excel. For this purpose, we need ...

How to Count Negative Numbers in Excel (3 Easy Ways)

We often have negative numbers in our Excel dataset. Negative numbers can create a problem while calculating in Excel. So, it is important to count ...

Excel Conditional Formatting Icon Sets Based on Another Cell

It is sometimes necessary to format a lot of data in Excel in certain ways for better readability when dealing with a large amount of data. If you ...

Up and Down Arrows in Excel Using Conditional Formatting

Having up and down arrows in the proper places of datasets makes them more presentable and visually pleasing. Excel's default arrow formatting ...

Conditional Formatting Icon Sets Based on Text in Excel

Consider the following dataset containing some students marks, with remarks on these marks. By using icon sets we can highlight these remarks easily. ...

How to Add Up and Down Arrows in Excel (4 Easy Ways)

In the dataset for this tutorial, you will find fields for the name of the Stock companies, yesterday’s closing price(YCP), Present Price, and the ...

[Fixed!] Table Border Not Showing in Print Preview (2 Solutions)

In order to decorate our data while working with Microsoft Excel, we often use tables. Normally, the data are organized in different rows and columns ...

2 Ways to Add the Fill Color Icon to Quick Access Toolbar in Excel

Here's the overview of adding the Fill Color command to the Quick Access Toolbar. Method 1 - Using the Context Menu of the Excel Ribbon ...

How to Use Sheet View in Excel (with Simple Steps)

We have made a dataset to use the Sheet View ribbon. It has column headers: Branch Name, Sales Rep, Product Name, and Sales. Step 1 - ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo