Leave a Reply

Your email address will not be published. Required fields are marked *

How to Keep Headings in View When You Print or PDF (So Your Excel Table is Easier to Read)

Updated on: Jun 18th, 2024
Data Visualization in Excel
, , , ,

Are you printing or PDFing that Excel table? If it’s a long table, and spills onto a second page, then you’ll need to keep the table headings in view.

Here’s how you can repeat a few rows at the top of each page.

What’s Inside

0:00 Welcome to Dataviz On The Go

0:08 The Visual Appendices

0:22 The PDF/Print Issue, Oops!

0:42 The Best Solution

1:42 3… 2… 1…

More about Ann K. Emery
Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

Leave a Reply

Your email address will not be published. Required fields are marked *

You Might Like

Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.


How to Make Great Graphs in Excel: 4 Levels of Excel Vizardry

Are you drowning in the deep end of Excel? In this article, you’ll learn the 4 Levels of Excel Vizardry, from making exploratory sparklines through disguising charts with Magic Tables.

More »

Need practical how-to tips? In this course, you’ll learn how to make great graphs inside software you already have. Includes beginner, intermediate, and advanced tutorials for making charts from start to finish.



Not another fluffy newsletter. Get actionable tips, videos and strategies from Ann in your inbox.