1) In Word, Do a Find->Replace to change all the line breaks to $$$$

• Find: ^p
• Replace with: $$$$
• Click ‘Replace All’

2) Select your table and copy it to Excel

3) In Excel, do a Find-Replace to change all the $$$$ back to line breaks

• Find: $$$$
• Replace with: (control-j)
• Click ‘Replace All’

Save the Word Perfect or .wpd document and save to your desktop.

Open Word.

Open the document with the .wpd extension located on your desktop.

The converter will run and you Save document as a Word document.

There maybe formatting that needs to be updated. 

First select the entire document by clicking Control A.

Then click Control/Shift/F9 and it will remove all links.

Save the document.

Open up your label form.
On the Home Ribbon under Paragraph click Center.
Ctrl A to select all the cells.
In the top left cell right click in the blue.
Click Center.
Save this as a template named label number form - for example 5660form.doc.

Word 2007 and Word 2010

1. Start Word, and then open a new blank document.
2. Go to Word Options
   • In Word 2007, click the Office Button, and then click Word Options.
   • In Word 2010, click File, and then click Options.
3. On the Advanced tab, go to the General section.
4. Click to select the Confirm file format conversion on open check box, and then click OK.
5. On the Mailings tab, click Start Mail Merge, and then select Step By Step Mail Merge Wizard.
6. In the Mail Merge task pane, select the type of document that you want to work on, and then click Next.
7. Under Select starting document, select the starting document that you want to use, and then click Next.
8. Under Select recipients, click Use an existing list, and then click Browse.
9. In the Select Data Source dialog box, locate the folder that contains the Excel workbook that you want to use as your data source, select the workbook, and then click Open.
10. In the Confirm Data Source dialog box, click to select the Show all check box. Click MS Excel Worksheets via DDE (*.xls), and then click OK.
11. In the Microsoft Excel dialog box, under Named or cell range, select the cell range or worksheet that contains the data that you want to use, and then click OK.
    NOTE: Your data now appears in the Mail Merge Recipients dialog box with the same formatting that appears in the Excel worksheet.

View the screen shot that shows how to go to  HOME > Change Styles > Select Word 2003, then single spacing is restored, even for envelopes, within the Mailings feature.

Select the worksheet(s) you want to print.

On the Page Layout tab, in the Sheet Options group, select the Print check box under Gridlines.

This prints the faint gridlines and not the bold table lines.

To Create an envelope:

From the Ribbon, select the Mailings tab.
In the Create section, select the Envelopes button.
Under the Envelopes tab, enter the information for the Delivery address.
Enter the information for the Return adress if necessary.
Click Print to print your envelope.

Print will send your envelope to your default printer.
If you have a laser jet the bypass tray will have a diagram of how to place your envelope.
If you have a BizHub the envelope is loaded in the bypass tray with the side to be printed on facing down and the top towards you.

Applies To: Faculty, Staff

Yes you can print both in the same document.

Under the Page Layout Ribbon you have the Orientation and Breaks options.

When you get to where you want the next Orientation you click on Breaks and Select Next Page and then change the Orientation.

You can do this throughout the document.

Log into Atomic Learning and under Excel 2010 click on Section G Workbook Views and Page Setup.

In Pages, Click File, Export, and choose Word for the file format.

NOTE:  Students must export to Word format in order for many of their professors to be able to open their documents.

Mail merges can be done in Word.  If you need assistance please contact the Information Desk at X 4357 or enter a ticket in WebHelpDesk.  See Related Resources if using Word 2010.

Save your Excel chart as a .pdf file.  Then it will hold onto the printing when sent to the BizHub.

Applies To: Students

Office 2010 applications
    Click the File tab, and then click Option.
    Click Add-Ins on the left side of the dialog box.
    Do one of the following:
        If PDFMOutlook or Acrobat PDFMaker Office COM Add-in is not listed, choose COM Add-Ins from the Manage pop-up menu and click Go.
        If PDFMOutlook or Acrobat PDFMaker Office COM Add-in is listed under Disabled Application Add-ins, select Disabled Items from the Manage pop-up menu and click Go.

    Select PDFMOutlook or Acrobat PDFMaker Office COM Add-in and click OK.
    Restart the Office application.

• First check out your page in Ingeniux
• Click Edit
• Right click in a Cell adjacent to where you want the addition and then drop down to either column or row
• Your options are to add before or after where your cursor is located
• If you don't like where you have placed your cell just right click in the emptey cell and delete the row or column
  

1. Open the Word Document.

2. Click on File in the upper Left hand corner.

3. Click on Save As

4. Choose PDF from the Save as type drop down.

5. Name the file and click save.

The PDF will be created in the same folder as the original word document.

Atomic Learning is the licensed provider for online tutorials at W&L. Tutorial topics include: Excel 2010 and 2011, Word 2010 and 2011, Windows 8, iMovie, SharePoint 2010, the Adobe Creative Suite including InDesign, Acrobat and Photoshop and many more.

Go to http://go.wlu.edu/LEARN and sign in with your network username and password to access all tutorials.

This resource is open to all current students, staff and faculty.

Applies To: Faculty, Staff, Students

In the Sakai site:

1. Go to Gradebook

2. All grades (it's in the light gray bar near the top of the screen)

3. Export Gradebook (a button to the right of the screen)

Applies To: Faculty

Students: If you are using Apple's "Pages" to create your documents,

you need to save as a Word document before you turn in your work.

Here's how:

1. In Pages, go to File > Save as

2. Click the down arrow by the Save As box.

3. Check the box, "Save Copy as: Word Document"

You can also go to: http://www.wlu.edu/x49936.xml and download

Office 2008 for the Macintosh. (W&L has a site license for Microsoft

Office for all university computers and for all student computers so

that everyone has access to a common software set.)

Applies To: Students

Create a distribution list by copying names from an Excel chart or received e-mail message.   
  
1.If using Excel copy the column.
2.In the message that you want to copy the names from, select the names in the To or Cc box. 
3.Right-click your selection, and then click Copy on the shortcut menu.
4.In Contacts on the Home ribbon New - Click New Contact Group and Name it.
5.On the Contact Group ribbon Members - Click Add Members and select from Outlook Contacts.
6.At the bottom of the Select Members dialog box, in the Members box, right-click and then click Paste on the shortcut menu. 

Note   A member does not need to be in your Address Book in order to be added to the distribution list. The member's name and e-mail address will be included when you copy and paste from the original e-mail message.

7.Click OK.
8.Click Save & Close.

Open Word 2010, click on Mailings tab on the Ribbon:

1.Click on Envelopes
2.Click on Options
3.Under Delivery Address, click on Font
4.Choose desired Font, i.e. Calibri, Regular, Size 12
5.Click on Set As Default and select Yes (Do you want to change the default envelope address font to Calibri, 12pt?)

Then, click on Font under Return Address
Repeat steps 3 to 5.
click on OK, then click on Close.
Save the document.

If the default goes back to +Headings.
Show hidden files then edit the Normal.dot template in
Documents and Settings\user\Application Data\Microsoft\Templates\normal.dot and save. 



 

From SQL Management Studio:

1. Tools
2. Options
3. Designers
4. Un-Check “Prevent saving changes that require table re-creation”