TIPS & TRICKS
Hiding Columns and Rows in Excel
Need to present a summary spreadsheet without showing the details needed to make them? Or do you need to print or view a portion of a large spreadsheet without being distracted by its intermediary sections? Hide or unhide rows and columns in Excel by following these steps:
- To hide a row(s), select the cells and then press Ctrl+9. To unhide a row(s), select cells containing the range of the hidden row(s) and press Ctrl+Shift+9.
- To hide a column(s), select the cells and press Ctrl+0. To unhide a column(s), select the cells containing the range of the hidden column(s) and press Ctrl+Shift+0.
- Need to unhide rows and columns on a whole worksheet? Press Ctrl+A to select all cells in the sheet. Press Ctrl+Shift+9, and then press Ctrl+Shift+0.
The Four Pack Heats Up!
Share this 4-day pass with up to 4 staff for Word, Excel, PowerPoint, Outlook and Access classes. WIN BIG and call for details!
You're Cool with The Classic Eight!
Share up to 8 classes with up to 8 colleagues. Attend Word, Excel, Access, PowerPoint, and Outlook End User classes and SAVE!!