LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Grouping / Fusing Cells

Can I fuse rows together into one unit? (Not merging.)

I have a spreadsheet that is conditionally formatted to alternate color at
every 5th row.

The five rows are merged into one cell at the first column; the rows are not
merged for the other columns. (For example, one contract number applies to
all five rows--so, the merged cells in the first column, along with the
shading, show that the five rows belong to the same contract.)

When I use the autofilter feature--my grouping totally disappears. The
filter erases every row within the group that doesn't have the filtered info.

Is there a way to "fuse" the group of rows so that they act as one unit?
I'd like for all five rows to show up when one of the five rows WITHIN THE
GROUP has the information in the filter. It would also allow me to sort the
first column by number without losing the adjacent rows that are part of that
group.

Thanks in advance!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating only non-empty cells... Jay Excel Worksheet Functions 9 September 22nd 06 03:20 AM
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 15th 05 11:14 PM
Can I use the grouping and lock and protect cells bfisher Excel Discussion (Misc queries) 1 January 11th 05 10:55 PM
Using a grouping of cells to check one cell against another... deucer Excel Worksheet Functions 1 January 11th 05 04:19 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"