Thursday, 26 October 2017

Hints - Microsoft Excel - Sorting a Range of Cells

Sorting a Range of Cells



Clair  asked if it is possible to sort a range of cells, and just that range. In other words, not to sort entire rows or entire columns. 

The answer is a resounding "yes," 



    As an example, let's assume you want to sort the cells in the range of C10:F40, based on the values in column D. To do this, follow these steps:







    Microsoft Accredited IT Training Provider
    Microsoft Certified Training Materials

    IT Training Courses delivered by Microsoft Accredited Facilitators
    Microsoft MOS Test Centre London




    No comments:

    Post a Comment