Insert column excel shortcut
In Excel 2003, yo u can select the worksheet tabs you want to delete (if you want to delete multiple worksheets in a workbook, hold the Ctrl key and select them one by oney), then press ALT+ E + L keys to delete them. Hold Shift key then press F11 key, then a new blank worksheet is inserted in the front of the active worksheet.
Insert column excel shortcut free#
Click forģ00 handy Excel add-ins, free to try with no limitation in If you want to insert blank rows in every other row, you may need to insert them one by one, but the Insert Blank Rows & Columnsof Kutools for Excel can solve this job in seconds. Select the entire row/column you want to delete, if you want to delete several rows/columns at once time, press Ctrl key to select them, then press Ctrl+ - keys delete.īatch insert blank rows or columns in a specific interval in Excel range Tip: If you want to add several rows/columns at once time, for example, insert five rows/columns, select entire five rows/columns by clicking Ctrl key first, then press Ctrl + + keys or Shift + Ctrl + + keys, then new blank five rows/columns are inserted. If your keyboard has no Keypad, you can press Shift + Ctrl + + keys to insert rows or columns. Select an entire row/column that you want to add a row/column above or left of it, and then press Ctrl + + keys, then a new blank row/column added above/left of your selected row/column. But actually, you can easily use shortcut keys to quickly insert or delete row/column/tab as you need in Excel. In daily Excel working, to insert or delete a row or a column or a sheet tab is usually used.
Select from current cell up to the first cell (A1) Select from current cell up to the last cell ( the last used column and row) When editing a cell, convert a formula to an array Go to the first cell of active worksheet (A1)ġ) select multiple cells, enter a formula, press CTRL+ENTER to autofill formula for all other cellsĢ) when editing a cell, press CTRL+ENTER will exit editing and stay focus in the editing cell Go to the lsat cell of active worksheet (last used row and last used column)
Insert column excel shortcut windows#
Maximize active Excel windows or revert to the previous size Open “Find and Replace” box and choose “Replace” tab
Excel Short keyĬopy value of the above cell and paste to current cell Some keys do not work in older version of Excel, as each Excel version adds additional shortcut key, but the majority would work. I referred to the Microsoft website for the Excel shortcut key, removed some unimportant Excel shortcut key, and then combined with some Windows short cut key that are also applicable in Excel and finally reordered and changed description of each shortcut key.
Excel Shortcut keyīelow is a table that summarizes most Excel shortcut key. This Excel tutorial summarizes a list of Excel shortcut key as well as Windows short cut key which are applicable to Excel.