Excel Basics Archives - Page 148 of 176

How to Lock Rows in Excel (6 Easy Methods)

Jun 14, 2024

The dataset we are using to lock rows contains some products and their prices and percentage of value-added tax (VAT). Method 1 - Lock ...

How to Lock Rows in Excel (6 Easy Methods)

How to Move Between Cells in Excel with Arrow Keys (6 Methods)

Jun 18, 2024

In this article, we'll reveal how to move around an Excel workbook using the arrow keys on the keyboard only, no mouse required. To demonstrate, ...

How to Move Between Cells in Excel with Arrow Keys (6 Methods)

Fix: Excel Cannot Shift Nonblank Cells (4 Methods)

Nov 11, 2025

While working in Excel, sometimes we need to add or Shift a Row or Column in our Worksheet. When we insert a new Cell, it pushes the next cell up to ...

Fix: Excel Cannot Shift Nonblank Cells (4 Methods)

If Cell is Blank Then Show 0 in Excel (4 Ways)

Jun 23, 2024

We have a dataset with production information of different factories. A unit is considered ready to sell when packaging is done. In the Unit Ready to ...

If Cell is Blank Then Show 0 in Excel (4 Ways)

How to Convert Timestamp to Date in Excel (2 Suitable Cases)

Apr 29, 2024

Here's an overview of the dataset and the features we'll use to convert UNIX time and timestamps into an Excel date. How to Convert a ...

How to Convert Timestamp to Date in Excel (2 Suitable Cases)

How to Unhide Rows in Excel – 8 Quick Methods

Aug 4, 2024

The sample dataset showcases item names and sales from January to March. Method 1 - Show Hidden Rows Using the Context Menu in Excel ...

How to Unhide Rows in Excel – 8 Quick Methods

How to Use Excel EXACT Function (6 Suitable Examples)

Aug 4, 2024

The Excel EXACT function tests two text strings and returns TRUE or FALSE depending on their exact match or otherwise respectively. The EXACT ...

How to Use Excel EXACT Function (6 Suitable Examples)

Excel Formula to Change Text Color Based on Value: 3 Ways

May 21, 2024

Method 1 - Using ISODD Function Steps: Select the column where you want to change the text color. Go to the Home tab. Select the New Rule ...

Excel Formula to Change Text Color Based on Value: 3 Ways

How to Shift Cells Right in Excel (4 Quick Ways)

Nov 11, 2025

While working on a worksheet, you may need to shift your existing cells to add some extra data in between. When cells are shifted, the content of ...

How to Shift Cells Right in Excel (4 Quick Ways)

How to Lock Columns in Excel (4 Methods)

Jul 9, 2024

The dataset below will be used for illustration. By default, an Excel worksheet has all its cells locked. But, it has no effect until the ...

How to Lock Columns in Excel (4 Methods)

How to Freeze Columns in Excel (5 Methods)

Nov 11, 2025

While working with a big dataset sometimes we need to know how to Freeze Columns in Excel as well as Rows, or both of a worksheet. It’s necessary to ...

How to Freeze Columns in Excel (5 Methods)

Conditional Formatting If Cell is Not Blank

Jun 12, 2024

Method 1 - Use the Conditional Formatting ‘Highlight Cell Rules’ Option If a Cell Is Not Blank Steps: Select the entire dataset B5:D13. ...

Conditional Formatting If Cell is Not Blank

How to Remove Formatting in Excel Without Removing Contents

Nov 11, 2025

"Removing formatting in Excel without removing contents" means separating the raw data (text, numbers, formulas) from formatting (font styles, ...

How to Remove Formatting in Excel Without Removing Contents

How to Swap Columns in Excel (5 Methods)

Jul 3, 2024

Let's assume we have a dataset with First Names, Last Names, Salaries, and Countries in Columns B, C, E, and D respectively. Method 1 - ...

How to Swap Columns in Excel (5 Methods)

How to Group and Ungroup Columns or Rows in Excel

May 9, 2024

Consider you have data in existing cells that contain names from different countries. They have different room numbers to be allocated ...