Fit multiple column report to fill page space when printed

If you have a report which has several columns and will span a number of pages when printed you can follow this method to increase the number of columns on a printed page in order to print more information on a single page. That way you can minimize the amount of paper used.

The report below isn't too large but as you can see there are 3 columns in the exported report.

When you try to print this on one page directly from Microsoft Excel you will end up printing 12 pages because of the unused white space on each page.

Follow the video below or the instructions here on how to use up more of the space on the page and reduce the number of pages you print.

Video:

Step by step instructions:

1. With the report exported and opened in Microsoft Excel select the columns that you would like to copy, then right-click the selection to copy them to the clipboard.

2. Open Microsoft Word and paste the copied columns into the blank document.

3. To add multiple columns to use up more of the available page click Layout, then click Columns and finally select the number of columns that fit your report size best. In my case, three columns appeared to be the best fit.

You will notice that your report immediately spans the number of columns that you selected.

4. To use up a little more of the available space click on Margins and select Narrow.

As you can see the data has expanded to take up more of the available page and the total page count is reduced from 12 to 4 printed pages. Adjust further as needed and print your report when you're ready.

• Related Articles

• Using Company Reports and Report Packs

  Company users have access to a set of reports that have been created specifically for your company by your company administrator. When viewing reports in Report Manager, you may have both Company Reports and Report Pack tabs. When logged into a farm, ...

• Report Guide: Report Map and Global Reports

  With dairy data, the possibilities for investigating data from different angles can be overwhelming. BoviSync has created a Report Map and a library of Global Reports with many pre-designed reports available to any farm or user. The Report Map ...

• Adding a BoviSync page to Farm Reports

  The breeding intensity report is a built in BoviSync report. If you want to add that to a menu, you can do that in the report manager. Setup > Report Manager > Farm Reports > Add Menu Item In the report manager, in farm reports: click on "add menu ...

• Modifying Pre-Designed Reports for Your Farm(s)

  The BoviSync team has developed an extensive set of pre-designed reports for users in the Reports menu (depicted below),Bovi-Insights-> Search, and Report Map. However, there will always be needs for farm-specific reports beyond these pre-designed ...

• Report Basics

  Reports are the primary place for getting information on what and how the farm, pens, and animals are doing. Pre-defined or Global Reports BoviSync comes with many pre-defined reports that are most often used. These reports are grouped into ...