Excel Basics Archives - Page 106 of 176

How to Create Multiple Word Documents from Excel (3 Easy Methods)

Jun 30, 2024

Method 1 - Create Multiple Word Documents Using Copy and Paste Feature The sample dataset below contains three worksheets in the Excel workbook. ...

How to Create Multiple Word Documents from Excel (3 Easy Methods)

How to Insert a Column without Affecting Formulas in Excel (2 Ways)

Aug 6, 2024

In the following dataset, we will count the Total Sales from 2015 to 2020 for different months. However, we have missed including the Sales for 2016. ...

How to Insert a Column without Affecting Formulas in Excel (2 Ways)

How to Split Excel Sheet into Multiple Files (3 Quick Methods)

Jun 14, 2024

Method 1 - Manual Approach to Split Excel Sheet into Multiple Files Method 1.1 Using Copy and Paste Options In the following dataset, we ...

How to Split Excel Sheet into Multiple Files (3 Quick Methods)

How to Move Filtered Cells in Excel – 3 Methods

Aug 10, 2024

This is the sample dataset. The data is filtered by Apple Watch: The filtered cell were moved applying a simple copy-paste method. This ...

How to Move Filtered Cells in Excel – 3 Methods

How to Convert Excel to PDF without Losing Formatting (5 Effective Ways)

Nov 11, 2025

Excel is extremely powerful for calculations. But most of the time, for better representation of the summary of data and calculation, it is more ...

How to Convert Excel to PDF without Losing Formatting (5 Effective Ways)

How to Save Excel as a PDF on One Page (3 Easy Methods)

May 12, 2024

This dataset includes bank account openings. The data couldn’t be saved on the page as a PDF. Method 1 – Using the 'Fit To' Option STEPS: ...

How to Save Excel as a PDF on One Page (3 Easy Methods)

How to Copy Multiple Row Height in Excel (3 Quick Tricks)

Nov 11, 2025

Excel has no such features that can allow you to copy multiple row heights only. However, you can copy entire row formats. That is how you can manage ...

How to Copy Multiple Row Height in Excel (3 Quick Tricks)

How to Insert Multiple Blank Rows in Excel (4 Methods)

May 8, 2024

The sample dataset contains 5 rows without headings. Method 1 - Selecting Multiple Rows and Insert an Equal Blank Rows in Excel ...

How to Insert Multiple Blank Rows in Excel (4 Methods)

Excel Formula to Insert Rows between Data (2 Simple Examples)

May 13, 2024

Example 1 - Excel Formula with MOD and ROW Functions to Insert Rows between Data We will use the combination of the MOD and ROW functions to insert ...

Excel Formula to Insert Rows between Data (2 Simple Examples)

How to Sort Alphanumeric Data in Excel – 2 Steps

Aug 8, 2024

What Is Alphanumeric Data in Excel? Alphanumeric is a term used to describe data that consists of both numbers and letters. The dataset below ...

How to Sort Alphanumeric Data in Excel – 2 Steps

How to Add Vertical Gridlines to Excel Chart (2 Easy Methods)

Nov 11, 2025

Gridlines are horizontal and vertical lines that run through your chart layout to represent axis divisions. It is beneficial to add horizontal or ...

How to Add Vertical Gridlines to Excel Chart (2 Easy Methods)

How to Save Excel as PDF without Cutting Off (4 Suitable Ways)

May 31, 2024

Cutting off a page means the output will appear on several pages which makes the table less readable. To show all the methods, we take a ...

How to Save Excel as PDF without Cutting Off (4 Suitable Ways)

How to Save Multiple Excel Sheets as One PDF (2 Easy Methods)

Apr 26, 2024

Method 1 - Save Multiple Excel Sheets as One PDF Using the ‘Save As’ Option There are three worksheets in our Excel workbook. ...

How to Save Multiple Excel Sheets as One PDF (2 Easy Methods)

How to Convert Excel to PDF with All Columns – 5 Methods

Aug 4, 2024

This is the sample dataset. If you convert this spreadsheet to PDF, this will be the output. The last column is cut and shifted to the ...

How to Convert Excel to PDF with All Columns – 5 Methods

[Fix:] Excel View Side by Side Not Working

Nov 11, 2025

Sometimes, users encounter identical Excel files or want to compare between files. In that case, Excel view side by side is very useful. However, in ...