» Copying & Pasting Cell Content to Thousands of Cells
CATEGORY - Excel Keyboard Shortcuts
VERSION - All Microsoft Excel Versions
1. Select and copy cell A1.
2. Type a cell address in the Name box, for this example, type A5000.
3. Press Shift+Enter to select the cells from A1:A5000.
4. To paste, press Enter.
Book Store:
Recommended Books:
- Understanding Financial Statements
- Special Edition Using Microsoft Excel 2002
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- The 22 Immutable Laws of Branding
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing



i am having query,
i am working on vba excel programming,here in sheet only some cells are editable,if u press F2 function key content will get cleared ,how to avoid not clear content of cells