Excel Basics

How to See Where Excel Autosave Files Are Stored (5 Easy Ways)

In this article, we will learn to see where Excel AutoSave files are stored. Microsoft Excel has AutoSave and AutoRecover systems that retrieve your ...

How to Save Excel as PDF (6 Useful Ways)

Just converting an Excel to a PDF isn’t something troublesome, but making it a neat, presentable & printable PDF document is a bit tricky. I'll ...

Horizontal Scroll Not Working in Excel (6 Possible Solutions)

This article highlights 6 possible solutions if the horizontal scroll is not working in excel. You need to scroll through your dataset if you have a ...

[Fixed!] Bottom Scroll Bar Missing in Excel (7 Possible Solutions)

Excel's scroll bar is an integral and essential navigational tool for quickly skimming through long passages of the worksheet window. When it comes ...

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

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

View Side by Side with Vertical Synchronous Scrolling in Excel

In the recent versions of Microsoft Excel comparing worksheets side by side is a lot easier with vertical synchronous scrolling. This is the feature ...

[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 Remove Sign in Excel (With 3 Examples)

We work in Excel for different purposes. Like, we work with currency-related operations, and there appear currency signs. And you could imagine a lot ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo