VBA & Macro Problems

How to Insert Copied Cells in Excel for Mac Using Shortcuts or Macros

Phi Hung Vo Oct 22, 2026 868 views

Question details

The user needs a fast and efficient way to repeatedly insert copied rows or cells in Excel for Mac, seeking either a keyboard shortcut or a VBA macro solution.

How to Insert Copied Cells in Excel for Mac

Product: Excel for Mac
Device & OS: Mac
Scenario: Performing repetitive data entry where specific copied rows or cells need to be inserted into a worksheet multiple times.
Observed behavior: Manual insertion using context menus is too time-consuming, prompting the need for a keyboard shortcut or an automated VBA macro to streamline the process.

Before you start

Ensure you are using the Excel for Mac desktop application, as VBA macros are not supported in Excel for the web.

Solution 1Recommended

Use the Keyboard Shortcut to Insert Cells

The quickest method for manual insertion of copied cells in Excel for Mac using standard keyboard shortcuts.

Copy the target cells

Highlight the cell, range of cells, or entire row you wish to duplicate, and press Command+C to copy them.

Select the destination

Click on the specific cell or row header where you want the copied data to be inserted.

Use the insert shortcut

Press Control + Shift + Equal Sign (=) on your keyboard to instantly insert the copied cells at the selected location.

Use the Keyboard Shortcut to Insert Cells

Shifting Cells: If you are inserting partial rows instead of entire rows, Excel will prompt you to choose whether to shift the surrounding cells down or to the right.

Solution 2

Automate Repeated Insertions with a VBA Macro

Create a VBA macro to automatically search for a marker text and insert copied rows at that specific location.

Efficient Data Management

Use WPS Spreadsheet for Fast Data Manipulation

WPS Spreadsheet offers a lightweight, highly compatible environment for handling repetitive data tasks seamlessly. It perfectly supports Microsoft Excel file formats (.xlsx) and standard keyboard shortcuts, allowing you to insert copied cells efficiently.

1. Open Your Spreadsheet in WPS: Launch WPS Office, click on 'Spreadsheet', and open your existing data file.
2. Copy the Data: Highlight the row or cells you need to duplicate and press Command+C (or Ctrl+C).
3. Insert Instantly: Right-click the destination row and choose 'Insert Copied Cells', or use the quick shortcut keys to shift data down seamlessly.

100% compatible with Microsoft Excel file formats, including .xlsx and .csv.Supports standard keyboard shortcuts for rapid data manipulation and cell insertion.Lightweight application that runs smoothly, saving your device's battery and memory.Clean, intuitive tabbed interface that makes switching between multiple spreadsheets effortless.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't my VBA macro run in Excel for the web?

VBA (Visual Basic for Applications) requires the underlying desktop architecture to execute. Excel for the web relies on cloud-based technologies and does not support VBA, though it does support modern Office Scripts.

Can I insert copied cells without shifting other data?

No, inserting new cells inherently requires existing cells to move out of the way. If you don't want to shift cells, you should use standard Paste (Command+V) to overwrite the existing data instead of inserting.

What is the equivalent shortcut to insert copied cells on a Windows PC?

On a Windows PC, you can copy the cells and then press Ctrl + Shift + Plus Sign (+) to bring up the insert copied cells prompt.

Excel & Data Problems