Como guardar un EXCEL en PDF sin que se corte

Welcome to this new video I am Miguel Vela from your channel El Tio Tech and today we are going to learn how to save from excel pdf but without cutting any part of your excel information we are going to learn to make some configurations so that do not miss information or the information does not send you to another page here I have two exercises that you can download if you want the link I will leave them in the description of this same video well and what we are going to do next it is also if you like this main title or this header of your table it can also appear in all the sheets we are going to make some configurations that will surely seem interesting to you well we are going to start with this but first please if one of our videos has helped you at some point or if this video from you would be helping us a lot if you subscribe to our channel by clicking only where it says subscribe and activating the bell so that you don't get caught. No news, now we are going to start the first thing we do is how we save from excel to PDF how we export we go to the upper left part to the file tab we are going to save as and we are going to examine, here I am going to select a path I am going to put it on the desktop and look here in type I am going to select this one that says pdf ok the extension dot pdf I click here and we are going to give it a name I am going to put for example test 01 and I have it I click on save and let's go let 's see how it doesn't export apparently it's fine look how it's behaving it went down a little look here it also seems to me that it would be fine apparently but in the end look here that a column the excel table is throwing me on another sheet and so on look at that this that's what I get right now we're going to make the settings I'm going to minimize this and I want you to notice that after saving to pdf these dotted lines appear, look I'm going to go down a little more and here I also have below look angela in the horizontal part the dotted lines that tells me that all this box that encloses the dotted lines is a sheet if I go to the next sheet look here too I have the dotted lines that we are observing then this would be another sheet and if I go downstairs I also have the third sheet and over here look I would also have one more sheet this is the result that we are observing here the four sheets look there we have it but if you wanted to see it you could say it in a more highlighted way on the right side bottom here we have this option that says page break preview we click here and I want you to notice that now the boxes the dotted lines appear blue and the page number also appears to me look at page 1 and page 3 what is this bit not that we are seeing it here look here is the page that is page 3 no and page 4 look is the end that is this bit tasting that says page 4 and page 2 what ah now we are going to do the following we are going to select all our data we select all our data look we select all our little table we go to the tab that says page layout and we are going to go where it says English printing area and we select establish printing area we give a click here and if it hasn't solved the problem it comes if it hasn't solved the problem we have here the line continues dividing into four pages so what we are going to do is the following we are going to go right here where it says disposition of peace and in scale we are going to go down a little look we are going to go down a little ok we are going to put 60 look it does not solve us we are going to put 55 it does not solve us in case it does not solve then we could drag the blue line towards the right, that is , to the top, we drag it to the right, look and it has already disappeared and automatically here it is sending me a scale of 54, that is, the adjustment has made it automatic when dragging the blue line on the right I want you to notice that here I have page 1 and here I have page 2 I mean I don't have four pages anymore and I'm going to the file tab I'm going to save it as examine we're going to see test 2 in type let's go to put pdf and here we are going to put test we are going to put test 02 we are going to see how it exports us we hit save look now yes now yes I only have two pages I only have two sheets look in the first test 4 it is not now the second one I only have two if I wanted to see that the header is repeated in all the sheets because it is very likely there are cases then we are going to come and again we are going to click on any part of your table we continue here in page layout and where it says print titles we go When you click , the next little window will pop up and here where it says repeat rows at the top, we are going to click and we are going to select all the entire header that we have in return , we have just selected it there r is row 11 we click accept we are going to go again file save as examine we are going to look for the pdf and we are going to put here test test test 03 we click save let's see let's see look and now the header the header notice that already it 's on two pages ok in the pdf let's see the last example quickly we have here exercise 2 and this one is quite wide look this one is quite wide we are going to do the following we select everything look we select all our board we are going to go where it says area printing the same print area and set print area we click here after that we are going to go look now if it will appear to you the dotted lines will appear here the dotted lines will appear let 's see I'm not seeing it but we are going to see what happens, we select everything again and we are going to go where it says look at orientation and in orientation we are going to give it where it says horizontal a click on horizontal well after that we are going to go again here where it says page break preview or a click here look it appears on three sheets what we are going to do now is drag those lines to the right look we are going to drag the lines on the right and it has just appeared on one page look control z the blue line the blue line this blue line we are going to drag everything to the right and only one page should appear we are going to go to file save as browse and we are going to see how it appears in pdf look here in pdf I'm going to put this if I'm not mistaken, it's test 404 you should save and look here it is but watch out it's already on a horizontal sheet and if I give more control look how it's getting closer and there's the data but in this way if the table is very wide it will also seem horizontal to me but the data obviously smaller not but as you can see everything is clear there if we zoom in well and that would be all Please subscribe to your channel El Tio Tech and see you in the next video

Channel: El Tío Tech

Views: 176,555

Keywords: El Tio Tech, como guardar un excel a PDF sin que se corte, guardar excel en pdf varias hojas, guardar excel en pdf en una sola hoja, Como guardar en PDF una hoja de Excel, ¿Cómo guardar Excel en PDF sin que se corte?, convertir excel a pdf, pasar de excel a pdf, de excel a pdf, pasar excel a pdf, convertir excel en pdf, guardar pdf en excel, Excel a pdf, guardar excel en pdf, imprimir en Excel, como imprimir en excel, como imprimir excel, convertir una Hoja Excel a PDF

Id: J8hZXqbJtYM

Length: 8min 59sec (539 seconds)

Published: Fri Jul 22 2022