» Selecting Cells in Horizontal or Vertical Ranges
CATEGORY - Excel Keyboard Shortcuts
VERSION - All Microsoft Excel Versions
To 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:
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Finance and Accounting for Nonfinancial Managers
No comments have been submitted.
