|
» Inserting a Copied Cell(s) Without Overwriting Existing Data
CATEGORY: Excel Editing |
VERSIONS: All Microsoft Excel Versions |
|
Using keyboard shortcuts To copy and paste a cell(s) containing data without overwriting existing data: 1. Copy a cell(s) containing data. 2. Select a cell inside the range of cells that should not be overwritten. 3. Press Ctrl++ (plus sign) to open the Insert dialog box. 4. Select Shift cells right or Shift cells down, and click OK. Using the mouse To copy & paste a cell(s) without overwriting existing data, using both a keyboard shortcut and the mouse: 1. Select a cell(s) that contains the data to be copied. 2. Hold the Ctrl+Shift keys, move the mouse over the selection border, and when the cursor changes to a small cross, drag the cell(s) to a new location and paste it. 3. Notice the gray line bar that follows the mouse. Position it in the new location and release the mouse. |
| Screenshot // Inserting a Copied Cell(s) Without Overwriting Existing Data |
  |
|
RATING:
3.07
VIEWS: 18173 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- How to Pay Zero Taxes (Annual)
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Adventure Capitalist: The Ultimate Road Trip
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
