Re: How prepare Excel file to sort when rows are unequal height
- From: "Beth Melton" <bmelton@xxxxxxxxxxxxxxxxx>
- Date: Sat, 4 Feb 2006 19:15:01 -0600
This group is dedicated to Word issue and there are Excel specific
newsgroups for Excel related questions. But, since you're here,
Are you sure the message you are encountered is 'rows' and not merged
cells? If that's the case then you'll need to remove the merged cells
if you want to sort. Select the cell range you are using for sorting
and either click the "Merge and Center" command on the Formatting
toolbar or go to Format/Cells and on the Alignment tab clear the tick
in the "Merge cells" option. Note if it doesn't appear empty (if it's
shaded) then click the check box until it is an empty check box.
If you have any additional questions then they should be posted in one
of the Excel newsgroups. :-)
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
"resevmirejudsha" <resevmirejudsha@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:0F4A36EE-B468-401A-ABD4-6E0B6C859A82@xxxxxxxxxxxxxxxx
I would like to be able to sort Excel files by various columns, but
am unble
to do so because my rows are not all of equal length
.
- Prev by Date: Re: Extra Space Between Footnotes
- Next by Date: Re: Extra Space Between Footnotes
- Previous by thread: Re: word, the following error, "Data Error 47 of 94 93 f4 f5"
- Next by thread: Re: Incorrect word count (spanned over two pages).
- Index(es):
Relevant Pages
|
