Insert, delete, hide, and unhide columns and rows rapidly

Keyboard Shortcuts

Avoid menu commands and use the mouse to insert and delete, as well as hide and unhide, columns and rows. Before inserting, deleting, and hiding, right-click the columns or rows you want to change and then select options from the pop-up menu. To unhide, select surrounding columns or rows before right-click and unhide.

- [Voiceover] There're quick easy ways…to insert and delete columns and rows, or cells,…also to hide and unhide columns and rows.…You really need the menu system…in getting to these features.…I want to add a new column to the left of column C.…I don't have to click column C.…I'll simply point the mouse toward that panel…where the letter C is and right-click,…and there's that shortcut menu, Insert…to get a new column to the left.…Let me undo that with Ctrl+Z.…Suppose I wanted a new column to the left of column C…and also to the left of column F.…

I'll click column C, and now with the Control key…I'll click column F, and then right-click immediately…and Insert.…We're getting two new columns to the left that way.…Let's again undo.…Occasionslly you use a keystroke shortcut.…If I click a column letter, for example C, and press Ctrl+,…we simply get a new column to the left immediately.…Or if I click row 5 and click Ctrl+,…we get a new row above row 5 immediately.…At a later time we might come back and say,…"I don't need row 5."…

Resume Transcript Auto-Scroll

Author

Released

4/21/2016

Excel expert Dennis Taylor helps Excel 2016 users take their spreadsheet skills to the next level with this collection of tips and tricks. He begins with his top 10 productivity boosters, and then highlights navigation, display, and selection techniques to keep you moving quickly.

The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time? Make sure to check out the "10 Tiny Tips" chapter for a quick productivity boost.