Skip to Content
Home
Maps
Calendar
Site Index / Search
Directory
  St. Edward's University

Computer Competency Requirement Navigation Bar
Competency Index
Competency Tutorial Index
Competency Glossary
Competency Site Index
Module 5 - Spreadsheets
Lesson 2 - Index Entering Data
Section 8 - Selecting Information

To select an entire column, click on the letter of the column you wish to highlight.

Highlight column

To select an entire row, click on the row number.

Highlighting row

To select contiguous cells, move the mouse pointer into the center of the first cell (the pointer will be a white cross) and drag the mouse pointer over the cells you wish to select.

Highlighting contiguous cells

In Excel XP, to select the entire worksheet, click in the blank square in the upper left hand corner of the worksheet between row header 1 and column header A.

Excel XP

Highlighting entire workbook

In Excel 2007, to select the entire worksheet, click in the square (with a down arrow) in the upper left hand corner of the worksheet between row header 1 and column header A.

Excel 2007

Excel 2007 Select Entire Sheet

To select noncontiguous cells, select the first cell or cell range as you normally would. Then hold down the control key as you select the next segment of data. All cells will appear selected.

Highlighting noncontiguous cells

Module 5 Lesson 2 Section 7
Module 5 Lesson 2 Section 9

 

 
St. Edward's University Logo St. Edward's University
3001 South Congress Avenue
Austin, Texas 78704
512-448-8400
Contact: itccmail@stedwards.edu
Updated: 09/2007
© 2003, St. Edward's University