Home

How to duplicate the row

%3CLINGO-SUB%20id%3D%22lingo-sub-880703%22%20slang%3D%22en-US%22%3EHow%20to%20duplicate%20the%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880703%22%20slang%3D%22en-US%22%3EExample%3CBR%20%2F%3EMoney%20row%201%3CBR%20%2F%3E%3CBR%20%2F%3ECoin%20row%204%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20any%20way%20to%20repeat%20row%202%20n%203%20as%20money%20and%205%20n%206%20as%20coin%20as%20I%20have%20hundreds%20line%20to%20do.%20Thanks%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-880703%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-880750%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20duplicate%20the%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-880750%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416748%22%20target%3D%22_blank%22%3E%40Skyong1976%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20do%20so%2C%20follow%20these%20steps...%3C%2FP%3E%3COL%3E%3CLI%3ESelect%20all%20the%20cells%20in%20column%20A%20with%20data%20and%20including%20blank%20cells.%3C%2FLI%3E%3CLI%3EPress%20%3CSTRONG%3ECtrl%2BG%3C%2FSTRONG%3E%20to%20open%20%3CSTRONG%3EGo%20To%3C%2FSTRONG%3E%20window%20and%20click%20on%20%3CSTRONG%3ESpecial%3C%2FSTRONG%3E%20and%20choose%20%3CSTRONG%3EBlank%3C%2FSTRONG%3E%20radio%20button.%3C%2FLI%3E%3CLI%3EThe%20above%20step%20would%20select%20all%20the%20blank%20cells%20in%20column%20A%20in%20the%20selected%20range.%3C%2FLI%3E%3CLI%3ENow%2C%20type%20%3CSTRONG%3E%3D%3C%2FSTRONG%3E%20from%20your%20keyboard%20and%20press%20%3CSTRONG%3EUP%20Arrow%20key%3C%2FSTRONG%3E%20and%20press%20%3CSTRONG%3ECtrl%2BEnter%3C%2FSTRONG%3E.%3C%2FLI%3E%3CLI%3EThen%20select%20the%20whole%20range%20again%2C%20copy%20it%20and%20paste%20it%20back%20as%20Values%20only.%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E
Highlighted
Skyong1976
Occasional Visitor
Example
Money row 1

Coin row 4

Is there any way to repeat row 2 n 3 as money and 5 n 6 as coin as I have hundreds line to do. Thanks
1 Reply
Highlighted

@Skyong1976 

To do so, follow these steps...

  1. Select all the cells in column A with data and including blank cells.
  2. Press Ctrl+G to open Go To window and click on Special and choose Blank radio button.
  3. The above step would select all the blank cells in column A in the selected range.
  4. Now, type = from your keyboard and press UP Arrow key and press Ctrl+Enter.
  5. Then select the whole range again, copy it and paste it back as Values only.
Related Conversations
Duplicate Favorites/Bookmarks
HotCakeX in Discussions on
0 Replies
Add Feature Duplicate Video
GoceR in Microsoft Stream Forum on
2 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Favorites duplicated again in latest Canary update
davequail in Discussions on
0 Replies
Outlook is sending duplicated mails
Growwing in Office 365 on
1 Replies