Can you copy and pate a Row Grouping?

J

jcueland

New Member
Joined
Mar 19, 2007
Messages
42
I have some rows that I want to group the same as some other rows. Is it possible to copy and paste the grouping somehow? When I just do copy formats it doesn't include the grouping.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
I don't use grouping that much, so I'm not so familiar with it.
But I just tried setting up some grouping (using Excel 2003), highlighted the ENTIRE ROWS that were grouped, then Copy, paste, and it worked fine, including duplicating the grouping.
You don't need to copy, paste special, formats.
It seems as if you have to paste into Col A.
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Excel Membership Data to Word Document
Replies
7
Views
236
Beaglebud
B
O
  • Question
Running through a Config and pulling out the relevant information using keywords into smaller sheets
Replies
0
Views
133
oitbc
O
E
  • Question
Does Excel have anything like Smartsheet's Hierarchy (Parent/Child rows)?
Replies
3
Views
425
Edgar_
Edgar_
P
  • Solved
Marco for making borders around 'groups'
Replies
4
Views
195
kevin9999
K
B
  • Question
Groups/Arrays/Patterns Help
Replies
5
Views
342
JamesCanale
JamesCanale

Forum statistics

Threads
1,214,849
Messages
6,121,925
Members
449,056
Latest member
denissimo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top