Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2004

Tip: Looking for answers? Try searching our database.

Column Width

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Kitchens - 21 Oct 2004 16:39 GMT
I am using Excel 2000.  I need to increase Column G from 67 pixels to to
212.

My problem is that I need to be able to do this just for Row 3.

Is there a way that I can Stretch G3 from 67 pixels to 212 pixels without
stretching the entire worksheet?

I am using data validation in cell G3 and the dropdown box is not long
enough.

Can anyone please help?

Sincerely,

John Kitchens
CarlosAntenna - 21 Oct 2004 16:44 GMT
You could try merging G3 with G4, G5 ... until it's wide enough.  But be
aware that merging cells often causes other limitations.

> I am using Excel 2000.  I need to increase Column G from 67 pixels to to
> 212.
[quoted text clipped - 12 lines]
>
> John Kitchens
CarlosAntenna - 21 Oct 2004 16:46 GMT
I meant to say "merge G3 with H3, I3 ... "

> I am using Excel 2000.  I need to increase Column G from 67 pixels to to
> 212.
[quoted text clipped - 12 lines]
>
> John Kitchens
John Kitchens - 21 Oct 2004 18:39 GMT
Sorry, But I don't know how to merge.

Can you please tell me what to do?

Sincerely,
John Kitchens

> I meant to say "merge G3 with H3, I3 ... "
>
[quoted text clipped - 14 lines]
> >
> > John Kitchens
CarlosAntenna - 21 Oct 2004 19:18 GMT
Click in cell G3 and hold the button down, drag to the right, highlighting
as many cells as you want to merge, release the button then pull down the
format menu, choose "cells", alignment tab, check the box for "merge cells".

> Sorry, But I don't know how to merge.
>
[quoted text clipped - 22 lines]
> > >
> > > John Kitchens
John Kitchens - 21 Oct 2004 20:09 GMT
Thank you very much Carlos. That did exactly what I needed it to do!

Thank you once again.

Sincerely,
John Kitchens

> Click in cell G3 and hold the button down, drag to the right, highlighting
> as many cells as you want to merge, release the button then pull down the
[quoted text clipped - 27 lines]
> > > >
> > > > John Kitchens
CarlosAntenna - 21 Oct 2004 20:09 GMT
You're welcome.

> Thank you very much Carlos. That did exactly what I needed it to do!
>
[quoted text clipped - 37 lines]
> > > > >
> > > > > John Kitchens
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.