function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
vicky85vicky85 

Printable View of the reports

Hi All,

 

I have created a matrix reports in Salesforce which has got several columns.

Whenever I run the report and click on Printable view, it gives me a excel output.

I need to print this excel output.. However, once the excel output is printed, it prints few columns on first page and rest of the columns on next page.

I want all the columns to appear on the same page.

I am ok if the data or column headings wrap in the cell.

 

Can someone guide me on this?

 

Thanks in advance for any help...

Pradeep_NavatarPradeep_Navatar

Follow these tips to print your Excel worksheet on one page (or as many pages as you wish).


1. Open the Excel spreadsheet that you want to print. Click on "File" in the Excel toolbar, or use the keyboard shortcut Alt+F.


2. From the "File" menu, choose "Page Setup."


3. In the "Page Setup" dialog box, click the "Page" tab.


4. Under "Scaling", click the radio button to the left of "Fit To."


5. Enter your desired number of pages in the "Pages Wide" and "Pages Tall" drop-down menus. For example, you may want to change only the width of your page so that the last columns do not print onto a separate page. In this case, you would enter "1" into "Pages Wide" and delete the number in the "Pages Tall" menu.


6. Click OK. Your Excel spreadsheet will now fit the way you want it to.


Did this answer your question? If so, please mark it solved.