Sorting data in Excel is messing up my rows!


I had a call from a client to say that several people were using the same worksheet, and somehow when the records were sorted, the records were no longer altogether with rows going astray. If you just click in one cell in a data area to be sorted, and then sort, the whole data area will be sorted. If you select a whole column and then try and sort you will get a message coming up asking whether you want to expand the selection or just sort on that column. Similarly, if you select a few cells in one column, the same message will appear – usually you do want to expand the selection and sort the whole data list.

The problem that was occurring was that people were selecting a subset of the data and then asking it to sort. The sort was then being performed just on the…

View original post 149 more words


About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 for every time someone says "If only I'd known that." ....
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s