Using Excel for Printing Purposes

SharePoint uses Internet Explorer to display and print content, which severely limits the user's control over printing options. You can't, for example, simply print out the contents of a list because IE will print the page as it displays on the screen, including graphics and menus. Changing the page margins and switching to Landscape view can help, but in many cases there are too many rows and columns of information to show up on the print job.

As mentioned in Lesson 10, the Datasheet view's task pane provides several Excel tools, one of which is Print with Excel. To print a list with Excel you must have Excel 2003 installed and should follow these steps:

1.
From within a library or list, click Edit in Datasheet ...

Get Sams Teach Yourself Microsoft® SharePoint™ 2003 in 10 Minutes now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.