These 46 Pro Excel Tips Will Transform You Into a Spreadsheet Magician Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Ctrl+9 —Hides the current row. Ctrl+F6 —Switches between open workbooks (that is, open Excel files in different windows). Ctrl+` —That's the accent mark, up by the 1 key.