Excel Basics Archives - Page 173 of 176

How to Shift Cells in Excel: 5 Easy Methods

Jun 4, 2024

Method 1 - Using Copy and Paste Commands Step 1: Select the cell range B5:B9, as I want to copy the employees' names rather than write them ...

How to Shift Cells in Excel: 5 Easy Methods

How to Print Selected Cells in Excel – 6 Methods

Aug 8, 2024

The dataset showcases 4 columns: Customer Name, Email, Phone Number, and Credit Card Type. Method 1 - Use the Print Option to ...

How to Print Selected Cells in Excel – 6 Methods

How to Select Multiple Cells in Excel (7 Useful Methods)

Aug 1, 2024

Download Practice Workbook Selecting Multiple Cells.xlsx 7 Ways to Select Multiple Cells in Excel Method 1 - Dragging Mouse to Select ...

How to Select Multiple Cells in Excel (7 Useful Methods)

How to Shift Cells Down in Excel (5 Easy Methods)

Jun 17, 2024

Method 1 – Using the Keyboard Shortcut Steps: Select the cell or cell range you want to shift down. Press the shortcut ...

How to Shift Cells Down in Excel (5 Easy Methods)

How to Use Point and Click Method in Excel (3 Examples)

Nov 11, 2025

When you use the Point and Click Method to build a formula in Excel, the formula becomes errorless and the process saves you time. So, it is ...

How to Use Point and Click Method in Excel (3 Examples)

How to Apply the Same Formula to Multiple Cells in Excel

Jul 29, 2024

Dataset Overview Let’s consider a sales data set where sellers receive a 10% commission on each product sold. To calculate the commission, we’ve ...

How to Apply the Same Formula to Multiple Cells in Excel

How to Use Excel Formula to Calculate Percentage of Grand Total

Aug 4, 2024

Basics of Percentage (%) Percentage (%) is one of the most important mathematical concepts that we use in our daily lives. The percentage is level ...

How to Use Excel Formula to Calculate Percentage of Grand Total

Adding and Subtracting in Excel in One Formula (4 Easy Ways)

Jun 26, 2024

Option 1 - Performing Calculations from Left to Right 100 – 50 + 30 – 20 + 10 = 10 + 30 +50 - 20 = 40 + 30 = 70 Option 2 - ...

Adding and Subtracting in Excel in One Formula (4 Easy Ways)

Division Formula in Excel for Multiple Cells: 5 Suitable Methods

May 31, 2024

Method 1 - Applying Formula to Divide Entire Column Values by Specific Number in Excel Steps: In the cell C5, insert this formula: =B5/10 ...

Division Formula in Excel for Multiple Cells: 5 Suitable Methods

How to Copy a Worksheet in Excel (4 Smart Ways)

Nov 11, 2025

The process of copying worksheets is a very common phenomenon among excel users. Especially, when the dataset gets quite large, we tend to copy the ...

How to Copy a Worksheet in Excel (4 Smart Ways)

How to Show Formula in Cells Instead of Value in Excel (7 Ways)

Aug 1, 2024

In the sample dataset, we have height in cell B5 and width in cell C5. The formula for calculating the area is, Area= Height*Width. We have ...

How to Show Formula in Cells Instead of Value in Excel (7 Ways)

How to Copy and Paste Multiple Cells in Excel (9 Quick Methods)

Apr 30, 2024

For this tutorial, we have a dataset of some Employee Names, Employee IDs, and Total Sales. These methods show you how to copy and paste multiple ...

How to Copy and Paste Multiple Cells in Excel (9 Quick Methods)

Excel Formula Symbols Cheat Sheet: 13 Cool Methods

Jul 5, 2024

Method 1 - Order and Precedence of Operators in Excel Excel uses many symbols for mathematical operations. These operations follow some precedence. ...

Excel Formula Symbols Cheat Sheet: 13 Cool Methods

How to use a Formula for an Entire Column in Excel – 6 Methods

Aug 3, 2024

Consider the Performance of Sales Reps dataset. It showcases Names, the 2022 Sales, and the 2021 Sales of each employee. Method ...

How to use a Formula for an Entire Column in Excel – 6 Methods

How to Make Excel File Read Only (2 Quick Methods)

Jun 5, 2024

There are two ways to make Excel files read-only, either with a password or without. Method 1 - Make an Excel File Read Only without Password ...