It's all about saving time whilst working in Excel.
Shift + F3 - Insert a function without having to navigate through the menuĪlt + F1 - Create an embedded chart of the data within the selected cell rangesį11 - Create a chart of the data in a selected range in a separate sheetĪlt + F8 - Use this to create, delete or edit a macro in your spreadsheet
EXCEL KEYBOARD SHORTCUTS FORMULA BAR CODE
Shift + Spacebar - Select the entire row in a worksheet without having to scroll across and clickĬtrl + Shift + U - Collapse or expand the formula bar at will using this formulaĬtrl + S - Quickly save your worksheet, it's advisable to do this every so often to avoid losing work should your programme crashĬtrl + C - Copy the information contained within one or more cellsĬtrl + P - Paste the information that you have copied, in Excel this will be done in the same amount of cells the data was copied fromĪlt + H, H - Choose a fill colour for your cell, handy if you like to colour code your worksheetsĬtrl + X - A simple shortcut to help you cut dataĬtrl + B - Make the data contained within the cell (or cells) boldĬtrl + I - Make the data contained within the cell (or cells) italicisedĬtrl + U - Make the data contained within the cell (or cells) underlinedĪlt + A - This shortcut allows you to open the data tab from the top navigationĪlt + W - Open the view tab from the top navigation using this shortcutĪlt + M - Open the Formula tab using this shortcutĬtrl + 1 - Open the format cells dialogue boxĬtrl + Shift + # - This shortcut applies the date format with day, month and year
Shift + Arrow Keys - This allows you to extend the selection of cells one by one until you have the amount you needĬtrl + Spacebar - Select the entire column in a worksheet without having to scroll up and click This shortcut will allow you to add new comments or edit existing ones.Ĭtrl - Shift - % - This one will add the percentage format to any numbered cellĬtrl + K - Add a hyperlink to a web page to any cell using this shortcutį7 - A quick way to run a spellcheck on your active worksheet Shift + F2 - You can add comments to cells for your own personal notes. Especially handy if you need to copy your data into another worksheet.
Clicking Ctrl + Z will undo your last action.Īlt + F8 - This quick shortcut opens up the macros dialogue boxĬtrl + ’ - Use this one to quickly copy the value from the cell that's above itĬtrl + Shift + 1 - If you need to format a cell into comma formats this shortcut does exactly thatĬtrl + Shift + Page Down Key - This one will quickly tab you across to the next worksheetĬtrl + Shift + Page Up Key - This one will do the reverse of the above and take you back to the previous worksheetĪlt + = - Select any numbered cells and use this shortcut to auto-sum themĪlt + Enter - If you need to add multiple lines of text in the formula bar, use the Alt key and Enter to avoid tabbing to the cellĬtrl + A - A quick way to select every cell within a single worksheet, no more dragging. Shift + F11 - This one will insert a new worksheet into your Excel documentĬtrl + 9 - Pressing this combination will hide the current row you're editingĬtrl + 0 - Similar to the above, but this one will hide the column instead of the rowĬtrl + Shift + 9 - This one will unhide the previously hidden row, best not to learn one without the other!Ĭtrl + Shift + 0 - Again, a quick way to unhide your previously hidden columnĬtrl + Shift + 4 - Use this little hack to format any numbered cell into currencyĬtrl + Shift + 7 - Apply a border around the outline or any selected cells with this shortcutį9 - Just this one key will recalculate your formulas, it couldn't be easierĬtrl + Z - If you tend to make a few mistakes whilst working in Excel, this one is invaluable.
EXCEL KEYBOARD SHORTCUTS FORMULA BAR PRO
Master these simple shortcuts and you will be an Excel pro in no time.Ĭtrl + 1 - This shortcut will allow you to format any selected cells or objectsį4 - Doing something repetitive? The F4 key will simply repeat your last action and eliminate the need to keep clicking over and over again.Ĭtrl + Shift : - This handy shortcut will input the current date into any selected cellĬtrl + Shift + : - Similar to the above, however, this variation will input the current time instead There's a lot of keyboard wizardry that you can employ in Excel that will make working on spreadsheets an absolute doddle. We're going to start our list off with a few super simple keyboard shortcuts.
0 kommentar(er)
