- Holding CTRL key, you can select multiple objects and copy/move then as a whole group. This is very useful when you have to make more space to add more columns, or copy columns from another report.
- Sometimes after the data is exported to Excel, some (newly added) columns will mysteriously appear at the end of the Excel file, instead of in their intended location in design view. To fix it, select these column headers, use UP arrow key to move them out the page header, then move back so that there is 0 top margin.
- When export to Excel file in data only format, always uncheck “Simplify page headers”, otherwise some column headers will disappear.