Excel Basics

How to Create a Vertical Scroll Bar in Excel (Step by Step)

In this article, we will describe how to create a vertical scroll bar in Excel. Watch Video – Create a Vertical Scroll Bar in Excel ...

How to Read Full Comment in Excel (6 Handy Methods)

In this article, we will walk you through some effective methods to read full comments in Excel. The following table contains the Name, Subject, ...

How to Put Sign in Excel Without Formula: 5 Methods

Method 1 - Use Format Cells Feature to Put Sign Without Formula STEPS: Select the cell in which you want to put a sign. We select cell C5. ...

How to Make Fractions Smaller in Excel (2 Possible Ways)

In this article, we present 2 methods to auto-format fractions such that they shrink to smaller characters in the cells in which they appear, to look ...

How to Hide Comments in Excel: 4 Quick Methods

Method 1 - Deselecting Show Comments Button to Hide Comments in Excel Worksheet Steps: Navigate to the Review tab, click Show Comments. ...

How to Edit Headers in Excel (6 Easy Methods)

We have a dataset of employees of the IT department of an organization named ABC containing their attendance list for the month of May 2022. By ...

How to Fix Excel Not Scrolling with Arrow Keys (4 Solutions)

1 - When the Enabled Scroll Lock Feature in Excel Prevents Scrolling with Arrow Keys 1.1 Turning Off Scroll Lock from External Keyboard   ...

How to Find Comments in Excel: 4 Easy Methods

Method 1 - Using Show Comments Command from Review Tab to Find Comments in Excel Steps There are threaded comments on some of the cells in the ...

How to Remove Pop-up Comments in Excel (4 Suitable Ways)

We have a data set with some comments in the cell, which are giving pop-up comments when hovering over the arrows at the edges of the cells. We will ...

How to Extract Comments in Excel (3 Suitable Examples)

To illustrate how to extract comments in Excel, we'll use a sample dataset with 4 comments in the range of cells C4:C8. The VBA module is ...

How to Change the Cursor Color in Excel -2 Quick Methods

The  mouse cursor and a cell border cursor are showcased in the image below. This is the sample dataset. Method 1 - Change the ...

How to Add Symbol Before a Number in Excel: 3 Methods

Method 1 - Use Symbols Group to Add a Symbol Before a Number Step 1: Open the Symbols Option Select cell B5. Click on the Insert tab. ...

How to Enable Editing in Excel Protected View (5 Methods)

Method 1 - Clicking on 'Enable Editing' to Edit in Protected View When opening an unsafe file (saved in previous versions of Excel or received from ...

How to Change Background Color to Grey in Excel (Step by Step)

In this article, we will explain how to change the Excel background color to grey. Unfortunately we can’t simply change the Excel background color ...

How to Hide Notes in Excel: 3 Handy Approaches

Method 1 - Hiding Notes in Excel Through Review Tab 1.1 Hiding All Notes STEPS: Go to Review ➤ Notes. Select Show All Notes. All ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo