How are you able to teach me more about Excel than my school teaches me :) The great thing is you are always able to really simplify things and its super helpful :D
Hi Alan. Great tips! A time saving keyboard to open Page Setup to the Sheet tab is: ALT, P, S, P, S. An even more time saving trick is to highlight the Columns and or Rows that you want to set and then click in the Name Box and enter the name: Print_Titles which is the special name that EXCEL automatically gives to the row and column ranges when you enter them through Page Setup. If no previous settings exist, then the currently highlighted row and columns will be set without having to navigate into Page Setup. If there is already a previous definition for Print_Titles, then when you type Print_Titles in the Name Box the highlights will show on the screen and then you must adjust them through Name Manager or Page Setup. Or, you can delete the name Print_Titles and then redefine, as noted above. Hope someone finds this useful. Thanks for your videos and lessons.. always great things at Computergaga :)) Thumbs up!!
00:00 - Headers not repeating on other pages 00:49 - Repeat headers row on every page with Print Titles 02:33 - Repeat columns on all pages when printing
Cool Tutorial,It's Surprising How Many Office User's Don't Know These Techniques For Print Setups...Thank You Alan :)
Thank you, Darryl.
Thank you very much, this saved me a ton of time. Very well explained.
Awesome! Thank you.
THANK YOU so very much!!! Incredibly helpful!!
Great to hear, Lisa. Thank you.
Such a beautifully simple tutorial! Thanks a ton
You're welcome. Thank you.
How are you able to teach me more about Excel than my school teaches me :)
The great thing is you are always able to really simplify things and its super helpful :D
Thanks, Ruth. Great to hear.
Really helpful
Thank you, i got it from your video.
Glad it helped Priya.
very useful page, thanks. i think this is also applied to ms project, repeating first columns
Thank you, Salum.
Hi Alan. Great tips! A time saving keyboard to open Page Setup to the Sheet tab is: ALT, P, S, P, S. An even more time saving trick is to highlight the Columns and or Rows that you want to set and then click in the Name Box and enter the name: Print_Titles which is the special name that EXCEL automatically gives to the row and column ranges when you enter them through Page Setup. If no previous settings exist, then the currently highlighted row and columns will be set without having to navigate into Page Setup. If there is already a previous definition for Print_Titles, then when you type Print_Titles in the Name Box the highlights will show on the screen and then you must adjust them through Name Manager or Page Setup. Or, you can delete the name Print_Titles and then redefine, as noted above. Hope someone finds this useful. Thanks for your videos and lessons.. always great things at Computergaga :)) Thumbs up!!
Thank you, Wayne. Nice tip on typing in the Name Box. I'm not a fan of keyboard sequences though 😊 Not for me.
@@Computergaga That's the fun thing about EXCEL.. always multiple ways to get things done.. so can pick whatever works best for you :))
Thanks mate. Its really useful😉👍
Excellent! My pleasure, Farhan.
Great boss thank you
You're welcome. Thanks.
Thank you
You're welcome, Sovicha.
thanks, big help
Great to hear. Thank you, Sean.
How do you repeat rows on top of every printout except the last page in Excel?
00:00 - Headers not repeating on other pages
00:49 - Repeat headers row on every page with Print Titles
02:33 - Repeat columns on all pages when printing
put the practiced files in the description...
The Gantt Chart file is in the description and for the first example, you can use and worksheet with 30 + rows.
talks way to slow
Thanks