Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
 So that's how! Working with really big worksheets 
 
  Overview  
 Show/Hide lesson sections Get a better view, and find your way around
 Show/Hide lesson sections Make worksheets work for you
  Feedback  
 Quick Reference Card Quick Reference Card  
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Overview
Work with ease in really big worksheets  

Learn how to work with ease in really big Microsoft Excel worksheets. Keep column and row names in sight no matter where you are on a worksheet, navigate to the far end of the largest worksheet by using a keyboard shortcut, move and copy sheets, and filter and sort data by using the AutoFilter arrows.

  • Length: 30–40 minutes
  

Next

GOALS

After completing this course you will be able to:

  • Freeze panes to keep names in place while you scroll through data, or split panes to get different views of the data in your worksheet at the same time.
  • Name cells or ranges of cells so that you can quickly return to those worksheet regions.
  • Navigate quickly by using keyboard shortcuts and the Go To dialog box.
  • Group worksheets to enter common data in multiple worksheets simultaneously.
  • Filter and sort data by using the AutoFilter arrows.
  • Print multiple worksheets at the same time.
  
ABOUT THIS COURSE

This course includes:

  • Two self-paced lessons and two practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.
COURSE TEXT

Do you want to keep column or row names in sight as you scroll down a worksheet so that you know what the data in the middle or the bottom of the sheet refers to? Perhaps you'd like to use keyboard shortcuts to navigate quickly back and forth across a worksheet.

Learn about great ways to work faster and easier in Excel on really big worksheets (although what you learn here will help you out on worksheets of lesser size as well).

Find out how to save time by creating multiple worksheets with common data or formatting at one time, how to print just a certain area of a worksheet instead of an entire worksheet, and how to print multiple worksheets at the same time.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column. Then click Next to start the first lesson.
  Go to previous page (disabled)    Next Go to next page
advertisement