Tech

Guides
 

Convert Word 2007 documents to PDF format

By Mary Ann Richardson, Special to ZDNet Asia
Thursday, February 28, 2008 11:30 AM

Converting your documents, spreadsheets and PowerPoint presentations to PDF is easy with Office 2007.


Microsoft Word


Convert Word 2007 documents to PDF format

Office 2007 lets you convert your documents, spreadsheets and PowerPoint presentations to PDF--optimized for online documents, printed documents, or both. Before you can convert your document to PDF format, you need to download and install the support for PDF and XPS from the Microsoft Web site. (Be sure you have an active Internet connection so you can download the support for PDF and XPS.) Now follow these steps:

  1. In Word 2007, go to Word 2007 Help, type PDF in the Search box, and then press [Enter].
  2. Scroll to and click Enable Support For Other File Formats, Such As PDF And XPS.
  3. Under "What Do You Want To Do?" click Install And Use The Publish As PDF Or XPS Add-In From Microsoft.
  4. When the Web page displays, click Microsoft Save A PDF Or XPS Add-In For 2007 Microsoft Office Programs.
  5. Follow the instructions to download the add-in.

To save a Word 2007 document as a PDF file, open the document and follow these steps:

  1. Click the Microsoft Office button, move to Save As, and click PDF Or XPS.
  2. Click the Options button to set Bookmarks, designate whether you want to save a part of the document or the entire document, and/or exclude document elements from the file. Click OK.
  3. Click the appropriate button for Standard or Minimize optimization.
  4. Click Publish.

You can follow these same steps to convert your spreadsheets and PowerPoint files to PDF.



Microsoft Excel


Use Excel 2007's built-in RANDBETWEEN function

Excel 2007 includes the RANDBETWEEN function, which allows you to quickly add sample data to your worksheets. (In previous versions of Excel, this function was available only after you installed the Analysis Tool Pack add-in.)

For example, say your worksheet contains a list of 14 customers in Column A and their corresponding purchases in Column B. Follow these steps to use the RANDBETWEEN function to add sample data to Column B:

  1. Click in Cell B2 and enter =RANDBETWEEN(0,100).
  2. Drag the fill handle at the bottom right corner to cell B15.

The sample data will remain in the worksheet until you close it. When you reopen the worksheet, Excel will recalculate the function and display new sample data. To prevent Excel from recalculating the values, follow these steps:

  1. Select B3:B15.
  2. Press [Ctrl]C.
  3. Click on the Home tab.
  4. Click Copy in the Clipboard group.
  5. Click Paste.
  6. Click Paste Values.
  7. Press [Esc].


Microsoft Access


Easily print multiple copies of an Access report

You often need to print five copies of an Access report for meetings. To save time, you can create a command button that will print the copies for you. Follow these steps:

  1. Open a new form in Design view.
  2. Click the Command Button tool in the Toolbox.
  3. Click and drag in the form where you want the tool.
  4. Click Cancel to close the Command Button wizard if necessary.
  5. Right-click the command button and select Properties.
  6. Click in the Caption property box under the All tab and enter Print Employee Report.
  7. Click the Event tab and click the On-Click property box.
  8. Select [Event Procedure] from the drop-down list.
  9. Click the Build button.
  10. Enter the following code at the prompt:
DoCmd.SelectObject acReport, "Employees", True 

DoCmd.Printout ,,,,5
  1. Press [Alt]Q.

Now when you need to print out five copies, simply click the Print Employee Report command button in your form.



WORTHWHILE?

0

0 votes
Blog

Talkback 0 comments

There are currently no comments for this post.

Guest user

Guest user

Level: 
Joined: —
Already a member? Log in »



 

Loading...

Whitepapers / Case Studies

Downloads

Microsoft Office Suite News


Tech Jobs Now!

Tags

  1. access
  2. active
  3. attributes
  4. availability
  5. by
  6. directory
  7. disable
  8. documents
  9. double-take
  10. easy
  11. excel
  12. function
  13. high
  14. mailbox
  15. openssh
  16. program
  17. project
  18. remote
  19. remove
  20. security
  21. server
  22. services
  23. should
  24. sql
  25. these
  26. time
  27. use
  28. using
  29. win
  30. word