dmaiox.blogg.se

Shift+Tab: Navigate to the previous cell.Ctrl+Up/Down Arrow: Do this if you want to move to the top or bottom cell in the column.Up/Down Arrow: Move a single cell up or down.Ctrl+Left/Right Arrow: These shortcuts are for moving to the farthest cell left or right in the row.Left/Right Arrow: Do this if you want to move one cell to the left or right.These shortcuts make it easier to navigate a cell or worksheet. Moving Around in an Excel Worksheet or Cell using Keyboard Shortcuts Alt+F11: Do you want to open the Microsoft Visual Basic For Applications Editor? Press these keys.Alt+F8: Do this if you want to create, run, edit, or delete a macro.Shift+F3: Press these keys to insert a function.Ctrl+Tab: Easily switch between open workbooks.Alt+H: If you want to go to the Home tab, then select this key.Alt+F: Want to open the File tab menu? This key will do it.Ctrl+F: Click this button if you want to search in a spreadsheet, or use Replace and Find.Alt+F1: This one is for creating an embedded bar chart based on select data on the same sheet.F11: For creating bar charts based on data you’ve selected on a separate sheet.Ctrl+F9: Press this key to minimize the workbook window.Ctrl+Shift+U: Collapse or expand the formula bar.Ctrl+F1: Do you want to show or hide the Ribbon? Press this key.Alt or F10: Press this key if you want to turn off key tips.Shift+F9: Perform calculations of all active worksheets.F9: For those who want to calculate every worksheet in all opened workbooks.Alt+Q: When you want to go to the “Tell me what you want to do” box.Ctrl+F2: Want to switch to Print Preview? This shortcut will get the job done.Shift+F11: If you want to insert a new worksheet then use this shortcut.For example, if you type “TWC” in a cell or change the color of a font, you can perform those same actions in another cell by clicking the F4 key. F4: This one is interesting because it allows the user to repeat the last command or action with just a single key.Ctrl+W: When it’s time to close a workbook.F12: If you want to open the Save As dialog box.Ctrl+S: Use this shortcut to save a workbook.Ctrl+O: This is for opening an existing workbook.Ctrl+N: All about creating new workbooks.