How to PROPERLY Convert Excel to PDF

Подписаться 2,6 млн

Просмотров 226 тыс.

50% 1

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

Опубликовано:

19 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 199

@LeilaGharani 4 месяца назад

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.

@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.

@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 😁

@OmANnIe Год назад

Great info! Very helpful. Thank you!

@lesportautrement Год назад

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

@bineshbheekhoo2210 Год назад

Thanks for the refresher video. Really like it.

@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.

@monkylinks 2 месяца назад

This has been really helpful. Thank you!

@andreasmaximus6116 Год назад

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

@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

@nabil1x Год назад

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

@deepakadroja6065 Год назад

Your tutorials are always with extraordinary tips💡

@pbgrafx Год назад

Great content. Thanks so much.

@twosongs7396 10 месяцев назад

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

@LeilaGharani 10 месяцев назад

You're so welcome!

@boubacardiallo6095 Год назад

Thank you much Leila for this video

@atique11 Год назад

Very helpful, thanks

@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 :)

@eslamfahmy87 Год назад

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

@jesus.moreno 11 месяцев назад

muchas gracias ... saludos desde Peru!!!

@Progressive.G 6 месяцев назад

Thank you!

@divyeshpatel7826 Год назад

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

@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.

@UmarAlFarooq Год назад

Love it! You are the best!

@rohitgope4800 Год назад

You are great... Thank you

@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

@abdulrahmanmuslih141 Год назад

thanks a lot for this .

@MiRofek Год назад

Nice! Good tutorial... as always.

@Aziz_Abdullayev_uz 6 месяцев назад

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

@getnet1261 9 месяцев назад

Thank you so much ❤

@MuhammadAmir12358 Год назад

Thank you teacher 😄

@shankardeb4933 Год назад

Superb explanation.

@Chris.Academy Год назад

Thank you Leila.

@LuisCarlosChavez717 Год назад

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

@rajeshaytha3678 Год назад

Hello Leila, excellent tips for new learners

@vanessay.4892 2 месяца назад

THANK YOU!!!

@omnibus574 6 месяцев назад

Thank you

@N7eptune Год назад

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

@LeilaGharani Год назад

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

@Luciano_mp Год назад

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

@LeilaGharani Год назад

My pleasure, Luciano.

@chrism9037 Год назад

Super helpful, thanks Leila!

@LeilaGharani Год назад

Thanks, Chris! Some basics 😊

@robertbmercer 8 месяцев назад

You're a genius!!

@user-lf8hz9fg7h 4 месяца назад

Thanks for these methods and tips, really got productive.

@LeilaGharani 4 месяца назад

Happy to hear that!

@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!

@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!

@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.)

@Techkomsan Год назад

This video really helpful for an office job

@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. 😁

@Ch.Mujahid.Gujjar 2 месяца назад

Very helpfull, cheers

@mirrorreflection3479 Год назад

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

@LeilaGharani Год назад

Sometimes we have to cover some basics too 😊

@gospelmoto2833 Год назад

another take home. Thanks Leila.

@kattomr6 5 месяцев назад

Again a very nice and practical video. Thank you Leila

@LeilaGharani 5 месяцев назад

You're welcome 😊

@alokkumar-ve8bt 2 месяца назад

Thanks much Mam!!

@flourishwithMJ Год назад

Thanks

@doloresbombales7731 8 месяцев назад

This is a great, more upload.

@iliesboukhatem7803 Год назад

very useful, thank you ^_^

@juliannamassielo2758 6 месяцев назад

thank u queen u saved me

@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 🙏🙏🙏

@germangr1014 Год назад

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

@LeilaGharani Год назад

Happy to help!

@shakenbacon3655 6 месяцев назад

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

@LeilaGharani 6 месяцев назад

Glad it was helpful!

@luayabdelbaqi7566 Год назад

Thanks Leila

@kijker1234 Год назад

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

@Herald-Fayez-im4jo 23 дня назад

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

@LeilaGharani 22 дня назад

Happy to hear that!

@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!

@hansstam6629 Год назад

Well done

@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.

@JJ_TheGreat Год назад

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

@raviawade 10 месяцев назад

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??

@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.

@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 😘

@mahendraroliya8695 3 месяца назад

Excellent💯💯💯💯💯

@kervincheng83 Год назад

I'm glad I have already known these skills🎉

@LeilaGharani Год назад

👍

@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?

@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.

@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😢

@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.

@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❤️

@ericswidler8743 Год назад

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

@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?

@amralsabban3533 4 месяца назад

THANKS

@LeilaGharani 4 месяца назад

You're most welcome!

@arturom7903 Год назад

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

@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?

@girishk1142 Год назад

nice :)

@ryanashby2459 8 месяцев назад

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

@saumilshah6926 7 дней назад

Can we create a power query for print to pdf various sheets in same file to different singular pdf

@AshrafAli-ig1nl 10 месяцев назад

❤❤❤❤ 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

@gerrykeaveney1657 Год назад

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

@traciesmobile683 Год назад

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

@TheStaszkowy Год назад

Nice vid :) But it only easiest way to print excel to PDF. The biggest issue of excel, is to insert a page number in a specyfic cell of out worksheet. Or even better, in the header (made from few rows) reapeted or each printing page, in MS Word it was quite easy, but in Excel, in my opinion, it can't be done without VBA.

@emsems1237 Год назад

#1 fan here ^_^

@KaisinSL Месяц назад

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

@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

@avsmvlogs2911 Год назад

From Austria

@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

@marylemma9932 Год назад

Ahhh if only this was posted 2 weeks ago!

@magnushultgrenhtc Год назад

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

@sunshine0282 Год назад

Great Leila! I actually had issues doing the opposite just last week. I converted PDF to excel: I deleted it faster than the speed of sound lol. Would you please make this your homework, Leila😂? To spice it up a bit: the PDF had some handwriting over it😮.

@LeilaGharani Год назад

I started this homework some time ago 😁: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-p2304BjvrB8.html

@sunshine0282 Год назад

@@LeilaGharani Well great then. I can't wait to watch it. I think I have my notifications on for your vids. Thanks already! Later!

@GameAGuy Год назад

Hi comunity. 😊 I just got a new HP Envy Laptop/Tablet/ Tent mode . It is awesome. I got a new 27 in wall mount screen at work. So I am using excel allot now and learning allot. I really apreciate this channel. However, when I got the Envy I only got a trial for Mc Afee anti virus. I was wondering what virus protector you guys here like?🤔 I need to get one and had Norton long time ago but been out of pc loop gor awhile.

@Eternal_Tech Год назад

Microsoft Defender, which is built into Windows, is sufficient, light on resources, and completely free. I recommend uninstalling the McAfee trial version, restarting your computer, and ensuring that Microsoft Defender is running and up-to-date.

@GameAGuy Год назад

@@Eternal_Tech ok. Thanks