Keyboard shortcuts: Excel — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Keyboard shortcuts: Excel

Get PDF file

by on
in Excel Training,Office Technology

Did you lose your outline levels in subtotal mode? Use Ctrl+8 to bring them back (or hide them) while keeping your actual subtotals visible.

Hide a row quickly (Hint: add Shift to Unhide) with Ctrl+9. It works on multiple rows, too. Rows are easily unhidden, so don’t use this to “secure” data.

Create a table from anywhere inside a well-built list with Ctrl+T. You don’t have to select all cells, as long as the table has no completely blank rows or columns.

Leave a Comment

 

Previous post:

Next post: