Ctrl+Shift+=
insert cells command
Cells Command
the button used to move the contents of a cell to the right three cells
To cut a cell or range of cells in Excel, you can use the "Cut" function by selecting the cell or range of cells you want to cut, then either right-click and select "Cut" or use the keyboard shortcut Ctrl+X.
If you insert cells into the range C1:D10, shifting the cells to the right, the data previously in cell E5 will move to cell F5. This occurs because the insertion of new cells pushes all existing cells in the specified range to the right, thereby altering their locations.
F11 is the keyboard shortcut for creating a chart from the selected cell range
Select the cell where you want the new cell to be. Right click and pick insert, and there will be a shift cells down option which will do it for you.
To put comments into a cell, with the cell selected go to the Insert menu and pick Comment. You could also right click on the cell and pick Insert Comment from the shortcut menu that appears.
To insert rows, you select the row(s) where you want the new row(s) to go. You can even just select a cell in the row(s) you want. So if you wanted to insert 2 new rows between row 1 and row 2, you could select a cell in row 2 and row 3, or select both of those rows. Right click, and pick Insert and choose to insert an Entire row. The existing rows 2 and 3 will be pushed down to become rows 4 and 5, and 2 news rows will be in row 2 and row 3. To delete a range, select the cells in the range. To delete the contents, press the Delete key. To get rid of the cells completely, right click and pick Delete on the shortcut menu. You can then choose to move the cells below up into the position where the range was, or move the cells to the right of them into the position of those cells.
The keyboard shortcut to format the selected cell or range to italic in Excel is Ctrl + I on Windows or Command + I on Mac. This shortcut toggles the italic formatting on and off for the selected text.
The autosum button will insert the function "=sum(...)" and suggest (highlight) a range it finds most likely - usually adjacent cells above, or to the left, of the cell where you insert the formula.
Insert Options