From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

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

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

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

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

“

- [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…

Contents