After sorting, the other corresponding row data won’t be sorted so your data would become incorrect information. Only the data in the highlighted column will be sorted. This option sorts one single column only and ignores the rest of the data, i.e., when you have multiple columns next to each other, non-highlighted columns will stay as they are. This option enables you to do the same sorting as above. ![]() Read the message carefully, or click Cancel to start again. ![]() The Sort Warning message comes up when you highlight the column. Otherwise, your data can get mixed up easily. DO NOT highlight the whole column when sorting. Tip: WARNING! Be careful when you perform sorting. Tip You don’t need to highlight the entire column.Ĭlick on Sort & Filter > Sort A to Z or Sort Z to A button. Select any cell in the column that you wish to sort by Sort by 1 column You have multiple columns and wish to sort by a particular column. 23Ĭlick any cell > Click on Sort & Filter > Sort A to Z or Sort Z to A button 15 Making the font size smaller to show all labels. 14 Making the chart/graph bigger to view hidden labels. Table of Contents *All tips are based on Microsoft Office 2007.
0 Comments
Leave a Reply. |