Excel Basics Archives - Page 111 of 176

How to Update Hyperlink in Excel Automatically (2 Ways)

Jul 29, 2024

We have a dataset containing brief information about some books, their writers, and hyperlinks where you can find these books to read. We will use ...

How to Update Hyperlink in Excel Automatically (2 Ways)

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

Aug 11, 2024

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

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

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

Jun 16, 2024

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 Make a Comma Separated List in Excel (5 Methods)

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

Nov 11, 2025

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 Find and Replace Hyperlinks in Excel (3 Quick Methods)

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

Nov 11, 2025

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 Gridlines Darker in Excel (2 Easy Ways)

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

Jul 6, 2024

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

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

How to Find and Replace Space in Excel: 5 Methods

May 25, 2024

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 Find and Replace Space in Excel: 5 Methods

How to Make a Comparison Table in Excel: 2 Methods

May 30, 2024

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

How to Make a Comparison Table in Excel: 2 Methods

Excel Fix: Gridlines Disappear When Color Added: 2 Solutions

Jul 4, 2024

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

Excel Fix: Gridlines Disappear When Color Added: 2 Solutions

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

Jun 18, 2024

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

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

How to Insert Date in Excel Formula (8 Ways)

Nov 11, 2025

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 Date in Excel Formula (8 Ways)

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

Jul 3, 2024

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 Insert Drop Down Calendar in Excel (With Quick Steps)

How to Auto Sort in Excel Without Macros: 3 Methods

Jul 6, 2024

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 Auto Sort in Excel Without Macros: 3 Methods

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

Jul 5, 2024

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 Sort Dates in Excel by Month and Year (4 Methods)

How to Insert Day and Date in Excel – 3 Methods

Aug 4, 2024

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