Latest Blog Posts - Page 413 of 589

How to Sort Data in Alphabetical Order in Excel: 8 Methods

Jul 4, 2024

Method 1 - Sort Value in Alphabetical Order in Excel with Sort Featur STEPS: Select the range B5:D10. Go to Home ➤ Editing ➤ Sort & ...

How to Sort Data in Alphabetical Order in Excel: 8 Methods

The Sort and Filter is Not Working in Excel

Aug 9, 2024

The sample dataset showcases Number of Visits of websites, their Name and Category. Dates and Platforms are also given. Solution 1 - There ...

The Sort and Filter is Not Working in Excel

How to Sum Columns in Excel When Filtered (7 Ways)

May 12, 2024

Consider the following dataset for demonstrating how to sum columns. We have Components, Manufacturer, Country of Manufacture, Quantity, Unit Price, ...

How to Sum Columns in Excel When Filtered (7 Ways)

How to Sum Columns in Excel Table: 7 Methods

May 19, 2024

Method 1 - Use of AutoSum Function to Sum Columns in Excel Table Steps: Select the entire range of cells B4:E14. Insert tab, select ...

How to Sum Columns in Excel Table: 7 Methods

How to Select the Print Area Using VBA in Excel – 3 Methods

Aug 4, 2024

This is the sample dataset. Enter the Code in Visual Basic Editor Go to the Developer tab. Click Visual Basic. In the Visual ...

How to Select the Print Area Using VBA in Excel – 3 Methods

How to Print Gridlines with Empty Cells in Excel (2 Methods)

Nov 11, 2025

Microsoft Excel does not print with gridlines automatically. Gridlines are helpful with viewing data as it separates row and column from one another. ...

How to Print Gridlines with Empty Cells in Excel (2 Methods)

How to distribute Columns Evenly in Excel – 5 Methods

Aug 11, 2024

The sample dataset showcases players, age, and countries. Method 1 - Distribute Columns Evenly Using the Format Option Steps Click ...

How to distribute Columns Evenly in Excel – 5 Methods

Excel VBA to Format Textbox Number with UserForm (With Easy Steps)

Jul 6, 2024

Step 1 - Create UserForm in Excel VBA to Format Number Go to the Developer tab from the ribbon. Click on Visual Basic under the Code ...

Excel VBA to Format Textbox Number with UserForm (With Easy Steps)

How to Count Space Before Text in Excel (4 Ways)

Jul 19, 2024

We will be using the following dataset. As you can see from the picture, there are different numbers of spaces before the text in each cell, and we ...

How to Count Space Before Text in Excel (4 Ways)

Excel VBA: Print Range of Cells – 5 Easy Methods

Aug 4, 2024

This is the sample dataset. Method 1 - Using the Excel VBA PrintOut Method to Print a Range of Cells Steps: Open Visual Basic in the ...

Excel VBA: Print Range of Cells – 5 Easy Methods

How to Space Rows Evenly in Excel (5 Methods)

May 1, 2024

Method 1 – Using the Row Height Command The dataset for this method contains the names of the Customer, the Product, the Price, and the ...

How to Space Rows Evenly in Excel (5 Methods)

Wrap Text Not Showing All Text in Excel: 4 Methods

May 16, 2024

Method 1 - Apply AutoFit Row Height Command to Fix Wrap Text Not Showing All Text We applied the Wrap Text command in the Book Name column. The ...

Wrap Text Not Showing All Text in Excel: 4 Methods

How to Calculate MTD (Month to Date) in Excel (3 Methods)

Jun 14, 2024

Method 1 - Combine SUM, OFFSET, ROWS & DAY Functions to Calculate MTD in Excel Suppose we have the following dataset of a fruit stall. The ...

How to Calculate MTD (Month to Date) in Excel (3 Methods)

How to Split Comma Separated Values into Rows or Columns in Excel

Jun 28, 2024

Method 1 - Separate Data into Rows/Columns by Comma Using Text to Columns in Excel Case 1.1 - Split Values into Columns We have a dataset ...

How to Split Comma Separated Values into Rows or Columns in Excel

How to Use the VBA Code to Create a Custom Print Button in Excel (5 Methods)

Jul 28, 2024

Method 1 - Print Dialog Box Create a button by going to Developer, select Insert and click on the Button Box. Drag the cursor to set ...