Excel Basics

How to Insert Dollar Sign in Excel Formula (3 Handy Methods)

Assume you have the following dataset. It contains sales from two different stores and their total. The FORMULATEXT function shows that the ...

How to Get Rid of Plus Sign Cursor in Excel: 2 Effective Methods

Method 1 - Using Excel Advanced Option Go to the File tab. Select Options from the left navigation menu. An Excel Options dialog box will ...

How to Save a Worksheet in Excel (2 Handy Approaches)

In this article, we will learn to save a worksheet in Excel. Generally, we can save an Excel workbook very easily. But to save a single worksheet in ...

How to Move Cursor in Excel Cell (2 Useful Methods)

Moving the cursor in an Excel cell is a quite simple and basic task. The arrow keys are the tool that we use most commonly in this regard. But some ...

How to Remove Dollar Sign in Excel Formula (2 Easy Ways)

  Introduction to Relative, Mixed, and Absolute Cell References We use cell references in Excel to automate the calculation. For example, “=A4 ...

How to Remove Plus Sign in Excel (2 Easy Techniques)

Sometimes, when we extract data from a text file, it might happen that we have extracted some unwanted plus signs. Now, it is required to remove ...

How to Insert a Check Mark in Excel – 7 Methods

Method 1 - Adding a Check Mark with ASCII Characters using the Microsoft Notepad Steps: Open the Microsoft Notepad. Press & hold ALT and ...

How to Type Minus Sign in Excel Without Formula: 6 Methods

Method 1 - Apply Insert Tab to Type Minus Sign in Excel Without Formula STEPS: Select cell C5. Go to the Insert tab. From the ...

How to Change Cursor from Plus to Arrow in Excel (3 Easy Steps)

Step 1 - Launch Visual Basic Window Select Visual Basic from the Developer tab. Step 2 - Insert VBA Code Click on Insert > Module. ...

How to Type Delta Symbol in Excel (8 Effective Ways)

We store various information in our Excel worksheet. They include texts, numbers, and even symbols. But, the input symbols are not a straightforward ...

How to Insert the Rupee Symbol in Excel -7 Quick Methods

The following dataset showcases ID No., Item, and Cost columns. Method 1 - Applying the Currency Format to Insert the Rupee Symbol in ...

How to Insert Symbol in Excel (6 Simple Techniques)

In our dataset, we have two columns named Symbol Name and Symbol. We need to insert 6 symbols. Method 1 - Directly Copy a Symbol from the ...

How to Put 0 in Excel in Front of Numbers (5 Handy Methods)

Method 1 - Convert Numbers to the Text Format to Add Leading Zeroes in Excel Steps: Insert an Apostrophe (') before starting a number to add 0 ...

[Solved]: All Excel Files Opening as Read Only (6 Solutions)

The sample alert message when opening a read-only file is shown in the image below. There could be a variety of causes for the issue. Some of the ...

Smooth Scrolling with Mouse Wheel in Excel (A Welcome Update)

Smooth Scrolling is a new feature that allows you to scroll one line vertically or a single character horizontally at a time using the mouse wheel in ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo