1. Home
2. Help
3. Software Help
4. Excel Help

How to select an entire row or column in a spreadsheet

Updated: 03/06/2020 by Computer Hope

To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

Tip

You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
• Home
• Help
• Software Help
• Excel Help

• How to select an entire row or column in a spreadsheet

  Updated: 03/06/2020 by Computer Hope

  To select an entire column or row in a spreadsheet, click the column header or row header. For example, if you clicked the "H" column header (marked in red in the picture below) the "H" column is highlighted. If you clicked the "16" row header (also marked in red), the 16th row is highlighted.

   

  Once a column or row is highlighted, you can apply any properties or changes that can be done to an individual cell. For example, once an entire column is highlighted you can click the center text icon to center all text in that column. You can also press the delete key on the keyboard to delete all highlighted content.

  Tip

  You can select multiple columns and rows by holding down the Ctrl on the keyboard and clicking each column or row header you want to highlight.

  Additional information

• How to hide rows or columns in Excel.
• How to add or remove a cell, column, or row in Excel.
• How to select one or more cells in a spreadsheet program.
• How to highlight or select text.
• See our column and row definitions for further information and related links.
• Microsoft Excel help and support.
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•