MrExcel Message Board

Go Back   MrExcel Message Board > Question Forums > Excel Questions

Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only.

Reply
 
Thread Tools Display Modes
Old Apr 14th, 2002, 09:33 PM   #1
chookers
Board Regular
 
Join Date: Mar 2002
Posts: 115
Default

Ok how about this - is there any way to split a cell in the same way that you can with Tables in Word?? (am not referring to merge/unmerge cells, I literally want to split a cell and be able to write text in 2 halves of it.)Someone please design a program that is just for a big document full of text tables!!
chookers is offline   Reply With Quote
Old Apr 14th, 2002, 10:10 PM   #2
Phylis Sophical
New Member
 
Join Date: Jan 2002
Location: Canada
Posts: 42
Default

Pressing Ctrl + Enter will allow you to type on a second row within the same cell.
Phylis Sophical is offline   Reply With Quote
Old Apr 14th, 2002, 10:26 PM   #3
chookers
Board Regular
 
Join Date: Mar 2002
Posts: 115
Default

Thanks Phylis, what I actually want to do though is get an effect that is 2 columns within a cell. Let's say you have a rectangular cell, and you're putting a list in it. You run out of space going down, and you still have a whole half a cell left on the right you can use, only you can't, unless you put a text box there.

That's what I'm after, probably with no luck!
chookers is offline   Reply With Quote
Old Apr 14th, 2002, 11:52 PM   #4
Tom Urtis
MrExcel MVP
 
Tom Urtis's Avatar
 
Join Date: Feb 2002
Location: San Francisco, California USA
Posts: 10,387
Default

Based on your description, I'd agree..."probably with no luck". Why are you wanting to do this? Is it that 256 columns is not enough columns? What are you trying to accomplish?
__________________
Tom Urtis
Microsoft MVP - Excel
Tom Urtis is offline   Reply With Quote
Old Apr 15th, 2002, 12:53 AM   #5
chookers
Board Regular
 
Join Date: Mar 2002
Posts: 115
Default

Well actually 256 columns is damn fine, BUT in the document I've got there is a cell that's quite large, let us say for the sake of ease it's for a 'description'. It's about 5 inches long and 2 inches high. It goes at the end of each row containing an item. I know I could re format the whole document and MERGE all the other cells, leaving me millions of cells in my 5 x 2 box, am just trying to avoid doing that. Usually I can just type away a description, but in some cases I need to use the equivalent of a bulleted list which is too long, so I want it to sort of, you know, wrap over to the other half of the cell.

I think you are right, I am out of luck!!

Thanks anyway...
chookers is offline   Reply With Quote
Old Apr 15th, 2002, 12:45 PM   #6
Chris Davison
MrExcel MVP
 
Join Date: Feb 2002
Location: Millbank, London, UK
Posts: 1,790
Default

Chookers,

your rectangular cell.......

replicate its size on a spare sheet somewhere twice

in the first replicated cell, type and format your text as you'd desire to see it if your "split" were possible

in the second replicated cell, type and format your text as you'd desire to see it if your "split" were also possible

goto :

. view
. toolbars
. customise
. commands
. tools
. scroll right down to the end of all the options on the right
. click n drag the camera icon into your toolbar

now you are armed with a camera (say "cheese")

highlight your first replicated cell
. click the camera
. go back to your original sheet and click to position your new photo (just drag down and right a lot, it will resize it perfectly)
. right-click the photo
. format picture
. colours and lines
. fill : colour = no fill
. line : colour = no colour

now go back to your second replicated cell

. click the camera
. go back to your original sheet and click to position your new photo (just drag down and right a lot, it will resize it perfectly)
. right-click the photo
. format picture
. colours and lines
. fill : colour = no fill
. line : colour = no colour

Your second image will now sit on top of the first, both being see-through and giving the appearance of a single cell.

Experiment a bit to get the desired effects.

