Excel Basics

How to Insert Scroll Bar in Excel (2 Suitable Methods)

Here is an overview of how to insert a scroll bar in the Excel worksheet using the Developer tab. 2 Ways to Insert Scroll Bar in Excel ...

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

We will use a workbook that contains some information about the projects of a company. Using the workbook, we will try to see where Excel AutoSave ...

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)

Solution 1 - Change the Page View Go to the View tab and switch between Normal and Page Break View. Switch back to Normal. Remember ...

The Bottom Scroll Bar is Missing in Excel – 7 Solutions

Solution 1 - Modify Excel Options Steps The bottom scroll bar is missing: Click File. Click Options. In Excel Options, ...

How to Enter an Equal Sign in Excel without a Formula – 4 Methods

This is an overview. Method 1 - Using an Apostrophe to Enter an Equal Sign without a Formula  Enter an Apostrophe (‘) before the ...

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

Excel Formulas Not Updating Until Saving: Possible Reasons The calculation mode is Manual. The cells are formatted as Text. Space before ...

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

Method 1 - Changing the Mouse Settings Steps: Go to the Control Panel or System Preferences on your PC. Select Change mouse settings. ...

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

Consider a dataset of 21 employees. We mentioned their ID in column B, their names in column C, residency area in column D, total income in column E, ...

How to Save One Sheet in Excel as PDF: 3 Useful Methods

Method 1 - Use the Save As Option in Excel to Save One Sheet As PDF Steps: Go to the worksheet that you want to save as a PDF. Click on the ...

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

Excel Cursor Locked in Select Mode: 6 Possible Solutions

Method 1 - Turn Off Extend Selection in Excel STEPS: Look for the F8 function key on your keyboard. Press the key. You can disable ...

How to Type Math Symbols in Excel: 3 Easy Methods

Method 1 - Apply Keyboard Shortcuts to Type Math Symbols in Excel Steps: You want to type the plus sign(+) without formula. Use the keyboard ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo