Excel Keyboard Shortcut – Selecting The Whole Data Region

If you need to select the whole data region (it might included some empty cells) in Excel without selecting all cells (<CTRL>+<A>), click on any cell inside that group and then type: <CTRL>+<SHIFT>+<8>. It is very useful for large data sets.

You should then get something like this:

excel spreadsheet screenshot

Try http://www.rnib.org.uk/xpedio/groups/public/documents/publicwebsite/public_rnib003503.hcsp for more keyboard shortcuts.


You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

AddThis Social Bookmark Button

Comments are closed.