Join Dennis Taylor for an in-depth discussion in this video Previewing page breaks, part of Excel 2013 Essential Training.
Another approach to printing begins with the idea that you'd like to get a…preview of what your printout is going to look like.…In the status bar, the three buttons in the lower right-hand corner include a…button called Page Break Preview.…And as we click this, the screen changes and we see blue borders and possibly…dotted lines as well.…If you start to scroll in this list, as I'm doing here, recognize the watermark…depiction here of Page 1, over in the left-hand side--up to the right in this…example it's Page 18.…So as we scroll up and down here, we see these.…Now, with Page Break Preview, you have the option here of controlling not only…the breaks, but the actual borders here.…
It's good to get an actual preview here.…If you do have available in your Quick Access Toolbar, the Print Preview button,…we added this in an earlier movie, you can click that or possibly press Ctrl+F2…or maybe even go to the File tab and choose Print.…Any of those three ways gives us the Print Preview.…And as we look at this list here and then use the outer scrollbar on the…
Author
Released
1/30/2013- What is Excel and what is it used for?
- Using the menus
- Working with dates and times
- Creating simple formulas
- Formatting fonts, row and column sizes, borders, and more
- Inserting shapes, arrows, and other graphics
- Adding and deleting rows and columns
- Hiding data
- Moving, copying, and pasting
- Sorting and filtering data
- Printing your worksheet
- Securing your workbooks
- Tracking changes
Skill Level Appropriate for all
Duration
Views
Related Courses
-
Excel 2013 Tips and Tricks
with Dennis Taylor4h 34m Appropriate for all -
Excel 2013: Charts in Depth
with Dennis Taylor3h 46m Advanced -
Excel 2016: Cleaning Up Your Data
with Dennis Taylor2h 26m Intermediate
-
Introduction
-
Welcome39s
-
-
1. Getting Started with Excel 2013
-
What is Excel used for?1m 49s
-
Using the menu system4m 30s
-
The Quick Access Toolbar4m 41s
-
Using the Formula bar1m 43s
-
Using the Status bar2m 24s
-
Using the built-in help2m 54s
-
Creating new files2m 11s
-
-
2. Entering Data
-
Working with dates and times3m 32s
-
Using Undo and Redo4m 50s
-
Adding comments2m 55s
-
Using Save or Save As3m 57s
-
3. Creating Formulas and Functions
-
Using SUM and AVERAGE3m 25s
-
4. Formatting
-
Designing borders3m 26s
-
Formatting numbers and dates4m 31s
-
Conditional formatting4m 21s
-
Creating and using tables9m 59s
-
5. Adjusting Worksheet Layout and Data
-
6. Printing
-
Previewing page breaks4m 56s
-
7. Introduction to Charting
-
Creating charts4m 36s
-
Exploring chart types7m 47s
-
Formatting charts5m 42s
-
-
8. Adjusting Worksheet Views
-
9. Multiple Worksheets and Workbooks
-
10. IF, VLOOKUP, and Power Functions
-
11. Security and Sharing
-
Protecting workbooks2m 40s
-
Sharing workbooks4m 7s
-
Tracking changes4m 32s
-
12. Database Features
-
Sorting data6m 9s
-
Using filters6m 16s
-
Removing duplicate records2m 38s
-
-
13. PivotTables
-
Creating PivotTables8m 36s
-
Manipulating PivotTable data9m 47s
-
Grouping by other factors2m 33s
-
Using PivotCharts3m 59s
-
-
14. Data Analysis Tools
-
Using Goal Seek6m 8s
-
Using Solver6m 34s
-
Using Scenario Manager6m 11s
-
Using Data Tables4m 36s
-
-
15. Introduction to Macros
-
Definition and examples6m 48s
-
Running a macro10m 43s
-
-
Conclusion
-
Next steps29s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Previewing page breaks