Thank you it was very useful.... I had to come here due to my attention lapse when our teacher was explaining this.... I'm very shy so didn't have the nerve to ask him to repeat but I'm glad I came here now.....
Hi TourGlobe, I made a video on Word Options. I'll link it below. Obviously not the same as Excel, but the process to access them is the same: ruclips.net/video/7zjyURsWUao/видео.html
i Have been messing around with excel for about a year and had a little bit of frustration today and I thought of something that should be standard for all print tutorials. that if you hit ctrl p got to file print or mess around with the lay out tab then the dotted line appears. I never print anything and I'm cussing trying to get it to disappear. i went to print accidently and there didn't realize that's the default location.im like ihave only seen a million of these print tutorials ............ and know i got to watch some more.
perfectly explained but I have a question, Can I set page breaks horizontally (by rows) and vertically (by columns) at the same time? I'll try when I have excel installed. thank you
Hi Christian, Yes, your page break will take place on the horizontal and vertical axis of the cell that you have active. If you choose the cell where you want the break to occur, it should apply the breaks at the same time.
Thank for the explaination. But i have some question. If i using wps apps at phone, where can i find the pages break preview column. Can you show me? Thank you
Hi Rina, I'm pretty sure that you cannot add custom page breaks on the Excel Mobile App. I was looking for a way to do this but couldn't find one. Is that what you were trying to do?
how did you brought the January February row (the heading) to every page when printing ? I couldn't do it for some reason .. btw thanks a lot for explaining
Hi Jukta, I had this question too. In Excel 2019, we can navigate to Page Layout tab -->Print Titles. We have "Rows to repeat at Top" option. Select the row which need to be repeated on all the pages. Hit OK. After setting up Page breaks, the selected row is repeated in all the pages. Hope this helps..
Hi Darryl, I'm not entirely sure without seeing your computer. You could always clear that break as well, but it probably has something to do with the editing within your workbook. I'm glad the video was helpful, thanks for watching!
hello, what about if the data extends horizontally beyond a VERTICAL page break and i want all the data to fit across the page horizontally, without cutting off onto page 2, how can that be done please?
hey, I was wondering, how can i remove the rows inside a page break dynamically. Suppose i have set different page break for different values which give me pages with variable rows. I want to convert them to pdf and then remove the lines and go on for the next page break to print it. how should i solve this issue? Thanks in advance.
Thanks for the expanation. Quick question how does the "Customer Header" stays in the different pages when you print? I tried using freeze panes but ir doesn´t work. Thanks
Hi Jose, Freeze panes won't work for printing. You'll need to repeat rows/columns at the top of each page. I made a video on how to do this, check it out below: ruclips.net/video/1i01SLdCqng/видео.html
For some reason when I try this in excel it only adds a horizontal page break. I have tried selecting a column to add a page break, but nothing happens. Any help is greatly appreciated!
Hello: I want to have my excel document in a page-break-preview mode, but I don't what to see the contexts of PAGE 1, PAGE 2 and so on. Is it possible?
At 0:53 after you exited "Print Preview" how come the dotted lines indicating page breaks appeared even though you were in normal/default view? I noticed you didn't even click on anything to make them appear, they appeared on their own. Do you mind explaining that?
hello, what about if the data extends horizontally beyond a VERTICAL page break and i want all the data to fit across the page horizontally, without cutting off onto page 2, how can that be done please?
Good video, but I'm still unable to insert a page break in a worksheet with only Page 1, I have to copy the worksheet and paste into next new worksheet to start insert page. weird.
I need a technique on how to break page betweek 1-50, 51 -100 so on and so port. I need continues and automatic breaks for item for 10000 columns Numbers. I wanna see 50 items per page
Hi, Here is a video I made on printing in Excel. It discusses how to print certain contents on each page. I hope it helps: ruclips.net/video/wSyDn10Ieyo/видео.html
Hi Susie, Try clicking the Row number where you want the horizontal break to occur. Avoid clicking individual cells, as it will create vertical and horizontal breaks at the cell, rather than the row. Thanks for watching.
You have no idea how much I've been trying to figure these out...Thanks, A lot You Really Save My A** 🙏🙏🙏
Best explanation for page breaks I have ever experienced - thank you!
Thank you it was very useful.... I had to come here due to my attention lapse when our teacher was explaining this.... I'm very shy so didn't have the nerve to ask him to repeat but I'm glad I came here now.....
Thank you professor. A hug from Puerto Rico 🇵🇷
Out standing . Very clear and in detail .
Glad you like it!
@@ProfessorAdamMorgan i am looking into Excel Options any of your videos related to that ?
Hi TourGlobe,
I made a video on Word Options. I'll link it below. Obviously not the same as Excel, but the process to access them is the same:
ruclips.net/video/7zjyURsWUao/видео.html
@@ProfessorAdamMorgan Thank you for the message . i am mainly looking for the formula's option which is not the same as word.
What are you trying to change regarding formulas?
i Have been messing around with excel for about a year and had a little bit of frustration today and I thought of something that should be standard for all print tutorials. that if you hit ctrl p got to file print or mess around with the lay out tab then the dotted line appears. I never print anything and I'm cussing trying to get it to disappear. i went to print accidently and there didn't realize that's the default location.im like ihave only seen a million of these print tutorials ............ and know i got to watch some more.
perfectly explained but I have a question, Can I set page breaks horizontally (by rows) and vertically (by columns) at the same time? I'll try when I have excel installed. thank you
Hi Christian,
Yes, your page break will take place on the horizontal and vertical axis of the cell that you have active. If you choose the cell where you want the break to occur, it should apply the breaks at the same time.
Thank you Sir...very clear explanation.
VERY VERY WELL presented tutorial - THANK YOU so much !!!!!!!!!!
Many thanks for this very good explanation
You explained everything except what I need - how to move the page break downwards. thanks
That’s exactly why I came here too :)
Great now I’m disappointed
Thank for the explaination. But i have some question. If i using wps apps at phone, where can i find the pages break preview column. Can you show me? Thank you
Hi Rina,
I'm pretty sure that you cannot add custom page breaks on the Excel Mobile App. I was looking for a way to do this but couldn't find one. Is that what you were trying to do?
Very good explanation
Very helpful.Thank you!
Is it possible to fix a permanent page break for page 2 and 8, if a sheet containing 12 or more pages, even after resetting?
how did you brought the January February row (the heading) to every page when printing ? I couldn't do it for some reason .. btw thanks a lot for explaining
Hi Jukta,
I had this question too. In Excel 2019, we can navigate to Page Layout tab -->Print Titles.
We have "Rows to repeat at Top" option. Select the row which need to be repeated on all the pages. Hit OK.
After setting up Page breaks, the selected row is repeated in all the pages.
Hope this helps..
Why does my reset page break put the first break at row 431? Thank you for your video! Was a big help!
Hi Darryl,
I'm not entirely sure without seeing your computer. You could always clear that break as well, but it probably has something to do with the editing within your workbook. I'm glad the video was helpful, thanks for watching!
hello, what about if the data extends horizontally beyond a VERTICAL page break and i want all the data to fit across the page horizontally, without cutting off onto page 2, how can that be done please?
Very helpful
hey, I was wondering, how can i remove the rows inside a page break dynamically. Suppose i have set different page break for different values which give me pages with variable rows. I want to convert them to pdf and then remove the lines and go on for the next page break to print it. how should i solve this issue?
Thanks in advance.
Thanks for the expanation. Quick question how does the "Customer Header" stays in the different pages when you print? I tried using freeze panes but ir doesn´t work. Thanks
Hi Jose,
Freeze panes won't work for printing. You'll need to repeat rows/columns at the top of each page. I made a video on how to do this, check it out below:
ruclips.net/video/1i01SLdCqng/видео.html
@@ProfessorAdamMorgan Thank you
Thank you you save my time
For some reason when I try this in excel it only adds a horizontal page break. I have tried selecting a column to add a page break, but nothing happens. Any help is greatly appreciated!
Thank you very much
Good sharing
Hello: I want to have my excel document in a page-break-preview mode, but I don't what to see the contexts of PAGE 1, PAGE 2 and so on. Is it possible?
Thank you very much!!!!! this is really helpful! 😇
nicely explained. thanks man
Thank you so much!
Thanks Adam!
direct and succinct. THANK YOU!!!
No problem Amanda, thanks for watching!
Thank You so much , easy to understand
Great job sir 👍👍👍👍👍👍👍👍👍 TQ
Its quite helpful....Tq bro....
Thanks so much very very helpful
what if page break, cannot be moved? Have 4 pages break but cannot move when hovering the mouse pointer on the break lines?
Very clear thank u so much.
You are welcome 😊
At 0:53 after you exited "Print Preview" how come the dotted lines indicating page breaks appeared even though you were in normal/default view? I noticed you didn't even click on anything to make them appear, they appeared on their own. Do you mind explaining that?
hello, what about if the data extends horizontally beyond a VERTICAL page break and i want all the data to fit across the page horizontally, without cutting off onto page 2, how can that be done please?
great job Adam. Thank you!
What if you are unable to move the page break using the arrow? The arrow is not showing up in my Excel only. Could you please help?
Thank you sir! 😭😭
You have 50 customers, is there a way to insert page break between each customer which should be 50 page breaks in total. Thanks!
This is what I need!
Thank you! Very useful! :)
Thank you!
THANK YOU!!!!!
Good video, but I'm still unable to insert a page break in a worksheet with only Page 1, I have to copy the worksheet and paste into next new worksheet to start insert page. weird.
1. How to print a document as booklet.
2. In my excel 2019 A5 page is missing. How to create it.
3. I cannot customise page size. How to solve it.
Sir Im not able to click on show page break option in settings
Hi Prathamesh,
Make sure you're using a full version of Office. If you're using Office Online, you won't see it.
I need a technique on how to break page betweek 1-50, 51 -100 so on and so port. I need continues and automatic breaks for item for 10000 columns Numbers. I wanna see 50 items per page
Hi,
Here is a video I made on printing in Excel. It discusses how to print certain contents on each page. I hope it helps:
ruclips.net/video/wSyDn10Ieyo/видео.html
and my problem is that the page break is missing :\ and when I add page break I can only add vertical and not horizontal breaks . . .
When I insert a page break, it doesn't add a horizontal one. Only a vertical one. It's so frustrating! I can't figure it out.
Hi Susie,
Try clicking the Row number where you want the horizontal break to occur. Avoid clicking individual cells, as it will create vertical and horizontal breaks at the cell, rather than the row. Thanks for watching.
Dankeschön!!!
Thanks sir
thank you
anyone on.
pls i would love to reduce the page breaks.
let say from 10 pages to just 5 page.
thanks
👍👍👍👍
this isnt wrkignfor me
Very helpful. Thanks!
Thank you so much 🙌
Thank you
You're welcome! Thanks for watching, Anwar.
Thank you so much!!
thank you so much sir!