Excel Basics

How to Show Full Cell Contents on Hover in Excel (5 Quick Ways)

The sample dataset contains the grades of 5 students in 4 subjects on different tests. The full cell contents for the column named Tests is not ...

How to Align Decimal Points in Excel (3 Quick Ways)

You have come to the right place if you are looking for the answer or some unique tips to align decimal points in Excel. There are 3 easy ways to ...

How to Bottom Align in Excel (3 Easy Ways)

The dataset below contains both texts and numbers, where the texts are vertically bottom-aligned and the numbers are top-aligned. Method 1 ...

How to Show Coordinates in Excel Graph (2 Easy Methods)

This tutorial will demonstrate the steps to show coordinates in an excel graph. Undoubtedly, graphs are very useful for easily representing any ...

How to Close Dialog Box in Excel (3 Easy Ways)

In this tutorial, we will demonstrate 3 easy ways to close a Dialog Box in Excel. Method 1 - Using a Keyboard Shortcut Suppose we open a ...

How to Change Date Alignment in Excel: 8 Simple Methods

Method 1 - Change Date Alignment with Text to Columns Feature STEPS: Select the date range D5:D8. Go to Data > Data Tools > Text to ...

How to Align Currency Symbol in Excel: 3 Easy Ways

Method 1 - Using Accounting Number Format to Align Currency Symbol Highlight the range or cell then select Accounting as Number Format from the ...

How to Align Columns in Excel (4 Easy Methods)

If you are looking for special tricks to know how to align columns in Excel, you've come to the right place. There are numerous ways to align columns ...

How to Remove Tracer Arrows in Excel

Tracer Arrows is a widely used tool in Excel. Though it is very helpful, we may want to remove these from the sheet after our desired work is done. ...

How to Maintain Excel Header Alignment (with Easy Steps)

The sample dataset contains information about some people. We will put a header and maintain its alignment. Step 1 - Opening the Page ...

How to Stop Excel from Changing Numbers to Dates (5 Ways)

Method 1 - Utilizing Format Cells Feature to Prevent Excel from Converting Numbers to Dates The format cells feature allows us to change the ...

How to Use AutoComplete in Excel (4 Easy Ways)

When we begin entering data into a cell, Excel suggests duplicate values from its related cells, and we can acquire the duplicate values by simply ...

Default Alignment of Numbers in Excel (Detailed Analysis)

When you enter any number in the Excel worksheet cell, you will see the number will align on the right side of the cell as a default. This is a ...

[Fixed!] Cutting Off Text When Printing in Excel

Microsoft Excel is widely used to organize data. Sometimes, we have to deal with a huge amount of data and organize them in different columns. It is ...

How to Swap Cells in Excel (4 Quick Tricks)

Sometimes, we may be required to rearrange the data table of our Excel sheet by exchanging the data of columns or rows. Following copy or cut-paste ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo