How to PROPERLY Convert Excel to PDF

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Discover the simplicity of converting Excel files to professional-looking PDFs using Excel's built-in features. Say goodbye to online converters and enhance your Excel skills!
🔍 What You'll Learn:
▪️ 3 Easy Conversion Methods: Explore three quick ways to convert Excel sheets to PDF, including handy shortcut keys.
▪️ Perfect PDF Creation Tips: Get insider tips on creating flawless PDFs directly from Excel, ensuring they look sharp and professional.
🛠️ Highlights:
▪️ Customizing PDF layout with Page Setup.
▪️ Adding professional touches like page numbers and headers.
▪️ Adjusting print areas for optimal PDF presentation.
🌍 My Online Courses ► www.xelplus.com/courses/
00:00 Convert Excel File to PDF
00:24 Method 1: Use Shortcut
01:18 Method 2: Use Export
01:30 Method 3: Use Save As
01:47 Best Practice Tips
02:36 Page Setup
04:04 Add Page Numbers
04:55 Landscape Orientation
05:03 Repeat Headers on Printouts
05:28 Add Page Breaks
07:08 The Final Result in PDF
07:35 Wrap Up
🎬 LINKS to related videos:
How To EASILY Convert PDF to Word: • How To EASILY Convert ...
Convert Picture to Data in Excel: • Import Data from a Pic...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #exceltips

[@LeilaGharani]

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

[@giritharta]

Leila, Here's an additional tip to make your reports look even better: when you're in the print preview mode and setting up your margins, make sure to check the 'center vertically' and 'center horizontally' options. This will help ensure that your report is perfectly centered and looks polished and professional.

[@AlphaNumericNZ0]

Came here to say this. It makes it look real sharp if you center on page.

[@Herald-Fayez-im4jo]

each time i open a video i learn new stuff even 30 seconds in thank you for these high quality video

[@LeilaGharani]

Happy to hear that!

[@marklord7614]

Wow, I'm sure lots of people will find this really helpful. This should be up there in the must-watch Excel videos.

[@triplex86]

What a brilliant video Leila - these are exactly the sort of issues that I encounter several times a week. I've watched the vid about half a dozen times, stopping 'n starting, playing with some examples. Boy, is it useful - one of the best you have ever done. BIG thank you 😀.

[@LeilaGharani]

Yay, thank you! Glad it's helpful.

[@lesportautrement]

Thanks for that booster shot, on the basis of the layout. Explanations run smoothly 👏👏

[@MrLeonGros]

I'm at work, was casually going on a coffee break wondering how I will export a pdf from excel, while out of a sudden, I receive a notification for this video on my cell phone!

[@DEVILTAZ35]

Lol I know right. I just used Excel all day today for work too.

[@LeilaGharani]

Glad my timing worked, Antoine 😁

[@bineshbheekhoo2210]

Thanks for the refresher video. Really like it.

[@monkylinks]

This has been really helpful. Thank you!

[@deepakadroja6065]

Your tutorials are always with extraordinary tips💡

[@OmANnIe]

Great info! Very helpful. Thank you!

[@abdurrahmanomar4110]

I didn't know that page setup could be applied to individual sheets and exported accordingly... Leila you never stop surprising me with these tips, thank you much for sharing!

[@LeilaGharani]

Glad you found something new!

[@TheIresh]

Same here. Never knew page settings can be applied to individual pages before printing.

[@nabil1x]

Great video! Will use as my uni doesn’t accept Excel files as submissions so will be trying this out !

[@UmarAlFarooq]

Love it! You are the best!

[@pbgrafx]

Great content. Thanks so much.

[@divyeshpatel7826]

It's really good content which I have searching for long time. Thanks.

[@mirrorreflection3479]

Leila, bringing us simple and advanced videos in a mix...

[@LeilaGharani]

Sometimes we have to cover some basics too 😊

[@ambarilhamchannel]

I knew only two ways how to convert Excel into PDF, through save as, and through print as pdf. Thank you very much, you give me an inspiration

[@Progressive.G]

Thank you!

[@twosongs7396]

Your videos are invaluable, Leila. Thank you so much for these.🌹

[@LeilaGharani]

You're so welcome!

[@MiRofek]

Nice! Good tutorial... as always.

[@boubacardiallo6095]

Thank you much Leila for this video

[@andreasmaximus6116]

Thanks Leila, this was helpful. I convert Excel sheets to PDF and often struggled to get it right. 🙏

[@atique11]

Very helpful, thanks

[@Aziz_Abdullayev_uz]

I've finally found a longed-for remedy to my pain. Thank you so much! 👍👍👍

[@mikicasporea971]

Leila, with your so useful and easy to follow tip's, my life goes easyer and much, much more professional :) Thank's for non-selfish share of knowledge. Regards from New Zealand :)

[@rohitgope4800]

You are great... Thank you

[@user-lf8hz9fg7h]

Thanks for these methods and tips, really got productive.

[@LeilaGharani]

Happy to hear that!

[@Bill_Woo]

For this Alt-V-N, Alt-V-P, and Alt-F-U were rather universally used by high performance users prior to the Microsoft De-productivity Act of 2007. They still exist and are invaluable when you don't want to needlessly burn productive time hunting things down in the psychedelic ribbon categorizations. (FYI you formerly would find EVERY shortcut by simply arrowing through menus - utterly priceless when you remembered only the start of a shortcut, e.g. alt-D or alt-D-F. Now you have to memorize entire shortcut sequences, or memorize where items are hidden in ribbons.)

[@Luciano_mp]

I liked this tips! Very good! Thank you Leila!

[@LeilaGharani]

My pleasure, Luciano.

[@abdulrahmanmuslih141]

thanks a lot for this .

[@chrism9037]

Super helpful, thanks Leila!

[@LeilaGharani]

Thanks, Chris! Some basics 😊

[@rajeshaytha3678]

Hello Leila, excellent tips for new learners

[@abhishekmajumder6582]

This is a life saver Leila! Encountered these issues so many times and had to go for crude solutions...well, not anymore! Thanks a ton!!!

[@LeilaGharani]

It's great to hear this is helpful, Abhishek!

[@LuisCarlosChavez717]

Hi Leila, I enjoyed watching your video. You did a fantastic job following the good practices. I appreciate your sharing.

[@MuhammadAmir12358]

Thank you teacher 😄

[@brightafghans2886]

Thank you Leila.

[@robertbmercer]

You're a genius!!

[@kattomr6]

Again a very nice and practical video. Thank you Leila

[@LeilaGharani]

You're welcome 😊

[@vanessay.4892]

THANK YOU!!!

[@jesus.moreno]

muchas gracias ... saludos desde Peru!!!

[@getnet1261]

Thank you so much ❤

[@shankardeb4933]

Superb explanation.

[@Techkomsan]

This video really helpful for an office job

[@coolkidz33]

Another great video!! I have a suggestion for a future video and that is about working with shapes in Excel. I have created a couple of documents that contain a lot of shapes. I find it rather frustrating trying to use the tools in Excel to group, size, align them, snap them into a cell so they look good, and many other things. It never seems to do what I want it to do when trying to align vertically, copying groups of shapes and then trying to align them, search for text in shapes by hitting control F....... I realize there are better programs to do what I am doing (Visio....) but I want to do it in Excel. I cannot be the only one having problems with shapes and I would love for you to do a video to help me get better. Love your channel.

[@eslamfahmy87]

Thanks, actually day by day I developed & accelerate my tasks more than before 🎉

[@shakenbacon3655]

Thank you, this was so useful! 😨 I had to go throgh several KZbin recommended tutorials that were horrible, so I'm grateful I eventually foind yours!

[@LeilaGharani]

Glad it was helpful!

[@N7eptune]

Thank you Leila, brilliant and I learnt some new things.🙂

[@LeilaGharani]

That's great to hear. Thanks for your continued support!

[@germangr1014]

Repeat titles! I didn’t know this one!! Thanks:D

[@LeilaGharani]

Happy to help!

[@moeeeeeeeekdkdkd]

To know and make sure that we are in love with your videos WE WILL notice what's written in sec 0:45 😍

[@LeilaGharani]

Thanks for noticing 😘

[@abril430]

this is one of the common daily printing problems that takes away so much time... i am so thankful that you featured this. thank you leila❤️

[@omnibus574]

Thank you

[@doloresbombales7731]

This is a great, more upload.

[@Ch.Mujahid.Gujjar]

Very helpfull, cheers

[@gospelmoto2833]

another take home. Thanks Leila.

[@alokkumar-ve8bt]

Thanks much Mam!!

[@Andi-sj7po]

Hello Leila, I love all your excel tips, keep doing the good work. I would like to ask, I was doing FILTER Function inside of SUM Function for my dynamic Financial Performance report. Is it better to use those functions for multiple criteria or just using SUMIFS? I don't know if that will impact performance for the 2 years of data

[@DEVILTAZ35]

Thanks Leila , this is really informative, clear and concise. Can you please instruct the AAA gaming industry that this is what actual quality content looks like. 😁

[@juliannamassielo2758]

thank u queen u saved me

[@iliesboukhatem7803]

very useful, thank you ^_^

[@hansstam6629]

Well done

[@kdunlap3289]

I've been using ctrl-p to create pdf's of my reports but didn't know I could put multiple sheets in 1 pdf. Many thx for all your tips!

[@chh8860]

I am familiar with several of the features presented but still picked up a few 'Tips & Tricks' ... very helpful (as usual). So once again ... thank you ... thank you ... thank you ... 😍😍😍

[@LeilaGharani]

Glad you found something helpful, Chris!

[@flourishwithMJ]

Thanks

[@luayabdelbaqi7566]

Thanks Leila

[@kervincheng83]

I'm glad I have already known these skills🎉

[@LeilaGharani]

👍

[@arturom7903]

Thanks so much, Leila. I usually work with excel and these funtions were unknow for me. Your great!

[@guyarnaultmfoumbi8876]

Thanks Leila for this tutorial, it is very nice and useful. I am asking could you do a video on how to perfectly print a cover page, sometimes when printing is not fit on the entire paper Please 🙏🙏🙏

