Excel Basics Archives - Page 126 of 176

How to Autofill Days of Week Based on Date in Excel (5 Easy Ways)

Jul 4, 2024

We'll use a sample dataset as an example. For instance, the following dataset represents a Salesman and his Joining Date in a company. We will ...

How to Autofill Days of Week Based on Date in Excel (5 Easy Ways)

How to Delete Rows in Excel without Affecting Formulas?

Nov 11, 2025

Sometimes you need to delete rows in Excel but want to keep the formulas. In this article, we will discuss how to delete rows in Excel without ...

How to Delete Rows in Excel without Affecting Formulas?

How to Delete Rows in Excel with Specific Text: 3 Ways

Jul 5, 2024

Method 1 - Using the Find Feature to Delete Rows with Specific Text Delete all the rows matched with the text "Alan." We'll show deletion for both ...

How to Delete Rows in Excel with Specific Text: 3 Ways

How to Copy Rows Automatically in Excel to Another Sheet (4 Methods)

Jul 7, 2024

Method 1 - Automatically Copy Rows in Excel to Another Sheet Using Filters In the following dataset, we will copy all rows from the data range ...

How to Copy Rows Automatically in Excel to Another Sheet (4 Methods)

On Error Resume Next: Handling Error in Excel VBA

Jul 7, 2024

Method 1 - On Error Resume Next’ Statement to Hide Worksheets in Excel VBA This is a VBA code that will hide all the worksheets of your active ...

On Error Resume Next: Handling Error in Excel VBA

Errors in Excel and Their Meaning (15 Different Errors)

Jul 18, 2024

We're going to use a sample dataset to show most common errors. The following dataset represents the Salesman, Product, and Net Sales of a company. ...

Errors in Excel and Their Meaning (15 Different Errors)

How to Copy Formula to Another Sheet in Excel (4 Methods)

May 6, 2024

Method 1 - Apply Keyboard Shortcuts to Copy a Formula to Another sheet in Excel Steps: Press Ctrl+C to copy a selected ...

How to Copy Formula to Another Sheet in Excel (4 Methods)

Excel Error: The Number in This Cell is Formatted as Text (6 Fixes)

Jun 17, 2024

How to Find a Cell That is Formatted as Text or Preceded by an Apostrophe When we use an apostrophe before a number, or when values are stored ...

Excel Error: The Number in This Cell is Formatted as Text (6 Fixes)

[Solved!] Can’t Delete Extra Columns in Excel: 3 Reasons and Solutions

Jul 6, 2024

To show the reasons and solutions, we’ll use the following dataset that represents some salespersons’ sales in different regions. Method 1 ...

[Solved!] Can’t Delete Extra Columns in Excel: 3 Reasons and Solutions

How to Remove Value Error in Excel (4 Quick Methods)

Jun 16, 2024

1. Using Excel SUM Function to Remove #VALUE! Error In the example below, the #VALUE! occurs because there is a text in cell D6. Here, ...

How to Remove Value Error in Excel (4 Quick Methods)

How to Convert Exponential Value to Exact Number in Excel (7 Methods)

Jun 25, 2024

Method 1 - Using Cell Formatting to Convert an Exponential Value to an Exact Number We have a dataset (B5:B8) containing several exponential values ...

How to Convert Exponential Value to Exact Number in Excel (7 Methods)

How to Convert Degrees, Minutes and Seconds to Decimal Degrees in Excel – 2 Methods

Aug 4, 2024

This is the sample dataset. Method 1 - Applying a Formula to Convert Degrees, Minutes and Seconds to Decimal Degrees in Excel Step 1: ...

How to Convert Degrees, Minutes and Seconds to Decimal Degrees in Excel – 2 Methods

How to Delete Empty Rows at the Bottom in Excel?

Jul 29, 2024

Our dataset contains empty rows, and we'll remove these empty rows in various ways. Method 1 - Manual Approach to Delete Empty Rows in ...

How to Delete Empty Rows at the Bottom in Excel?

How to Disable Copy and Paste in Excel without Macros (With 2 Criteria)

Jun 25, 2024

Sometimes we need to share our Excel worksheet with users or clients. Suppose we want them to only be able to view the worksheet but not copy and ...

How to Disable Copy and Paste in Excel without Macros (With 2 Criteria)

How to Create a Formula in Excel That Will Place the Word Yes (7 Ways)

Nov 11, 2025

In this article, you will get to know about various ways to create a formula in Excel that will place the word Yes easily. Sometimes we want a result ...