kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 922
- Office Version
- 365
Hi,
I have the following table with the first rows merged to indicate the years. When I insert tables in excel 2007, Excel seems to add the word "Column" in empty cells and I cant seems to delete the word "Column".
Here is sample how the table looks before inserting the table and after the table is inserted.
Is there any way I can delete the word "Column" ?
Appreciate assistance. Thanks.
I have the following table with the first rows merged to indicate the years. When I insert tables in excel 2007, Excel seems to add the word "Column" in empty cells and I cant seems to delete the word "Column".
Here is sample how the table looks before inserting the table and after the table is inserted.
Is there any way I can delete the word "Column" ?
Excel Workbook | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | |||
2 | Before Inserting Table | * | * | * | * | * | * | * | * | * | ||
3 | Year | 2006 | 2007 | 2008 | ||||||||
4 | Dept | M1 | M2 | M3 | M1 | M2 | M3 | M1 | M2 | M3 | ||
5 | Staff | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | ||
6 | Dependents | 380 | 380 | 380 | 380 | 380 | 380 | 380 | 380 | 380 | ||
7 | * | * | * | * | * | * | * | * | * | * | ||
8 | * | * | * | * | * | * | * | * | * | * | ||
9 | After Inserting Table | * | * | * | * | * | * | * | * | * | ||
10 | * | * | * | * | * | * | * | * | * | * | ||
11 | Year | 2006 | Column1 | Column2 | 2007 | Column3 | Column4 | 2008 | Column5 | Column6 | ||
12 | Dept | M1 | M2 | M3 | M1 | M2 | M3 | M1 | M2 | M3 | ||
13 | Staff | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | ||
14 | Dependents | 380 | 380 | 380 | 380 | 380 | 380 | 380 | 380 | 380 | ||
Sheet3 |
Appreciate assistance. Thanks.