Difference between revisions of "Sorting by question response labels"

From mtab wikisupport
Jump to: navigation, search
(Created page with "mTAB has always had a very useful sort feature in the Spreadsheet view, which allows a user to sort the data by selecting a range of cells within the same row or column, then ...")
 
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
mTAB has always had a very useful sort feature in the Spreadsheet view, which allows a user to sort the data by selecting a range of cells within the same row or column, then choosing '''“Sort…”''' from the dropdown '''Data''' menu.
+
mTAB has always had a very useful sort feature in the Spreadsheet view, which allows users to sort the data by selecting a range of cells within the same row or column, then choosing '''Sort''' from the Spreadsheet ribbon.
  
  
Now, users can also sort by the response text in the Spreadsheet using the same functionality.
+
[[File:Spreadsheet sorting-by-question-response sort.jpg|thumb|right|x400px]]Now, users can also sort by the response text in the Spreadsheet using the same functionality.
  
  
Simply select a range of cells in the response text column or the response text row, and choose “Sort…” from the dropdown Data menu.
+
Simply select a range of cells in the response text column or the response text row, and choose '''Sort''' from the spreadsheet ribbon.
  
  

Latest revision as of 16:00, 31 July 2013

mTAB has always had a very useful sort feature in the Spreadsheet view, which allows users to sort the data by selecting a range of cells within the same row or column, then choosing Sort from the Spreadsheet ribbon.


Spreadsheet sorting-by-question-response sort.jpg
Now, users can also sort by the response text in the Spreadsheet using the same functionality.


Simply select a range of cells in the response text column or the response text row, and choose Sort from the spreadsheet ribbon.


Choose either Ascending, Descending, or Original Order and click OK.


The responses will now sort according to your selection, along with the corresponding rows or columns of data.