Learn 50 most important excel shortcut keys that streamline data entry, formatting, and navigation, saving you time and boosting your productivity.
Cut selection. Ctrl+X Go to the Insert tab. Alt+N Apply bold formatting. Ctrl+B Center align cell contents. Alt+H, A, C Go to the Page Layout tab. Alt+P Go to the Data tab. Alt+A Go to the View tab. Alt+W Open the context menu. Shift+F10 or Windows Menu key Add borders...
SUM. The SUM function automatically adds up a range of cells or numbers. To complete a sum, you would input the starting and final cells with a colon in between. Here’s what that looks like:SUM(Cell1:Cell2).Example: =SUM(C5:C30). AVERAGE. The AVERAGE function averages out the valu...
3. Using Shortcut (Suitable for masters) Step 1:Use Ctrl+C to copy the source cells and put the cursor on the paste location. Step 2:Press the following hotkey combinations to paste the values in the destination location. Pressing these hotkeys will bring the “Paste Special” dialogue b...
In such cases, you can insert a line break to display the entire string within the cell, as shown in the screenshot below. Adding line break Using shortcut Using the Wrap Text feature (Auto) After a specific character using the Find and Replace feature Removing line break...
Click the cell to select it. Selecting a Range of Contiguous Cells: Select a single cell. Left-click and drag the cursor in any direction to select multiple contiguous cells. Or holdShiftand press the arrow keys on the keyboard to drag the selection cursor over the cells. ...
1. The first step is to open the file in which you want to add the pivot table. You can also use the shortcut key Alt+D+P. Choose the file 2. Then it would be best to mention the cells where you want to add the pivot table. Then click on the arrow button at the right side...
Cursor will not highlight the selected cell Custom table style not working as expected Customize Slicer Buttons DASH CHARACTER PROBLEM Data Labels - Value From Cells - Text Not Updating Data Source path in Pivot Table changes to absolute on its own Data Validation Error in excel file date export...
Method 1 – Using the Keyboard Shortcut Steps: Select the cell or cell range you want to shift down. Press the shortcut Ctrl+Shift+”+”. The Insert box will pop up. Select Shift cells down in this box and click on OK. The dataset will now look like this. Read More: How to ...
To edit any cell in Excel, we can use the shortcut key which is one of the function key as F2. And the process of doing this is also very easy. We just have to put cursor and press F2. “F2” We will be seeing the different use in later on below examples. ...