I often use tables in Excel 2013. Adding a column on the right hand side of the table usually works fine--the new column is added to the table automatically.
However, when I add a column on the left-hand side of the table (or occasionally when I do something else crazy), I need to use Resize Table to redefine the dimensions of my table.
I'd like to be able to do this without taking my hands off the keyboard, ie. without using the mouse.
Opening the Resize Table dialog is simple: alt, jt, i. However, once the dialog is open, if I use the arrow keys to try to move the cursor so I can change one character in the address range, Excel moves the cursor on the spreadsheet, thinking I want to select a range of cells.
As such, unless I want to delete the entire data range with the dialog and retype it all (I don't), I have to use the mouse to move the cursor to the column address I want to change.
Is there any way to avoid using the mouse?