Latest Blog Posts - Page 469 of 589

How to Fill Blanks in Excel – 4 Methods

Aug 2, 2024

Method 1 - Fill Blanks using the ‘Go To Special’ Dialog Box The sample dataset contains employees' information: Department, Age, and Working ...

Print to PDF in Excel VBA with the ExportAsFixedFormat Statement: 5 Examples

May 29, 2024

Method 1 - Print to PDF in Excel VBA with No Name or Path Specified We have a worksheet with the book records of a bookshop called Marin Bookstore. ...

Print to PDF in Excel VBA with the ExportAsFixedFormat Statement: 5 Examples

How to Add Rows and Columns in Excel (3 Methods)

Jul 16, 2024

Method 1 - Using Keyboard Shortcut You can use keyboard shortcuts to add adjacent & non-adjacent columns or rows in Excel. Here are 4 cases ...

How to Add Rows and Columns in Excel (3 Methods)

How to Group Rows in Excel – 5 Easy Methods

Aug 8, 2024

The dataset showcases data of a company that operates in 3 regions and sells 3 different products- TV, Heater, and Fan. Method 1 - Grouping ...

How to Group Rows in Excel – 5 Easy Methods

How to Sort and Ignore Blanks – 4 Methods

Aug 6, 2024

The following data table has blank rows. Before applying the sort command, hide the rows first. Method 1 - Hide Blank Rows to Sort ...

How to Sort and Ignore Blanks – 4 Methods

How to Print Landscape in Excel (3 Easy Methods)

Nov 11, 2025

In this tutorial, we will cover how to print landscape in Excel. When we print something from an Excel worksheet by default, Microsoft Excel prints ...

How to Print Landscape in Excel (3 Easy Methods)

How to Freeze Top Two Rows in Excel (4 ways)

Apr 16, 2024

To put the concept of freezing the top two rows into practice, here's a sample data set of people's basic information: Last Names, Ages, Occupations, ...

How to Freeze Top Two Rows in Excel (4 ways)

How to Print Labels in Excel (With Easy Steps)

Nov 11, 2025

In this article, we will learn about how to print labels in Excel. Labeling is essential in terms of marketing a product, the address of a person to ...

How to Print Labels in Excel (With Easy Steps)

How to Center the Print Area in Excel – 4 Methods

Aug 12, 2024

The dataset contains the salary statements of the sales representatives. Method 1 - Using Keyboard Shortcuts to Center the Print Area in ...

How to Center the Print Area in Excel – 4 Methods

How to Turn Off AutoFill in Excel (3 Quick Ways)

Nov 11, 2025

We may use Excel's AutoFill tool to fill a list of similar values or a sequence of consecutive entries. It's generally shown at the bottom-right ...

How to Turn Off AutoFill in Excel (3 Quick Ways)

How to Use VBA Space Function in Excel (3 Examples)

Nov 11, 2025

In this tutorial, I will explain the details of the excel VBA Space function along with some examples. This function can only be used in VBA code. ...

How to Use VBA Space Function in Excel (3 Examples)

How to Generate Random Number with Excel VBA (4 Examples)

Nov 11, 2025

By using the built-in Rnd function in VBA Excel, we can generate a random number easily. These generated random numbers are usually in the range of 0 ...