#Excel keyboard shortcut to insert row how to
#Excel keyboard shortcut to insert row update
#Excel keyboard shortcut to insert row windows

#Excel keyboard shortcut to insert row update

Any rows below the inserted row will simply be shifted down, and any formulas referencing a cell in those moved rows will automatically update to the new cell location.

#Excel keyboard shortcut to insert row how to

The tutorial below will show you how to insert a new row in the exact location of your worksheet where you want that row to appear. Adding a New Row Between Existing Rows in Excel 2013 (Guide with Pictures)

Our article continues below with additional information on inserting new rows in Excel, including pictures of these steps. Click the Insert arrow, then Insert Sheet Rows.

Select the row number below where you want the new row.So check out our guide below to find out how you can insert a row into your Excel 2013 worksheet with just a few short steps.Ħ Additional Sources How to Add a New Row in Excel 2013 This structure also makes it easy to add new rows or columns when you discover that you need to add more data in a location within your currently existing data. The rows and columns in your spreadsheet also have labels to identify them, which are indicated by row numbers and column letters. This is due largely to the grid-like structure of the worksheet, which consists of columns that run vertically throughout the sheet and rows that run horizontally. One of the most useful features of Microsoft Excel 2013 is how easy it is to manipulate and sort data. But there are some options for adding rows in Excel that can make it much easier to include data within an existing dataset.

Shift + F3 − Opens the Excel formula window.Have you ever meticulously entered a lot of data into a spreadsheet, only to find that you need to add something between two existing rows? You may have solved this issue by cutting all of your data and pasting it one row lower, or you might have even deleted a bunch of data to make room for the new row. For example, C6.į7 − Spell checks the selected text or document.į11 − Creates chart from the selected data.Ĭtrl + Shift + − Enters the current time.Īlt + Shift + F1 − Inserts New Worksheet.Īlt + Enter − While typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.į5 − Goes to a specific cell. Below is the list of all the major shortcut keys in Microsoft Excel.Ĭtrl + A − Selects all contents of the worksheet.Ĭtrl + I − Italicizes the highlighted selection.Ĭtrl + U − Underlines the highlighted selection.Ĭtrl + 1 − Changes the format of selected cells.Ĭtrl + 5 − Strikethrough the highlighted selection.Ĭtrl + P − Brings up the print dialog box to begin printing.Ĭtrl + F9 − Minimizes the current window.Ĭtrl + F10 − Maximize currently selected window.Ĭtrl + F6 − Switches between open workbooks or windows.Ĭtrl + Page up − Moves between Excel work sheets in the same Excel document.Ĭtrl + Page down − Moves between Excel work sheets in the same Excel document.Ĭtrl + Tab − Moves between Two or more open Excel files.Īlt + = − Creates a formula to sum all of the above cellsĬtrl + ' − Inserts the value of the above cell into cell currently selected.Ĭtrl + Shift + ! − Formats the number in comma format.Ĭtrl + Shift + $ − Formats the number in currency format.Ĭtrl + Shift + # − Formats the number in date format.Ĭtrl + Shift + % − Formats the number in percentage format.Ĭtrl + Shift + ^ − Formats the number in scientific format.Ĭtrl + Shift + − Formats the number in time format.Ĭtrl + Arrow key − Moves to the next section of text.Ĭtrl + Space − Selects the entire column.Ĭtrl + - − Deletes the selected column or row.Ĭtrl + Shift + = − Inserts a new column or row.Ĭtrl + ~ − Switches between showing Excel formulas or their values in cells.į3 − After a name has been created F3 will paste names.į4 − Repeat last action.

#Excel keyboard shortcut to insert row windows

If you are familiar with windows operating system, you should be aware of most of them. MS Excel offers many keyboard short-cuts.