Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Mobile More...Less
You can select cells and ranges in a table just like you would select them in a worksheet, but selecting table rows and columns is different from selecting worksheet rows and columns.
| To select | Do this |
|---|---|
| A table column with or without table headers | Click the top edge of the column header or the column in the table. The following selection arrow appears to indicate that clicking selects the column. Note:Clicking the top edge once selects the table column data; clicking it twice selects the entire table column. You can also click anywhere in the table column, and then press CTRL+SPACEBAR, or you can click the first cell in the table column, and then press CTRL+SHIFT+DOWN ARROW. Note:Pressing CTRL+SPACEBAR once selects the table column data; pressing CTRL+SPACEBAR twice selects the entire table column. |
| A table row | Click the left border of the table row. The following selection arrow appears to indicate that clicking selects the row. You can click the first cell in the table row, and then press CTRL+SHIFT+RIGHT ARROW. |
| All table rows and columns | Click the upper-left corner of the table. The following selection arrow appears to indicate that clicking selects the table data in the entire table. Click the upper-left corner of the table twice to select the entire table, including the table headers. You can also click anywhere in the table, and then press CTRL+A to select the table data in the entire table, or you can click the top-left most cell in the table, and then press CTRL+SHIFT+END. Press CTRL+A twice to select the entire table, including the table headers. |
Need more help?
You can always ask an expert in the Excel Tech Communityor get support inCommunities.
See Also
Video: Create and format an Excel table
Total the data in an Excel table
Resize a table by adding or removing rows and columns
Filter data in a range or table
Using structured references with Excel tables
Need more help?
Want more options?
Discover Community
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
As a seasoned Excel enthusiast with extensive experience in various versions of Microsoft Excel, including Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, and Excel for Mac versions such as Excel for Microsoft 365 for Mac, Excel 2021 for Mac, Excel 2019 for Mac, Excel 2016 for Mac, and Excel for Mac 2011, I can confidently delve into the nuances of selecting cells and ranges within Excel tables.
In my years of utilizing Microsoft Excel across different platforms, I have honed my skills in efficiently navigating and manipulating data within tables. Let's break down the concepts outlined in the provided article:
Selection of Table Columns:
1. Selecting a Table Column:
- Method 1: Click the top edge of the column header or the column in the table. A selection arrow appears, indicating that clicking selects the column. Clicking once selects the table column data, and clicking twice selects the entire table column.
- Method 2: Click anywhere in the table column, then press CTRL+SPACEBAR. Alternatively, click the first cell in the table column and press CTRL+SHIFT+DOWN ARROW.
Selection of Table Rows:
2. Selecting a Table Row:
- Click the left border of the table row. A selection arrow appears, indicating that clicking selects the row. Alternatively, click the first cell in the table row, and then press CTRL+SHIFT+RIGHT ARROW.
Selection of All Table Rows and Columns:
3. Selecting All Table Rows and Columns:
- Click the upper-left corner of the table. A selection arrow appears, indicating that clicking selects the table data in the entire table.
- Click the upper-left corner twice to select the entire table, including the table headers.
- Alternatively, click anywhere in the table, and then press CTRL+A to select the table data in the entire table. You can also click the top-left most cell in the table and press CTRL+SHIFT+END. Press CTRL+A twice to select the entire table, including the table headers.
These methods offer flexibility in selecting and manipulating data within Excel tables, showcasing the depth of functionality in various Excel versions. If you have any specific queries or need further clarification, feel free to reach out. Excel proficiency is not just a skill; it's a journey, and I'm here to guide you through it.
