(Msg. 1) Posted: Tue Nov 23, 2004 3:22 pm
Post subject: Data Sort Archived from groups: microsoft>public>excel>datamap (more info?)
I have an excel data base with 800 rows of data. Some of
the row heights are different because of the data entered
in some fields.
There are 10 colums headings.
I would like to sort the data based on the column headings.
I get the following message:
"The operations requires the merged cells to be identically
sized"
I do not understand what is the problem?
Allan Goldbach
(Msg. 2) Posted: Fri Nov 26, 2004 12:23 pm
Post subject: RE: Data Sort [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Allan
Some of the cells in your book are merged together, probably to create more
space for data display. You need to find them and split them. Then your sort
will work.
"Allan Goldbach" wrote:
> I have an excel data base with 800 rows of data. Some of > the row heights are different because of the data entered > in some fields. > There are 10 colums headings. > I would like to sort the data based on the column headings. > I get the following message: > "The operations requires the merged cells to be identically > sized" > I do not understand what is the problem? > Allan Goldbach ><!-- ~MESSAGE_AFTER~ -->
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office