Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]

Here is a very quick spreadcheat for the new year.

If you need to select all the cells in a series (either row-wise or or in columns) you can use one of these 2 shortcuts (and avoid unnecessary scrolling)

1. Select the first cell in the series

2. Press Shift + Ctrl + Down arrow

Or

1. Select the first cell in the series

2. Hold down SHIFT and Double click on the edge of cell in the direction you want to select

for eg. double click on the think black line (that you see when you select a cell) and excel selects all the cells in that direction

Posts & Navigation Have an Excel Question? « Excel 2007 Review – 10 things that WOWed me Happy New Year to all PHD Readers » Go Back to Home Page Tags: howto, keyboard shortcuts, Learn Excel, microsoft, MS, quick tip, select, spreadcheats, spreadsheets, tips, tricks

Comments

RSS feed for comments on this post. TrackBack URI

Leave a comment

If you have a question, please ask in the forums