Save time and make it easier to compare date in spreadsheets.
This article appears in the May 07 issue of PC Advisor, available now in all good newsagents.
If you work with large Excel spreadsheets it's easy to get lost in all the data. To save time and make it easier to compare columns you actually want to look at, you can hide away any irrelevant data and then unhide it again when you need to view it.
Select the columns that you want to hide, then go to the Format menu and select Column, Hide. The selected columns will now disappear. When you want to unhide them again just reverse the process by choosing Format, Column, Unhide. You can hide rows of data in the same way by selecting Row instead of Column.