Thank you, that was great tutorial. I'm not sure, just curious and I tried your 1 sheet method to more sheets into a PDF and it only did 1 of my Excel sheets. Can it be done in 1 document from several Excel sheets to PDF. I guess I could copy the other sheets to 1 sheet and then convert to PDF, just curious if it can be done whilst having a few sheets of data. Thanks again.
All good, I worked it out, just set up each sheet the way you want it viewed, and then hold down ctrl and click on all other sheets then save as PDF. So for others trying this, select all sheets tabs below at the same time after using the page view. Thanks for the video as it helped me to do it from the start.
Thank you sooo soo much… I had problems with page breaks which they caused me problems while I was exporting Large Excel file to PDF file.. Again thank you sooo much
Thank you so so much. I only wish I had googled and discovered this years ago. Now large PDFs are no longer my enemy. Thank you for sharing. You are officially bookmarked in my 'how to' list.
HEY, DEAR YOU MADE MY DAY☺ , Thank you so so much… I had problems with page breaks which they caused me problems while I was exporting Large Excel file to PDF file.. Again thank you so much😘
I have combined many types of documents including excel into one file. I want to print the excel documents in legal size, landscape (because the excel has a lot of data) and the rest the default letter size portrait. Is there anyway, I can set the printer to print both size paper automatically.
The same issue its happened to me when I save from email some tables cutout can you please show me how to save it as pdf from email without break table
I now have an Excel spreadsheet where I'm trying to remove the page breaks and Save As PDF, as I learned in this video, but there is a stubborn dotted vertical line page break that won't disappear and forces the document in two pages. What is going on here? I have a photo of how it looks. How can I send it to you to view?
@@excellikeaboss6189 Yes, I have. The vertical dotted line remains in place. I also have just tried dragging the horizontal page break line further down and the same thing occurs at line 161...a dotted line appears and remains in place, creating 4 pages. I'm guessing at this point that there is a limit as to how large a pdf Excel will Save As on one single page.
Hi, 1) I would make this column a little wider than actual fit - try this out! 2) if 1st trick doesn’t help, change that data type as text - it shouldn’t convert text to hashtags ( as that happens with numbers or dates sometimes).
Hey Ricardo! Good question! No, unfortunately I don’t have a macro to share. But if you are familiar with macros, I would use record option and than adapt code - from first glance it seems to be not too complicated and reusable :)
Thank you, that was great tutorial.
I'm not sure, just curious and I tried your 1 sheet method to more sheets into a PDF and it only did 1 of my Excel sheets. Can it be done in 1 document from several Excel sheets to PDF.
I guess I could copy the other sheets to 1 sheet and then convert to PDF, just curious if it can be done whilst having a few sheets of data. Thanks again.
All good, I worked it out, just set up each sheet the way you want it viewed, and then hold down ctrl and click on all other sheets then save as PDF. So for others trying this, select all sheets tabs below at the same time after using the page view. Thanks for the video as it helped me to do it from the start.
Thank you sooo soo much… I had problems with page breaks which they caused me problems while I was exporting Large Excel file to PDF file.. Again thank you sooo much
Thank you so so much. I only wish I had googled and discovered this years ago. Now large PDFs are no longer my enemy. Thank you for sharing. You are officially bookmarked in my 'how to' list.
Happy to hear that this was helpful!
mam i swear i waste my 2 hours to find out how to do that all thanks to you u really save my time again thanku
Thank you! Now I can finally submit my assignment!
HEY, DEAR YOU MADE MY DAY☺ , Thank you so so much… I had problems with page breaks which they caused me problems while I was exporting Large Excel file to PDF file.. Again thank you so much😘
Glad that I could help 😉
Thank you so much! Google has put to many add website that didn't help at all. I subscribed and left a like.
Thank you so much. I've been looking for this exact tricks for years :)
Thankyou soo soo soo much. You saved my money for freelancing ❤️
This video is very helpful for an excel Lerner's
I am not regretting at all and a very life saver with very very helpful.🥰🥰🥰🥰🥰🥰
you are the most good person ever
thanks
I am very thankful to you for giving this Deep Excel Pdf Knowledge ❤❤
Thank you for making this video! It was very, very helpful. Wonderful!!
Thank you for sharing. I was asked to consolidate big excel file with crazy long cells into printable pdf
Hi! I am following all steps but when I save it to pdf it saves it as 130 pages instead of the 4 I created
Bless you dear, this was very helpful
I suffered a lot before you.
thanks.
Thanks for the simple but secret tip.
F*CKING THANK YOU. ALL THE OTHER VIDEOS DIDN'T EXPLAIN THIS!! THANK YOU!!!!!!!
You are one gem of a person ❤️Thank you so much ❤️❤️❤️❤️
YOU ARE THE BEST - thank you for this video, saved my day!
I have combined many types of documents including excel into one file. I want to print the excel documents in legal size, landscape (because the excel has a lot of data) and the rest the default letter size portrait. Is there anyway, I can set the printer to print both size paper automatically.
SERIOUSLY THANK YOU SO MUCH
Thanks it's very useful
thankk you, this helped me soooo muchh
Literally saved my day! Thanks Boss!
I love you girl! thank you so much!!
Thank you SO MUCH !
Thank you for this video.
Thank you so much help me alot
Thank you so much!!
You are a life saver!!!
Ur voice very nice
Thanks Mam please start uploading new content on excel will be helpful
thank you, you saved my day, excellent video.
Thank you verry much.
Thank you so much! But what if a have multiple sheets? How can I convert all in the same file?
It was very helpful. Thanks a lot.
Thank you so much I was so much frustrated.
Thank You dear...
This helped alot, you are the best!
THANK YOU!!
I put all in 1 page drag the blue lines but when printing to pdf the table not centered in center of page what to do
Very nice . But am using office 2013 and am failing to save the entire sheet as pdf file is cutting off some columns? Please help me
Thank you so much with the help of you I did the same thank you
Thank you thank you so much❤️
It was very helpful 👍🏻
you saved my life :)
thankyou....you saved the day :)
awesome quick and easy thanks :)
WHEN IM CONVERTING THE LAGRGE EXCEL FILE TO PDF AFTER THE FIRST PAGE AND SECOND PAGE STRAT WITH SOME BLANK GAP BETWEEN THE TWO PAGES. HOW TO FIX IT.
Thanks so much😊
Thank You Very Very Much. 🥰🥰
The same issue its happened to me when I save from email some tables cutout can you please show me how to save it as pdf from email without break table
thank you so much
Big thank !!!
Thank you very much..👍👍👍
great video
Thank you very much. Pretty useful
Greta tutorial
Great. you made my day
Thank you so much!!!
thanks, this was pretty useful
Thank you
Thank You for your help..!!
Thanks 🙏
This is great, thanks!
Hi
How can I save multiple sheets in one pdf?
thanks a lot sister
thanks a lot, it is life saving!!!!
Thank you
thanks a lot --Amazing!!!
Thanks
Thanks!!
how to change the page number of the page break?
With pio char base individually
I now have an Excel spreadsheet where I'm trying to remove the page breaks and Save As PDF, as I learned in this video, but there is a stubborn dotted vertical line page break that won't disappear and forces the document in two pages. What is going on here? I have a photo of how it looks. How can I send it to you to view?
Hi Mike, thank you for your question! Have you tried to drag and drop that line to end of your data? ( to the right side)?
@@excellikeaboss6189 Yes, I have. The vertical dotted line remains in place. I also have just tried dragging the horizontal page break line further down and the same thing occurs at line 161...a dotted line appears and remains in place, creating 4 pages. I'm guessing at this point that there is a limit as to how large a pdf Excel will Save As on one single page.
Thankyou!!
thank u
life saver
Good is working
ThnkYouVeryMuch
Hello. But when I do the same with my table, the text in the cells becomes small. When the file is already in PDF.
Hi! Do you do exactly the same steps as I do in video?
Have 14 digit figures in few columns, excel shows hashtags.
How to export pdf with numerical figures visible.
Kindly help
Thanks.
Hi, 1) I would make this column a little wider than actual fit - try this out! 2) if 1st trick doesn’t help, change that data type as text - it shouldn’t convert text to hashtags ( as that happens with numbers or dates sometimes).
@@excellikeaboss6189 Thanks for the immediate reply.
Great
Do you a macro for this and run it once for multiple excel files?
Hey Ricardo! Good question! No, unfortunately I don’t have a macro to share. But if you are familiar with macros, I would use record option and than adapt code - from first glance it seems to be not too complicated and reusable :)
@@olgalmt5134 Thank you, Olga!
Thnz
Thanku Mam
Not useful at all. Where is the Rows and columns ? and you are too slow to and wasted my 6 mins
Thank you!
Thanx a lot dr
Thank you so much ❣️
thanks Its help a lot
Thank-you very much....
thanks
Wonderful
thank you