Num Lock+Minus Sign (-) on numeric keypadĬollapse the current selection (if it's expanded), or select the parent folder Move a window from one monitor to another.ĭisplay all subfolders under the selected folderĭisplay the contents of the selected folder Windows logo key +Shift+Left Arrow or Right Arrow Stretch the window to the top and bottom of the screen. Maximize the window to the right side of the screen. Maximize the window to the left side of the screen. Switch to the program that displayed a message in the notification area. Use the arrow keys to cycle through programs on the taskbar by using Aero Flip 3-D. Open the Jump List for the program pinned to the taskbar in the position indicated by the number.Ĭycle through programs on the taskbar by using Aero Flip 3-D. Switch to the last active window of the program pinned to the taskbar in the position indicated by the number. Start a new instance of the program pinned to the taskbar in the position indicated by the number. If the program is already running, switch to that program. Start the program pinned to the taskbar in the position indicated by the number. Search for computers (if you're on a network). Restore minimized windows to the desktop. Open a folder one level up if a folder is selected in the Save As or Open dialog boxĭisplay the System Properties dialog box. Select a button if the active option is a group of option buttons Select or clear the check box if the active option is a check box Replaces clicking the mouse for many selected commands Perform the command (or select the option) that goes with that letter Switch the keyboard layout when multiple keyboard layouts are enabledĬhange the reading direction of text in right-to-left reading languages Switch the input language when multiple input languages are enabled Prevent the CD from automatically playing View the folder one level up in Windows Explorer Open the next menu to the left, or close a submenu Open the next menu to the right, or open a submenu Perform the menu command (or other underlined command)Īctivate the menu bar in the active program Use the arrow keys to cycle through programs on the taskbar by using Aero Flip 3-DĬycle through items in the order in which they were openedĬycle through screen elements in a window or on the desktopĭisplay the address bar list in Windows Explorerĭisplay the shortcut menu for the selected item Use the arrow keys to switch between open itemsĬycle through programs on the taskbar by using Aero Flip 3-D Open the shortcut menu for the active windowĬlose the active document (in programs that allow you to have multiple documents open simultaneously) Select multiple individual items in a window or on the desktopĬlose the active item, or exit the active program Select more than one item in a window or on the desktop, or select text within a document Move the cursor to the beginning of the previous paragraph Move the cursor to the beginning of the next paragraph Move the cursor to the beginning of the previous word Move the cursor to the beginning of the next word You can also use the Refresh every option on the Data tab to specify how often you want Excel to automatically refresh the data in your workbook.Windows 7 Keyboard Shortcuts - printable cheatsheet Windows 7 Keyboard Shortcutsĭelete the selected item and move it to the Recycle Binĭelete the selected item without moving it to the Recycle Bin first This option allows Excel to refresh data in the background while you continue to work on other tasks. To improve performance, you can use the Enable background refresh option on the Data tab. This can be a slow process, depending on the size of the data set and the speed of the data connection. When you refresh data, Excel re-queries the data source and gets the latest data. You can also use the Refresh All command to refresh all the data in your workbook, including data from external data sources. If you are using an external data source, such as a Microsoft Access database, you can use the Refresh Data command on the Data tab to refresh the data in your workbook. Click the Refresh All button on the Data tab.Click the Refresh button on the Data tab.To refresh data in an Excel workbook, you can use one of the following methods: Note: These keyboard shortcuts work in all versions of Excel. Ctrl + V: Paste data from the clipboard into selected cells. Ctrl + K: Insert a hyperlink in selected cells.ġ1. Ctrl + H: Find and replace data in cells.Ĩ. Ctrl + G: Go to a specific cell in the worksheet.Ħ. Ctrl + F: Find and replace data in cells.ĥ. Ctrl + A: Selects the entire worksheet.Ĥ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |