I work with tons of tables inside Excel and sometimes there are requirements to do some simple but repetitive activities on a table that I have always wanted to automate. These tasks include inserting a row, inserting a column, deleting a row, deleting a column, hiding a column or row etc. So this blog post will be all about these simple tasks. Our dataset looks like one below.
Inserting a Row and Column
This is one of the easiest shortcut to remember.
To insert a row at current location: ALT + I + R (like (I)nsert + (R)ow)
To insert a column at current location: ALT + I + C (like (I)nsert + (C)olumn)
Our excel will show an output like below.
Deleting a Row or Column
If adding was this easy. Now we might want to delete rows ad columns too right? There are two mode for me. Here is the lengthy route. If you press ALT+ E + D, you will get the following dialog.
Now, using the dialog box can be easy. We can still use some of the hotkeys on the dialog. Check the row and column. So the lengthy route to:
Delete row: Alt + E + D + R + Enter
Delete column: Alt + E + D + C + Enter
I have already calling this as lengthy approach. So there must be something simpler right. You guessed it correct. Use the below shortcuts.
Delete row: Shift + Spacebar + Ctrl + -
Delete column: Ctrl + Spacebar + -
That seems to be slightly lesser keystrokes right? Found it interesting? Let us move to the next shortcut.
Hiding Row or Column
What we want to achieve is to hide column D and Row 12.
So here are the shortcuts for the same.
Hide a Row: CRTL + 0
Hide a Column: CTRL + 9
The last part of this tips would be, to unhide the row or column – select the rows and right click to Unhide. Do you know of a shortcut to unhide columns or rows? Drop a line and let us learn from each other. Hope you enjoyed this tip today.