I have an iMac (OS 10.9.2) and MSOffice (2008). I am working on an Excel documen

Question

I have an iMac (OS 10.9.2) and MSOffice (2008). I am working on an Excel document that I did not create myself. At my office I work on a PC and the document sorts just fine. However, when I work with the document (downloaded from the same original source as the office-copy of the document) on my iMa!c at home, it will not sort correctly. I emailed the document to someone who also works on a Mac annd it sorted fine. We tried it multiple times and each time it sorted correctly on his computer and inccorrectly on mine. I am at a loss as to why the document won't sort correctly on my Mac but will on another Mac. Has anyone run into this issue in the past?

Thank you for any insight, it has been a frustrating couple of days!!!!

Explanation / Answer

Try this; Select & Copy any blank, unmodified cell Select the list of years [not including the column heading]. Tip: ass long as all records have content in that column, select just the first then use Shift+Command+Down Arrow. Go to Edit> Paste Special Click the Values option Click the Add option Click OK See how the list sorts now. aBTW: Contrary to what some might believe, it isn't necessary to select your entire list in order to sort it. As long as you have no empty columns/rows, preferably with headings in the top row, you can select any cell in the column you want to sort on then click the A-Z/Z-A button. IOW, Excel recognizes the extent of a valid list & the data will be sorted by row.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.