» Selecting Cells in Horizontal or Vertical Ranges
CATEGORY - Excel Keyboard Shortcuts
VERSION - All Microsoft Excel Versions
Using keyboard shortcutsTo select a range of cells:
• Vertically from top to bottom, press Ctrl+Shift+Down Arrow.
• Vertically from bottom to top, press Ctrl+Shift+Up Arrow.
• Horizontally from left to right, press Ctrl+Shift+Right Arrow.
• Horizontally from right to left, press Ctrl+Shift+Left Arrow.
To select cells one after another:
• Press Shift+ Arrow.
Using the mouse
Select a cell in a range, press the Shift key and double-click the edge of the selected cell when the mouse image changes to four directional arrows.

Book Store:
Recommended Books:
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Adventure Capitalist: The Ultimate Road Trip
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Microsoft Access 2002 for Dummies
- Finance and Accounting for Nonfinancial Managers
No comments have been submitted.

