How to Insert a Page Break in MS Excel

There are situations when you need to print your Excel worksheets. You can always do this as the print feature is always available in MS Excel. 

The problem most likely that you will encounter is on how do you configure the number of pages. MS Excel can help you achieve this by applying page breaks. 

With this feature, you can set the number of pages you want printed before printing your worksheet.

  1. An example of a worksheet with page breaks

There are two ways on how you can insert page breaks in your worksheet.

2 Ways to Insert Page Breaks in MS Excel

  • Inserting a page break using the Page Layout tab
  • Inserting a page break using the Right-click context menu

There are two types of page breaks—vertical and horizontal. This article will guide you on how you can insert them to your worksheets using the methods specified above. Before learning the steps, it is important to understand the difference between these two types. The vertical page break divides your worksheet into vertical sections. In contrast, the horizontal page break divides your worksheet into horizontal sections. 

The number of sections created by these breaks will be the number of pages when you print your worksheet. Now, it’s time for you to learn how to insert them.

Let’s get started!

Read more

How to highlight alternate rows in MS Excel

Reading through massive amounts of data in Microsoft Excel can get extremely confusing. Ever been the type to hover your mouse over a row while dragging it to the side, just so you won’t get lost while looking through your spreadsheet?

Well, instead of having to put up a ruler on your screen, you can figure out how to highlight every other row in MS Excel instead. 

Now, if you can excuse the random shopping list, the steps to highlight every other row in MS Excel are relatively simple. 

How to Highlight Every Other Row in MS Excel

  • Using a custom formula to highlight every other row

We’ll go over the detailed steps throughout the guide below, so you can finally arrange your Excel sheet better.

At the same time, we’ll go over formulas and conditional formatting if you’re interested in figuring that out.

You’ll find these sections at the end of the article. Furthermore, we’ll also teach you how you can completely remove or clear highlighted areas rows. Finally, you can do more than just highlight, but also format the font color, size, cell border, and so on. 

All of this will be discussed below, so keep an eye and your Excel sheet ready!

If you’re feeling hesitant about doing this because you’re bad with formulas, don’t worry.

This guide was made with beginners in mind, so hopefully, the steps should be easy to follow. 

Let’s get started!

Read more

How to Wrap Text in MS Excel

Learning how to wrap text in Excel is a great way to format text in a cell, so it doesn’t take up your entire window. It’s one of those subtle quirks from Excel that affect how your data is displayed. Having a clear view of your dataset on Excel improves readability, efficiency, and helps reduce errors.

There are a few ways to go about text wrapping cells in Excel. 

2 Ways to Wrap Text In Excel

  • Wrapping Text automatically through a format setting
  • Manually adding a line break at each cell

We will cover both methods and guide you through the step-by-step instructions below. Along the way, we will also answer questions you may have so we can clear any confusion regarding how you can do this.

This article was written with beginners in mind, so you don’t need to know any technical knowledge before proceeding with this tutorial.

Let’s get started.

Read more