In Excel for Microsoft 365 on Windows, copy the cells with Ctrl+C, select the cell where the copied range should begin, then press Ctrl+Shift+Plus (+) to insert the copied cells. On most US keyboards, type this as Ctrl+Shift+=; if Excel displays an insertion dialog, choose how to move the existing cells.
The shortcut and what it does
The key combination is Ctrl+Shift+Plus. It is a keyboard way to insert copied cells rather than paste over the destination. The copied range is placed at the selected location, while Excel shifts existing cells out of the way according to the insertion choice. That distinction matters: Ctrl+V normally replaces the contents of cells in the pasted area, whereas inserting copied cells makes room for the incoming data.
On many US keyboards, the plus sign shares the equals key, so you press Ctrl and Shift and tap =. The exact physical key can differ on international or compact keyboards. Use the key that produces a plus sign with the applicable keyboard layout. If the shortcut is awkward on your device, the right-click command described below is a dependable alternative.
Steps to insert copied cells
- Select the source cells and press Ctrl+C. A moving dashed border, sometimes called marching ants, usually indicates that Excel is still holding the copied range.
- Select the destination cell. This is the upper-left cell of the space where the copied range should begin; you generally select one cell rather than preselecting a same-sized destination block.
- Press Ctrl+Shift+Plus. If Excel asks how to make room, choose whether to shift cells right or down, or select a whole-row or whole-column option when that is what you intend.
- Check the surrounding cells and formulas after insertion. Excel moves the existing cells to make room, and references that point to moved cells may adjust.
You can also right-click the destination and choose Insert Copied Cells. This command is especially useful if you cannot easily type the plus sign or want to see the insertion choices before confirming. In the ribbon, the ordinary Insert command is not always the same as inserting the copied range, so check that you have chosen the copied-cells command when preserving the copied data is the goal.
How Excel makes room
Excel works with a grid, so inserting a rectangular selection requires a decision about the direction in which the cells already in the destination area should move. Shifting cells down creates room vertically; shifting them right creates room horizontally. The copied range keeps its shape. For example, copying a 2-row-by-3-column block and inserting at B4 places a 2-by-3 block starting at B4, while existing cells are displaced based on your choice.
Those two choices can affect different parts of a worksheet. Shifting cells down moves content below the insertion point in the affected columns. Shifting cells right moves content to the right in the affected rows. If the surrounding data is a carefully aligned table, a partial shift can separate related fields or disrupt the visual layout. Before confirming, consider whether the data should move as complete rows or columns instead.
When the source is an entire row or column, Excel can insert that whole row or column. This is often safer in a conventional table because all fields in a record stay together. It is not identical to inserting a small group of cells: a full-row insertion affects the entire worksheet row, including cells far outside the visible table.
Choosing the right insertion option
Decide what must stay aligned before you insert. If you are adding a missing value in one list and neighboring columns are unrelated, shifting only the relevant cells may be appropriate. If each row represents one person, order, or transaction, moving an entire row is usually the more coherent choice. Likewise, a new field in a structured grid may call for inserting a full column rather than shifting cells in just a few rows.
- Shift cells down: use this when the new block belongs above existing entries in the same columns and the other columns should not move.
- Shift cells right: use this when the new block belongs before existing entries in the same rows and other rows should remain in place.
- Entire row: use this when a new record needs a full worksheet row so values in all columns remain together.
- Entire column: use this when adding a field that should move all existing columns to the right.
For instance, suppose A and B contain customer names and account numbers, with each row representing one customer. Inserting copied cells into column A and shifting only that column down could misalign names with account numbers. Inserting a whole row instead keeps each existing customer record intact. Conversely, if you are maintaining a single-column list with no related fields, shifting cells down may be exactly what you need.
Insert copied cells versus ordinary paste
Both commands use copied cell contents, but they handle occupied destination cells differently. Ctrl+V pastes into the selected destination and can replace existing values in the pasted area. Insert Copied Cells instead opens space by moving existing cells. That is why it is useful when adding copied material in the middle of a list without simply overwriting what is already there.
Inserting is not the same as copying and inserting an entire worksheet row. A copied range can be a few cells, a block, or a full row or column. The range size and the choice of shift direction determine how the surrounding grid changes. If you need to duplicate the source but leave the destination area untouched, regular paste may be appropriate; if you need to preserve destination entries by moving them, insert the copied cells.
What gets copied: values, formulas, and formatting
Copying cells carries more than the displayed text in many cases. A copied cell may contain a formula, number format, fill, border, or other cell formatting. The inserted copy generally retains the copied cells’ contents and formatting, while Excel adjusts relative references in formulas as it does when copying and pasting. For example, a formula referring to a nearby cell can point to a correspondingly shifted cell in the new location.
That adjustment can be helpful, but it is worth reviewing formulas in calculated columns and totals. Absolute references, written with dollar signs such as $A$1, behave differently from relative references when copied. If the inserted cells contain formulas connected to nearby data, confirm that the results still refer to the intended inputs after insertion. The insertion also moves existing cells, which can affect formulas that refer to those cells.
Common problems and fixes
If Ctrl+Shift+Plus does not seem to insert the copied range, first check that the source was copied and the destination is selected. If the marching-ants border has disappeared, copy the range again. Excel may also interpret the key differently on a non-US keyboard; the context-menu command Insert Copied Cells avoids that particular keyboard-layout issue.
- The wrong cells moved: undo immediately with Ctrl+Z, then repeat and choose a different shift direction or insert a whole row or column.
- Existing values were replaced: this usually means a regular paste was used. Undo if possible, recopy the source, and use Insert Copied Cells.
- The option is unavailable: confirm that you have copied a cell range rather than merely selected it, and that Excel is in a state where a cell insertion is allowed.
- The result appears misaligned: inspect neighboring columns and rows. A partial shift can break a table’s record-by-record alignment even if the copied cells were inserted correctly.
Ctrl+Z usually reverses an accidental insertion, but do not rely on undo after making many subsequent changes or after running actions that clear the undo history. Check the worksheet promptly. If the workbook is important, saving a separate copy before a large structural edit provides an additional recovery option.
Using Excel on Mac or in a browser
The instructions above target Excel for Microsoft 365 on Windows. On a Mac, keyboard layouts and Excel shortcut mappings can differ, so the Windows Ctrl+Shift+Plus combination may not map directly to the keys on your keyboard. Use the context menu on the destination and choose Insert Copied Cells when available; it avoids guessing which modifier-key combination your setup expects. Mac keyboards also distinguish Control from Command, so do not substitute one automatically without checking the shortcut shown by your Excel version.
Excel for the web can have different keyboard behavior because the browser and operating system may use some key combinations themselves. If the shortcut is intercepted or does not produce the expected insertion, use the available cell context-menu or ribbon insertion command in the web interface, and verify that it is specifically inserting copied cells. The desktop Windows shortcut is the clearest answer when using the Windows desktop version.
Related shortcuts and alternatives
Ctrl+C copies a selection, Ctrl+X cuts it, Ctrl+V pastes, and Ctrl+Z undoes the most recent action. These shortcuts are related but not interchangeable. Cutting cells and inserting them is a move operation, while copying and inserting leaves the source in place. If the copied information should not remain at the original location, cut-and-insert may better match the task; if the source must remain, copy-and-insert is the appropriate approach.
For a one-time edit, the right-click Insert Copied Cells command is often the simplest alternative. You can also use the ribbon’s cell insertion controls, but inspect the menu wording because inserting blank cells and inserting copied cells are distinct operations. For large data rearrangements, consider whether sorting, moving a whole row, or pasting into a newly created area would preserve the table structure better than shifting a small block of cells.
Frequently Asked Questions
What is the shortcut for Insert Copied Cells in Excel?
In Excel for Microsoft 365 on Windows, copy the range, select the destination, and press Ctrl+Shift+Plus. On a typical US keyboard, the plus sign is entered with Shift and the equals key.
Does Ctrl+Shift+Plus overwrite cells?
It is used to insert copied cells and make room by shifting existing cells, rather than simply pasting over the destination. Choose the shift direction carefully so related data stays aligned.
How do I insert copied cells without using a shortcut?
Copy the range, right-click the destination cell, and choose Insert Copied Cells. Select the appropriate shift option if Excel prompts you.
Can I insert copied cells as a whole row?
Yes. Copy the row, select the row location, and use the insert-copied-cells command. Choose the entire-row option where shown to move records together across the worksheet.
Why does Excel ask whether to shift cells right or down?
A rectangular cell range can be inserted in either direction. Excel needs to know which neighboring cells should move to make room; choose the direction that preserves the layout of your data.
Related
- Excel Formatting Keyboard Shortcuts: A Practical Guide
- Excel Format Numbers in Thousands (K)
- Excel Format Cells Shortcut: Quick Keys for Windows and Mac
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Page Break Command: Insert, Move, and RemoveIn Excel for Microsoft 365 on Windows, use Page Layout > Breaks > Insert Page Break to add…
- Microsoft PowerPoint Loop Slideshow: Setup and FixesYes. In the PowerPoint desktop app, open Slide Show > Set Up Slide Show, select Loop continuously until…
- Excel Group Rows: How to Expand and Collapse Rows EasilyIn Excel for Microsoft 365 on Windows, select the rows you want to fold away, choose Data >…
- Outlook Webmail Signature: How to Create OneTo create a signature in Outlook webmail, open Settings, find the signature editor, write and format your signature,…
- Freeze Panes in Excel: Shortcut Key and How It WorksIn Excel for Microsoft 365 on Windows, the Freeze Panes shortcut is Alt, W, F, F—press the keys…
- Google Sheets: How to Split Text in a Cell or ColumnTo split text in Google Sheets, select the cell or range, then choose Data > Split text to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.