View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
 
Posts: 209
Default 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