Excel Basics

How to Clear Cache in Excel (7 Ways)

  Method 1 - Disabling a Recent Document List Steps: Select the File tab on your Excel ribbon. Select Options from the left side of ...

How to Rename Files in a Folder in Excel (2 Easy Ways)

Here, we will need some files instead of a data set to perform my task. We will rename the following files which all are located in the same folder. ...

How to Apply Top and Bottom Border in Excel (3 Efficient Ways)

In this Excel tutorial, we will explain how to apply Top and Bottom border. In the image below, the cells on the left don't have borders, but on ...

How to Add a Comment on a Graph in Excel (3 Easy Methods)

We will consider a dataset of Sales of ABC Traders from B4 to C10. We will add a chart and add a comment on it. Method 1 - Adding a ...

How to Rename Multiple Sheets in Excel (With Easy Steps)

We can rename multiple sheets by using a simple Visual Basics for Applications (VBA) code. Step 1: Insert Multiple Sheets In this ...

How to Clear Recent Documents in Excel (3 Effective Ways)

Method 1 - Using Excel Options Feature to Clear Recent Documents Steps: Go to the File tab. Click on Options. In the Excel ...

Comments Are Not Displaying Properly in Excel: 3 Methods

Method 1 - Mark Indicator Only, and Comments and Notes on Hover Option Solution: Click the File tab beside the Home tab. Click on ...

How to Convert Numbers to Barcode in Excel (3 Easy Ways)

We will use the sample dataset below to illustrate how to convert numbers to Barcode in Excel. Method 1 - Converting Numbers to Barcode ...

How to Apply Alignment in Excel Conditional Formatting

To demonstrate alignment using conditional formatting, we have a sample data table like the image below. Method 1 - Apply Right and Left ...

[Solved]: Filter by Color Not Working in Excel (7 Quick Fixes)

To demonstrate the solutions, we have a sample dataset of employee salaries. In the dataset, three cells with values below $3500 are filled yellow. ...

How to Paste an Image into an Excel Cell from Clipboard (2 Easy Ways)

Method 1 – Using a Keyboard Shortcut Below are the blank cells where we will paste the image from the clipboard. We have also resized the cell size ...

How to Move Barcode Scanner to Next Row in Excel (2 Ways)

Let’s look at the ways to move the barcode scanner to the next row in Excel. We'll use a simple dataset with random product codes. Method ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo