Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to sort with merged rows
This is my delema. I have data that I need to input. At the same time I
would like to have a blank area below each contact so that I can add notes. The first problem is that when I try to sort, excel keeps saying "this operation requires the merged cells to be identically sized" Even if I do get by that problem, how can I keep the notes and the contact/data info above it together when I use a sort. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to sort with merged rows
Chris wrote:
This is my delema. I have data that I need to input. At the same time I would like to have a blank area below each contact so that I can add notes. The first problem is that when I try to sort, excel keeps saying "this operation requires the merged cells to be identically sized" Even if I do get by that problem, how can I keep the notes and the contact/data info above it together when I use a sort. My solution would be to put the notes in as a comment. Simply right click and select comments. This will bring up a "note pad" and mark the cell so that you know it has an attached comment. Another method would be to put the note in the same row as the contact name. gls858 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to sort with merged rows
But every contact is going to have a lot of data. And every contact will
have notes. I also want to keep it under one page so I can print it out for review on a daily basis. Below is my example. First row Bob Smith/IRA/Destination/Amount/Address/Phone Number Second Row- Notes: Bob Smith called to say that he received the paperwork. "gls858" wrote: Chris wrote: This is my delema. I have data that I need to input. At the same time I would like to have a blank area below each contact so that I can add notes. The first problem is that when I try to sort, excel keeps saying "this operation requires the merged cells to be identically sized" Even if I do get by that problem, how can I keep the notes and the contact/data info above it together when I use a sort. My solution would be to put the notes in as a comment. Simply right click and select comments. This will bring up a "note pad" and mark the cell so that you know it has an attached comment. Another method would be to put the note in the same row as the contact name. gls858 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to sort with merged rows
Chris wrote:
But every contact is going to have a lot of data. And every contact will have notes. I also want to keep it under one page so I can print it out for review on a daily basis. Below is my example. First row Bob Smith/IRA/Destination/Amount/Address/Phone Number Second Row- Notes: Bob Smith called to say that he received the paperwork. "gls858" wrote: Chris wrote: This is my delema. I have data that I need to input. At the same time I would like to have a blank area below each contact so that I can add notes. The first problem is that when I try to sort, excel keeps saying "this operation requires the merged cells to be identically sized" Even if I do get by that problem, how can I keep the notes and the contact/data info above it together when I use a sort. My solution would be to put the notes in as a comment. Simply right click and select comments. This will bring up a "note pad" and mark the cell so that you know it has an attached comment. Another method would be to put the note in the same row as the contact name. gls858 Where do the merged cells come into this? gls858 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to sort with merged rows
On the top I have all of the contact/data information.
Below that I have a blank merged cell row that I can imput the details. Even if I don't use the merged cells, I will still have the problem of not being able to sort the two rows together; right? I really appriciate your help. "gls858" wrote: Chris wrote: But every contact is going to have a lot of data. And every contact will have notes. I also want to keep it under one page so I can print it out for review on a daily basis. Below is my example. First row Bob Smith/IRA/Destination/Amount/Address/Phone Number Second Row- Notes: Bob Smith called to say that he received the paperwork. "gls858" wrote: Chris wrote: This is my delema. I have data that I need to input. At the same time I would like to have a blank area below each contact so that I can add notes. The first problem is that when I try to sort, excel keeps saying "this operation requires the merged cells to be identically sized" Even if I do get by that problem, how can I keep the notes and the contact/data info above it together when I use a sort. My solution would be to put the notes in as a comment. Simply right click and select comments. This will bring up a "note pad" and mark the cell so that you know it has an attached comment. Another method would be to put the note in the same row as the contact name. gls858 Where do the merged cells come into this? gls858 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to sort with merged rows
"Chris" wrote:
.. On the top I have all of the contact/data information. Below that I have a blank merged cell row that I can imput the details. Even if I don't use the merged cells, I will still have the problem of not being able to sort the two rows together In row2: Bob Smith/IRA/Destination/Amount/Address/Phone Number In row3: Notes: Bob Smith called to say that he received the paperwork (merged) Just venturing some thoughts .. Assuming the sample data above is in cols A to F, in row2 down .. Insert a new col A, unmerge & left align the merged cells in cols B to G Then put in A2: =INT((ROW(A1)-1)/2)+1 Copy A2 down to return a "double numbered row" series: 1,1,2,2,3,3 ... Kill the formulas in col A with an "in-place" copy paste special values The double numbered rows would stick together as long as we sort cols A to G with col A as the 1st sort key .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to sort with merged rows
Instead of merging the 2nd row for each record in cols B to G, try "Center
across selection". Select the cells, then Format Cells Alignment tab, under Text alignment - Horizontal's droplist, select "Center Across Selection" OK. You could do the above for the "2nd row" of the 1st record then use the format painter (double-click on the icon, with the centred-aross-selection cells selected) to paint the format to the rest. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort multiple rows without affecting others rows | Excel Discussion (Misc queries) | |||
Sort Macro to Exclude Blank Rows? | Excel Worksheet Functions | |||
SORT Header Row(s) | Excel Discussion (Misc queries) | |||
Select rows and sort based on type | Excel Discussion (Misc queries) | |||
How to sort merged cells | Excel Worksheet Functions |