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…
Transcript
[00:00:00] I’m Ann Emery. You’re watching Dataviz On The Go, the series where I make quick tutorials for you as I’m racing around between my workshops. I was giving a dataviz workshop recently and we were making these visual appendices for the back of a report. And they look nice in Excel. They’ve got some light visuals here, like the bars to help us find key patterns.
And then you go to print and you’re like, this almost looks right. You know, this, this would be like PDFed or printed or something. Imagine this as the appendix of your report. It looks nice on the first page. You can tell what’s what, the column headers are there, but then on the second page, it’s like, Oh, what’s even going on?
What’s what? Okay. How do you repeat the column headers when your table breaks across multiple pages? There are a couple of ways to do this. I’m going to show you the way that I think is the fastest. I don’t want to waste your time with any like, so, so mediocre solutions. I think the best way is you go to.
Page layout. You go to print titles [00:01:00] and look at this rows to repeat at the top when it’s printed or pdf. You click on the little arrow which minimizes your window and then you go select the row that you want to repeat. Not the whole thing. Because that would be redundant. That would be unnecessary. It’s probably just this juicy row, row six.
And then you go back to your little arrow. It expands the window. You can say, okay, I’m going to click print preview here while we’re in here, just to show you what it would look like. Look, column headers there as usual, right where you expected. And they’re also on the second page. Isn’t that nice? You just repeat a couple of rows at the top of your page.
Three, two, one. Don’t forget to like, subscribe, and share. Not sponsored. What did you say?
Leave a Reply