Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.
Last year, it emerged that Health New Zealand used an Excel spreadsheet as its "primary data file" for managing and analysing its financial performance. This made collection and consolidation of data ...