Ask Experts Questions for FREE Help !
Ask
    Whiskey14's Avatar
    Whiskey14 Posts: 219, Reputation: 16
    Full Member
    		  
    #1

    Mar 13, 2007, 06:36 PM
    Wrap Text in Excel 2003
    Am setting up a table for my DVD collection, so far, so good. Under the Notes column where I put in information regarding the movie, I've been going to Format, Cells, Alignment and clicking Wrap Text to get how I want it. Is there a way where the text would wrap without me doing that for every movie?

    TIA
    hadi88's Avatar
    hadi88 Posts: 59, Reputation: 5
    Junior Member
    		  
    #2

    Mar 15, 2007, 08:17 AM
    How about selecting the colums or rows first and apply the wrap text to all of them, so when u type, it will wrap the text itself where it is needed.

    hadi88
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Mar 15, 2007, 08:21 AM
    To expand on what hadi said, just click the header of the Notes column, then format it for Word wrap.
    Whiskey14's Avatar
    Whiskey14 Posts: 219, Reputation: 16
    Full Member
    		  
    #4

    Mar 19, 2007, 11:39 AM
    I've tried that, it worked for the first few entries, then I had to go to Format, Cells, Alignment, Wrap Text. For some reason, Excel isn't remembering the setting for Wrap Text. Any other suggestion?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #5

    Mar 19, 2007, 04:57 PM
    If you highlight the whole column it should remember it.
    Whiskey14's Avatar
    Whiskey14 Posts: 219, Reputation: 16
    Full Member
    		  
    #6

    Mar 19, 2007, 06:42 PM
    Hi Scott,

    Did that before adding any information, then again when it forgot. Just added two more entries, again I had to do the "Format, Cells, Alignment, Wrap Text". Checked for spyware and viruses thinking perhaps that could be the problem, nothing found except for the usuall cookies. This is happening in Excel 2003 and 2007.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel 15 digit issue, tried converting to text, text to column feature negates fix [ 6 Answers ]

I have the following numbers that exceed 15 characters that needs to be split into its own columns. Down the road, there would be thousands of such rows of data with the first couple set of unique numbers. 890432453253208820,5004500558,05CC,1,0,0,0,0,0,0, 0000,5.0000,2007-01-11...

Disappearing Text Boxes in Excel Bar Chart [ 7 Answers ]

I have been working on this large horizontal bar chart. It has about 100 items to show as bars of different sizes, and requires 100 text boxes for comments. I HAVE A PROBLEM WITH TEXT BOXES BECAUSE THEY DISAPPEAR CONTINUALLY. If I click the area where a text box is, then it comes back. But I...

Excel 2003 issue [ 2 Answers ]

Hi I have a problem with the auto calculation feature in excel. It doesn't seem to be working. I have to use the super calculation feature, crtl+F9 or F9 in order for the calculation to work. Do you know why this is? I'm running excel 2003 (Office 2003 SP1) and the file was saved in excel XP....

Display text vertically and not horizontally in 1 cell (Excel) [ 2 Answers ]

How would you display a line of text to show vertically after each text in one cell? For example: Total Activity Cost And not Total Activity Cost (in one cell)? Thank you in advance.

Microsoft Excel 2003 Worksheet Problem [ 1 Answers ]

Hi: Would you please help me solve the problem I am having! This is the problem: I have installed MS Office 2003 on my two home computers. Everything is OK on one computer, but MS Excel 2003 is a problem on another computer. When I open a new workbook, I always get a blank worksheet that has...

View more questions Search