Join Dennis Taylor for an in-depth discussion in this video Exploring the Page Layout tab and view, part of Excel 2013 Essential Training.
If you're about to print a worksheet, it's best to get a Print Preview first.…A couple of ways to do this.…You can go to the file tab in the ribbon and choose print and you do get a preview.…Recognize on the far right-side of the screen you'll see two sets of scroll bars.…If you use the outer scroll bar and drag downward, recognize not only will you…see the full page but the all-important indicator at the bottom of the screen is…to how many pages this is likely to take up.…Now if this particular worksheet has about 700 rows or so and you see that it's…going to take 35 pages, that don't sound quite right, does it?…If you click the Preview here and either use the mouse wheel or use the…inner scroll bar there to drag downward--eventually, we'll begin to realize…that in this particular set of data here that we are working with--it looks…as if the first few columns are going to be printed and then some others on additional sheets.…
And then if we keep scrolling here we'll see how the other data eventually…
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: Exploring the Page Layout tab and view