Latest Blog Posts

How to Open a Word Document and Replace Text with Excel VBA (6 Examples)

In the following sections, we will provide six examples of how to open a Word document and replace text using VBA in Excel. Some things to ...

How to Use Random 5 Digit Number Generator in Excel (7 Methods)

Method 1 - Using the Excel RANDBETWEEN Function  Steps: Enter the below formula in Cell B5 and press Enter. =RANDBETWEEN(10000,99999) ...

Excel VBA: Delete Same Sheet from Multiple Workbooks

In Microsoft Excel, we may face a situation where we have to delete sheets from multiple workbooks. We can do this manually. But this process becomes ...

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

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 Import Text File with Multiple Delimiters into Excel (3 Methods)

The sample dataset represents sale details for a shop. The data is separated by either a comma or a semicolon. We want to import this data from the ...

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

  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 Import Data from Text File into Excel (3 Methods)

We’ll use the following data present in a text file as our source. The data contains the Salesman, Product, and Sales information of a company. We’ll ...

How to Move Filtered Cells in Excel – 3 Methods

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 Convert Excel to CSV without Opening (4 Easy Methods)

  Method 1 - Using the 'Save As' Command to Convert Excel to CSV Steps: Go to the File tab. Select Save As and click on ...

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

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 Open CSV File with Columns in Excel: 3 Easy Methods

Method 1 - Using Legacy Wizard to Open CSV File in Excel with Columns Steps You need to enable the text import wizard. Go to the File tab in ...

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

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

Excel Not Saving CSV with Commas: 7 Possible Methods

Method 1 - Changing Separator When Saving CSV Steps: Select the File tab from the ribbon. Go to Options. A dialog box titled ...

How to Convert a Text File to Excel Automatically (3 Ways)

We will convert the following text file, which we named 'Convert Text File', to Excel. Here is a preview of how this text file will look after we ...

How to Convert Excel to a Comma Delimited CSV File (2 Methods)

Method 1 - Convert an Excel Worksheet Open the Excel workbook containing the worksheets you want to convert (e.g., Names and Sales). ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo