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
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

@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
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies