word documents open with several columns

To sort data in an MSWorks spreadsheet, click Tools> Sort. Now mouse-select all the names and click Data> Sort, whereupon a dialog box will offer various sorting options. Type your name into Cell A1 along with several random names below it in the ' A' column. One of a spreadsheet's most useful functions is its ability to sort data alphabetically and/or numerically. Double-click on the Excel file to import it into the Calc spreadsheet, where it can subsequently be saved as a Calc or Excel file (or a file compatible with several other listed programs). Next create a blank spreadsheet in OpenOffice Calc and click File> Open, whereupon all the Document folder's files will be listed. (You can transfer the file via email or a portable external drive.) Now copy this newly-converted Excel file to the new PC and store it in the Documents folder.

Open the MSWorks spreadsheet, click on File> Save As, and choose Excel ( *.xls) in the 'Save As Type:' field. However, Peggy's MSWorks spreadsheet can be easily converted to an Excel file. (LibreOffice is free from Well, Calc can read Excel and Quattro Pro spreadsheets, but not MSWorks files. Peggy Merchant asked how to move an MSWorks spreadsheet from an older PC into a LibreOffice Calc spreadsheet on her new PC. Notice how the address in Row 4 wrapped to a second line in the illustration below.Ĭopying a Spreadsheet from one PC to Another A cell's data will then 'wrap' onto another line if it doesn't fit on one line. Highlight a cell, row, column, or the entire worksheet then click Format> Cells> Alignment. Well, a second row isn't necessary because data within any row can be 'wordwrapped' into multiple lines.

To remove columns, select the text and chose one column from the Columns drop-down list.Claudia Donovan wrote that an address book she created with Excel is very wide and asked if she could split information into two rows and then be able to sort by 'every other row.' In Word 2007, select the text and click Columns in the Page Setup group on the Page Layout tab. Highlight the appropriate number of columns (watch the bottom text update as you select columns to keep up with how many columns you’re creating) and then click. Doing so displays a palette-type drop-down list of columns. In version 2003 and earlier, select the text you want to display in column format and click the Columns tool on the Standard toolbar. The good news is that they’re easy to implement and you don’t have to apply the column format to your entire document you can columnize any text with just two clicks. Here are the steps for 'columnizing' your document text in older versions of Word and in Word 2007.Ĭolumns, or specifically, newspaper-style columns, are common in newsletters and reports. How to create columns in the middle of a Word documentįormatting a Word document with multiple newspaper-style columns can improve the layout and make the text easier to read.

Word documents open with several columns