Insert Copied Cells - Mac Shortcut

Question

Good Morning all!

I have an excel spreadsheet that I am working on the Mac (Version 16.69) and also Office Online 365 via Safari (As some features are not in the installed Mac application), In the document there is 1000's of lines of data.

In Column B there is irregular intervals of "Insert Data Here" based upon a formula to help guide you to "insert copied cells" in data anytime you see the message Insert Data Here.

On a Mac & Office 365 online it is very tedious to keep scrolling, Right click and hit Insert Copied cells 100's of times.

Is there a keyboard shortcut or a macro code that can be ran to speed this process up as I have about 50 workbooks like this to get through.

Thanks in advance!

Answer 1

Short cut "Control+Shift+Equal sign ( = )" will work.

Could you share us how to find the row which should be insert into your table? If it can be find, then it could use macro to do it.

For example, I know the row should be between 3 and 4. Where is the row copy from.

Answer 2

Hi KiloHotel,

Greetings! Thank you for posting to Microsoft Community.

What do you mean of "insert copied cells"? Try:

Control+Shift+Equal sign ( = )

For shortcuts, reference:

Keyboard shortcuts in Excel - Microsoft Support

Could you share us a sample file or a sample table with dummy data in it and the expected result?

From your description, if the actions are same, macro is the best way to do it.

Note: macro can be run on desktop app instead of Excel online.

Best regards,

Snow Lu

Answer 3

Do you mean you want to copy the same data at the above of the “Insert copied cells” ?

=================

Sub Macro1()

Rows("20:20").Select 'copy data

For I = 1 To 100 

If Cells(I, 3) = "Insert Copied Cells" Then 

Cells(I, 3) = "" 

Selection.Copy 

Rows(I).Select 

Selection.Insert Shift:=xlDown 

End If

Next I 

End Sub

===================

Answer 4

Hi,

That shortcut works only in the application and it only works once, Meaning when I hit CMD+Shift+Equal sign ( = ) it inserts any copied data to the row selected however I cannot progress to the next row I want to insert the copied data and hit the same keyboard shortcut, I wants me to go back to the top and copy the data again.

"Short cut "Control+Shift+Equal sign ( = )" will work."

Do you know the shortcut for Office 365 online (I am using a MacBook)

"Could you share us how to find the row which should be insert into your table? If it can be find, then it could use macro to do it.

For example, I know the row should be between 3 and 4. Where is the row copy from."

The data to be copied from is multiple rows 1 to 7, all the way down the sheet where that message in Column B shows

"INSERT COPIED CELLS"

Answer 5

Hi Snow Lu,

"What do you mean of "insert copied cells"?"

I mean when you select a row of data and press CMD + C for copying and then going to the row where it states to insert copied cells by right clicking on the row and selecting "Insert Copied Cells" to paste in the row that was copied.

I tried that keyboard shortcut but it did not work on Mac or Office Online.

My example table is;

So how it works is, In Column B there is a formula =IF(A2=A1,"","INSERT COPIED CELLS") to help guide whenever there is a change in the data in COLUMN A, When the change of data happens I have a row of data to paste in, In the below example that would happen between row numbers 3 & 4 and again at 7 & 8.

At present I am right clicking the row number 4 IN THIS EXAMPLE, then selecting Insert Copied Cells to paste in the data between the rows

1	A	B	C	D
2	6789		TEST DATA	TEST321
3	6789		TEST DATA	TEST321
4	12345	"INSERT COPIED CELLS"	TEST DATA	TEST321
5	12345		TEST DATA	TEST321
6	12345		TEST DATA	TEST321
7	12345		TEST DATA	TEST321
8	54321	"INSERT COPIED CELLS"	TEST DATA	TEST321
9	54321		TEST DATA	TEST321
10	54321		TEST DATA	TEST321