To insert and move rows down in Excel, select the row(s) you want to move, then hold down the Shift key, hover over the border until you see a four-sided arrow, and drag the row(s) down to the desired spot, releasing the mouse button first, then the Shift key to insert without overwriting data. This "Shift-drag" method creates space for the moved rows, pushing existing data down.
Right-click the cell above which you want to insert a new cell. Select Insert, and then select Shift cells right or Shift cells down.
Ctrl+' Copies a formula from the cell above the active cell into the cell or the Formula Bar. Ctrl+- Delete the selected column or row Ctrl+~ Switch between showing Excel formula or their values in cells. Ctrl+1 Displays the Format Cells dialog box. Ctrl+2 Applies or removes bold formatting.
In Microsoft Excel, Ctrl+F12 is a shortcut that opens the "Open" dialog box, allowing you to browse for and open an existing workbook file, similar to going to File > Open. It's a handy way to quickly access your saved files without using the mouse, though on some laptops you might need to press Ctrl + Fn + F12.
Alt+F2 is a keyboard shortcut most commonly used to open the Save As option in Excel.
In Excel, shortcut key Ctrl + R is used to fill the selected cell with active cells to the right. In Microsoft Excel and other spreadsheet programs, pressing Ctrl+R fills the row cell to the right with the contents of the selected cell.
Method 1: Shifting Cells Down With the Insert Function
Select the column that you want to move. To select more than one column, drag the pointer until you have selected the columns that you want. Do one of the following: In Datasheet view, drag the selected columns horizontally to the position that you want.
Drag the rows or columns to another location. Hold down OPTION and drag the rows or columns to another location. Hold down SHIFT and drag your row or column between existing rows or columns. Excel makes space for the new row or column.
The Ctrl+\ keyboard shortcut most commonly used to select cells with a static value or don't match the value in the active cell in Microsoft Excel. Below are other programs that use this keyboard shortcut and related information.
Ctrl + shift + L is the shortcut to enable filtering of selected cells in MS-Excel.
Using Ctrl + T to create a Table in Excel. If you have a chart or a pivot table or a VLOOKUP based on a range of data that might expand, using Ctrl + T is a great way to make sure the new rows are included in the chart or pivot table.
Some of the most commonly used function key shortcuts include: F1 to display help or the Office Assistant, F2 to edit the active cell, F3 to paste a name or function into a formula, and F4 to repeat the last action. F5 allows you to go to a cell or find data, F6 moves between panes, and F7 performs a spelling check.
Alt+F3 is a keyboard shortcut most commonly used to open the Create New Building Block window in Microsoft Word.
Word, Excel, PowerPoint: Press ctrl + f2 to show print options. Word, Excel, PowerPoint: Press ctrl + alt + f2 to show the Open window.
Shift+F12 is a keyboard shortcut to save an open document in Microsoft Office programs.
The Ctrl + F4 keyboard shortcut is primarily used to close the active tab or window within an application, making it great for quickly closing one document or webpage without exiting the whole program, unlike Alt + F4, which closes the entire application. In web browsers, it closes the current tab; in programs like Microsoft Excel, it closes the active workbook, leaving Excel open.
What are the function keys used for?