Customising Your Report in Excel: Hiding Rows and Columns¶
Once you have sent your view to Excel, a feature you may want to use is the Excel “hide” row and column function so that these “behind the scenes” details don’t appear on the final published report.
- On your Excel worksheet, highlight the data you wish to hide
- Right-click to show a drop-down menu
- Choose the Hide option from the drop-down menu
Your header is now hidden