Excel Basics Archives - Page 29 of 124

How to Skip Columns in Excel (3 Methods)

Jul 12, 2024

Dataset Overview Let’s suppose we have a sample data set containing various Salesmen and their sales per month (January to June). Method 1 ...

How to Skip Columns in Excel (3 Methods)

How to Select Only Filtered Cells in Excel Formula (5 Methods)

May 1, 2024

The sample dataset, contains 3 columns, States, Quantity, and Unit Price. Method 1 - Employing Go To Special feature to Select Only ...

How to Select Only Filtered Cells in Excel Formula (5 Methods)

How to Paste in Reverse Order in Excel – 7 Methods

Aug 3, 2024

This is the sample dataset. Method 1 - Using the Sort Command 1.1 Pasting in Reverse Order Vertically Steps: Select D5 and enter 1. ...

How to Paste in Reverse Order in Excel – 7 Methods

How to Reverse Order of Data in Excel (4 Useful Methods)

Jul 4, 2024

To illustrate, we have used 2 types of datasets in Excel; one for horizontally reversing, and the other one for vertically reversing, the data order ...

How to Reverse Order of Data in Excel (4 Useful Methods)

How to Merge Datasets in Excel (5 Easy Methods)

May 10, 2024

The below dataset contains a table displaying, Student IDs and Names and another table containing Student IDs, Math, and Physics Scores. We will ...

How to Merge Datasets in Excel (5 Easy Methods)

How to Select Visible Cells in Excel (5 Quick Tricks)

Jul 4, 2024

When working with large data sets containing hidden cells, one can easily select the visible cells along with the hidden cells by dragging the mouse ...

How to Select Visible Cells in Excel (5 Quick Tricks)

How to Cut Text Using Formula in Excel (6 Simple Methods)

Jul 6, 2024

Method 1 - Combine LEFT and FIND Functions to Cut Text in Excel To cut the first text from cell B5 of the dataset, we will use the LEFT and FIND ...

How to Cut Text Using Formula in Excel (6 Simple Methods)

How Do I Quickly Select Thousands of Rows in Excel (2 Ways)

Jul 3, 2024

We have a large dataset that we need to select rows from. Method 1 - Using the Name Box to Quickly Select Thousands of Rows Steps: ...

How Do I Quickly Select Thousands of Rows in Excel (2 Ways)

How to Clear Multiple Cells in Excel: 4 Ways

Jul 7, 2024

Using Context Menu Select the cells/ranges to clear. Right-click on the selection for the context menu. Select the Clear Contents command. ...

How to Clear Multiple Cells in Excel: 4 Ways

How to Remove Last Modified By in Excel (3 Ways)

Jun 18, 2024

Why Should We Remove “Last Modified By”? In a word - confidentiality. Every Excel file contains some information like Author name, Organization ...

How to Remove Last Modified By in Excel (3 Ways)

How to Reverse a Number in Excel – 6 Quick Examples

Aug 4, 2024

Only 4-digit numbers were used. Example 1. Combining the SUM and the VALUE Functions Steps: Go to C5 and enter the formula: ...

How to Reverse a Number in Excel – 6 Quick Examples

How to Insert Last Modified Date and Time in Excel Cell

Jul 3, 2024

We’ll use a sample dataset, with Input in column B and the Timestamp in column C. We'll input the timestamp in column C whenever we modify the ...

How to Insert Last Modified Date and Time in Excel Cell

How to Reverse a String in Excel: 3 Suitable Ways

May 21, 2024

Method 1 - Using MID and CONCATENATE Functions to Reverse a String in Excel Steps: Enter the following formula in cell C4: ...

How to Reverse a String in Excel: 3 Suitable Ways

How to Move Data from a Row to a Column in Excel (4 Easy Ways)

Jun 18, 2024

Below, we have a sample dataset for these methods. Method 1 - Using Paste Special Command to Move Data from Row to Column in Excel Steps: ...

How to Move Data from a Row to a Column in Excel (4 Easy Ways)

How to Reverse Column Order in Excel: 4 Useful Methods

May 30, 2024

Method 1 - Use Sort Feature to Reverse Column Order in Excel Steps: Select the Helper Column. Go to the Data On the Sort and Filter ...