Excel Keyboard Shortcuts - A collection of 200+ Excel Keyboard Shortcuts that will make you super fast in Excel. Move to the Top Edge of Data Region.
Love ’em or loathe ’em, spreadsheets are the lifeblood of any Finance department. Why not make it as easy on yourself as possible?
Here’s a collection of the best Excel shortcuts – bet you don’t know them all: CTRL — Shift & Outline border to the selected cells. CTRL Shift # — Change Date format with day, month and year.
CTRL Shift @ — Change Time format with hour and minute, AM or PM. CTRL Shift: — For the current time.
CTRL; — For current date. CTRL 9 — Hide selected rows. CTRL 0 — Hide selected columns. CTRL ` — Display Formulas/Alternate in the worksheet. CTRL+K — To insert Hyperlink. CTRL+H — Opens up the Find and Replace dialog box.
CTRL+R — Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. CTRL+7 — Hides or displays the standard toolbar. ALT+F1 — This creates a chart out of the data in the current range (selected cells). This is the most well-known feature of Excel, and now you know a new way to use it! ALT+SHIFT+F1 — Inserts a new worksheet into a workbook. F6 — Switches between the worksheet, Ribbon, task pane, and Zoom controls.
This is probably the most useful shortcut of all. This cool shortcut is also the most beloved to all the anti-mouse users out there. SHIFT+F6 — The reverse of the F6 shortcut. CTRL+F6 — Switches to the next workbook window when multiple workbook windows are open. CTRL+SHIFT+$ — Applies the currency format to the selected cells. CTRL+` — Alternates between showing the value of a cell and the formula in the worksheet.
Great for complex worksheets. CTRL+D — Fill down command on the selected cells.
Fill down copies the content and format of the topmost cell into the cells below. CTRL+R — Fill right command on the selected cells. Fill right copies the content and format of the leftmost cell to the cells to the right. It’s worth posting a copy of this list next to every Finance PC. It can save time and frustration. Any additional shortcuts you’d like to share?
Pass them along here. Ctrl ` is also repeated.
This list includes several shortcuts I didn’t know, so thanks! I just tried Ctrl 9 and Ctrl 0 for hiding and discovered that adding the Shift key Un-hides. Ctrl F and Ctrol H open the same dialog box but default to different tabs – F for find, H for replace. Here are some of my most favored favorites: Shift + spacebar selects the current row(s) Ctrl+ spacebar selects the current column(s) Combine these with: Ctrl – (minus) to delete the selected row or column Ctrl + to insert the number of rows/columns that are highlighted. If you have already copied (Ctrl C) or cut (Ctrl X) rows or columns, then the Ctrl + acts as Insert-Paste. Another of my favorites is Ctrl ‘ (apostrophe) which copies the contents of the cell directly above. It doesn’t copy formatting.
I guess the delete and insert ones above aren’t as useful if you are working on a laptop keyboard, but I’m usually working on a standard keyboard and use them daily. F2 – allows quick access the contents of a cells also available/evident in the formula bar. F4 – changes a cells reference types only when the cell is in EDIT mode (absolute, relative references, and mixed) where formulas are evident. F2 followed by F4 is a quick way to switch a cells reference types. CTRL + Insert: another way to copy cells contents SHIFT + Insert: another way to paste cells contents CTRL + P: Print CTRL + O: Open file dialog CTRL + B: Bold formatting CTRL + I: Italic formatting CTRL + U: Underline formatting CTRL + F10: Maximize wb CTRL + F9: Minimize wb.etc all very handy. CFO Daily News, part of the Catalyst Media network, delivers the latest financial news, best practices and proven strategies to help CFOs control costs and increase revenue while keeping their companies in compliance with IRS and other federal and state regs.
A trusted source within the industry, CFO Daily News is counted on by more than 437,000 financial professionals. CFO Daily News’ editorial staff is lead by veteran Editor-in-Chief Jennifer Azara. Through its e-newsletter, CFO Daily News provides a weekly dose of the latest headlines impacting the world of Finance and Accounting.
The Ultimate Guide to Office 365 We can always use a few shortcuts to save time. Here are eight useful keyboard shortcuts to speed up your work in Excel. Add border to cells PC: Alt+H, B Mac: +Option+0 If you want to add an outline (outer) border around your selected cells, just use this quick shortcut. Insert table PC: Ctrl+T MAC: ^T Use this shortcut to quickly insert a table. You will be asked where the data is for your table, and then your table will automatically be created. Select entire row PC: Shift+Space Mac: ⇧+ Space Selecting an entire row can be a great timesaver. Use this shortcut to select a single entire row.
Bonus: Hold down Shift and the up/down arrows to select multiple rows. Select entire column PC: Ctrl+ Space Mac:⌃+ Space Likewise, selecting entire columns can be a great timesaver too. Bonus: Hold down Shift and the left/right arrows to select multiple columns. Hide rows PC: Ctrl+ 9 Mac: ⌃ 9 Sometimes it can be useful to hide rows in your worksheet. If you don’t want certain sensitive data to be visible, you can hide them (hidden rows and columns do not print).
Hide columns PC: Ctrl+ 0 Mac: ⌃+ 0 7. Copy formula from the cell above PC: Ctrl+ ‘ Mac: ⌃+ ‘ Copying the formula from the cell above is a great way to make an exact copy of a formula. Cell references will remain unchanged. Copy value from the cell above PC: Ctrl+ Shift+ ” Mac: ⌃+ ⇧+ ” If you don’t want to copy the formula from the cell above and you just want the value, you can use this useful shortcut.