Excel Basics

How to Filter by Text Color in Excel (5 Easy Methods)

If you want to apply a Filter based on text color this is the right place for you. Here, I will explain how to filter by text color in Excel. ...

How to Clear Excel Temp Files: 3 Quick Methods

Method 1: Using Excel Options dialog box to Clear Temp Files Steps: Select File > Options option. Press the Ctrl + T keys to open the Excel ...

The Clipboard is Not Working in Excel – 11 Possible Solutions

This is an overview. Possible Reasons: If your Microsoft Office application is not updated. The clipboard is full. Other ...

How to Add Arrow in Excel Graph (with Easy Steps)

You might discover that, whether your worksheet includes a column chart or a line chart, you need to include arrows in the column chart to ...

How to Insert Red Arrow in Excel Cell (5 Examples)

Often, you might want to add up and down arrows in Excel so that you can easily understand the increase and decrease in the price of your business ...

How to Generate EAN 13 Barcodes in Excel (2 Methods)

While QR codes are becoming increasingly popular, barcodes remain widely used for product identification. Among these, the International Article ...

How to Create a Barcode Scanner to Track Check-in & Check-out Times in Excel (Step-by-Step)

  Step 1: Insert a Command Button in Excel Define a cell where you will put the input barcode. Here, I will put it in cell C4. Create a ...

How to Remove Text Box Border in Excel (2 Useful Methods)

If you are looking for how to remove text box border in Excel, then you are in the right place. A text box is an empty field where a user can fill in ...

How to Change International Number Format in Excel (4 Examples)

Example 1 - Converting European Number Format to US Number Format   Steps: Select the Cell C5 and enter the following formula. ...

How to Add Border to a Chart in Excel (3 Useful Methods)

If you are looking for how to add border to a chart in Excel, then you are in the right place. We frequently have to create charts in Excel for ...

Border Not Showing in Excel – 6 Solutions

This is the sample dataset. Solution 1 - Changing Line Color In the following dataset some cells have no borders because the Borders line ...

How to Add Thick Box Border in Excel (3 Quick Ways)

The following image shows data on the left without a border and on the right with a thick box border, including student names and departments. ...

How to Align Right in Excel (5 Simple Methods)

Here are five different ways to align cells to the right in Excel: Method 1 - Using the Home Ribbon The most common way to right-align the ...

How to Lock Borders in Excel (With Easy Steps)

In this article, we will explain how to lock the borders of a table in a few easy steps. Step 1 - Creating a Dataset To start with, we need a table ...

How to Align Text Boxes in Excel – 3 Examples

This is the sample dataset. Example 1 - Align Excel Text Boxes in a Horizontal Row Step 1: Insert Text Boxes Go to the Insert tab. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo