Excel Basics Archives - Page 68 of 124

How to Auto Populate Word Document from Excel (with Quick Steps)

Jul 3, 2024

Step 1 - Prepare the Excel File Create an Excel file with the dataset if you don’t have one already. If you have one, make sure the dataset ...

How to Auto Populate Word Document from Excel (with Quick Steps)

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

How to Move Data from One Cell to Another in Excel – 5 Methods

Aug 7, 2024

Download Practice Workbook Download the practice workbook for free! Move Data from One Cell to Another.xlsm The sample dataset ...

How to Move Data from One Cell to Another in Excel – 5 Methods

How to Remove Gridlines from an Excel Graph – 5 Methods

Aug 12, 2024

The sample dataset showcases a company's monthly revenue over 9 month. To create a graph: Go to Insert > Charts. ...

How to Remove Gridlines from an Excel Graph – 5 Methods

How to Space out Cells in Excel – 2 Methods

Aug 14, 2024

The following dataset contains extra space below the text. This is the sample dataset. To add space between text and cell borders: ...