MS Excel - Cell overlap

April 27, 2009 at 13:56:12
Specs: Windows XP
Is it possible to have a number overlap the adjacent cell like text does?

I want to do this so I can have daily subtotals in a separate column to to the data, but have it look like it is underneath. (ie in a column that is only 1 pixel wide). This way, I can get a monthly total of all subtotals without including the original data inputs into the sum.

See More: MS Excel - Cell overlap

Report •

April 27, 2009 at 16:43:39
I'm not totally clear on what you are trying to do, but have you looked into merging the cells?

Select 2 (or more) adjacent cells and click the "Merge and Center" button on the Formatting toolbar - the box with the little a and the arrows in it.

Report •

April 27, 2009 at 16:51:47
I have, and it does not solve the problem. All it does is screw up the sum.

Report •

April 27, 2009 at 17:00:58
No, wait. Yes it does.

I was adding the column on the right and merging the sub totals cells. Which wouldn't work.

By adding the column to the left of the data and merging the data cells and not the sub totals, I am able to do it.

Thank you.

Report •

Related Solutions

Ask Question