How To Add Print Option To Excel Webart In Sharepoint

Are you looking to enhance your SharePoint experience by adding a print option to Excel Webart? Follow these simple steps to get started.

To add a print option to Excel Web Parts in SharePoint, follow these steps. First, open a SharePoint page for editing and choose “Add a Web Part” in a zone on the page. Then, select “Excel Web Access” under the Business Data category and click “Add” to add the Web Part. Next, connect a workbook to the Excel Web Access Web Part by specifying the workbook’s web site address or browsing for the workbook. Optionally, you can specify a named item to display in the Web Part instead of the entire workbook. After connecting the workbook, you can specify navigation and interactivity settings for the Excel Web Access Web Part. Finally, choose the properties you want to enable in the Toolbar and Title Bar section and the Navigation and Interactivity section of the Excel Web Part tool pane.

By following these steps, you can easily add a print option to Excel Webart in SharePoint. This will allow you to conveniently print Excel Web Parts directly from your SharePoint page, enhancing the usability and accessibility of your data.

So, don’t miss out on the opportunity to optimize your SharePoint experience. Start adding a print option to your Excel Webart today and enjoy the benefits of improved functionality and user-friendly access to your data.

Adding Excel Web Access Web Part to SharePoint

Begin by opening the SharePoint page you want to edit and navigate to the zone where you want to add the Excel Web Access Web Part. Follow these steps to seamlessly integrate Excel Web Access into your SharePoint site:

  1. Open the SharePoint page for editing.
  2. Select “Add a Web Part” in the desired zone.
  3. In the Web Part Categories pane, choose “Business Data” and click “Add”.
  4. Scroll down to locate the “Excel Web Access” Web Part and click “Add” to include it in your page layout.

Now that you have successfully added the Excel Web Access Web Part, it’s time to configure it to display your desired workbook and customize its settings.

Connecting and Customizing the Excel Web Access Web Part

To connect a workbook to the Excel Web Access Web Part, follow these steps:

  1. Specify the web site address of the workbook or browse for it.
  2. Optionally, you can choose to display a named item from the workbook instead of the entire workbook.

Once you have connected the workbook, you can further enhance the functionality of the Excel Web Access Web Part by adjusting navigation and interactivity settings. Tailor it to meet your specific requirements and preferences.

Finally, you have the option to enable specific properties in the Toolbar and Title Bar section as well as the Navigation and Interactivity section of the Excel Web Part tool pane. Determine which features are most useful to your users and activate them accordingly.

By following these simple steps, you can seamlessly integrate Excel Web Access into your SharePoint site and enhance your users’ experience with the ability to view and interact with Excel workbooks directly within the SharePoint environment.

Web Part Configuration Steps: Benefits:
Open SharePoint page for editing Customize your SharePoint site to include Excel Web Access
Select “Add a Web Part” in desired zone Add the Excel Web Access Web Part to your page layout
Choose “Business Data” category and click “Add” Access Excel Web Access in the Web Part Categories pane
Locate and add the “Excel Web Access” Web Part Effortlessly integrate Excel Web Access into your SharePoint site

Connecting and Customizing the Excel Web Access Web Part

Once the Excel Web Access Web Part is added, you can connect a workbook to it by specifying its web site address or browsing for the workbook. This allows you to display the workbook’s content within the Web Part and customize its settings according to your preferences.

To connect a workbook, simply open the Web Part’s tool pane and navigate to the “Workbook” section. Here, you have the option to enter the web site address of the workbook or use the browse button to locate and select the desired workbook from your SharePoint site.

Additionally, if you only wish to display a specific named item from the workbook instead of the entire workbook, you can specify it in the “Named Item” field. This feature allows you to focus on a particular section or data within the workbook.

Once the workbook is connected, you can further customize the Excel Web Access Web Part by adjusting its navigation and interactivity settings. In the tool pane, under the “Web Part Display” section, you can enable or disable features such as toolbar and title bar, which provide users with additional options for navigating and interacting with the workbook.

Meet the Author

Abdul Rahim has been working in Information Technology for over two decades. Learn how Abdul got his start as a Tech Blogger , and why he decided to start this Software blog. If you want to send Abdul a quick message, then visit his contact page here.