Monday, 12 February 2018

Excel Hints and Tips - Hiding rows and columns



If you need to hide specific rows and columns there is a quick keyboard shortcut you can use.

In order to hide columns, highlight any cells in the columns you wish to hide and press Ctrl+0, the columns with selected cells will be hidden. The same principle works with rows, highlight any cells in the rows you wish to hide and press Ctrl+9.

No comments:

Post a Comment

Select 'ANONYMOUS' in the comment as field. Add your name to the body of the comment if you wish.