Merge and Center Multiple Rows

[Guest]

I have two rows of numbers. After doing some comparisons, I want to send this spreadsheet to the customer with JUST the value for each column that we want them to see. Currently, we are going to the two side-by-side columns, deleting the number that we don't want them to see, then highlighting both cells and clicking on the merge and center button on the toolbar. This is all fine and dandy if you're doing one or two rows of data....but we've got pages and pages we have to do this to. My question is two-fold - I know about the STUPID error "The cell reference for a merged cell is the upper-left cell in the original selected range" when I've tried to do two rows at a time. Is there ANY WAY at all to not only merge and center multiple rows (provided of course, we've already deleted the value from the row we don't want) at a time, but to possibly create a shortcut or something to make our lives easier

I'd appreciate any help at all

Kelly

 

[Robert Rosenberg]

Excel has a Merge Across feature, though not obvious to many...

1. Click Tools-->Customize

2. Click the Commands Tab

3. Click the Format Category on the left

4. Scroll down the right side until you find the "Merge Across" button

5. Drag that button out of the dialog and onto any location on any toolbar

6. Close the dialog

You can now select any desired amount of rows and click that button to merge
each row separately. You won't encounter the multiple entry warning unless
you have more than one entry per row.

Note that it doesn't center the data so you may need to click the center
button right after performing the merge (while the range is still selected).

--
__________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel

I have two rows of numbers. After doing some comparisons, I want to send

this spreadsheet to the customer with JUST the value for each column that we
want them to see. Currently, we are going to the two side-by-side columns,
deleting the number that we don't want them to see, then highlighting both
cells and clicking on the merge and center button on the toolbar. This is
all fine and dandy if you're doing one or two rows of data....but we've got
pages and pages we have to do this to. My question is two-fold - I know
about the STUPID error "The cell reference for a merged cell is the
upper-left cell in the original selected range" when I've tried to do two
rows at a time. Is there ANY WAY at all to not only merge and center
multiple rows (provided of course, we've already deleted the value from the
row we don't want) at a time, but to possibly create a shortcut or something
to make our lives easier?