Excel Basics

How to Format a Phone Number with Extension in Excel – 3 Methods

The image below showcases phone numbers with extensions before and after formatting: Method 1 - Using a Custom Number Format Each phone ...

How to Make a Comma Separated List in Excel (5 Methods)

We have an Excel file that contains information about various types of fruits. These fruits are listed in the column titled Fruit in that Excel ...

How to Find and Replace Hyperlinks in Excel (3 Quick Methods)

After setting hyperlinks in Excel you can easily edit them or find and replace them using some features of Excel. This article will provide you with ...

How to Make Gridlines Darker in Excel (2 Easy Ways)

In this tutorial, we will show you how you can make gridlines darker in Excel. When we open a workbook Microsoft Excel automatically adds gridlines ...

How to Make a To Do List in Excel (3 Easy Methods)

We will use a sample dataset to illustrate. The following dataset represents the Task, Status, and Deadline. Method 1 - Using the Filter ...

How to Find and Replace Space in Excel: 5 Methods

Method 1- Inserting TRIM Function to Find and Replace Space in Excel ➤ Type the following formula in cell F4. =TRIM(C4) ➤ Press ENTER. ...

How to Make a Comparison Table in Excel: 2 Methods

Method 1 - Comparison of Two Tables with Conditional Formatting Steps: Select Table 2 (B14:E18). From Excel Ribbon, go Home > ...

Excel Fix: Gridlines Disappear When Color Added: 2 Solutions

Method 1 - Add Cell Border If Gridlines Disappear When Color Is Added Steps Press ALT+T+O, or ALT+F+T, or select File >> Options to open ...

How to Insert the Last Saved Date in Excel (4 Methods)

  Method 1 - Using BuiltinDocumentProperties Steps: Press ALT+F11 or go to the tab Developer, Select Visual Basic to open Visual ...

How to Insert Date in Excel Formula (8 Ways)

Excel can store date values as a different category of its own. Dates starting from 1st January 1990 follow this pattern. You can write dates ...

How to Insert Drop Down Calendar in Excel (With Quick Steps)

This drop-down calendar is only available in Microsoft Excel 2007 and 32-bit versions of Excel 2010, 2013, and 2016. Use a third-party add-in for ...

How to Auto Sort in Excel Without Macros: 3 Methods

Method 1 - Use of SORT Function to Auto Sort in Excel Introduction to the SORT Function The SORT function in Excel returns a sorted range of ...

How to Sort Dates in Excel by Month and Year (4 Methods)

Method 1 - Applying the TEXT Function to Sort Dates by Month and Year Steps: Make columns for Months and Dates. Enter the following ...

How to Insert Day and Date in Excel – 3 Methods

This is the sample dataset. Method 1 - Using the TEXT Function to Insert Day and Date Steps Select Cell C5 and enter the following ...

How to Move Columns in Excel without Overwriting (3 Methods)

While working in Excel, sometimes we need to move columns for many reasons like if we do a mistake to arrange columns or maintaining the chronology. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo