Excel Basics

How to Use Fill Handle to Copy Formula in Excel (2 Examples)

We have made a sample dataset for some companies. We will use the Fill Handle tool both vertically and horizontally. Example 1 - Copying a ...

How to Convert Decimal Time to Hours and Minutes in Excel

We have a dataset that contains some employee names and their total working time for a week. However, the time is in decimal format, so we need to ...

How to Change Excel Theme to Black (with Easy Steps)

Usually, an Excel file contains a default theme, we do not need to set the theme on our own. The built-in theme is a Colorful one. But with the ...

How to Stop Excel from Scrolling to Infinity (7 Effective Methods)

In the following dataset which we will use to illustrate our methods, we have some people's IDs, Names, and Email addresses. Let's lock the cells ...

How to Stop Excel from Rounding Up Decimals (4 Easy Methods)

We frequently round Excel numbers to make them easier to understand. However, when working with sensitive data, it can be inaccurate. Simple ...

How to Stop Rounding in Excel: 5 Handy Ways

Method 1 - Increasing Column Width to Stop Rounding in Excel Steps: Place your cursor at the border of the column index, and it will turn into ...

How to Save Multiple Tabs in Excel as Separate Files (5 Easy Methods)

If you want to save multiple tabs in Excel as separate files, you have come to the right place. Here, we will walk you through 5 easy and effective ...

How to Fix If Excel CSV File Is Not Saving Changes (6 Solutions)

  The following dataset is saved in a CSV file. Here, we’ll demonstrate easy and effective solutions to save CSV files and see the desired ...

How to Save Excel File with Password

Excel files contain sensitive calculations or preferred data formatting that users do not want to let anyone to meddle with. Therefore, users want to ...

How to Save an Excel File as CSV (3 Methods)

    What Is a CSV File CSV stands for comma-separated values. In simple terms, each line consists of multiple fields or values ...

How to Add Decimals in Excel: 4 Easy Ways

Method 1 - Using Format Cells Dialog Box Select the cells where you want to add decimals. Go to Home tab > Number group > Format Cells ...

Troubleshooting: Preventing Fractions from Changing to Dates in Excel (5 Solutions)

Why Do Fractions Automatically Change to Dates in Excel? By default, Excel uses the General cell format. When you insert a fraction into a cell with ...

Why Does Excel Autosave Keep Turning Off (Reason & Solution)

If you are a Microsoft 365 subscriber, you will see the AutoSave button at the top left corner of the Excel window. But you need to store the Excel ...

How to Unlock Arrow Keys in Excel (2 Ways)

Method 1 - Using the Keyboard Key Almost all keyboards contain a dedicated Scroll Lock key that you can use to turn off the Scroll Lock and unlock ...

How to Drag Formula and Ignore Hidden Cells in Excel (2 Examples)

This is the sample dataset. Example 1 - Drag Formula and Ignore Hidden Cells Using SUBTOTAL Function Steps Press Ctrl and select row ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo