Hey there stranger!

Sign up to get access.

How To Export Your Beautiful Sheets to PDF

About this Tutorial

Want to create sleek, stunning PDFs from your Google Sheets? Look no further! Learn how to easily export your sheets to PDF format and impress your audience. Create a PDF from your Google Sheet.

Video Transcript

 Hey, welcome. This video, I'm just gonna talk about exporting to pdf. So sometimes we want to share some information or some type of data with people. And this is, this might be what you think of when you think of Google Sheets, right? You think of this and you think of downloading, and we're gonna say pdf, right?

And this is what it looks like, right? It looks. Pretty darn like a spreadsheet. And you can print this out as a, as a pdf. Sure. You have some options over here. Like you have very, a lot of different paper sizes, margins. You can even do normal, narrow wide. You can do custom numbers Here you have some formatting.

, you can actually, the, the grid lines were already on there so you can't even get 'em off. Or sorry, they were added on top of the normal grid lines. You can even show notes if you wanna append it. You can, you have a lot of like headers and footers here. You can add really interesting stuff like current date time all this type of stuff.

But then, You really are exporting whatever is in your sheet. So if we design our sheet better maybe like this, like a, and we say, okay, let's see. File, download pdf. Now it looks like this, right? We we can do fit to width, fit to height. We can change how it goes. We can delete all of the, let's do this.

Let's delete all of these. Let's delete all of this. All these rows, and this is gonna be our information, but we don't want any let's tick off the grid lines, so that looks a little bit better. Let's go to view grid lines. That looks nice. Now file download is a pdf and again, we have sort of a nicer version of that, but still has all the colors, has all what we fit to height.

We fit to width. We can do all sorts of formatting here. , but we can also do better. We can go like, let's go. Oh, this is actually the wrong one. Let's go to this design. We can have a nice big banner. I, all I did here was I did file.  Or sorry, insert image. Image into cell. And this is a banner image and it could be anything.

It could have the background white with a round image here if you wanted to show a little bit something else other than squares and and rectangles. And then here's some different items, like if you wanna put stats in here or something. But they're all squares, right? Something different than a normal spreadsheet.

And they're all spaced as well. So this is like a really nice design. And if we go download pdf,  Now that looks nice, right? And we can also make it portrait and it cuts it off a little. Maybe we can go back here and say let's do this. Let's just cut off delete column and let's add insert, right? I'm gonna add just that to there.

I'm gonna make put this image all together. Let's see if that looks a little bit better. Download pdf. Yeah. And that looks cool. That is a portrait size image. We can add more down here. Looks like we can add, let's do, let's add 10 rows. Let's just copy and paste this a couple times.

Let's go here. Let's do that again.

Yeah, let's keep it like that and we'll just delete those rows and then file download as a pdf.  No, that's cool, right? We have maybe some totals down here or some other information, some extra information, but like this is a pretty darn cool print off that we can do directly from Google Sheets. We don't need to go anywhere else.

We don't have to export this to anywhere. And it's a pretty well designed, we can insert information in, we can even insert data into another sheet and then have this, aggregate that data for us and print off a really nice pdf. Cool. Enjoy.

Courses

Better Than Happy | Redesign of The Feelings Wheel

How Starter Story Designs Data

Learn to Love Your Sheets

Best Header Font Ever

Sheet Review! 150 Active VCs by LemonIO

Anika Asks: How To Set Text Overflow All The Time

Introducing: Brutal Calendar

Add a Checkbox to Turn on Dark Mode

00:05:10

Create Drop Shadows! This makes your dashboards pretty.

00:12:04

Merge Cells for Dashboards

00:05:29

10 Things I Hate About Your Spreadsheets

Dark Mode / Better Font Color

00:09:35

Better Font Colors

00:02:45

Magical Things You Can do with Checkboxes in Google Sheets

00:12:31

How To Export Your Beautiful Sheets to PDF

00:04:06

Consider Labels as Opposed to Headers

00:04:02

Add Icons To Your Sheets With a Domain Name

00:04:21

How To Color Cell Blocks So Others Enter Data Easily

00:10:30

Great Sheets! Corona Hiring Sheet

00:10:43

Great Sheets! Community Information Board by Seedtable.com

00:07:35

Roast: Hotel PPC Channel Cost Calculator

00:11:25

Better Header Fonts - Best Fonts To Use In Google Sheets

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

00:09:49

Basic Keyboard Shortcuts To Speed Up Your Productivity

00:13:44

Basics - 5 Ways to Change Row Height

00:05:08

Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

00:09:31

How to Refer to Other Cells - A1 and R1C1 Explained

00:13:22

Change the Default Font

00:03:33

Biggest Flaw In Dashboards with Dark Colors

00:07:45

Basics - 4 Ways to Change Column Width

00:05:48

Basics - Structure of a Sheet: Index() Row() and Column()

00:06:49

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

00:08:55

Use Cmd + Y To Do It Again, and Again, and Again

00:03:03

Create an Auto-Update Sales Chart: Trailing 12 Months

00:09:57

Google Sheet Basics - The Absolute Basics

00:09:48

Secure Your Sheets by BetterSheets.co

00:11:07

How To Create An AutoFill in Google Sheets

00:06:07

Build a Thermometer for Savings Goals

Make Your Lists Spicy Hot in Google Sheets

00:01:47

Restrict Access to a Cell if Another Cell is Blank

How to Use Smarket

00:03:28

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

00:06:23

Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!

00:53:31