Table Modes, Hiding Detail, Ranking etc... |
Key | Function Performed |
F2 | HIDE/SHOW the TOTAL column |
F3 | HIDE/SHOW EMPTY rows and columns |
DEL | Hide selected row or column |
F9 | RE-CALCULATE Table (restore to original after ranking, hiding, etc.) |
Ctrl+R | RANK on TOTAL Column |
Ctrl+Shift+A | RANK ALPHABETICALLY |
Ctrl+G | Show GAIN/LOSS (Shows Rank positions and flags any CHANGE from the PREVIOUS time period) |
Ctrl+L | Show Leverage (Shows % difference from Total column) |
Ctrl+H | Show Rate-of-change (Shows % difference from PREVIOUS time period |
Ctrl+N | Show netted rows ONLY (hide the rest) (Press F9 (Calculate) to restore table.) |
Ctrl+Shift+N | Show non-netted rows/cols ONLY (hide the nets) (Press F9 (Calculate) to restore table.) |
Shift+Comma | Hide rows below selected net 'level' (Select a row at the 'level' you wish to view, then right-click or press Shift+Comma) (Press F9 (Calculate) to restore table.) |
Shift+F9 | ZOOM out |
Ctrl+1 | Decrease the width of the side label column |
Ctrl+2 | Increase the width of the side label column |
Ctrl+3 | Decrease the width of the banner columns |
Ctrl+4 | Increase the width of the banner columns |
Navigating Variables Within the Variable Index |
HOME | Move selection to TOP of index |
PageUp | Move selection (up to) 10 LINES HIGHER |
PageDn | Move selection (up to) 10 LINES LOWER |
END | Move selection to BOTTOM of index |
Ctrl+C | COLLAPSE all SECTIONS in index |
Ctrl+E | EXPAND all SECTIONS in index |
LeftArrow | COLLAPSE selected SECTION |
RightArrow | EXPAND selected SECTION |
UpArrow | Move UP one line of the index |
DownArrow | Move DOWN one line of the index |
ENTER | Replace TITLE with selected variable (including those in the 'Banners' section) |
DoubleClick | Replace TITLE (or Banner if variable is in 'Banners' section) with selected variable |
Ctrl+I | Close the VARIABLE INDEX |
Ctrl+F | Opens the FIND window to search the index |
Navigating Variables Within Table View |
Ctrl+I | Open the VARIABLE INDEX (can also be opened by moving mouse pointer to the left of the window) |
F5 | Replace the title with the FIRST VARIABLE in the index |
F6 | Replace the title with the PREVIOUS VARIABLE in the index |
F7 | Replace the title with the NEXT VARIABLE in the index |
F8 | Replace the title with the LAST VARIABLE in the index |
Ctrl+F7 | Replace the title with the NEXT MARKED VARIABLE in the index (after running a scan for differences, zero bases, dubious or missing data) |
Ctrl+F | Opens the FIND window to search the index |
Ctrl+V | Flip back to the PREVIOUS table you viewed |
Alt+[number key] | Replace the banner with the n'th banner. eg: Alt+1 changes to the 1st banner, Alt+9 changes to the 9th banner, Alt+0 changes to the 10th banner |
Shift+Alt+[number key] | Replace the banner with the 1n'th banner. eg: Shift+Alt+1 changes to the 11th banner, Shift+Alt+9 changes to the 19th banner, Shift+Alt+0 changes to the 20th banner |
File, Print, Copy, Export & Program Options |
F1 | Open the HELP contents |
F10 | Moves focus to the FILE MENU to allow keyboard navigation |
Ctrl+P | PRINT Table |
Ctrl+C | COPY TABLE to clipboard |
Shift+Ctrl+C | COPY SELECTION to clipboard |
Ctrl+O | Opens the OPTIONS window where you can change various settings of U-Tab |
F12 | EXPORT Table to Excel |
Charts, Graphs, etc |
F11 | Show CHART |
Shift+F11 | Show MS-PowerPoint GRAPH |
Ctrl+F11 | Show MAP |
Shift+Ctrl+F11 | Show CORRESPONDENCE MAP |
Ctrl+K | Show CORRELATION MATRIX |
Significance Testing |
Ctrl+T | Quick SIG TEST (vs. each other) Labels each column alphabetically from A. Each cell is tested against all the other cells in that row and labelled with the letter corresponding to the column(s) that it is significantly higher than. |
Ctrl+Q | Quick SIG TEST (vs. all others) Tests each cell against the rest of the sample, then highlights those that are significantly higher or lower in green or red. |
Ctrl+Y | Yes/No SIG TEST If your banner contains sub-groups that split the samples into two groups (e.g. Yes vs No, or Positive vs. Negative), you can test the columns in groups of two. Each pair of columns is tested against each other and significantly high and low figures are highlighted green or red. |
Ctrl+Z | SIG TEST Selected column against all others Select a column then hit Ctrl+Z |
Ctrl+H | Horizontal SIG TEST mode |
Special Filtering |
F4 | BASE to POSITIVE answers |
Ctrl+F4 | BASE to POSITIVE answers (press again to switch off) |
Shift+F4 | BASE to EXISTING DATA only (press again to switch off) |
Creating New Variables |
Ctrl+M | Create a new MULTI-CODED VARIABLE |
Ctrl+S | Create a new SINGLE-CODED VARIABLE |
Ctrl+B | Create a QUICK BANNER |