Keep Headers but Delete Page Breaks when exporting a report to Excel
Currently when exporting a report Excel, the system gives the option of deleting headers and page breaks. It would be EXTREMELY helpful if the system could separate this option into two options: (1) delete headers (2)delete page breaks. The option to delete only page breaks would eliminate the time consuming process of deleting column headings throughout a report while still allowing the page header to print on each page.
Comments: 8
Oldest
•
Newest
•
Most likes
•
Fewest likes
-
19 Jul, '23
Jason GibsonHighlighted comment
An alternative solution is to allow users to have "Fit Columns to Page", "Fit Rows to Page", and "Fit Report to Page" options when printing or running the report as a PDF. I have many reports where I have to export to Excel just to convert them to a PDF where all columns are on the page. I have entered this as a suggested change. -
22 Nov, '17
Rachael Johannes Admin MergedOften times I want to retain the information given in the header but not the page breaks when exporting to excel. Perhaps it could be setup to choose which parts to keep and which not to.
-
07 Apr, '22
Megh Waltimire Admin"Remove only page breaks not header and info" (suggested by Rachael Johannes on 2017-11-22), including upvotes (4) and comments (0), was merged into this suggestion.
-
07 Apr, '22
Megh Waltimire System"Page Breaks" (suggested by Anonymous on 2017-04-19), including upvotes (4) and comments (0), was merged into this suggestion.
-
29 Aug, '22
Mitch FarmerThree Separate options 1.Remove Headers, 2.Remove Footers, 3.Remove Page breaks.
-
07 Mar, '23
Scott RonkenI currently have to craft a header for some of my Excel reports. I agree this would be very helpful.
-
12 Jan, '24
Sharon WilsonI like this suggestion and feel it would be useful. I have needed to add some type of header information sending the Excel file MIP created to end users so they are area of what entity, dates etc. The information is for.