Microsoft
Tech Community
Home
Community Hubs
Community Hubs
Community Hubs Home
Products
Special Topics
Video Hub
Close
Products
(50)
Special Topics
(27)
Video Hub
(462)
Most Active Hubs
Microsoft 365
Microsoft Teams
Windows
Security, Compliance and Identity
Outlook
Planner
Windows Server
Azure
Exchange
Intune and Configuration Manager
Content Management
SQL Server
Microsoft Viva
Connect and learn from experts and peers
Microsoft FastTrack
Best practices and the latest news on Microsoft FastTrack
Microsoft Copilot for Sales
A role-based copilot designed for sellers
Most Active Hubs
Education Sector
AI and Machine Learning
ITOps Talk
Microsoft Partner Community
Microsoft Mechanics
Healthcare and Life Sciences
Public Sector
Internet of Things (IoT)
Driving Adoption
Small and Medium Business
Startups at Microsoft
Azure Partner Community
Expand your Azure partner-to-partner network
Microsoft Tech Talks
Bringing IT Pros together through In-Person & Virtual events
MVP Award Program
Find out more about the Microsoft MVP Award Program.
Video Hub
Azure
Exchange
Microsoft 365
Microsoft 365 Business
Microsoft 365 Enterprise
Microsoft Edge
Microsoft Outlook
Microsoft Teams
Security
SharePoint
Windows
Blogs
Blogs
Events
Events
Events Home
Microsoft Ignite
Microsoft Build
Community Events
Microsoft Learn
Microsoft Learn
Home
Community
Blog
Azure
Dynamics 365
Microsoft 365
Security, Compliance & Identity
Power Platform
Github
Teams
.NET
Lounge
Lounge
1.4M
Members
15.3K
Online
328K
Discussions
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show
only
|
Search instead for
Did you mean:
Sign In
Sign In
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show
only
|
Search instead for
Did you mean:
Home
Home
Microsoft 365
Excel
How to duplicate the row
How to duplicate the row
Discussion Options
Subscribe to RSS Feed
Mark Discussion as New
Mark Discussion as Read
Pin this Discussion for Current User
Bookmark
Subscribe
Printer Friendly Page
Skyong1976
Copper Contributor
Sep 28 2019
08:32 AM
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Report Inappropriate Content
Sep 28 2019
08:32 AM
How to duplicate the row
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
Labels:
Labels:
Excel
Formulas and Functions
All Discussions
Previous Discussion
Next Discussion
1 Reply
Subodh_Tiwari_sktneer
replied to
Skyong1976
Sep 28 2019
08:48 AM
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Report Inappropriate Content
Sep 28 2019
08:48 AM
Re: How to duplicate the row
@Skyong1976
To do so, follow these steps...
Select all the cells in column A with data and including blank cells.
Press
Ctrl+G
to open
Go To
window and click on
Special
and choose
Blank
radio button.
The above step would select all the blank cells in column A in the selected range.
Now, type
=
from your keyboard and press
UP Arrow key
and press
Ctrl+Enter
.
Then select the whole range again, copy it and paste it back as Values only.
Browse