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 / Word / Long Documents / October 2004

Tip: Looking for answers? Try searching our database.

Get document out of spreadsheet format

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brandi - 20 Oct 2004 16:52 GMT
I have a document in spreadsheet format, with cells and
what-not, and I need to get it into regular word format
so as to alphabetize it, but I can't do it.  I really
don't want to re-type it, but nothing works.  I've
already tried to hide the gridlines.  Help!
Jay Freedman - 20 Oct 2004 17:13 GMT
> I have a document in spreadsheet format, with cells and
> what-not, and I need to get it into regular word format
> so as to alphabetize it, but I can't do it.  I really
> don't want to re-type it, but nothing works.  I've
> already tried to hide the gridlines.  Help!

Hi Brandi,

Hiding gridlines has nothing to do with it -- the text is still in a table,
whether you can see the lines or not.

You can sort a table -- in fact, you have more options available if you do
sort a table than if you sorted the same material when it isn't in a table.
Just put the cursor in the table and select Tables > Sort. You can choose
which column to sort on and how you want it sorted.

If you really want the text to be not-in-a-table for other reasons, select
Table > Convert > Table To Text. You'll still be able to sort with Table >
Sort, but some of the options for choosing how to sort will be gone.

A bit of advice: Make a copy of the document before you sort. If you don't
like the results of the sort and you want to start over, it's more reliable
to take a new copy of the original than it is to use Undo.

Signature

Regards,
Jay Freedman
Microsoft Word MVP          FAQ: http://word.mvps.org

- 20 Oct 2004 17:53 GMT
Thank you very much, you just saved me a lot of work!  :)
>-----Original Message-----
>> I have a document in spreadsheet format, with cells and
[quoted text clipped - 20 lines]
>like the results of the sort and you want to start over, it's more reliable
>to take a new copy of the original than it is to use Undo.
 
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.