Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Nevermind, I figured it out.

In case anyone else has a similar desire and wants to know... I simply select all the rows I want to belong to a group, add a border around it all, and insert a row above the box I just made. The inserted box contains the label I want; I make sure to turn off word wrapping for that one cell.

On 7/20/2012 12:57 PM, Andrew Brager wrote:
Using Calc, I need a way to specify that a group of rows all belong together/have the same title.

For example. Say I have a bank that has multiple branches. Each branch has it's own name like "southwest branch", but they're all part of the same bank - Bank of America perhaps. Each branch has it's own row containing branch name, address, phone, etc. but I need a way to tie them all together as being Bank of America, ideally without creating a column that is repeated for all rows.

That way, as I'm scanning down the page, I can choose a particular bank and then select a specific branch of that bank.

I've tried using the Group function which I kind of like, however there's no way I can find to label the group itself with the bank name. I have to open each group and _still _don't necessarily know which bank it is.

I've got a picture in my head that looks like a box which contains all the rows, and the box itself has a caption with the bank name. I'm open to any solution especially a better one.

Using a database is not an option.

Thank you in advance

Andrew Brager
Green Gold Real Estate
1331 Cottonwood Rd
Bakersfield, CA 93307
661 412 3304

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:

