ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Expand curly bracket symbol over multicells (https://www.excelbanter.com/excel-discussion-misc-queries/61119-expand-curly-bracket-symbol-over-multicells.html)

Hal Plimpton

Expand curly bracket symbol over multicells
 

I recall some months ago being able to add a curly bracket symbol and
being able to span the symbol over multiple cells for purposes of
adding an inclusive notation. Have lost the instrux for doing this. Can
anyone help out?

Many thanks


--
Hal Plimpton


------------------------------------------------------------------------
Hal Plimpton's Profile: http://www.excelforum.com/member.php...fo&userid=5487
View this thread: http://www.excelforum.com/showthread...hreadid=494749


Chip Pearson

Expand curly bracket symbol over multicells
 
Go to the View menu and choose the Drawing toolbar. On that
toolbar, choose AutoShapes and then Basic Shapes. You'll find the
shape there. Click it then drag and draw on the worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Hal Plimpton"
wrote
in message
news:Hal.Plimpton.20b82m_1135033801.0822@excelforu m-nospam.com...

I recall some months ago being able to add a curly bracket
symbol and
being able to span the symbol over multiple cells for purposes
of
adding an inclusive notation. Have lost the instrux for doing
this. Can
anyone help out?

Many thanks


--
Hal Plimpton


------------------------------------------------------------------------
Hal Plimpton's Profile:
http://www.excelforum.com/member.php...fo&userid=5487
View this thread:
http://www.excelforum.com/showthread...hreadid=494749




Hal Plimpton

Expand curly bracket symbol over multicells
 

Bingo... works like a charm.

Many thanks Chip for your quick reply.

Seasons greetings to you.....Hal


--
Hal Plimpton


------------------------------------------------------------------------
Hal Plimpton's Profile: http://www.excelforum.com/member.php...fo&userid=5487
View this thread: http://www.excelforum.com/showthread...hreadid=494749


Gord Dibben

Expand curly bracket symbol over multicells
 
Hal

Termed "Array" formulas.

Check out Chip Pearson's site

http://www.cpearson.com/excel/array.htm


Gord Dibben Excel MVP

On Mon, 19 Dec 2005 17:06:47 -0600, Hal Plimpton
wrote:


I recall some months ago being able to add a curly bracket symbol and
being able to span the symbol over multiple cells for purposes of
adding an inclusive notation. Have lost the instrux for doing this. Can
anyone help out?

Many thanks


Gord Dibben

Expand curly bracket symbol over multicells
 
Hoo boy.

Did I ever miss this one<g


Gord

On Mon, 19 Dec 2005 16:49:46 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Hal

Termed "Array" formulas.

Check out Chip Pearson's site

http://www.cpearson.com/excel/array.htm


Gord Dibben Excel MVP

On Mon, 19 Dec 2005 17:06:47 -0600, Hal Plimpton
wrote:


I recall some months ago being able to add a curly bracket symbol and
being able to span the symbol over multiple cells for purposes of
adding an inclusive notation. Have lost the instrux for doing this. Can
anyone help out?

Many thanks



All times are GMT +1. The time now is 10:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com