Access Keys:
Skip to content (Access Key - 0)

Selecting Entire Columns or Rows in Microsoft Excel

Added by LAURA NICOLE MASSARO KAUFFMAN , last edited by LAURA NICOLE MASSARO KAUFFMAN on Jan 18, 2010 10:26


Selecting Entire Columns or Rows in Microsoft Excel

  • To select an entire column, left-click the lettered column header above the column. 
  • To select an entire row, left-click the numbered header before the row.
  • To select an entire worksheet, left-click the corner between the row and column headers.
Icon

Tip: To select several consecutive columns or rows at once, left-click the first header, and while holding down the shift key select the last header.  All of the rows or columns in between will also become selected.

#top

#top