Open Format CellsCtrl +Shift dialog box +F Select All.. Ctrl +A Select entire row .. Shift +Space Select entire column Ctrl + Space Hide selected rows .. Ctrl +9 Hide selected columns Ctrl +0 Excel Tips and Tricks Cheat Sheet Keystroke Shortcuts Ctrl + s Saves your workbook Ctrl + c Copies highlighted cells Ctrl + v Pastes copied contents into new cells Ctrl + n Creates a new workbook Ctrl + p Opens the print option Ctrl + b Turns text bold Ctrl + i Makes text italic Ctrl + u Underlines text Ctrl + z Undo Ctrl + y Redo Whether you are a Microsoft Excel beginner or an advanced user, you'll benefit from these step-by-step tutorials. 10 handy ways to get more from Excel (free PDF) The tips, tricks and shortcuts Excel View PDF. OneDrive View PDF. OneNote View PDF. Outlook View PDF. PowerPoint View PDF. SharePoint Online View PDF. Microsoft Teams View PDF. Word View PDF. Yammer View PDF. Office downloadable guides - Mac version. Excel for Mac View PDF. OneNote for Mac View PDF. The new Outlook for Mac View PDF. PowerPoint for Mac View PDF. Advanced Excel 10 Step 3: As you browse through the Recommended Charts, you will see the preview on the right side. Step 4: If you find the chart you like, click on it. Step 5: Click on the OK button.If you do not see a chart you like, click on All Charts to see all the available chart types. Step 6: The chart will be displayed in your worksheet. Step 7: Give a Title to the chart. Ctrl + Shift + 7 - Apply a border around the outline or any selected cells with this shortcut 12. F9 - Just this one key will recalculate your formulas, it couldn't be easier 13. Ctrl + Z - If you tend to make a few mistakes whilst working in Excel, this one is invaluable. Clicking Ctrl + Z will undo your last action. 14. General Back To Index Open help F1 Undo last action Ctrl + Z Redo last action Ctrl + Y Copy selection Ctrl + C Repeat last action F4 Cut selection Ctrl + X Paste content from clipboard Ctrl + V Display the Paste Special dialog box Ctrl + Alt + V Display nd and replace with Find tab selected Ctrl + F Display nd and replace with Replace tab selected Ctrl + H Find previous match (after initial Download Excel Formulas Cheat Sheet PDF. Click on the button below to download the PDF with 102 Excel Functions. I have documented every Excel formula with its syntax and a good number of examples. Click here to download the PDF. Excel Formulas with Examples in an Excel Sheet (Free Download .xlsx File) Ctrl + Shift + Up Arrow. 25. To select all the cells below the selected cell. Ctrl + Shift + Down Arrow. In addition to the above-mentioned cell formatting shortcuts, let's look at a few more additional and advanced cell formatting Excel shortcuts, that might come handy. We will learn how to add a comment to a cell. When Excel Chooses the Wrong Format for Your Data • You want 00125678, not 125678 • The format of the cells that you are entering data in needs to be corrected. • Go to Format and click on Cells. Excel displays the Format Cells dialog box. • Click on the Number tab. • In the Category list, choose Text and click okay. Instead, either hit Ctrl+A or click the arrow button at the top corner of the spreadsheet to select all in seconds. 2. Add More Than One New Row Or Column. As you build and add to your spreadsheet, it's essential to be able to add multiple rows or columns at once rather than going the manual route. Hassle ends up here! The following fun Excel tricks will increase your mind's sharpn