» Selecting Cells from Any Cell to the Last Cell in the Sheet's Used Range
CATEGORY - Excel Keyboard Shortcuts
VERSION - All Microsoft Excel Versions
To select cells from any cell to the last cell in the sheet's used range:
The keyboard shortcuts Ctrl+Shift+End and Ctrl+Shift+Home enable the quick selection of cells either down to the last cell of the sheet's Used Range or to the first cell (A1), respectively.
Example:
To clear the cell content from cell A7 to the last cell in the sheet's Used Range (cell G13 in this example):
1. Select cell A7.
2. Press Ctrl+Shift+End.
3. Press Delete.
Book Store:
Recommended Books:
- Financial Statement Analysis with S&P insert card
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Marketing Plans
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
No comments have been submitted.
