Excel hotkey insert row how to#
Excel hotkey insert row code#

This should add three new rows as shown below: Now press the same shortcut key as for single row: You may also select only a few cells of these rows: Suppose, we want to add three new rows between the existing row number 7 and 8. The example of adding multiple rows by shortcut Note that, if you right click on row number 7 and press the Insert option, it will add a new row between 6 and 7. This should add a new row with number 8 while that row becomes number 9. Adding a row by right click exampleįor adding a new blank row between 7 and 8, right-click on the number 8 or any cell of the row number 8 and click the “ Insert” option. Rather than selecting the whole row, you may also select a single cell e.g.

This should add a new blank row which number should be 8. The target is to add a new row between row number 7 and 8 as shown below:įor adding a single row by shortcut, select the row number 8 and press Ctrl Shift +. That is, press these keys together for adding a new row.įor showing how adding one or more row works, I have a worksheet that contains a few rows of data. With demos, you can also see the shortcut for adding rows.

Excel hotkey insert row how to#

In this tutorial, I will show you how to add one or multiple rows in Excel. May be worth trying.While working in Excel, you will require adding one or more rows in between the existing rows that contain text or other information.

Excel hotkey insert row code#

I found this with an internet search for 'disable excel 2003 keyboard shortcuts in excel 2013': I would guess that somewhere along the way, code like this was excecuted that turned off the 2003 keyboard accelerator keys. I might suggest that, even if you figure out how to re-enable the 2003 keyboard sequences, it would be wise to learn how to navigate using the 2013 ribbon and its keyboard sequences. When I did finally 'upgrade' to 2007, I decided I had better learn the new keyboard sequences to access the commands I need. In many ways, I am surprised that they have kept the 2003 menu key sequences active 10 years after 2003. I'm a late adopter (I was still using Excel 2002 until a year or two ago), so I am well aware that Microsoft does not feel a particular obligation to keep things 'backwards compatible'. Since the 2013 key sequences still work so that we know the command itself works, then something has disabled the 2003 version 'shortcut' keys. I am not aware of anything (except something in a macro somewhere) that can disable the 2003 menu keys. Write a macro to insert a new row ( is the command), then assign it to whatever key combination you want (see for how to do that).Īgain, I know that doesn't answer your original question, and I'm probably telling you what you already know - sorry. ( /ic will insert a column to the left if you're wondering.)ĥ. Select a cell, type /ir which will insert a row above (it's an old Visicalc command) - don't worry, it doesn't overwrite what's in the cell. Select a cell, press Control-Shift-= (or Control-+), then press the down arrow to select 'entire row' then press Enter to enter a row above.Ĥ. Select a cell, press Control-Space to select that row, then do as above.ģ. Select a row, press Control-Shift-= (or Control-+ using the number keyboard) to enter a row above.Ģ. There are other ways of inserting a row, which you've probably found yourself by googling round:ġ. I know that doesn't fix your problem, but maybe you could just use the new sequence? In English versions, Alt-H selects the 'Home' tab, where Insert Row is, so pressing (in sequence) Alt-H-I-R will insert a row. In ribbon versions of Excel (2007/2010/2013), pressing Alt brings up the letter for a ribbon tab (that's the F,H,N,P,M etc you're seeing). As a debugging step, I would try using the key sequence for the current version to see if something is causing the 2003 keystroke 'compatibility' function to be turned off, or if it is because you cannot access any commands through the keyboard, or if the insert row command itself has been disabled.Īlt-I-R is the pre-ribbon keyboard shortcut (i.e. So, Alt - H will access the home group, I brings up the Insert menu, and R executes the insert row command (at least in 2007, I don't know if it changes in 2013). As you press the keys, you should see the available command at each step. Alt still 'activates' the ribbon, and displays the key to access each ribbon group.

In 2003, alt 'activates' the menu, I activates the 'insert' menu, and r executes the 'insert row' command.Ģ007 and later also allows you to access the ribbon from the keyboard in much the same way, except that the letters for each group and command necessarily change. (Aside, is it because we still really prefer the old 2003 and earlier toolbar+menu user interface?). One thing I notice about those of us that use 'keyboard shortcuts' like this to access commands is that we seem to be 'stuck' with the Excel 2003 versions of the shortcuts.