Pretorius

Hi,

I keep a film database in Excel, and the way I have it formatted right now is that I have the original language title in size 10 black font and all alternate titles following it (in the same cell) in size 8 grey font, each alternate seperated by backslashes. This looks messy, and I'm wondering if there's some way to rig it so that only the original language title appears in the cell, and that when the cell is selected it expands downwards showing all the alternate titles listed underneath. Is that possible? I know very little about Excel.

Thanks.

Hellbreather

Do you mean like a drop down box?

__________________
There are 10 types of people in the world, those who understand binary code, and those who don't
Windows XP Pro Setup
Intel Pentium 4 Processor - 3.2Ghz With HT Technology, 1024MB DDR RAM, 200GB SATA HDD, 40GB SATA HDD, Sound Blaster Live! 24 BIT!, Radeon 9800 PRO 256MB, Gigabit Ethernet Card

Pretorius

Yeah, I think so. Can that be done in Excel?

sm100378

Are you referring to filter-----auto filter?

__________________
AMD Athlon 64 3200+ Venice 2000MHz
CORSAIR ValueSelect 1GB (2 x 512MB)
MSI NX7600GS-T2D256E GeForce 7600GS
Foxconn NF4SK8AA-8KRS 939 NVIDIA nForce4 SLI
COOLER MASTER Centurion 5 CAC-T05-UW Aluminum
BenQ FP91G+ 19"LCD Monitor
NEC 16x DVD +/- DVD Burner
SONY DVD-ROM 48x/16x
SEAGATE Barracuda 7200rpm 250g HD
ANTEC TruePower II 430w Dual ATX12v Power Supply

Pretorius

I don't know. I actually don't want a drop-down box. You know when you highlight a cell that has text running beyond its borders, and the cell expands to show it? I want that to happen downwards to show the hidden list of alterate titles.

Pretorius

Actually, I have another question. If I want to rate the films out of ten, how can I stop Excel automatically turning "8/10" into "08-Oct"?

Pretorius

Any ideas?

Marzeth

For the 8/10...
Go to the cell's format properties and on the number Tab select Text.
You can also go to Custom and create your own which is very simple and would be like this: 00"/"00

In regards to the "drop-down" cell, I think you want a "sub-data switch" (which I don't know how to technically call). I've done this with numerical values but never text. Now, if you can give all your same-movie texts a similar numerical value on a hidden cell, you could be able to pull this off.

__________________
--Laptop--
Intel Core 2 Duo @ 2.0GHz + 2GB RAM
128MB nVidia GeForceGo 7300
80GB HDD
--Console--
Sony - Playstation 3[/size]

Pretorius

Thank you.

[quoteIn regards to the "drop-down" cell, I think you want a "sub-data switch" (which I don't know how to technically call). I've done this with numerical values but never text. Now, if you can give all your same-movie texts a similar numerical value on a hidden cell, you could be able to pull this off.[/quote]
Sorry, but I have no idea what you mean by "numerical value" or "hidden cell". I really know nothing about how Excel works.