I have a column named "Product". Beneath it I would like the product
column split into two columns, one named "Qty" and one named "Amount".
Hope this helps!
The word "Product" should be in a cell by itself. "Qty" and "Amount"
should each be in their own columns in the next row (with a line to
separate each column) directly beneath the word "Product".
If "Product" is in cell A1, and your product lists start in cells A1 and
B2, the suggestion above should work. Hilite cells A1 and B1, and click
the Merge & Center button (or do it through the cell formatting menus).
"Products" will be perfectly centered above the A and B columns.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
