Outline data by using shortcut keys:Outline data by using shortcut keys:The following is a table of commands available in Microsoft Excel for outlining data. The left column gives the desired action and the right column gives the associated keyboard shortcut.
| Desired Action | Keyboard Shortcut |
|---|---|
| Ungroup rows or column. | ALT+SHIFT+LEFT ARROW |
| Group rows or columns. | ALT+SHIFT+RIGHT ARROW |
| Display or hide outline symbols. | CONTROL+8 |
| Hide selected rows. | CONTROL+9 |
| Unhide selected rows. | CONTROL+SHIFT+( |
| Hide selected columns. | CONTROL+0 |
| Unhide selected columns. | CONTROL+SHIFT+( |
Contact us at infotechaccess@server.rehab.uiuic.edu