Group lines with bracket

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I want to have the bracket } over three lines and point to
a cell, i.e. the three lines relate to that cell. Such
that data in a1,a2,a3 are shown with a single symbol in b1-
b3 that has a large bracket showing that they relate to
Summary in c2.

Thanks
 
Couple of ideas:

1) Put a } in a cell (you may want it bold). Hold the shift key down
and choose Edit/Copy as Picture. Paste the picture, then
format/resize it to be 3 lines high, cropping most of the right
side. Set the picture to move and size with cells in the
Format/properties tab).

2) I get somewhat better results by inserting an equation object
(Insert/Object/Microsoft Equation) that consists of a single right
bracket. Format it as above.
 
Another option that uses Mergedcells (yech!):

Select B1:B3 and format|Cells|Alignment tab|check merged cells.

Then type in the curly bracket and adjust the font size.

(adjust the vertical alignment on the same dialog.)

Be aware that mergedcells can cause some problems depending on what you do those
cells.
 
Back
Top