Excel 2003, Vista

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

daffer

Thread Starter
Joined
Apr 12, 2008
Messages
7
I am writing a spreadsheet and I need to have at the end of two rows a single box with a function to add the aggregate results of the two rows. The box is square and made up of four cells. I can easily put the result in any of the four cells, but how do you get the result in the centre of the box.

Daffer
 
Joined
Apr 7, 2007
Messages
439
Select your four cells, right click, select Format cells, tick Merge cells, on Horizontal select "Center" (centre), on Vertical select "Center" and click OK.

The value will be centred in the centre of the four cells.

I'm pretty sure this is what your asking for, if not then please add a little more information on what exact you want to do.
 

daffer

Thread Starter
Joined
Apr 12, 2008
Messages
7
Thank you MRdNk

That works as you knew it would. To think I spent half a day messing about with text boxes etc.

Watch this space because I'm sure to get stuck again.

Daffer
 
Joined
Apr 7, 2007
Messages
439
OK

This button also merges the cells, although won't centre vertically for you, but can add vertical alignment buttons quite easily. ---->
 

Attachments

daffer

Thread Starter
Joined
Apr 12, 2008
Messages
7
MRdNk

I have never noticed that button before. I tried a sample page and found to centre the text, just click on centre in the alignment box of the format menu.

Thanks again

Daffer
 
Joined
Apr 7, 2007
Messages
439
You can vertical align buttons to the toolbar which is very useful if you use it a lot. That's the way I always setup Excel - work / home etc. - Very Useful.
 
Joined
Jul 25, 2004
Messages
5,458
Hello there, welcome to the board!

May I ask why? Merging cells can cause huge headaches down the road. They should be a last resort only. I can probably count on my hands how many times I've used merged cells in the last 4 years.
 
Joined
Apr 7, 2007
Messages
439
Zack's got a point, I generally don't bother with merged cells either, instead opt for centre across selection, as noted it causes issues.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top