I exported an Allotment Expenditure Status report to Excel, but there are a lot of extra columns and rows and merged cells in the exported file. What can I do to prevent this from happening?
Instead of exporting the report to Excel, use the Excel format when scheduling the report. You can then use certain features in Excel to easily reformat the report. Follow the steps below: a. Select the Excel format when scheduling the report. In the Schedule Format menu, use the “Details” value for the “Column Width Based on Objects” menu selection. Using this option results in output with a lot less merged cells. b. After the report is processed, view the report and save it in Excel format. Open up the file and insert a blank worksheet. c. Copy the worksheet containing the original report data to the newly inserted worksheet. Use the “Paste Special” menu option, selecting “Formulas” and “Skip Blanks” to paste the data into the blank worksheet. d. Use the macro “DeleteEmptyColumns1” contained in the attached worksheet Delete_Empty_Columns_Macro.xls to delete empty columns. The shortcut to run this macro is ctrl+a. e. Use the macro Remove_Blank_Lines_Macro.xls to delete empty rows. The
Related Questions
- How can I transfer data from columns or lists on the calculator to a PC so that it can be used in Excel or some other application?
- Can international medical graduates request a confirmation or status report for themselves?
- If a report is downloaded into Excel from TRMS NET/WEB are the columns functional?
