4. Selecting Cells Efficiently

  1. John Walkenbach

Published Online: 11 NOV 2011

DOI: 10.1002/9781118257647.ch4

John Walkenbach's Favorite Excel® 2010 Tips & Tricks

John Walkenbach's Favorite Excel® 2010 Tips & Tricks

How to Cite

Walkenbach, J. (2010) Selecting Cells Efficiently, in John Walkenbach's Favorite Excel® 2010 Tips & Tricks, Wiley Publishing, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118257647.ch4

Publication History

  1. Published Online: 11 NOV 2011
  2. Published Print: 28 JUN 2010

ISBN Information

Print ISBN: 9780470475379

Online ISBN: 9781118257647

SEARCH

Keywords:

  • cells efficiently;
  • arrow keys;
  • select ranges;
  • selection of cells;
  • lower right cell

Summary

This chapter contains sections titled:

  • Selecting a range by using the shift and arrow keys

  • Selecting the current region

  • Selecting a range by Shift+clicking

  • Selecting noncontiguous ranges

  • Selecting entire rows

  • Selecting entire columns

  • Selecting multisheet ranges