hey experts, here is the problem:
I have a bunch of data mapped out in excel. Prior to creating a table, I have a bunch of data, one column is normal, the other column is spread across 8 cells and all of the cells are merged. So this second cell is spread across the whole page.
I NEED to make this thing into a table. When I go to Format as table, it turns my second column (made of merged cells) into 8 columns.
If I delete the unnecessary ones, then the column in the table is now really tiny, and I can't expand it without expanding the column for the entire spreadsheet.
How can I merge columns IN A TABLE? (note: Excel 2007)
-Jeff
Try to save your file as xls not xlsx and see the result,
if it still doesn't work then try to wrap the text in one cell instead of merge 8 cells.
good luck
Wellous