Excel Basics Archives - Page 123 of 124

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 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 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 ...

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

How to Print Excel Spreadsheet with Lines and Change Its Color

Aug 2, 2024

Download the Practice workbook Printing Spreadsheet with Lines.xlsx 2 Ways to Print Excel Spreadsheet with Lines and Change Its Color We ...

How to Print Excel Spreadsheet with Lines and Change Its Color

How to Apply the Accounting Number Format (ANF) in Excel (6 Methods)

Jul 17, 2024

The following image provides a clear overview of the purpose of this Excel tutorial. The right side of the image presents the result of the methods ...

How to Apply the Accounting Number Format (ANF) in Excel (6 Methods)

Excel Table vs. Range: What Is the Difference?

Aug 15, 2024

A Range in Excel An Excel Range is a set of two or more cells. It is represented by the combination of the reference of the first cell and the last ...

Excel Table vs. Range: What Is the Difference?

How to Enable and Use Synchronous Scrolling in Excel (2 Cases)

Jul 15, 2024

Synchronous scrolling allows you to view and compare two Excel workbooks or two worksheets within the same workbook simultaneously. It’s a handy ...