Excel Basics Archives - Page 85 of 124

How to Copy Unique Values to Another Worksheet in Excel – 5 Methods

Aug 6, 2024

The dataset showcases a list of colors with duplicates in Sheet1. To copy the unique colors to another worksheet in the same workbook. ...

How to Copy Unique Values to Another Worksheet in Excel – 5 Methods

How to Convert Text Date and Time to Date Format in Excel – 7 Methods

Aug 14, 2024

In the dataset below date and time values are in Text Format (they are left aligned). Method 1 - Convert Text Date and Time to ...

How to Convert Text Date and Time to Date Format in Excel – 7 Methods

How to Copy Merged and Filtered Cells in Excel: 4 Methods

May 29, 2024

Method 1 - Copy Merged Cells Using Paste Option Steps: Select the cells and press CTRL+C and paste it anywhere in the worksheet you want by ...

How to Copy Merged and Filtered Cells in Excel: 4 Methods

How to Use Formulas to Copy and Paste Values in Excel (5 Examples)

Jul 7, 2024

Below is the dataset we’ll use to explore the methods. Method 1 - Using Cell Reference to Copy and Paste Values in Excel Steps: ...

How to Use Formulas to Copy and Paste Values in Excel (5 Examples)

How to Calculate Average Rating in Excel: 7 Methods

Jul 6, 2024

Method 1 - Calculate Average Rating Using Multiplication and SUM function Step 1: Go to Cell E5. Put the formula below, which is the ...

How to Calculate Average Rating in Excel: 7 Methods

How to Paste Link and Transpose in Excel (8 Quick Ways)

Jul 7, 2024

When in Paste Special, if you click on the Transpose option, the Paste Link option is automatically disabled. However, there are still ways to use ...

How to Paste Link and Transpose in Excel (8 Quick Ways)

How to Copy and Paste in Excel with Merged Cells (2 Methods)

Apr 23, 2024

The following picture demonstrates how you can copy into merged cells with formulas. How to Copy and Paste in Excel with Merged Cells: 2 ...

How to Copy and Paste in Excel with Merged Cells (2 Methods)

How to Convert Unix Timestamp to Date in Excel (3 Methods)

May 21, 2024

The Unix timestamp is a system of tracking time as a running total of seconds. The time count started at the Unix Epoch on January 1st 1970 UTC. So a ...

How to Convert Unix Timestamp to Date in Excel (3 Methods)

How to Convert Active Directory Timestamp to Date in Excel (4 Methods)

Apr 16, 2024

Consider a dataset, there are 6 AD timestamps which need to be converted to readable dates. To do that, the example will use Sequential Serial ...

How to Convert Active Directory Timestamp to Date in Excel (4 Methods)

How to Copy and Paste in Excel When Filter Is On (5 Methods)

Jul 3, 2024

We're going to use a sample dataset as an example. The following dataset represents the Salesman, Product, and Net Sales of a company. There are two ...

How to Copy and Paste in Excel When Filter Is On (5 Methods)

How to Fix Convert to Number Error in Excel (6 Methods)

Jun 17, 2024

The sample dataset represents some bestseller books at amazon.com. The triangle-shaped green sign at the top-left corner of every cell in the ...

How to Fix Convert to Number Error in Excel (6 Methods)

How to Unhide Top Rows in Excel: 7 Methods

May 20, 2024

Method 1 - Using Format Command in Excel to Unhide Top Rows Use the Ribbon shortcut to unhide the top 3 rows of our dataset. Step 1: Go ...

How to Unhide Top Rows in Excel: 7 Methods

How to Convert Scientific Notation to Number in Excel (7 Methods)

Jul 4, 2024

Method 1 - Apply the TRIM Function to Convert Scientific Notation to Numbers in Excel Step 1: Select cell C5 to convert scientific notation to ...

How to Convert Scientific Notation to Number in Excel (7 Methods)

How to Freeze First 3 Columns in Excel (4 Quick Ways)

Jun 18, 2024

Method 1 - Freeze First 3 Columns Using Freeze Panes The Freeze Panes option of Excel is available in the View tab. We can use the Freeze Panes ...

How to Freeze First 3 Columns in Excel (4 Quick Ways)

How to Protect an Excel Sheet from Copy-Paste (4 Methods)

May 10, 2024

Method 1 – Using the Info Option We will use a dataset containing sellers' sales amounts for the first five months. 1.1 Secure a Workbook ...