Ok, one of the most searched posts on this blog is Can you divide an Excel cell in half? In it, I explain that you can’t.

And you still can’t.

But if you are trying to have a cell half the size of the cells around it (or a quarter of the size, or whatever you like) you can simply merge and center all of the cells around the smaller cell. So if you wanted cells B1 and B2 to be half the size of A1 and C1, you would merge and center A1 with A2, and C1 with C2, leaving B1 and B2 seemingly half-sized cells.

The only other option is to place a text-box or image of some sort in the cell so it seems to divide it, but you lose functionality that way.

There is a way to divide the contents of an Excel cell, however.

Jared Hawk is a professional Excel Seminar Trainer and Consultant in Boise, Idaho. He is also a contributing author to www.masterthebusiness.com and to IdahoCLE.com.