Excel Basics Archives - Page 110 of 124

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 Unused Columns in Excel (6 Methods)

Jun 17, 2024

The sample dataset contains Product, Product Code, Color, Size, and Price columns and two unused columns as indicated in red to be deleted. ...

How to Delete Unused Columns in Excel (6 Methods)

How to Delete Multiple Sheets in Excel (3 Ways)

May 20, 2024

In this tutorial, we will explore 3 ways to delete multiple sheets in Excel, and how to do so based on different criteria. To illustrate, we have ...

How to Delete Multiple Sheets in Excel (3 Ways)

Why Excel Shows Formulas Instead of Results (7 Reasons)

Jul 5, 2024

For example, we have the following dataset and you see Excel is showing formulas in the cells instead of calculated results. Let’s check how we can ...

Why Excel Shows Formulas Instead of Results (7 Reasons)

How to Create a Formula in Excel for Multiple Cells (9 Easy Ways)

Jul 26, 2024

We have a dataset that contains some employees’ salaries for two years and their salary increments. Method 1 - Use the AutoFill Tool ...

How to Create a Formula in Excel for Multiple Cells (9 Easy Ways)

How to Lock a Cell in Excel Formula (2 Easy Ways)

Aug 6, 2024

Method 1 - Assigning a Dollar Sign ($) Manually to Cell References Steps: Let’s calculate the speed of light for the Water medium. Select ...

How to Lock a Cell in Excel Formula (2 Easy Ways)

Percentage Formula in Excel: 6 Ideal Methods

Jul 6, 2024

Method 1 - Calculate Percentage Using Basic Formula in Excel Example for Basic Percentage Formula in Excel: Assume that we have a simple data ...

Percentage Formula in Excel: 6 Ideal Methods

How to Delete Every Other Row in Excel

Jul 6, 2024

Method 1 - Using Filter Feature to Delete Every Other Row in Excel Step 1: Select the column header. From your Home Tab, go to the Editing ...

How to Calculate Difference Between Two Dates and Times in Excel

Jun 23, 2024

Part 1 - Calculating the Difference Between Two Dates in Excel We have the Starting Date of different projects in column C and the Ending ...

How to Calculate Difference Between Two Dates and Times in Excel

How to Reference to Another Sheet in Excel (5 Suitable Methods)

Jun 15, 2024

Download Practice Workbook Download this practice sheet to exercise while you are reading this article. Referencing Another Sheet.xlsx ...