Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel: Joining boxes using "Drawing"

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel: Joining boxes using "Drawing"

Resolved · Low Priority · Version 2007

Reply Tue 18 Oct 2011, 12:18 Edited on Tue 18 Oct 2011, 12:21Delegate Barry said...

Barry has attended:
No courses

Excel: Joining boxes using "Drawing"

Excel: Joining boxes using "Drawing"

Hi to all that read this as I have only joined today. My very first question on this site is on MS Excel 2003. You can join 2 normal rectangular boxes on a worksheet by using the Drawing lines. I am doing MOS (Excel) & 1 of the questions is to join 2 boxes on a worksheet, how do you join them as I can't find the Drawing (line) option like 2003 has?

Thanks

Baz

For upcoming training course dates see: Pricing & availability

Reply Tue 18 Oct 2011, 12:39Trainer Paul said...

RE: Excel: Joining boxes using "Drawing"

Hi

No quite I know what you mean but if you mean you are trying to join two boxes that have been inserted using SHAPES then you can use the arrows or connectors on from the DRAWING TOOLBAR. To access this toolbar on your file menu select VIEW, then TOOLBARS, the DRAWING.

Hope that helps.

Thanks
Paul

Reply Tue 18 Oct 2011, 13:01Delegate Barry said...

RE: Excel: Joining boxes using "Drawing"

Thanks Paul I will try it this evening as my work has 2003 whereas I have 2007 at home.

TVM

Baz

Reply Tue 18 Oct 2011, 14:12Trainer Paul said...

RE: Excel: Joining boxes using "Drawing"

That solution was for 2003. For 2007 you need to click the INSERT tab on your ribbon and then select SHAPES, there you will see the lines I think your after.

The only other thing you could mean is to merge to cells? If thats the case then select the MERGE button on your ribbon which is found on the HOME tab.

Thanks
Paul

Reply Tue 18 Oct 2011, 14:22 Edited on Tue 18 Oct 2011, 14:30Delegate Barry said...

RE: Excel: Joining boxes using "Drawing"

Paul it's not the merge at all it is the joining of for want of a better word rectangular boxes & I will try your suggestions above as soon as I can.

Thanks

Baz

Excel articles

· Trust Excel To Protect Your Data
· What Do The Formula Error Messages Mean In Excel?
· Which Is Better, Excel Or Access?
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· What Is A Sparkline And How Do They Work?

Please browse our web site to find out more about
microsoft excel training and other Microsoft training courses.

Excel tip:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips