Publish As PDF In Microsoft Office 2007, Save As PDF Add-In

Recently Microsoft Released a Save As PDF Or XPS Add-In/Plugin for Office 2007, for those who like to publish the office documents in PDF and XPS. You can download your copy of add-in from here. This plugin allows you to save any kind of document in PDF or XPS format, either it might be your worksheet in excel or your resume or your daily reports.

The add-in works with all the Microsoft office programs There is a one click button in the file menu with name "Publish As PDF" to save or convert the documents in PDF and xps format as shown in the below screen.

Moreover, if your converted pdf documents are of large size, then you can optimize and reduce the your pdf documents. Check my Previous Post on how to reduce the pdf file size.

Thanks!

Using Paste Special And Transpose To Convert Rows Into Columns

Microsoft Office 2003 and 2007 at its best.Here is a small tip to convert your data columns to rows and rows to columns, otherwise to move data between rows and columns in Microsoft Office Excel 2003 and Microsoft Office Excel 2007. Excel 2000 or later provides an paste special and transpose options to interchange the data between rows and columns. Follow the rest of the post on how to do that.

Here Is my data in a single Column In the Excel sheet(you can use the below links to browse and download thousands of microsoft office excel,word, power point and infopath templates for free from microsoft office website).

Award certificates

Brochures

Budgets

Business cards

Calendars

Content slides

Contracts

Databases

Design slides

Diagrams

Envelopes

Expense reports

Copy the data and open another worksheet and right click the mouse and click on paste special to bring up the paste special popup window as shown in the below screen, select(tick mark) the transpose check box at the bottom and click on OK to get your data transposed into rows, you can follow the same procedure inorder to convert rows to columns in microsoft office excel.

Award certificates Brochures Budgets Business cards Calendars Content slides

You might get a different window when copying a content with hyperlinks and trying to paste in an microsoft excel using paste special as shown below.

Select html, if you want to retain the hyperlinks of the content and click on Ok to paste in a normal way, then copy the pasted content and open(switch to sheet 2 at the bottom and right click and click on paste special and use the transpose option to convert columns into rows and rows into columns.

Try Microsoft Office 2007 free for 60 days and explore yourself
Discuss using comments

Thanks
HP Answers