Excel - Print headings, gridlines, formulas, and more Tutorial

In this video, you will learn about printing headings, gridlines, formulas, and more in Excel.
The video covers how to print row and column headings, including sequential IDs, and how to print gridlines to make the worksheet easier to read.
It also demonstrates how to print comments on the worksheet and how to show all comments before printing.
Additionally, the video shows how to create a watermark on the worksheet and how to display all formulas instead of resulting values.
This tutorial will help you enhance your printing skills in Excel and improve the readability of your worksheets.

4:29
4124 views

Available in Microsoft365

Objectifs :

This document aims to provide a comprehensive guide on how to enhance printing options in Excel, including printing row and column headings, comments, gridlines, and adding watermarks. It also covers how to display formulas for review purposes.

Chapitres :

Introduction to Printing in Excel
Printing in Excel can be optimized to improve readability and presentation. This guide will explore various features that allow you to print essential elements such as row and column headings, comments, and gridlines, as well as how to add a watermark.
Printing Row and Column Headings
To make your printed worksheet easier to read, you can print row and column headings. The first row of your worksheet typically contains labels for the columns, known as the header row. To print this header row on every page, follow these steps: 1. Click on the 'Page Layout' tab. 2. Select 'Print Titles'. 3. Click in the 'Rows to repeat at top' box and select the first row. 4. You can also select columns to repeat on the left by clicking 'Columns to repeat at left'. 5. Use 'Print Preview' to check how the header will appear on printed pages.
Printing Comments
Excel allows you to print comments that are attached to cells. To print comments as they appear on the worksheet: 1. Click the 'Review' tab and select 'Show All Comments' to display them. 2. Go back to the 'Page Layout' tab and click 'Print Titles'. 3. Click the comments down arrow and choose 'As displayed on sheet'. 4. Use 'Print Preview' to see how the comments will look when printed.
Printing Gridlines
By default, gridlines are not printed in Excel. To include gridlines in your printout: 1. Go to the 'Page Layout' tab. 2. Check the option for 'Print' under the 'Gridlines' section. 3. Now, when you print the worksheet, the gridlines will be included, enhancing readability.
Adding a Watermark
While Excel does not have a built-in watermark feature, you can simulate one by adding a background image. To do this: 1. Click on the 'Page Layout' tab. 2. Select 'Background'. 3. Choose an image you want to use as a watermark. You can find images using options like Bing image search. 4. The selected image will now appear as a background on your worksheet.
Displaying and Printing Formulas
To review the equations in your worksheet without clicking on each cell: 1. Click the 'Formulas' tab. 2. Select 'Show Formulas' to display all formulas instead of their resulting values. 3. Print the worksheet to have a clear view of all formulas used.
Conclusion
By utilizing these printing features in Excel, you can significantly enhance the clarity and professionalism of your printed documents. Whether it's ensuring that headings, comments, and gridlines are included or adding a watermark, these adjustments can make your worksheets more effective for presentations and reviews.

FAQ :

How do I print the header row on every page in Excel?

To print the header row on every page, go to the Page Layout tab, click on 'Print Titles', and then select the row you want to repeat in the 'Rows to repeat at top' field.

Can I print comments in Excel?

Yes, you can print comments in Excel. First, display the comments by clicking the Review tab and selecting 'Show All Comments'. Then, go to the Page Layout tab, click 'Print Titles', and choose how you want to print the comments.

How can I print gridlines in my Excel worksheet?

To print gridlines, go to the Page Layout tab and check the 'Print' option under the Gridlines section. This will ensure that gridlines are included in your printed document.

Is there a way to add a watermark in Excel?

Excel does not have a built-in watermark feature, but you can simulate one by going to the Page Layout tab, clicking 'Background', and selecting an image to use as a watermark.

How do I display all formulas in my worksheet?

To display all formulas, click on the Formulas tab and select 'Show Formulas'. This will change the view to show the formulas instead of their resulting values.

Quelques cas d'usages :

Creating Professional Reports

When preparing a report for stakeholders, using the Print Titles feature to repeat header rows ensures that the data is easily understandable across multiple pages, enhancing readability.

Reviewing Formulas in Financial Models

In financial modeling, using the Show Formulas feature allows team members to quickly review and verify the accuracy of calculations without having to click through each cell.

Printing Comments for Feedback

When collaborating on a project, printing comments at the end of the worksheet can provide valuable feedback for team members, ensuring that all notes are considered during revisions.

Adding Visual Elements to Presentations

Using a background image as a watermark can enhance the visual appeal of a presentation or report, making it clear that the document is confidential while maintaining a professional look.

