Excel Printing Customization - Add Headers, Footers, Breakup Pages, Hiding

Published: 07 June 2023
on channel: Chris Menard
1,498
44

Let's have a look at printing in Microsoft Excel. When you try to print in Excel, maybe the pages are not the right size or they don't break up where you want them. If you want to add specific data to your printouts such as dates, times, names of people who printed it, document titles, page numbers and more, all these can be inserted onto your printouts.

In this video we look at how you can customize printed worksheets in Excel, how to hide columns you don't want to print, how to make the headers in your document repeat on each printed page.

We then look at how to customize the headers and footers of printed documents in Excel, how to add your name to the header or footer, the current date, the number of pages or even custom text.

Chapters:
00:00 Introduction
00:24 Print preview
01:16 Fix printing data
01:28 Hide unwanted columns from print
01:52 Repeat header row on every page
02:49 Customize header and footer

Popular Videos from Chris Menard
Add polling to Zoom Meetings
   • Add polling to Zoom Meetings by Chris...  
Create a PivotTable in Excel using multiple worksheets
   • Create a PivotTable in Excel using mu...  
What-If analysis in Excel with a Data Table
   • What-If analysis in Excel with a Data...  
Insert a Word Document into a PowerPoint presentation
   • Insert a Word Document into a PowerPo...  
Excel - Conditional Formatting find duplicates on two worksheets
   • Excel - Conditional Formatting find d...  
Microsoft Word - delete the empty or blank page at the end of your document
   • Microsoft Word - delete the empty or ...  
Sum up hours and minutes in Excel by Chris Menard
   • Sum up hours and minutes in Excel by ...  
OneDrive - Sync Icons Explained for files and folders
   • OneDrive - Sync Icons Explained for f...  
Break-even analysis in Excel with a chart / cost-volume-profit analysis by Chris Menard
   • Break-even analysis in Excel with a c...  

And make sure you subscribe to my channel!

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!


Watch video Excel Printing Customization - Add Headers, Footers, Breakup Pages, Hiding online without registration, duration hours minute second in high quality. This video was added by user Chris Menard 07 June 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,498 once and liked it 44 people.