Тёмный

How to Break an Excel Worksheet into Separate Pages for Printing 

Teacher's Tech
Подписаться 975 тыс.
Просмотров 230 тыс.
50% 1

In the Microsoft Excel video tutorial, I will show you how to break a worksheet into separate pages for printing. Adding page breaks in Microsoft Excel is quick and easy to do. Need to modify the page breaks? Simply try dragging them into the correct location or removing or resetting them to add some new page breaks.
Make of copy of the example worksheet here: leveragingdigi...

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

 

15 сен 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 50   
@olajesutheophilus
@olajesutheophilus 10 месяцев назад
Thank you so much… This saves me a lot of headache. Something I don’t know in my 10years of working with Excel.
@robertdufour2456
@robertdufour2456 2 года назад
Thank you! Your lessons are always clear and on point!
@nicholasmacdonald8015
@nicholasmacdonald8015 6 месяцев назад
You saved me so much time. Thank you.
@rogerjohnson02
@rogerjohnson02 Месяц назад
This was excellent and EXTREMELY helpful! Thanks!
@jinouji6025
@jinouji6025 Год назад
Thank you very much for getting straight to the point with easy to follow instructions. Can't tell you how much I appreciate it. Have a great day buddy!
@ashkan9230
@ashkan9230 11 месяцев назад
thanx for very useful summary about the Page-Breaks
@jamessbca
@jamessbca 6 месяцев назад
Great video. Thank you! How did I not know this???!!!!
@chuiqushonwy648
@chuiqushonwy648 2 года назад
cam on bai giang cua ad, ad noi nghe rat ro rang , ngan gon va de hieu mong nhan dc nhieu bai giang cua ad
@anthonycampazestupinan4922
@anthonycampazestupinan4922 2 года назад
Thanks so much I love it
@PemberiSolusi
@PemberiSolusi 2 года назад
thank so much, this new for me,.. success forever
@lilianpokuaa2618
@lilianpokuaa2618 5 месяцев назад
Great lesson!!!
@pamelacarrera4795
@pamelacarrera4795 Год назад
Thank you so much, all these years I sent documents with pages cut in the middle of images 🤭
@ariarfiandi
@ariarfiandi 5 месяцев назад
Ah dude life saver,,,thank you
@Hamid-e2z
@Hamid-e2z 15 дней назад
Thank you sir
@carltonwashington2779
@carltonwashington2779 7 месяцев назад
This was awesome! Thanks man
@TeachersTech
@TeachersTech 7 месяцев назад
Glad you liked it!
@bouloshabiby1
@bouloshabiby1 7 дней назад
Thanks for the video, but when I insert a page break in my case, I can only see that a vertical blue line is added. I am unable to add a "horizontal" page break. Can you please advise? Thanks!
@frasatali3461
@frasatali3461 2 года назад
Lovely Explained well.
@NomadFlow
@NomadFlow 2 года назад
Hey there, Jamie! Can you make a Shotcut tutorial for the new way of recording audio/doing voice overs? The way to do it got a lot simpler in the latest versions.
@TeachersTech
@TeachersTech 2 года назад
That’s a great idea!
@kristynrebeccatk1899
@kristynrebeccatk1899 2 года назад
cam on ad da chia se kien thuc cho moi nguoi a
@maryeva2491
@maryeva2491 2 года назад
Jamie, do you have any courses or give private classes? I’m starting a career into technology but I’m really naïve and your tutorials are helping me a lot! In case you don’t teach out of RU-vid, is there a recommendation you could give ? I’m based in Brazil 🇧🇷 Thank you for all your wonderful videos and please please keep it coming 🤗
@TeachersTech
@TeachersTech 2 года назад
You're welcome! Unfortunately, at this this time I don't offer any private lessons or courses. I might add this later on.
@malcolmalexander5246
@malcolmalexander5246 Год назад
Thank you, very helpful
@meatiethatsme2471
@meatiethatsme2471 8 месяцев назад
Excellent
@mdsalahuddinkaiser9308
@mdsalahuddinkaiser9308 10 месяцев назад
Thanks you Sir.
@oldehatt476
@oldehatt476 Год назад
Nice thank you much!
@tutsecret499
@tutsecret499 2 года назад
I noticed that when printer is not attached to computer where the document was done, it does not allow me to adjust the page under view. I was trying to make the page to fit using the 80%, 90% reduction I was on a network where I was not allowed to add printer, so I could not use the layout, view, page break, nothing to adjust the page. Is there a way to do that when printer is not available. It's outreageous excel microsoft not allowing me to format the page if I don't have a printer attached. Now the person that received my spreadsheet can only view, if they print it will be in 2 pages or more, unless they fix on their end. It was so embarrassing, it was an attachment part of my job application. They might think I don't know how to adjust the page. I did the application last minute, and deadline would expire in minutes, so I told them that the attachment is only for view because printer was not available, and I would provide in another time another attachment with page layout when printer would be available. It was embarrassing, and I will lose points with that.
@haitsijsiyokjtso4669
@haitsijsiyokjtso4669 2 года назад
cam on ad them nhieu video hon nua ad oi
@jasonmeyer8909
@jasonmeyer8909 3 месяца назад
Is there a way to scale one page in a work sheet and not the others if there a multiple. (and not use a separate worksheet)
@felixmbawa6452
@felixmbawa6452 Год назад
thank you
@Mygoogleaccount-gr2qf
@Mygoogleaccount-gr2qf 9 месяцев назад
Thanks alot
@toms641
@toms641 6 месяцев назад
Yes, but how do I exit now from page break view. This is what all these legacy publishers do. They take an APP design which was totally intuitive, scramble it: "New and Improved". Now I am stuck in page break view, now idea how to exit it. Page Break setup used t be on the Print menu. Everything was fine.
@diemah217
@diemah217 Год назад
COOL BRO THANKSSS
@Parimal_Asodiya
@Parimal_Asodiya 7 месяцев назад
My query is i am unable to view page breck in excel 365 online program
@bhavyac
@bhavyac 4 месяца назад
How do I add different page numbers to each broken page?
@SK71509
@SK71509 9 месяцев назад
Very basic and high-level and doesnt explain the complexities that arise when you try to page break. I see some tabs can be printed as only page while other tabs with lesser rows/columns c'ant be put into one page.
@walterkalita5435
@walterkalita5435 11 месяцев назад
unfortunately, it doesn't work for me. There seems to be nothing I can do to insert page breaks. I have to reset the print area and print each page individually.
@alimasudi6844
@alimasudi6844 11 месяцев назад
How do I create an attendance register on excel
@perosweweckman2366
@perosweweckman2366 2 года назад
lot dep hong nhung video hoc tap thu vi tiep theo cua ban
@monaisyong3080
@monaisyong3080 2 года назад
coi clip dau tien va sub luon
@mohammadalti9825
@mohammadalti9825 3 месяца назад
The intro confused me
@ozanequhenrich936
@ozanequhenrich936 2 года назад
video hay qua , ra them video di chi oi
@alrhon50
@alrhon50 Год назад
I was after a keyboard shortcut myself
@bitv4815
@bitv4815 2 года назад
Fuck ill co back later
@lucutes2936
@lucutes2936 Год назад
Excel doesn't seem to understand the breaks very well
@CC-me7bc
@CC-me7bc 2 года назад
Excel is so unintuitive compared to numbers for Mac.
@tressabranco4014
@tressabranco4014 2 года назад
bai hoc bo ich a,em cam on a
@JustNishh
@JustNishh 2 месяца назад
thanks
@BoonBoonAlexanderhotmailcom
Thank you . This video help me alot ❤❤
Далее
How to Print in Microsoft Excel - For Beginners
13:10
EASILY Make an Automated Data Entry Form in Excel
14:52
ЗАБЛУДИЛИСЬ В ТРАВЕ #shorts
00:25
Просмотров 370 тыс.
How to use Formulas and Functions in Microsoft Excel
26:26
MS Excel - Print Page Setup & Print Data Tips
13:52
Просмотров 1,5 млн
How to Create Pivot Table in Excel
20:49
Просмотров 1,2 млн
How to Split Each Excel Sheet Into a Separate File
2:53
Excel for Beginners - The Complete Course
54:55
Просмотров 6 млн