Forum Discussion
How to convert 2 columns to be part of an existing table
I just noticed that in my spreadsheet some columns are in a table format and others are not. In my example attached, I need Column3 and 4 (C and D) to also be part of the table so I can filter on them. How can I add these two columns to the existing table format that A and B have?
Thank you!
I put your question to the Bing chatbot:
To change the range of an Excel table, you can use the Resize command. Here’s how:
- Click anywhere in the table, and the Table Tools option will appear.
- Click Design > Resize Table.
- Select the entire range of cells you want your table to include, starting with the upper-leftmost cell1.
You can also convert a table to a range by clicking anywhere in the table and then going to Table Tools > Design on the Ribbon. In the Tools group, click Convert to Range2. Is there anything else you would like to know? 😊
2 Replies
I put your question to the Bing chatbot:
To change the range of an Excel table, you can use the Resize command. Here’s how:
- Click anywhere in the table, and the Table Tools option will appear.
- Click Design > Resize Table.
- Select the entire range of cells you want your table to include, starting with the upper-leftmost cell1.
You can also convert a table to a range by clicking anywhere in the table and then going to Table Tools > Design on the Ribbon. In the Tools group, click Convert to Range2. Is there anything else you would like to know? 😊
- Excellent thank you! I was not familiar with the resize table functionality so was not sure how to search for it.
