Microsoft Excel 
ITTraining@sgul.ac.uk Page 14 St. George’s Information Services 
SELECTING ROWS 
 
 
 
 
 
  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
If you want to make changes to an entire row, 
such as bolding all of the headings in a row or 
changing the font of all the cell entries, you must 
first select the row. This is done by clicking on the 
row header to the left of the row. Remember that 
any changes you make will apply to every cell in 
the row all the way across to column XFD, so be 
careful! 
 
Try This Yourself: 
Same 
File Continue using the previous file 
with this exercise, or open the file 
E705 Ranges_1.xlsx... 
 
Press  +  to make cell A1 
the active cell 
 
Move the mouse pointer to the 
row heading for row 5 
Notice that the mouse pointer 
changes to a black arrow that 
points towards the row… 
 
Click once on row heading 5 to 
select the entire row 
 
Click in cell B7
and press  + 
 
This is the key combination for 
selecting an entire row… 
 
Click on the row header for row 7 
to select this row 
 
Hold down  and click on the 
row header for row 10 
All rows from 7 to 10 will be 
selected… 
 
Click in the row header for row 5, 
then hold down the left mouse 
button and drag down the row 
headers to row 10 
This is another technique for 
selecting rows, but it does require 
a steady hand! 
 
For Your Reference… 
To select an entire row: 
1. Click on the row header of the row that you 
want to select 
OR 
1. Click in any cell in the row and press 
 
+  
Handy to Know… 
 When every cell in a row or column is 
selected, the corresponding row or column 
header is filled in dark blue. When only some 
of the cells are selected, the row or column 
header is filled in orange. These indicators 
help you locate the active cell(s) on the 
worksheet. 
  
2 
3 
4 
6 
7