[6 minutes total]
These four tutorials show how to move around the Excel workspace. They also teach useful “hot key” combinations that can help you move around, select data, and save you time.
After viewing the tutorial(s), use the back key in your browser to return to this web site.
- Moving around with the arrow, Home, End, Page Up, and Page Down keys(1:15)
- Moving around with the Ctrl (control) key with the arrow, Home, and End keys(2:18)
- Using the Shift key with the arrow, Home, and End keys(1:18)
- Using the Shift and Ctrl keys with the arrow, Home, and End keys(1:21)
Rows and Columns
[4 minutes total]
These four tutorials show how to select rows and columns in your data. They also teach how to rearrange, resize,and/ormoveyour rows and columns to enhance the readability or create subsets of your data.
After viewing the tutorial(s), use the back key in your browser to return to this web site.
- Selecting rows and columns(0:56)
- Using the Ctrl key to select noncontiguous rows and columns(1:19)
- Using the Ctrl key to copy and paste noncontiguous rows and columns(1:04)
- Selecting the entire worksheet(0:57)
[4 minutes total]
These three tutorials show how to “lock“columns or rows (or both!) so that they are always visible on the screen. Freezing a row of column headings is especially useful when working with large school– or district-level data files since it’s easy to get lost in the data and forget which column of data or student you’re examining.
After viewing the tutorial(s), use the back key in your browser to return to this web site.
- Freezing rows to remain visible(1:11)
- Freezing columns to remain visible(0:40)
- Freezing both rows and columns to remain visible(0:49)
You may need to turn off your browser’s pop-up blocker or install the latest Flash plug-in to view these tutorials.