Note though : the images are real-time : if you change the contents of the scource cells, the images UPDATE themselves. This might be a hinderance, but in all the times I've used it, it's actually a mighty fine bonus


__________________
:: Pharma Z - Family drugstore ::
Chris Davison is offline   Reply With Quote
Old Apr 15th, 2002, 04:21 PM   #7
chookers
Board Regular
 
Join Date: Mar 2002
Posts: 115
Default

Wow, I'll try it. Never even knew about that one!

Cheers!
chookers is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT -4. The time now is 09:37 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
All contents Copyright 1998-2012 by MrExcel Consulting.
diabetic desserts recipes recipes Diabetic Soups Holiday Pizza Recipes Popcorn Recipes Recipes For Microwave Pasta Recipes Casserole Recipes Chili Recipes Curry Recipes Crockpot Recipes Apples Recipes Bread Recipes Vegetarian Recipes Vegetable recipes Desserts Recipes Appetizers Ethnic Recipes Meat Dishes Barbecue Recipes Sauces Recipes Marinade Recipes Low Fat Recipes Frugal Gourmet Kitchen Classics Recipes On The Grill Cook Books Seafood Recipes Cajun Recipes Breads Low Fat Low Fat Breads Bread Machine Recipes Yeast Breads Quick Breads Fat Free Vegetarian Salad Recipes Eggplant Recipes Radish Recipes Tomato Recipes Jalapeno Recipes Potato Recipes Lettuce Recipes Cabbage Recipes Beans Ambrosia Recipes Biscotti Recipes Desserts Low Fat Cookie Recipes Cheesecake Recipes Cake Recipes Pie Recipes Muffin Recipes Custard Recipes Best Appetizers Appetizers Low Fat Salsa Recipes Dip Recipes International Recipes Afghan Recipes Alaska Recipes French Recipes German Recipes Greek Recipes Italian Recipes Spanish Recipes Thai Recipes Korean Recipes Chinese Recipes Mexican Recipes Indian Recipes Beef Recipes Pork Pork & Ham Pork Butts Pork Chop Recipes Pork Ribs Rulled Pork Poultry Recipes Stews Recipes Ground Beef Barbecue Grill Barbecue Smoker All Purpose Sauce BBQ Sauce Barbecue Sauce Carolina BBQ Sauce Pickle Recipes Marinades Smoking Low Fat Appetizers & Dips Low Fat Breakfast Low Fat Cakes Low Fat Cheesecakes Low Fat Cookies Low Fat Desserts Low Fat Fish & Seafood Low Fat Meats Low Fat Pasta Low Fat Pies Low Fat Salads Low Fat Sandwiches Low Fat Sauces & Condiments Low Fat Sides Low Fat Soups Low Fat Vegetarian Baker's Dozen Taste of Home Recipe Book Bon Appetit Cookbook Blacktie Cookbook Buster Cook Book Cookbook USA Cook Book Cook Book Sara's Cookbook Sara's Cookbook Appetizers and Dips Poultry recipes Diabetic recipes Holiday recipes Miscellaneous recipes 110 recipes 1986 Usenet cookbook 2900 recipes Cyberrealm recipes Great sysops of world Specialty recipes Ceideburg recipes Cheese recipes Chili recipes Fruits recipes Garlic recipes Great chefs of NY Londontowne recipes Raisins recipes Recipes for kids US Food Vegetarian recipes Bread recipes Drinks Meat Dishes Brisket recipes Caribou recipes Chicken recipes Filet mignons recipes Pork recipes Swordfish recipes Turkey recipes Pasta recipes Uncategorized recipes Ethnic recipes Canada recipes English recipes Ethiopia recipes Germany recipes Greece recipes Mexican recipes Philippines recipes Welsh recipes Microwave recipes Soups recipes Vegetable recipes Asparagus recipes Barley recipes Brown rice recipes Lentil recipes Mushrooms recipes Salads recipes Wild rice Desserts recipes Cakes recipes Chocolate recipes Cookies recipes Ice cream recipes