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 2007

Tip: Looking for answers? Try searching our database.

splitting cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joanne - 08 Oct 2007 14:54 GMT
In excel 2003 is it possible to split a cell into 3 or 4 cells in one
particular row without it affecting the col setup in the rest of the
worksheet?
Joanne
Gord Dibben - 09 Oct 2007 03:28 GMT
No.

What effect would you like achieve.

There may another method like Center Across Selection.

Gord Dibben  MS Excel MVP

>In excel 2003 is it possible to split a cell into 3 or 4 cells in one
>particular row without it affecting the col setup in the rest of the
>worksheet?
>Joanne
Joanne - 08 Oct 2007 16:05 GMT
I want to put:
Vendor Name     Cust Name    Cust Phone    Cust Fax all on one row
For the sake of consistency throughout a large workbook, I wanted to use
cells to keep everything lined up equally.
Thought about using text boxes, and maybe even coding in the Workbook
Name = Vendor Name, Worksheet Name = Customer name - then I would only
have to add the phone and fax on each worksheet. But since the workbook
is already so large, I figured adding textbox controls and coding to
each worksheet to do something that can be done once and will never
change was going to bulk up the workbook and slow things up
un-necessarily.

> No.:
>
[quoted text clipped - 8 lines]
> >worksheet?
> >Joanne
Gord Dibben - 09 Oct 2007 05:03 GMT
It's late so maybe that's why I don't see a problem.

What is preventing you from entering Vendor Name  Cust Name  Cust Phone  Cust
Fax  in A1:D1?

It can't be that easy so what else have I missed or you have left out?

Maybe you need VLOOKUP formulas on each sheet?

Gord

>I want to put:
>Vendor Name     Cust Name    Cust Phone    Cust Fax all on one row
[quoted text clipped - 20 lines]
>> >worksheet?
>> >Joanne

Rate this thread:






 
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.