Unlike MS Word, an MS Excel printout seldom looks the same as it is on the screen in front of you. 

For one, you may have a large dataset, and need to know whether everything will fit onto one page, or not, and if so, where the print margins are.

Print Preview helps you understand the layout of your printout, by providing a visual presentation of how your printed copy will look like.

Using this feature, you can customize your printout as per your requirements. You may need to scale the data, shrink the width, or hide a particular row or column to get the desired results.

2 Methods to preview a worksheet before printing in Microsoft Excel:

• Use the Print Preview option
• Use the Page Break Preview option

Let us begin.

Read more

If you have a spreadsheet with a large number of rows, it might extend to the next page when you print it. You would’ve noticed that the header row or title gets printed only on the first page.

This is the default behavior in excel.

It is also possible to print the title row on every page while printing your worksheet. IN this tutorial will share the exact steps to achieve the same.

Easy Method for printing the title row on every page in Microsoft Excel:

Read more

Gridlines are not printed on a Microsoft Excel worksheet or workbook by default. But you might want to print them to improve the readability of the data. In this tutorial, we’ll show you how you can achieve this in a few easy steps.

2 Methods for printing gridlines in Microsoft Excel:

• Use the Page Layout menu
• Use the keyboard shortcut

Let us begin.

---

Read more

The faint lines that appear between cells on a worksheet are known as gridlines. 

Depending on your type of work, gridlines can be both useful and bothersome. They are important in separating cells when working with a lot of data. Meanwhile, if you have a specific format for your document, you might want to remove them.

3 Methods to show and hide gridlines in Microsoft Excel:

• Use the View menu
• Use the keyboard shortcut
• Change the background color

Let us begin.

Read more

If you don’t want to print your entire Excel sheet, you can select a specific range of cells to be printed. You can also select multiple ranges of cells. Each range can be printed on a separate page. You can keep adding to your existing print area, and you can also clear out all the print areas. 

If you want a preview, you can view all the print areas before actually printing them out. Printing pre-selected areas in Excel is not just a great feature, but also an easy one that you can do in seconds.

3 Methods to set the print area in Microsoft Excel:

• Use Set Print Area
• Use Add Print Area
• Use the Page Setup dialog box

Let us begin.

---

Read more

Even in this digitized world, we need printouts. We need hard copies of books, reports, financial statements, and more. A workbook printout can aid in many ways, including the following:

• You will not be at the mercy of the internet connectivity to use the workbook.
• You do not need your laptop or phone to view the workbook.
• Once the data is ready, a workbook printout is more portable and workable to use.
• Most people prefer using a printout rather than viewing the data online.

2 Methods to print an entire workbook in Microsoft Excel:

• Use the Print Entire Workbook option
• Use the Print Active Sheets option

Let us begin.

Read more