[AI] Useful short cuts of XL.
Hello Friends, Here are some useful shortcuts of XL taken from tutorials by John Wilson. i found them really handy. 4.1. Keyboard Shortcuts and Hot Keys for Excel I strongly recommend that you carefully study the training tapes which come with your particular screenreader to accustom yourself with the specialist shortcuts for operating a spreadsheet which it provides. Nonetheless, I have provided below in this section most of the main and more important screenreader hot keys for the JAWS, HAL and Window-Eyes screenreaders, plus a list of Excel's own hot keys for navigating in and carrying out commands in spreadsheets. 4.2. Excel General Shortcuts Whether the below hot keys do anything when you press them will, of course, depend on what type of worksheet environment you are in, what stage you are at and whether or not you have highlighted any cells, etc. This is a short list of Excel's own most useful and frequently used shortcuts which should prove particularly helpful for those who prefer shortcut keystrokes over using menu choices. However, it is a fraction only of the Excel general shortcuts. For a more exhaustive list of these shortcuts, see Appendix 1. Press BACKSPACE: To delete the character to the left of the insertion point. Press F1: To invoke Excel's online help system. Press F2: To be able to edit the contents of the current cell. Press F8: To turn on extending a selection by using the ARROW keys. Press F11: To create a chart which uses the current range. Press F7: To invoke the spell-checker for any text in your spreadsheet. Press F9: To calculate all sheets in all open workbooks. Press right, left, up or down ARROW keys: To move one cell at a time in any direction. Pressing TAB also moves you one cell at a time along a row from left to right and SHIFT TAB moves you backwards. Pressing ENTER after completing a cell moves you down a row in the current column. Press PAGE up or down: To move through a spreadsheet upwards or downwards respectively by 25 lines each press. In some set-ups this may move you by only 23 lines. Press ALT =: To generate an auto sum. Press =: To then be able to type a formula into the current cell. Press CONTROL SPACEBAR: To highlight/select the whole of the column the cursor is currently in. Press SHIFT SPACEBAR: To highlight/select the entire row the cursor is in. Press ALT ENTER: to insert a carriage return and start a new line in the same cell. Press CONTROL F: To bring up the find dialogue box. Press CONTROL 1: To display the format cells dialogue box. Press CONTROL with any of the ARROW keys: To move to the edge of data regions, e.g. CONTROL down ARROW when in the middle of row D of a page with several rows in it will jump you to the last cell in row D with data in it. Press CONTROL PAGE down: To switch to the next spreadsheet page including any with charts on them. Press CONTROL PAGE up: Opposite of the above. Press ALT PAGE down: To move right one screenful of information, which will normally mean jumping 11 rows to your right each time you do this. Press HOME: To jump to the beginning of the current row. Press END and then left ARROW: To jump to the end of the current row. Press CONTROL HOME: to jump to Cell A1. Press CONTROL END: to jump to the last cell in your current data range. Press CONTROL ;: To insert the date in the current cell. Press CONTROL SHIFT 7: To obtain a border format outline. Press CONTROL SHIFT -: To remove a border. Press CONTROL SHIFT ;: to insert the time. Press CONTROL `: to toggle displaying formulae or values, i.e. displaying a formula in a cell or the results of that formula. Press CONTROL N: to open a new workbook. Press SHIFT F11: To insert a new Excel worksheet. Press CONTROL SHIFT SPACEBAR: To highlight all objects. Press CONTROL SHIFT !: To invoke two decimal place format. Press CONTROL SHIFT &: to generate an outline border around the worksheet. Press CONTROL SHIFT _: To remove borders. Press CONTROL SHIFT 8: To highlight the whole region of the worksheet data. Press CONTROL SHIFT ~: To obtain general number format. Press SHIFT up, down, left or right ARROW: To highlight/select cells as you go. Note 1: You can use the standard Windows highlighting methods to highlight/select text in cells, i.e. combinations of CONTROL, SHIFT, the ARROW keys and the HOME and END keys, e.g. CONTROL SHIFT PAGE up to select one screen of information, SHIFT HOME to select from the beginning of the current row to the cell the cursor is currently in, CONTROL SHIFT END to select from the current cursor position to the end of the worksheet, etc. Note 2: The standard Windows shortcuts for copying to the Clipboard, pasting, etc, all work as normal, e.g. CONTROL C, CONTROL X AND CONTROL V. 4.3. JAWS 4, 4.5, 5 and 6 Special Spreadsheet Hot Keys As you move to a new cell, JAWS will automatically read out the cell's contents and the column and row co-ordinates. Press ALT 1: To hear the contents of the first cel
[AI] Useful short cuts of XL.
Hello Friends, Here are some useful shortcuts of XL taken from tutorials by John Wilson. i found them really handy. 4.1. Keyboard Shortcuts and Hot Keys for Excel I strongly recommend that you carefully study the training tapes which come with your particular screenreader to accustom yourself with the specialist shortcuts for operating a spreadsheet which it provides. Nonetheless, I have provided below in this section most of the main and more important screenreader hot keys for the JAWS, HAL and Window-Eyes screenreaders, plus a list of Excel's own hot keys for navigating in and carrying out commands in spreadsheets. 4.2. Excel General Shortcuts Whether the below hot keys do anything when you press them will, of course, depend on what type of worksheet environment you are in, what stage you are at and whether or not you have highlighted any cells, etc. This is a short list of Excel's own most useful and frequently used shortcuts which should prove particularly helpful for those who prefer shortcut keystrokes over using menu choices. However, it is a fraction only of the Excel general shortcuts. For a more exhaustive list of these shortcuts, see Appendix 1. Press BACKSPACE: To delete the character to the left of the insertion point. Press F1: To invoke Excel's online help system. Press F2: To be able to edit the contents of the current cell. Press F8: To turn on extending a selection by using the ARROW keys. Press F11: To create a chart which uses the current range. Press F7: To invoke the spell-checker for any text in your spreadsheet. Press F9: To calculate all sheets in all open workbooks. Press right, left, up or down ARROW keys: To move one cell at a time in any direction. Pressing TAB also moves you one cell at a time along a row from left to right and SHIFT TAB moves you backwards. Pressing ENTER after completing a cell moves you down a row in the current column. Press PAGE up or down: To move through a spreadsheet upwards or downwards respectively by 25 lines each press. In some set-ups this may move you by only 23 lines. Press ALT =: To generate an auto sum. Press =: To then be able to type a formula into the current cell. Press CONTROL SPACEBAR: To highlight/select the whole of the column the cursor is currently in. Press SHIFT SPACEBAR: To highlight/select the entire row the cursor is in. Press ALT ENTER: to insert a carriage return and start a new line in the same cell. Press CONTROL F: To bring up the find dialogue box. Press CONTROL 1: To display the format cells dialogue box. Press CONTROL with any of the ARROW keys: To move to the edge of data regions, e.g. CONTROL down ARROW when in the middle of row D of a page with several rows in it will jump you to the last cell in row D with data in it. Press CONTROL PAGE down: To switch to the next spreadsheet page including any with charts on them. Press CONTROL PAGE up: Opposite of the above. Press ALT PAGE down: To move right one screenful of information, which will normally mean jumping 11 rows to your right each time you do this. Press HOME: To jump to the beginning of the current row. Press END and then left ARROW: To jump to the end of the current row. Press CONTROL HOME: to jump to Cell A1. Press CONTROL END: to jump to the last cell in your current data range. Press CONTROL ;: To insert the date in the current cell. Press CONTROL SHIFT 7: To obtain a border format outline. Press CONTROL SHIFT -: To remove a border. Press CONTROL SHIFT ;: to insert the time. Press CONTROL `: to toggle displaying formulae or values, i.e. displaying a formula in a cell or the results of that formula. Press CONTROL N: to open a new workbook. Press SHIFT F11: To insert a new Excel worksheet. Press CONTROL SHIFT SPACEBAR: To highlight all objects. Press CONTROL SHIFT !: To invoke two decimal place format. Press CONTROL SHIFT &: to generate an outline border around the worksheet. Press CONTROL SHIFT _: To remove borders. Press CONTROL SHIFT 8: To highlight the whole region of the worksheet data. Press CONTROL SHIFT ~: To obtain general number format. Press SHIFT up, down, left or right ARROW: To highlight/select cells as you go. Note 1: You can use the standard Windows highlighting methods to highlight/select text in cells, i.e. combinations of CONTROL, SHIFT, the ARROW keys and the HOME and END keys, e.g. CONTROL SHIFT PAGE up to select one screen of information, SHIFT HOME to select from the beginning of the current row to the cell the cursor is currently in, CONTROL SHIFT END to select from the current cursor position to the end of the worksheet, etc. Note 2: The standard Windows shortcuts for copying to the Clipboard, pasting, etc, all work as normal, e.g. CONTROL C, CONTROL X AND CONTROL V. 4.3. JAWS 4, 4.5, 5 and 6 Special Spreadsheet Hot Keys As you move to a new cell, JAWS will automatically read out the cell's contents and the column and row co-ordinates. Press ALT 1: To hear the contents of the first cel
[AI] Useful short cuts of XL.
Hello Friends, Here are some useful shortcuts of XL taken from tutorials by John Wilson. i found them really handy. 4.1. Keyboard Shortcuts and Hot Keys for Excel I strongly recommend that you carefully study the training tapes which come with your particular screenreader to accustom yourself with the specialist shortcuts for operating a spreadsheet which it provides. Nonetheless, I have provided below in this section most of the main and more important screenreader hot keys for the JAWS, HAL and Window-Eyes screenreaders, plus a list of Excel's own hot keys for navigating in and carrying out commands in spreadsheets. 4.2. Excel General Shortcuts Whether the below hot keys do anything when you press them will, of course, depend on what type of worksheet environment you are in, what stage you are at and whether or not you have highlighted any cells, etc. This is a short list of Excel's own most useful and frequently used shortcuts which should prove particularly helpful for those who prefer shortcut keystrokes over using menu choices. However, it is a fraction only of the Excel general shortcuts. For a more exhaustive list of these shortcuts, see Appendix 1. Press BACKSPACE: To delete the character to the left of the insertion point. Press F1: To invoke Excel's online help system. Press F2: To be able to edit the contents of the current cell. Press F8: To turn on extending a selection by using the ARROW keys. Press F11: To create a chart which uses the current range. Press F7: To invoke the spell-checker for any text in your spreadsheet. Press F9: To calculate all sheets in all open workbooks. Press right, left, up or down ARROW keys: To move one cell at a time in any direction. Pressing TAB also moves you one cell at a time along a row from left to right and SHIFT TAB moves you backwards. Pressing ENTER after completing a cell moves you down a row in the current column. Press PAGE up or down: To move through a spreadsheet upwards or downwards respectively by 25 lines each press. In some set-ups this may move you by only 23 lines. Press ALT =: To generate an auto sum. Press =: To then be able to type a formula into the current cell. Press CONTROL SPACEBAR: To highlight/select the whole of the column the cursor is currently in. Press SHIFT SPACEBAR: To highlight/select the entire row the cursor is in. Press ALT ENTER: to insert a carriage return and start a new line in the same cell. Press CONTROL F: To bring up the find dialogue box. Press CONTROL 1: To display the format cells dialogue box. Press CONTROL with any of the ARROW keys: To move to the edge of data regions, e.g. CONTROL down ARROW when in the middle of row D of a page with several rows in it will jump you to the last cell in row D with data in it. Press CONTROL PAGE down: To switch to the next spreadsheet page including any with charts on them. Press CONTROL PAGE up: Opposite of the above. Press ALT PAGE down: To move right one screenful of information, which will normally mean jumping 11 rows to your right each time you do this. Press HOME: To jump to the beginning of the current row. Press END and then left ARROW: To jump to the end of the current row. Press CONTROL HOME: to jump to Cell A1. Press CONTROL END: to jump to the last cell in your current data range. Press CONTROL ;: To insert the date in the current cell. Press CONTROL SHIFT 7: To obtain a border format outline. Press CONTROL SHIFT -: To remove a border. Press CONTROL SHIFT ;: to insert the time. Press CONTROL `: to toggle displaying formulae or values, i.e. displaying a formula in a cell or the results of that formula. Press CONTROL N: to open a new workbook. Press SHIFT F11: To insert a new Excel worksheet. Press CONTROL SHIFT SPACEBAR: To highlight all objects. Press CONTROL SHIFT !: To invoke two decimal place format. Press CONTROL SHIFT &: to generate an outline border around the worksheet. Press CONTROL SHIFT _: To remove borders. Press CONTROL SHIFT 8: To highlight the whole region of the worksheet data. Press CONTROL SHIFT ~: To obtain general number format. Press SHIFT up, down, left or right ARROW: To highlight/select cells as you go. Note 1: You can use the standard Windows highlighting methods to highlight/select text in cells, i.e. combinations of CONTROL, SHIFT, the ARROW keys and the HOME and END keys, e.g. CONTROL SHIFT PAGE up to select one screen of information, SHIFT HOME to select from the beginning of the current row to the cell the cursor is currently in, CONTROL SHIFT END to select from the current cursor position to the end of the worksheet, etc. Note 2: The standard Windows shortcuts for copying to the Clipboard, pasting, etc, all work as normal, e.g. CONTROL C, CONTROL X AND CONTROL V. 4.3. JAWS 4, 4.5, 5 and 6 Special Spreadsheet Hot Keys As you move to a new cell, JAWS will automatically read out the cell's contents and the column and row co-ordinates. Press ALT 1: To hear the contents of the first cel