![]() Let's say you want column C to be column A * column B in your worksheet. Protecting Against Errors with IF functions (Excel 2007 and later) Shift + Spacebar: Selects an entire row in a worksheet.Ĭtrl + Shift + Spacebar: Selects the entire worksheet. ![]() Spacebar: In a dialog box, performs the action for the selected button, or selects or clears a check box.Ĭtrl + Spacebar: Selects an entire column in a worksheet. Page Up: Moves one screen up in a worksheet.Īlt + Page Down: Moves one screen to the right in a worksheet.Īlt + Page Up: Moves one screen to the left in a worksheet.Ĭtrl + Page Down: Moves to the next sheet in a workbook.Ĭtrl + Page Up: Moves to the previous sheet in a workbook.Ĭtrl + Shift + Page Down: Selects the current and next sheet in a workbook.Ĭtrl + Shift + Page Up: Selects the current and previous sheet in a workbook. Page Down: Moves one screen down in a worksheet. You can then use the arrow keys to navigate through the ribbons.Īlt: Pressing alt will overlay the ribbon with numbers and letter which you can use to navigate the different tabs and sub menus.Īlt Gr: This stands for Alternative Graphic and most keyboards have an Alt Gr button that can be used to give access to a series of symbols and accented letters without having to go through a menu to get them.Ĭtrl + Shift + Home: Extends the selection of cells to the beginning of the worksheet. If you have just undone something it will replace it otherwise it will repeat the last action you did.į5: Go to a particular cell or named range.į10: Select the active ribbon. ![]() Go to Word shortcuts that also work in ExcelĬtrl + Y: Repeat last action / redo. Most of the basic key commands were covered there and you can follow the link to see them. Many of these work for Excel and other programs. In one of our Smatterings Time Savers sections we wrote about shortcut keys that you can use in Microsoft Word. These are some useful shortcut keys that you can use in Excel to reduce the need to switch back and forth between the keyboard and mouse and so save you time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |