Latest Blog Posts

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

How to Make a Monthly Sales Report in Excel – 2 Simple Steps

In the sample dataset you have the sales in January, February, and March in different sheets. This sheet contains the Sales in January. ...

[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 Calculate the Debt Service Coverage Ratio in Excel (2 Examples)

Dataset Overview Let’s say we have a user’s Debt and Income Statement, or Balance Sheet as shown in the image below. And we want to find the Debt ...

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 a Save Workbook in a Specific Folder Using VBA in Excel (4 Methods)

The below dataset consists of 3 columns: Name, Car Model, and Car Maker. This dataset represents the car information of 6 employees car information ...

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)

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo