+3 votes
47 views
Learn how to print an Excel Sheet

in Office by (551k points)
reopened | 47 views

1 Answer

+4 votes
Best answer

How to print a sheet in Excel

Excel is one of the most versatile programs for working with numerical data, dates, text and much more with the functions and formulas that help comprehensive management of each data, it is normal that at some point it is necessary to print the content of the data in the spreadsheet and at the time of printing we will see disorder or that the data does not add up as necessary..

 

Many times we have quite large sheets in Excel and it is complicated to configure them to know how we can print everything well, avoiding that our data moves and something is left out of the print. That is why TechnoWikis has this tutorial to teach you how to print in Excel in a simple and functional way.

 

 

 

To stay up to date, remember to subscribe to our YouTube channel!   SUBSCRIBE

 

How to print a sheet in Excel

 

Step 1

We open Excel to see the data to print:

 

image

 

Step 2

We use the following keys to access the print preview:

 

Ctrl + P

 

 

 

 

image

 

 

Step 3

It is possible to see that the data is not organized based on the sheets in which we work and other elements of said data.

 

In the "View" menu we click on "Page Break View":

 

image

 

Step 4

We will see the following structure:

 

image

 

step 5

There we see each page that makes up the data and the print area is the area covered by the blue lines, what we see in gray is content that will not be printed, we can adjust our data by clicking on the blue line and dragging it to where we want be printed:

 

image

 

 

step 6

We use the following keys to access the print preview and we can see how the print area has been extended based on the defined print area:

 

Ctrl + P

 

 

 

image

 

 

Step 7

There we can click on the zoom icon located at the bottom to see the design better:

 

 

image

 

 

step 8

We return to the spreadsheet and in the "Page layout" menu click "Print titles":

 

image

 

 

step 9

The following popup will open:

 

image

 

 

step 10

We click on "Repeat rows at the top" and then select the title row:

 

image

 

 

step 11

We apply the changes, and to access printing we can go to "File - Print":

 

image

 

 

step 12

All spreadsheets will have the title:

 

image

 

 

step 13

We go back to the sheet and in the "Page Layout" menu we click on the "Page Setup" icon located at the bottom:

 

image

 

 

step 14

In the displayed window we go to "Header and footer":

 

image

 

 

step 15

We click on "Customize header" and configure:

 

  • In "Left section" we add Date and Time
  • In "Right section" we add File name

 

 

 

 

 

image

 

 

Note
To add this data we click on the respective buttons.

 

 

step 16

Apply the changes:

 

image

 

step 17

We click on "Customize footer" to see this:

 

image

 

 

step 18

In "Right Section" we add Page Number, then leave a space and write "of", add Sheet Number:

 

image

 

 

step 19

Apply the changes:

 

image

 

 

step 20

We apply the global changes and use the following keys to see the new form of printing:

 

Ctrl + P

 

 

 

image

 

 

step 21

Now we will see in all sheets the header and footer as configured:

 

image

 

 

step 22

Let's go to each sheet to validate this:

 

image

 

This is the ideal way to print Excel sheets with the required data..

 

 


by (3.5m points)
edited

Related questions

+3 votes
1 answer
asked May 11, 2023 in Office by backtothefuture (551k points) | 50 views
+3 votes
1 answer
asked Nov 20, 2019 in Office by backtothefuture (551k points) | 253 views
+3 votes
1 answer
asked Oct 3, 2019 in Office by backtothefuture (551k points) | 185 views
+4 votes
1 answer
asked Oct 1, 2019 in Office by backtothefuture (551k points) | 215 views
+3 votes
1 answer
Sponsored articles cost $40 per post. You can contact us via Feedback
10,632 questions
10,764 answers
510 comments
3 users