Preparing Data for Client Meetings

When preparing data for client meetings, printing gridlines along with row and column headings can help in discussing specific data points, making it easier for clients to follow along.

Glossaire :

Header Row

The first row of a worksheet that contains labels for the columns, making it easier to identify the data in each column.

Print Titles

A feature in Excel that allows users to repeat specific rows or columns on every printed page for better readability.

Print Preview

A feature that allows users to see how their document will look when printed before actually printing it.

Gridlines

The faint lines that separate the cells in a worksheet. By default, these are not printed unless specified.

Watermark

A text or image that is placed in the background of a document to indicate its status (e.g., 'Confidential'). Excel does not have a built-in watermark feature, but users can simulate one using background images.

Show Formulas

A feature in Excel that displays all formulas in the worksheet instead of their resulting values, allowing users to review the equations easily.

Comments

Notes or annotations added to specific cells in a worksheet, which can be printed either as they appear on the worksheet or at the end of the document.

00:00:06

including printing headings, grid lines,

00:00:10

row and column headings and formulas.

00:00:13

You can even mimic a watermark, and print it.

00:00:18

The first row of this worksheet has labels for the columns.

00:00:21

This is referred to as a header row.

00:00:24

Since the worksheet is longer than a page,

00:00:27

printing the header row on every page makes the worksheet easier to read;

00:00:32

you won't have to keep flipping back to page 1

00:00:35

to remember what data is in a column.

00:00:38

Click the Page layout tab and click Print titles;

00:00:43

click in Rows to repeat at top; and then click Any cell in row 1;

00:00:49

the entire row is automatically filled in for me.

00:00:53

You can select multiple rows.

00:00:56

You can also select Columns to repeat at left,

00:00:59

to have columns repeat on the left of every page:

00:01:03

click Print Preview, and in Print Preview

00:01:06

you can see the header will print at the top of every page.

00:01:16

There are comments in this worksheet.

00:01:18

When I point to the red indicator in the corner of this cell,

00:01:22

the comment appears.

00:01:25

When you print a worksheet, you can print the comments at the end of the worksheet,

00:01:29

or as they display on the worksheet.

00:01:33

To print the comments as they display on the worksheet,

00:01:35

you first have to display them: click the Review tab,

00:01:41

and click Show all comments.

00:01:45

Now I click the Page layout tab;

00:01:48

click Print titles;

00:01:53

click the Comments down arrow;

00:01:55

you have the options to print them at end of sheet, or as displayed on sheet;

00:02:02

click As displayed on sheet; click Print Preview;

00:02:07

and in Print Preview you can see the comments on the worksheet.

00:02:13

On the screen, by default, the worksheet's pages have grid lines,

00:02:18

making it easier to read across rows, and down columns,

00:02:23

but when you print,

00:02:25

by default, the gridlines are not printed.

00:02:30

To print grid lines in a worksheet, on the page layout tab,

00:02:35

under Gridlines, check Print.

00:02:39

Now when you print the worksheet, the gridlines are

00:02:41

printed, and it's easier to read.

00:02:46

You can print row and column headings.

00:02:49

This is 1, 2, 3 and so on for rows,

00:02:53

and A, B, C and so on for columns.

00:02:57

It makes it easier to discuss a print out if the rows and

00:03:00

columns don't have some sort of sequential IDs.

00:03:05

On the Page layout tab, under Headings, check Print;

00:03:12

now when you print the worksheet, the headings are printed.

00:03:18

You want to print a watermark on your worksheet that says "Confidential".

00:03:23

There isn't a watermark feature in Excel, but you can come pretty close:

00:03:29

on the Page layout tab, click Background.

00:03:33

I already have an image I want to use;

00:03:36

if you don't, you can find one by clicking Options,

00:03:40

such as Bing image search;

00:03:42

browser search to find the image you want; click it;

00:03:47

and you worksheet now has a watermark that says "Confidential".

00:03:53

Say you want to have a group review of the equations in your worksheet

00:03:58

to make sure they're correct,

00:04:00

but you don't want to have to click in every cell that has

00:04:02

a formula to do the review. Instead,

00:04:07

click the Formulas tab, and click Show formulas,

00:04:13

and now all the formulas, not the resulting values,

00:04:16

are displayed in your worksheet.

00:04:19

Print the worksheet and the formulas are printed.

00:04:23

Now you've got a pretty good idea about how to print worksheets and workbooks.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

2797 Views

Video Training Microsoft Excel - Discovery level

Discover and familiarize yourself with Excel: from creating and using your tables to enhancing your visuals and collaboration. Our introduct...

ALL COURSES