Underlines all cells in highlighted section. Puts italics all cells in the highlighted section. Pastes everything copied onto the clipboard.Ĭuts all cells in the highlighted section.Ĭhanges the format of the selected cells.īolds all cells in the highlighted section. Underlines all cells in the highlighted section. Then press Ctrl+ R to fill them with the contents of the original cell. To fill more than one cell, select the source cell and press Ctrl+ Shift+ Right arrow to select multiple cells. Fills the cell to the right with the contents of the selected cell. Puts italics on all cells in the highlighted section.įill right. Then press Ctrl+ D to fill them with the contents of the original cell. To fill more than one cell, select the source cell and press Ctrl+ Shift+ Down arrow to select multiple cells. Fills the cell beneath with the contents of the selected cell. Move to the next cell, to the right of the currently selected cell.īold all cells in the highlighted section.Ĭopy all cells in the highlighted section.įill down.

Thanks for reading CFI’s guide to Excel shortcuts for your PC and Mac keyboard! By taking the time to learn and master these keys, you’ll significantly speed up your financial analysis.Some of the Microsoft Excel shortcut keys below may not work in Excel 365. If you want to learn these keyboard shortcuts with your own personal online instructor, check out CFI’s Free Excel Crash Course! You’ll receive step by step instructions and demonstrations on how to avoid the mouse and only use your keyboard. Excel is quite robust, meaning there are a lot of different tools that can be utilized within it, and therefore there are many skills one can practice and hone.

You may also want to check out our section on Excel formulas or the Excel formulas cheat sheet. If you follow our tips and tricks below you’ll be able to master these shortcuts on Windows or Mac operating systems. Your mouse will be taken away and you’ll be expected to learn financial modeling with only keyboard shortcuts. The first thing you’ll do if you’re hired as an investment banking analyst is take a series of intense Excel training courses.

These are critical for careers in investment banking, equity research, FP&A, finance, accounting, and more. To be more productive, faster, and more efficient when building financial models or performing financial analysis, it’s important to know the main keyboard shortcuts in Excel.

Microsoft excel shortcut keys 2013 pdf