I just reinstalled windows (XP) and Office 2003, SP3.
When entering text in a column and if it was larger than the current column, it used to just display into the next column unless there was data in that column. I liked it that way.
Now, it just displays a few letter from the end of the first word. How can I change this back as default?
Last edited by Annelie; 04-19-2009 at 09:06 AM.
Annelie
Look in the format of the cell, see if Word Wrap is enabled. If so, uncheck it.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Yes, I finally realized that each one had word wrap marked. This data was exported from access using tools, office links, analyze data in excel.
I wonder if there is a way to change the default in which the data comes over.
Annelie
Sounds like a question for the Access forum.
Meanwhile, if that takes care of this question, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Re: text longer than a column
I guess I should put a second "resoved" here, because I was trying to figure out how to mark a post as solved.
Thanks,
Annelie
Annelie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks