Excel keyboard shortcuts and function keys for Windows. This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Excel 2. This includes the access keys that you can use for ribbon commands. For Excel Online, see Keyboard shortcuts in Excel Online. Tips: To keep this reference available when you work, you may want to print this topic. To print this topic, press CTRL+P. To see an online workbook with this information, check out our spreadsheet on Docs. This workbook lets you scroll, sort, and filter for any key combination. And, you can also download it. Get these keyboard shortcuts in a Word document at this link: Excel 2. Windows keyboard shortcuts. Frequently used shortcuts. If you're new to the Ribbon, the information in this section can help you understand the Ribbon's keyboard shortcut model. The Ribbon comes with new shortcuts, called Key Tips, which you can make appear when you press the Alt key. The Ribbon groups related commands on tabs. For example, on the Home tab, the Number group includes the Number Format command. This table lists the most frequently used shortcuts in Excel 2. To do this. Press. Close a spreadsheet. Ctrl+WOpen a spreadsheet. Ctrl+OGo to the Home tab. Alt+HSave a spreadsheet. Ctrl+SCopy. Ctrl+CPaste. Ctrl+VUndo. Ctrl+ZRemove cell contents. Delete key. Choose a fill color. Alt+H, HCut. Ctrl+XGo to Insert tab. Alt+NBold. Ctrl+BCenter align cell contents. Alt+H, A, then CGo to Page Layout tab. Alt+PGo to Data tab. Alt+AGo to View tab. Alt+WOpen context menu. Prevent a Replacement Form Region from Being Used to Create a New Item or from Being Modified in the Forms Designer. Description. Shortcut Key. Bold toggle for selection. Ctrl + B. Italic toggle for selection. Ctrl + I. Underline toggle for selection. Ctrl + U. Strikethrough for. Detailed information on the features of Xara Designer Pro, the top of the range graphic design title from Xara. 1. Make sure you have the Windows 2003 Administration Tools installed. 2. In Active Directory Users and Computers go to View and select Advanced features. Shift+F1. 0, or. Context key. Add borders. Alt+H, BDelete column. Alt+H,D, then CGo to Formula tab. Alt+MHide the selected rows. Ctrl+9. Hide the selected columns. Ctrl+0. Top of Page. Ribbon keyboard shortcuts If you're new to the ribbon, the information in this section can help you understand the ribbon's keyboard shortcut model. When you press the Alt key, letters appear in small images, called Key. Tips, next to tabs and commands on the ribbon, as shown in the following image. You can combine these letters with Alt to make shortcuts called Access Keys for ribbon commands. For example, Alt+H opens the Home tab, and Alt+Q goes to the Tell me box. Press Alt again to see Key. Tips for the commands on any tab. Access keys for ribbon tabs. To go directly to a tab on the ribbon, press one of the following access keys: To do this. Press. Open the Tell me box on the Ribbon and type a search term for assistance or Help content. Alt+Q, and then enter the search term. Open the File page and use Backstage view. Alt+FOpen the Home tab and format text and numbers and use the Find tool. Alt+HOpen the Insert tab and insert Pivot. Tables, charts, add- ins, Sparklines, pictures, shapes, headers, or text boxes. Alt+NOpen the Page Layout tab and work with themes, page setup, scale, and alignment. Alt+POpen the Formulas tab and insert, trace, and customize functions and calculations. Alt+MOpen the Data tab and connect to, sort, filter, analyze, and work with data. Alt+AOpen the Review tab and check spelling, add comments, and protect sheets and workbooks. Alt+ROpen the View tab and preview page breaks and layouts, show and hide gridlines and headings, set zoom magnification, manage windows and panes, and view macros. Alt+WTop of Page. Work in the ribbon with the keyboard To do this. Press. Select the active tab of the ribbon, and activate the access keys. Alt or F1. 0. To move to a different tab, use access keys or the arrow keys. Move the focus to commands on the ribbon. Tab or Shift+Tab. Move down, up, left, or right, respectively, among the items on the Ribbon. The Down Arrow, Up Arrow, Left Arrow, or Right Arrow key. Activate a selected button. Spacebar or Enter. Open the list for a selected command. The Down Arrow key. Open the menu for a selected button. Alt+Down Arrow. When a menu or submenu is open, move to the next command. Down Arrow key. Expand or collapse the ribbon. Ctrl+F1. Open a context menu. Shift+F1. 0Or, on a Windows keyboard. Context key (between the right Alt and right Ctrl keys)Move to the submenu when a main menu is open or selected. Left Arrow key. Top of Page. Excel keyboard shortcut reference. Navigate in cells: keyboard shortcuts. To do this. Press. Move to the previous cell in a worksheet or the previous option in a dialog box. Shift+Tab. Move one cell up in a worksheet. Up Arrow key. Move one cell down in a worksheet. Down Arrow key. Move one cell left in a worksheet. Left Arrow key. Move one cell right in a worksheet. Right Arrow key. Move to the edge of the current data region in a worksheet. Ctrl+arrow key. Enter End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. If the cells are blank, move to the last cell in the row or column. End, arrow key. Move to the last cell on a worksheet, to the lowest used row of the rightmost used column. Ctrl+End. Extend the selection of cells to the last used cell on the worksheet (lower- right corner). Ctrl+Shift+End. Move to the cell in the upper- left corner of the window when Scroll Lock is turned on. Home+Scroll Lock. Move to the beginning of a worksheet. Ctrl+Home. Move one screen down in a worksheet. Page Down. Move to the next sheet in a workbook. Ctrl+Page Down. Move one screen to the right in a worksheet. Alt+Page Down. Move one screen up in a worksheet. Page Up. Move one screen to the left in a worksheet. Alt+Page Up. Move to the previous sheet in a workbook. Ctrl+Page Up. Move one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked cells. Tab. Cycle through floating shapes, such as text boxes or images. Ctrl+Alt+5, and then the Tab key repeatedly. Exit the floating shape navigation and return to the normal navigation. Esc. Top of Page. Format in cells: keyboard shortcuts. To do this. Press. Open the Format Cells dialog box. Ctrl+1. Format fonts in the Format Cells dialog box. Ctrl+Shift+F or Ctrl+Shift+PEdit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference. F2. Add or edit a cell comment. Shift+F2. Open the Insert dialog to insert blank cells. Ctrl+Shift+Plus (+)Open the Delete dialog box to delete selected cells. Ctrl+Minus (- )Enter the current time. Ctrl+Shift+colon (: )Enter the current date. Ctrl+semi- colon (; )Switch between displaying cell values or formulas in the worksheet. Ctrl+grave accent (`)Copy a formula from the cell above the active cell into the cell or the Formula Bar. Ctrl+apostrophe (')Move the selected cells. Ctrl+XCopy the selected cells. Ctrl+CPaste content at the insertion point, replacing any selection. Ctrl+VOpen the Paste Special dialog box. Ctrl+Alt+VItalicize text or remove italic formatting. Ctrl+I or Ctrl+3. Bold text or remove bold formatting. Ctrl+B or Ctrl+2. Underline text or remove underline. Ctrl+U or Ctrl+4. Apply or remove strikethrough formatting. Ctrl+5. Switch between hiding objects, displaying objects, and displaying placeholders for objects. Ctrl+6. Apply an outline border to the selected cells. Ctrl+Shift+ampersand (& )Remove the outline border from the selected cells. Ctrl+Shift+underline (_)Display or hide the outline symbols. Ctrl+8. Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. Ctrl+DApply the General number format. Ctrl+Shift+tilde (~)Apply the Currency format with two decimal places (negative numbers in parentheses). Ctrl+Shift+dollar sign ($)Apply the Percentage format with no decimal places. Ctrl+Shift+percent (%)Apply the Scientific number format with two decimal places. Ctrl+Shift+caret (^)Apply the Date format with the day, month, and year. Ctrl+Shift+number sign (#)Apply the Time format with the hour and minute, and AM or PM. Ctrl+Shift+at sign (@)Apply the Number format with two decimal places, thousands separator, and minus sign (- ) for negative values. Ctrl+Shift+exclamation point (!)Open the Insert hyperlink dialog. Ctrl+KCheck spelling in the active worksheet or selected range. F7. Display the Quick Analysis options for selected cells that contain data. Ctrl+QDisplay the Create Table dialog box. Ctrl+L or Ctrl+TTop of Page. Make selections and perform actions: keyboard shortcuts. To do this. Press. Select the entire worksheet. Ctrl+A or Ctrl+Shift+Spacebar. Select the current and next sheet in a workbook. Ctrl+Shift+Page Down. Xara Designer Pro Advanced Features. Xara Designer Pro's photo and bitmap handling is amongst the fastest to be found anywhere. It uses compression techniques that mean that Xara files including photos can be up to ten times smaller than equivalent images in other graphics programs, with enormous benefits for speed and usability. Plus Xara's unique non- destructive editing maintains the high quality of your original photo, however many times you edit it, and gives you the ability to undo any edits you've made to your photo, even after saving and reloading. As a result many people use Xara Designer Pro as their primary, general purpose image composition tool. Almost anything you can do to vector drawings you can also do to photos/bitmaps in Designer Pro. For example, you can edit the shape, alter the transparency, including graduated transparency, use bitmaps as fills on any shape, add a drop shadow, feather the edges and a lot more - all in real- time. Xara Designer Pro also includes a fully integrated, very fast photo editing tool which offers all the common photo editing features such as cropping, rotating, enhancing (brightness, contrast etc), red- eye removal and perspective correction etc with a fast, interactive, live- preview of all edits. Plus it includes an effective photo panorama creator and the innovative content aware scaling and zooming which allows images to be stretched or squashed while retaining the proportions of important parts of the picture. The Color Select controls allow you to alter selected colors in you photo, and then there are the erase tools; 'Magic' Erase and Photo Healing make it easy to seamlessly remove unwanted objects from your photo, and Magnetic Lasso and Background Erase can remove the background so you can place a selected object in your photo on a different background. Xara Designer Pro includes a fast bitmap tracer to help convert bitmaps to vector shapes. Xara Designer Pro also supports third party plug- ins such as Adobe Photoshop plug- ins to expand the range of available effects that you can apply to your photos. Xara Designer Pro supports all the common bitmap formats, for both import and export. Add to this the ability to handle multi- layer 3. Xara Designer Pro is a supreme image composition tool. Finally Designer Pro includes a collection of professionally designed, fully editable templates that include photo panels, photo grids and photo frames.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |