corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Excel - Unlimited cell depth?


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Excel - Unlimited cell depth?
Kyle T
Premium Member

Avatar

Registered: 11th Sep 04
Location: Selby, North Yorkshire
User status: Offline
26th Sep 05 at 18:44   View Garage View User's Profile U2U Member Reply With Quote
Is there a way to make a cells depth unlimited so that people can keep adding data without manually resizing the cell?

If I get an answer by tomorrow, brownie points off the boss

Cheers

Lotus Elise 111R

Impreza WRX STi
CCA
Member
Registered: 6th Dec 04
Location: Somewhere Drives: Not a bloody Vauxhall!
User status: Offline
26th Sep 05 at 18:54   View User's Profile U2U Member Reply With Quote
Is there not an Adobe document that can tell you?
Corsa E-Tec
Member
Registered: 4th Feb 04
Location: Stevenage Drives: Leon Cupra
User status: Offline
26th Sep 05 at 18:56   View User's Profile U2U Member Reply With Quote
text wrap
Kyle T
Premium Member

Avatar

Registered: 11th Sep 04
Location: Selby, North Yorkshire
User status: Offline
26th Sep 05 at 19:04   View Garage View User's Profile U2U Member Reply With Quote
Let me just find a machine with XL installed, I never use Excel, boss just came up to me and said "Heres one for you Kyle, how do you bla bla bla", I ummm'd a bit and then he said "sleep on it, tell me tomorrow"

Ill have a gander in a minute

Lotus Elise 111R

Impreza WRX STi
Corsa E-Tec
Member
Registered: 4th Feb 04
Location: Stevenage Drives: Leon Cupra
User status: Offline
26th Sep 05 at 19:05   View User's Profile U2U Member Reply With Quote
right mouse click on cell, properties and text wrap.
CCA
Member
Registered: 6th Dec 04
Location: Somewhere Drives: Not a bloody Vauxhall!
User status: Offline
26th Sep 05 at 19:08   View User's Profile U2U Member Reply With Quote
wrap text is to make the width of the cell match the word without changing the whole columm
Kyle T
Premium Member

Avatar

Registered: 11th Sep 04
Location: Selby, North Yorkshire
User status: Offline
26th Sep 05 at 19:11   View Garage View User's Profile U2U Member Reply With Quote
quote:
Originally posted by CCA
wrap text is to make the width of the cell match the word without changing the whole columm


ah, that would be no good then...

Keep trying folks

Lotus Elise 111R

Impreza WRX STi
CCA
Member
Registered: 6th Dec 04
Location: Somewhere Drives: Not a bloody Vauxhall!
User status: Offline
26th Sep 05 at 19:17   View User's Profile U2U Member Reply With Quote
I think the only thing you can really do is make an entry not change with the size of the cell. other than that i dont know of anything to be able to automatically change the depth.
Ally
Member
Registered: 2nd Jul 03
Location: Pontypool Drives: a Skoda
User status: Offline
26th Sep 05 at 19:34   View User's Profile U2U Member Reply With Quote
Why not merge the entire column then turn on shrink and text wrap?
Kyle T
Premium Member

Avatar

Registered: 11th Sep 04
Location: Selby, North Yorkshire
User status: Offline
26th Sep 05 at 19:36   View Garage View User's Profile U2U Member Reply With Quote
Well basically the excel sheet is a draft for a TV guide entry, with the channels in columns, time in rows.

The draft will be emailed forward to the editing team who will edit the stuff at last minute if need be, then send it to the final stage where someone enters the info into quark or some shit like that.

Dno if that makes sense, but it means that the columns cant be merged.

Lotus Elise 111R

Impreza WRX STi
Ally
Member
Registered: 2nd Jul 03
Location: Pontypool Drives: a Skoda
User status: Offline
26th Sep 05 at 19:39   View User's Profile U2U Member Reply With Quote
Ok then, turn on wrap text, then go to the top bar and click format > row then select autofit
Kyle T
Premium Member

Avatar

Registered: 11th Sep 04
Location: Selby, North Yorkshire
User status: Offline
26th Sep 05 at 19:51   View Garage View User's Profile U2U Member Reply With Quote
Hey, cheers ally - works a treat.

Saves me pratting around on excel all night and disrupting my hard work

Cheers

Lotus Elise 111R

Impreza WRX STi
Richie
Member
Registered: 3rd Dec 02
Location: Newport, Wales
User status: Offline
26th Sep 05 at 19:52   View User's Profile U2U Member Reply With Quote
it was my fix she keeps logging into my PC on her name
Kyle T
Premium Member

Avatar

Registered: 11th Sep 04
Location: Selby, North Yorkshire
User status: Offline
26th Sep 05 at 19:56   View Garage View User's Profile U2U Member Reply With Quote
Cheers anyhow.

Should please the boss for another day or two if im lucky.

Lotus Elise 111R

Impreza WRX STi
Ally
Member
Registered: 2nd Jul 03
Location: Pontypool Drives: a Skoda
User status: Offline
27th Sep 05 at 08:09   View User's Profile U2U Member Reply With Quote
quote:
Originally posted by Richie
it was my fix she keeps logging into my PC on her name


Don't lie, you know all of your ICE and computer knowledge comes from me

 
New Topic
New Poll

Corsa Sport » Message Board » Off Day » Excel - Unlimited cell depth? 24 database queries in 0.0203090 seconds