Excel Basics

How to Put Equal Sign in Excel without Formula (4 Easy Ways)

Sometimes, users need to put an equal sign in Excel without a formula. Some situations demand inserting equal signs without performing a calculation ...

[Solved]: Excel Formulas Not Updating Until Save (6 Possible Solutions)

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. ...

How to Stop Excel from Jumping Cells When Scrolling (8 Easy Methods)

If you are looking for some special tricks to stop Excel from jumping cells when scrolling, you've come to the right place. There are numerous ways ...

[Fixed!] Excel Horizontal Scroll Bar Not Working (8 Possible Solutions)

When we work with a large number of columns in a dataset, the Horizontal Scroll Bar of Excel helps us a lot to move horizontally. However, sometimes ...

How to Save One Sheet in Excel as PDF (3 Useful Ways)

PDF files are easy to print and in some cases also to read. So most of the time while printing our Excel file it is convenient to convert it into PDF ...

How to Change Theme Font in Excel (2 Easy Ways)

Sometimes, we don’t like our default theme font in Excel. Excel gives us a platform where we change the theme font and at the time, we can customize ...

How to Repeat Rows in Excel When Scrolling (6 Suitable Ways)

Sometimes while working with a big dataset we need to repeat rows in Excel when scrolling. This feature helps to keep important rows visible during ...

[Fixed!] Excel Cursor Locked in Select Mode (6 Possible Solutions)

We perform various operations in the Excel worksheet. It is tiresome to use keyboard arrow keys to go to desired cells and select them. Mouse cursor ...

How to Type Math Symbols in Excel (3 Easy Methods)

While working with Microsoft Excel, sometimes we need to deal with mathematical symbols. We can easily type those mathematical symbols in excel. ...

How to Convert Decimal to Time Over 24 Hours in Excel (2 Quick Methods)

If you don’t apply the proper format while converting the decimal numbers to times, you will get a time ranging from 0 to 24 hours. However, in this ...

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

This article illustrates how to insert the dollar sign ($) in the Excel formula. The dollar sign is used to change the cell references from relative ...

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

When working in Excel, you may encounter situations where the cursor transforms into a white plus sign. This white plus sign cursor issue can be a ...

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)

We use the Dollar sign to make absolute/mixed cell references in Excel. And also after using it, we often may have any need to remove the Dollar ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo