|
» 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: 18168 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Advanced modelling in finance using Excel and VBA
- Microsoft PowerPoint Version 2002 Step by Step
- Windows XP for Dummies
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Absolute Beginner's Guide to Microsoft Office Excel 2003
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.
