Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2011, 01:42 PM
gib65 gib65 is offline merging rows and creating sub-rows Windows XP merging rows and creating sub-rows Office 2003
Advanced Beginner
merging rows and creating sub-rows
 
Join Date: Aug 2010
Posts: 70
gib65 is on a distinguished road
Default merging rows and creating sub-rows

A couple questions about Excel 2007:

1) How can I highlight a whole block of cells and merge them across the rows only? So they would become a single column of rows, but the number of rows would remain the same as before the merge.

2) Is there a way of creating a spreadsheet within a spreadsheet? I mean that I want to create a set of sub-rows within a row under a specific column. Can this be done?
Thanks
Reply With Quote
  #2  
Old 12-08-2011, 07:28 PM
macropod's Avatar
macropod macropod is offline merging rows and creating sub-rows Windows 7 64bit merging rows and creating sub-rows Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,232
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

Hi gib65,

1: Unless you're into vba coding, not possible if you select more than one row at a time;
2: Not if you mean multiple rows & columns in a single row/column. You can, of course merge rows&columns around your sub-set, but this doesn't change the underlying workbook structure.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Last edited by macropod; 12-08-2011 at 07:30 PM. Reason: Clarification
Reply With Quote
  #3  
Old 12-09-2011, 02:09 PM
gib65 gib65 is offline merging rows and creating sub-rows Windows XP merging rows and creating sub-rows Office 2003
Advanced Beginner
merging rows and creating sub-rows
 
Join Date: Aug 2010
Posts: 70
gib65 is on a distinguished road
Default

Too bad. Thanks for your response, macropod.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
merging rows and creating sub-rows How make rows equalized Yumin Word Tables 2 09-21-2011 09:17 AM
Product and Sum on 2 rows apolloman Excel 2 04-27-2011 07:14 AM
merging rows and creating sub-rows Rows to Columns kyakobi Excel 5 12-07-2010 03:12 PM
merging rows and creating sub-rows Average of many rows speedycorn1 Excel 1 10-30-2010 07:54 PM
merging rows and creating sub-rows How do I turn the top 2 rows into a header GR8Fandini Excel 1 02-06-2010 12:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft