Excel Basics

How to Use the Status Bar in Excel? (All Things to Know)

In this Excel tutorial, you will learn - About the default options in the status bar that appear whenever you open the Excel application - How to ...

How to Open, Run and Turn Off Excel Safe Mode (Complete Guideline)

This tutorial was prepared using Microsoft 365, but the operations apply to all versions of Excel. ⏷What Is Safe Mode in Excel? ⏷Open ...

How to Add, Remove, and Print Background in Excel

Here's an overview of how a table looks without and with a background. Click here to see the full image ⏷What Is Excel Background? ⏷Add ...

How to Freeze Panes in Excel – Rows/Columns/Multiple Panes

Consider the following dataset. It contains 60 rows and 11 columns. The top row is frozen.   How to Freeze Rows in Excel 1. ...

How to Insert and Remove Carriage Return in Excel

A carriage return is also known as a line break in an Excel cell. While they are technically different, the traditional meaning of carriage return ...

How to Attach File in Excel (4 Easy Methods)

Here's an overview showing what types of files you can attach to a sheet. ⏷When Do We Attach File in Excel? ⏷How to Attach a File ...

How to Add, Change and Format Cell Borders in Excel [Ultimate Guide]

In this Excel tutorial, we will describe how to add, change, format, draw, remove, and create custom styles for cell borders in Excel, and even how ...

How to Use the Excel Screenshot Option (Take, Edit and Copy)

To take a screenshot in Excel, first, go to the Insert tab and then select the Screenshot option from the Illustrations group. There are two ...

How to Link PowerPoint Chart to Excel: 2 Methods

Method 1 - Create the Chart in Excel Select the table range C5:D13 and go to Insert Tab >> Chart to create a chart. An Excel ...

How to Return All Rows That Match Criteria in Excel

Returning all rows that match criteria in Excel means showing the rows in a dataset that meet specific conditions. For example, this is a dataset ...

How to Make House Estimate Format in Excel (5 Easy Steps)

The house estimation allows us to create a reasonable budget, which will eventually lead to a proper path toward managing the construction of a house ...

How to Make Good Excel Color Combinations (5 Methods)

Method 1 - Using a Color Combination Based on Values Steps: Choose the set of cells containing the values you want to make a good color ...

[Solved!] Excel Themes Option Is Not Working (5 Easy Fixes)

Excel Themes offer a professional look to your spreadsheets, allowing you to enhance the overall aesthetic appeal of your data. Problems with Excel ...

How to Apply a Bottom Double Border in Excel – 2 Methods

In the following image, the Bottom Double Border is applied in the row before the Total row. Method 1 - Using the Built-in Border Option ...

How to Remove Trace Dependents in Excel (3 Swift Ways)

Trace dependents can make it easier to find which cells track data, but can also make the sheet a bit messier. We'll use a simple dataset as an ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo