KeyTips are special key combinations you can use to quickly get to a command on the ribbon by pressing a few keys, regardless of where you are in Access. You can navigate the ribbon with just the keyboard. When selected, each ribbon tab displays a different ribbon, which is made up of groups, and each group includes one or more commands. The ribbon is the banner at the top of Access, organized into tabs. Top of Page Navigate the ribbon with only the keyboard Open the Find tab in the Find and Replace dialog box in the Datasheet View or Form View. Open the Page Setup dialog box (for forms and reports). Open the Print dialog box (for datasheets, forms, and reports). Go to a specific record in the Datasheet View.Īlt+F5, then, in the record number box, type the record number and press Enter Move to the next or previous field in the Datasheet View. Switch to the Form View from the form in the Design View. Switch between Edit mode (with insertion point displayed) and Navigation mode in the Datasheet View or Design View. Move the focus to a different pane of the window. (To move to a different ribbon tab, use KeyTips or the arrow keys.)ĭisplay the shortcut menu for the selected item. Select the active tab of the ribbon and activate KeyTips. This table itemizes the most frequently used shortcuts in Access desktop databases. Navigate in the Print Preview and Layout Preview Work with text boxes, combo boxes, and list boxesĬommon shortcuts for the Design, Layout, and Datasheet views Work with menus, dialog boxes, wizards, and property sheets Navigate the ribbon with only the keyboard This topic assumes that JAWS users have the Virtual Ribbon Menu feature turned off. Keys for other layouts might not correspond exactly to the keys on a US keyboard.Ī plus sign (+) in a shortcut means that you need to press multiple keys at the same time.Ī comma sign (,) in a shortcut means that you need to press multiple keys in order. You can press the Home key to move the cursor back up quickly.The shortcuts in this topic refer to the US keyboard layout. Note that the first method does come with a minor caveat - your view/cursor will move to the bottom of the spreadsheet (which does not happen with the Ctrl+Y method). you don't use the context menu button to modify anything). All subsequent work can be done purely with the keyboard, so long as you only use it to enter data (i.e. This means that you do need to use the mouse, but only the first time. To repeat the "auto-fill down" step, so long as you only enter data and press enter, you can repeat it by pressing Ctrl+Y. Once you fill in the cell you want to auto-fill downwards, double-click the bottom right corner as usual. Method 2 (my preferred way, one-time mouse interaction) Then, press Ctrl+D to "fill down" into the entire range from the top cell. After you enter the data in the cell, press Ctrl+Shift+End to select from the current cell to the end of the range that would be auto-filled. Method 1 (alternate, but it works with no mouse interaction)Īnother way to accomplish this is to use a combination of the fill-down shortcut and the select all in range. Should you go the macro route, the AutoFill method on any Range object should be all that you need. Outside of these two methods, I do not believe you can accomplish what you seek without the use of macros or add-in modules. I highly suggest you try both methods and then determine which works best for you. Unfortunately, both methods do have their own caveats, since Excel does not provide an all-in-one keyboard shortcut for auto-fill. I provide you with two methods to accomplish what you want.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |