Excel Basics Archives - Page 158 of 176

How to Show Formula as Text in Another Cell in Excel (6 Ways)

Jul 29, 2024

Consider the List of Employee Salary dataset shown in the B4:F13 cells containing the Job ID, Name, Salary, Allowances, and Total Salary columns, ...

How to Show Formula as Text in Another Cell in Excel (6 Ways)

How to Fill Blank Cells with Value Above in Excel (4 Easy Methods)

Jun 15, 2024

Let’s consider the following dataset. It contains the list of product IDs, sales dates, and sales numbers. Some of the cells have blank ...

How to Fill Blank Cells with Value Above in Excel (4 Easy Methods)

How to Insert Picture into Excel Cell (3 Methods)

Jul 8, 2024

Practice Workbook Insert Picture into Cell.xlsx 3 Methods to Insert a Picture into Excel Cell Method 1 - Copy-Paste Method to Insert a ...

How to Insert Picture into Excel Cell (3 Methods)

How to Set the Same Height and Width in Excel Cells – 3 Methods

Aug 7, 2024

Method 1 - Making Excel Cells Equal by Pixels to Get the Same Height and Width This is the sample dataset. Click on the image for better quality ...

How to Set the Same Height and Width in Excel Cells – 3 Methods

How to AutoFit in Excel (7 Easy Ways)

Jun 18, 2024

Suppose we have a datasheet, in which we have 3 columns and 5 rows to represent the price and quantity of some chocolates. In some Product Names the ...

How to Delete a Cell in Excel (4 Easy Ways)

Aug 9, 2024

We are going to use a datasheet with four columns containing sales information for some sales representatives. This table represents sales ...

How to Delete a Cell in Excel (4 Easy Ways)

How to Make a Cell Bigger in Excel (7 Easy Ways)

Jul 6, 2024

Method 1 - Using the Merge and Center Options to Make a Cell Bigger in Excel Select Cell D5 and its adjacent cells that are required to make the ...

How to Make a Cell Bigger in Excel (7 Easy Ways)

How to Count Specific Words in a Column in Excel – 2 Methods

Aug 10, 2024

In the sample dataset, count “happy” and “life” in C5:C10. Method 1 - Combine Functions to Count Specific Words in a Column Steps: ...

How to Count Specific Words in a Column in Excel – 2 Methods

How to Create a Dynamic Named Range in Excel – 2 Methods

Aug 13, 2024

This is an overview. The sample dataset showcases students' Names and their Marks in English. Method 1 - Using the OFFSET ...

How to Create a Dynamic Named Range in Excel – 2 Methods

How to Delete Multiple Columns in Excel: 5 Suitable Methods

Jul 6, 2024

Method 1 - Deleting Multiple Columns Through Context Menu in Excel Steps: Select the three columns (Joining Month, Joining Date & Salary). ...

How to Delete Multiple Columns in Excel: 5 Suitable Methods

How to Insert Pictures Automatically Size to Fit Cells in Excel: 3 Methods

Jun 4, 2024

For the purpose of demonstration, I have used the following sample dataset. Here, the dataset contains information about Microsoft Office products. ...

How to Insert Pictures Automatically Size to Fit Cells in Excel: 3 Methods

How to Delete a Column in Excel Without Affecting the Formula – 2 Methods

Aug 9, 2024

The following dataset showcases Unit Production in column C and Per unit Cost in column D. The total per month is calculated in column E. To ...

How to Delete a Column in Excel Without Affecting the Formula – 2 Methods

How to Delete Rows in Excel: 7 Methods

Jul 7, 2024

This article will show seven effective techniques to delete rows in Excel, with examples and illustrations. Download the Practice Workbook In ...

How to Delete Blank Cells and Shift Data Up in Excel: 8 Methods

Jul 5, 2024

Method 1 - Deleting Blank Cells Manually Steps: Hover the cursor until a downward pointing arrow appears >> left-click to select the ...

How to Delete Blank Cells and Shift Data Up in Excel: 8 Methods

How to Delete Multiple Rows in Excel with Condition?

Nov 11, 2025

While working in Excel, we sometimes have to delete multiple rows from a data set with a given condition. Today I’ll show you how to delete multiple ...