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:
Figure 14.1 shows the results of following these steps for the tasks list in the ProServices site. The task list was updated with some new tasks, so a total of 14 tasks appear in the list. It is not unusual to see lists that grow to dozens or hundreds of items in production environments. From here you are free to format the content however you likeadding graphics, headers, and footers to the sheet, adding gridlines, and making changes to fonts and colors.
Figure 14.1. List content exported to Excel.