[@thinktoomuchb4028]

Great info! But does this solve the problem of Excel distorting shapes when you print them? I tried making round labels by using a barcode scanner to enter barcodes that were linked to semicircular Wordart. It was very frustrating. Going to View>Page Layout helps, but it isn't perfect.

[@raviawade]

That 3rd example really helped me. What if i want certain rows at the bottom (along with certain rows at top) need to appear on every page??

[@mahendraroliya8695]

Excellent💯💯💯💯💯

[@kijker1234]

Great video. Is it also possible to add a scope to the headers of a table to fullfill the PDF/UA norm?

[@Kunalindia3]

Hi Leila, This is Kunal from India. Although, this tutorial was informative but it lacks the usual USP like other videos. Would like to suggest a thing... Adding infographics/shapes & setting them in PDF is a daunting task in itself. Will you please share a video to ease such tasks? Thanks.

[@MooYum]

This is great info! My experience has been, though, that Excel's built in pdf print/save/export doesn't consistently respect the manual page breaks I've inserted, which is sometimes (but not even always) solved by using an external excel to pdf tool. Any tips/reasons why that may be happening?

[@MustafaKalafat]

I usually use publish option to print, because it allows me to do it in one click without any questions asked. However, I wonder whether there is any pros/cons between these 3 type of pdf making methods in terms of the resultant pdf file. I mean size of the file, quality of the tables and pictures, converting them back to excel files.

[@ericswidler8743]

Can you adjust the scale for each tab to the same height and width by selecting all the sheets?

[@burakbugan4926]

I think the easiest way is tapping F12 key and then setting the file type as PDF and save. Also you can do this with F12>TAB>P>Enter. In seconds. All done.

[@JJ_TheGreat]

6:08 I am definitely more used to - and lime using the "Page Break Preview" mode a lot more.

[@furzle1552]

Is there any way to print extra wide tables (that would otherwise take up two or more pages) such that they come in two different tables on top of each other?

[@marylemma9932]

Ahhh if only this was posted 2 weeks ago!

[@eriklehman3175]

Another well done video! Is there a solution to import PDF that has hyperlinks that will import with the file? There doesn't seem to be without writing code😢

[@traciesmobile683]

with editable pdf software you can add page numbers. you can also set book marks.

[@amralsabban3533]

THANKS

[@LeilaGharani]

You're most welcome!

[@boonloong]

Is it possible to use power automate to change the page layout to scale to fit the width to 1 page before it exports the excel in pdf format?

[@josimardealencar2428]

Hi Leila, how are you? Do you know any way or resource to convert table in image format in Excel?

[@emsems1237]

#1 fan here ^_^

[@girishk1142]

nice :)

[@gerrykeaveney1657]

leila, can you show us how the training form in the video is made please?

[@magnushultgrenhtc]

I use [F12], [Tab], [P], [Enter] a lot...! So simple.

[@throwyourmindat]

Hi @LeilaGharani could you please make a small video on how to animate the cell data to show like the text is appearing from from top and then sits inside the cell.. I mean just like how the vertical rotation. I wish I could show an animation . like a vertical cyclic ticker .. the word Leela .. appears coming from top edge of the Cell and then sits like every regular text does in side the cell. and when the value changes to Guarani, then the new values again appears coming from top and sits inside the cell. .. it will look like a vertically rotating text.. like a ticker. I hope I am able to explain

[@ryanashby2459]

Great tut! I was trying to print to PDF with a full bleed and no matter what setting and margins set there is always a strip of white at the bottom and right side... Help! haha

[@AshrafAli-ig1nl]

❤❤❤❤ Very good explanation But when I convert my Excel file to pdf the horizontal and vertical lines didn’t show In pdf? Please mention that

[@seppa193]

After you selected the print area, you can select to print only page 1 because page 2 has no info at all as far as I can see (3.24). So you dont have to scale anything anymore.

[@actng]

how to go the other way? our vendors send us quotes in PDFs but i need them in excel format to build our quotes.

[@KaisinSL]

Hi, how do we get this workbook sample for execising?

[@bdboyo]

If someone can tell me why when I save to PDf my book has extra pdf pages full of old data which doesnt exist. The workbook is 22 pages yet the pdf version has 40 and the extra pages are of old data which no longer exists.

[@avsmvlogs2911]

From Austria

[@jhisanmahmud3108]

I love you from the bottom of my heart. Only you can set my heart on fire❤❤❤❤

[@jhisanmahmud3108]

Your videos are so much informative and powerful to present business accounts

[@idwtv534]

I have two pages to print my second page is data is centered. I want it to flow immediately after the first page. Can anyone help

[@lazalazarevic6192]

Any idea on how to count number of cells in a range but only when text len is less than 20? Can it be done with formula?

[@LeilaGharani]

=SUMPRODUCT(--(LEN(A1:A10)

[@lazalazarevic6192]

@@LeilaGharani thank you. I am trying to make it work inside SUBTOTAL formula so the filtered rows are counted only but not succiding. Any tip on that?