[jaws-uk] Re: Microsoft Excel 2007 Key stroke
- From: Alen Podrebarac <alen.podrebarac@xxxxxxxxx>
- To: jaws-uk@xxxxxxxxxxxxx
- Date: Sun, 30 Mar 2014 00:09:08 +0100
Regards,
are there any shortcuts for power point and access?
Does this shortcuts work in version 2010th?
thanks
Alen
On 29.3.2014. 16:50, Sakthi TAB wrote:
> ctrl+shift++
> Insert a new row or column (after the current row is selected with
> shift+space, or column is selected with ctrl+space
> arrow left, arrow right, arrow up, arrow down
> Move one cell up, down, left, or right in a worksheet.
> ctrl + arrow keys
> Moves to the edge of the current data region
> shift + arrow keys
> Extends the selection of cells by one cell.
> ctrl+shift+arrow keys
> Extends the selection of cells to the last nonblank cell in the same
> column or row as the active cell, or if the next cell is blank,
> extends the selection to the next nonblank cell
> backspacebackspace
> Deletes one character to the left in the Formula Bar. Also clears the
> content of the active cell. In cell editing mode, it deletes the
> character to the left of the insertion point
> delete
> Removes the cell contents (data and formulas) from selected cells
> without affecting cell formats or comments. In cell editing mode, it
> deletes the character to the right of the insertion point.
> end
> Moves to the cell in the lower-right corner of the window when SCROLL
> LOCK is turned on. Also selects the last command on the menu when a
> menu or submenu is visible.
> ctrl+end
> Moves to the last cell on a worksheet, in the lowest used row of the
> rightmost used column. If the cursor is in the formula bar, CTRL+END
> moves the cursor to the end of the text
> ctrl+shift+end in worksheet
> Extends the selection of cells to the last used cell on the worksheet
> (lower-right corner).
> ctrl+shift+end in formula bar
> Selects all text in the formula bar from the cursor position to the
> end--this does not affect the height of the formula bar.
> enter
> Completes a cell entry and selects the cell below
> shift+enter
> Completes a cell entry and selects the cell above.
> ctrl+enter
> Completes a cell entry and stays in the same cell
> alt+enter
> Starts a new line in the same cell
> esc
> Cancels an entry in the cell or Formula Bar. Closes an open menu or
> submenu, dialog box, or message window. It also closes full screen
> mode when this mode has been applied, and returns to normal screen
> mode to display the Ribbon and status bar again.
> homehome
> Moves to the beginning of a row in a worksheet. Moves to the cell in
> the upper-left corner of the window when scroll lock is turned on.
> Selects the first command on the menu when a menu or submenu is
> visible.
> ctrl+home
> Moves to the beginning of a worksheet.
> ctrl+shift+home
> Extends the selection of cells to the beginning of the worksheet
> page down
> Moves one screen down in a worksheet.
> alt+page down
> Moves one screen to the right in a worksheet.
> ctrl+page down
> Moves to the next sheet in a workbook.
> ctrl+shift+page down
> Selects the current and next sheet in a workbook
> page up
> Moves one screen up in a worksheet.
> alt+page up
> Moves one screen to the left in a worksheet.
> ctrl+page up
> Moves to the previous sheet in a workbook.
> ctrl+shift+page up
> Selects the current and previous sheet in a workbook
> spacebar
> In a dialog box, performs the action for the selected button, or
> selects or clears a check box.
> ctrl+spacebar
> Selects an entire column in a worksheet.
> shift+spacebar
> Selects an entire row in a worksheet.
> ctrl+shift+spacebar
> Selects the entire worksheet.
> tab
> Moves one cell to the right in a worksheet. Moves between unlocked
> cells in a protected worksheet. Moves to the next option or option
> group in a dialog box.
> shift+tab
> Moves to the previous cell in a worksheet or the previous option in a
> dialog box.
> ctrl+tab
> Switches to the next tab in dialog box
> ctrl+shift+tab
> Switches to the previous tab in a dialog box.
> ctrl+1
> Format cells dialog.
> ctrl+b (or ctrl+2)
> Apply or remove bold formatting.
> ctrl+i (or ctrl+3)
> Apply or remove italic formatting.
> ctrl+u (or ctrl+4)
> Apply or remove an underline.
> ctrl+5
> Apply or remove strikethrough formatting.
> ctrl+shift+&
> Apply the outline border.
> ctrl+shift+_ (underscore)
> Remove outline borders.
> ctrl+shift+f
> Display the Format Cells with Fonts Tab active. Press tab 3x to get to
> font-size. Used to be ctrl+shift+p, but that seems just get to the
> Font Tab in 2010.
> alt+' (apostrophe / single quote)
> Display the Style dialog box.
> f4
> Repeat previous formatting on current cell
> f1
> Displays the Microsoft Office Excel Help task pane.
> ctrl+f1
> Displays or hides the Ribbon, a component of the Microsoft Office
> Fluent user interface.
> alt+f1
> Creates a chart of the data in the current range.
> alt+shift+f1
> Inserts a new worksheet.
> f2
> Edits the active cell and positions the insertion point at the end of
> the cell contents. It also moves the insertion point into the Formula
> Bar when editing in a cell is turned off.
> shift+f2
> Adds or edits a cell comment.
> ctrl+f2
> Displays the Print Preview window.
> f3
> Displays the Paste Name dialog box.
> ctrl+f3
> Display the Name Manager, create new names.
> shift+f3
> Displays the Insert Function dialog box.
> f4
> Repeats the last command or action, if possible.
> ctrl+f4
> Closes the selected workbook window.
> f5
> Displays the Go To dialog box.
> ctrl+f5
> Restores the window size of the selected workbook window.
> f6
> Switches between the worksheet, Ribbon, task pane, and Zoom controls.
> In a worksheet that has been split (View menu, Manage This Window,
> Freeze Panes, Split Window command), F6 includes the split panes when
> switching between panes and the Ribbon area.
> shift+f6
> Switches between the worksheet, Zoom controls, task pane, and Ribbon.
> ctrl+f6
> Switches to the next workbook window when more than one workbook window is
> open.
> f7
> Displays the Spelling dialog box to check spelling in the active
> worksheet or selected range.
> ctrl+f7
> Performs the Move command on the workbook window when it is not
> maximized. Use the arrow keys to move the window, and when finished
> press ENTER, or ESC to cancel.
> f8
> Turns extend mode on or off. In extend mode, Extended Selection
> appears in the status line, and the arrow keys extend the selection.
> shift+f8
> Enables you to add a nonadjacent cell or range to a selection of cells
> by using the arrow keys.
> ctrl+f8
> Performs the Size command (on the Control menu for the workbook
> window) when a workbook is not maximized.
> alt+f8
> Displays the Macro dialog box to create, run, edit, or delete a macro.
> f9
> Calculates all worksheets in all open workbooks.
> shift+f9
> Calculates the active worksheet.
> ctrl+alt+f9
> calculates all worksheets in all open workbooks, regardless of whether
> they have changed since the last calculation.
> ctrl+alt+shift+f9
> Rechecks dependent formulas, and then calculates all cells in all open
> workbooks, including cells not marked as needing to be calculated.
> ctrl+f9
> Minimizes a workbook window to an icon.
> f10
> Turns key tips on or off.
> shift+f10
> Displays the shortcut menu for a selected item.
> alt+shift+f10
> Displays the menu or message for a smart tag. If more than one smart
> tag is present, it switches to the next smart tag and displays its
> menu or message.
> ctrl+f10
> Maximizes or restores the selected workbook window.
> f11
> Creates a chart of the data in the current range.
> shift+f11
> Inserts a new worksheet.
> alt+f11
> Opens the Microsoft Visual Basic Editor, in which you can create a
> macro by using Visual Basic for Applications (VBA).
> f12
> Displays the Save As dialog box.
> ctrl+shift+(
> Unhides any hidden rows within the selection.
> ctrl+shift+)
> Unhides any hidden columns within the selection.
> ctrl+shift+&
> Applies the outline border to the selected cells.
> ctrl+shift+_
> Removes the outline border from the selected cells.
> ctrl+shift+~
> Applies the General number format.
> ctrl+shift+$
> Applies the Currency format with two decimal places (negative numbers
> in parentheses).
> ctrl+shift+%
> Applies the Percentage format with no decimal places.
> ctrl+shift+^
> Applies the Exponential number format with two decimal places.
> ctrl+shift+#
> Applies the Date format with the day, month, and year.
> ctrl+shift+@
> Applies the Time format with the hour and minute, and AM or PM.
> ctrl+shift+!
> Applies the Number format with two decimal places, thousands
> separator, and minus sign (-) for negative values.
> ctrl+shift+*
> Selects the current region around the active cell (the data area
> enclosed by blank rows and blank columns). In a PivotTable, it selects
> the entire PivotTable report.
> ctrl+shift+:
> Enters the current time.
> ctrl+shift+"
> Copies the value from the cell above the active cell into the cell or
> the Formula Bar.
> ctrl+shift++
> Displays the Insert dialog box to insert blank cells.
> ctrl+-
> Displays the Delete dialog box to delete the selected cells.
> ctrl+;
> Enters the current date.
> ctrl+`
> Alternates between displaying cell values and displaying formulas in
> the worksheet.
> ctrl+'
> Copies a formula from the cell above the active cell into the cell or
> the Formula Bar.
> ctrl+1
> Displays the Format Cells dialog box.
> ctrl+2
> Applies or removes bold formatting.
> ctrl+3
> Applies or removes italic formatting.
> ctrl+4
> Applies or removes underlining.
> ctrl+5
> Applies or removes strikethrough.
> ctrl+6
> Alternates between hiding objects, displaying objects, and displaying
> placeholders for objects.
> ctrl+8
> Displays or hides the outline symbols.
> ctrl+9
> Hides the selected rows.
> ctrl+0
> Hides the selected columns.
> ctrl+a
> Selects the entire worksheet. If the worksheet contains data, CTRL+A
> selects the current region. Pressing CTRL+A a second time selects the
> current region and its summary rows. Pressing CTRL+A a third time
> selects the entire worksheet.
> ctrl+shift+a
> Inserts the argument names and parentheses when the insertion point is
> to the right of a function name in a formula.
> ctrl+b
> Applies or removes bold formatting.
> ctrl+c
> Copies the selected cells.
> ctrl+c
> Followed by another CTRL+C displays the Clipboard.
> ctrl+d
> Uses the Fill Down command to copy the contents and format of the
> topmost cell of a selected range into the cells below.
> ctrl+f
> Displays the Find and Replace dialog box, with the Find tab selected.
> ctrl+shift+f
> Opens the Format Cells dialog box with the Font tab selected.
> ctrl+g
> Displays the Go To dialog box.
> ctrl+h
> Displays the Find and Replace dialog box, with the Replace tab selected.
> ctrl+i
> Applies or removes italic formatting.
> ctrl+k
> Displays the Insert Hyperlink dialog box for new hyperlinks or the
> Edit Hyperlink dialog box for selected existing hyperlinks.
> ctrl+n
> Creates a new, blank workbook.
> ctrl+o
> Displays the Open dialog box to open or find a file.
> ctrl+shift+o
> Selects all cells that contain comments.
> ctrl+p
> Displays the Print dialog box.
> ctrl+shift+p
> Opens the Format Cells dialog box with the Font tab selected.
> ctrl+r
> Uses the Fill Right command to copy the contents and format of the
> leftmost cell of a selected range into the cells to the right.
> ctrl+s
> Saves the active file with its current file name, location, and file format.
> ctrl+t
> Displays the Create Table dialog box.
> ctrl+u
> Applies or removes underlining.
> ctrl+shift+u
> Switches between expanding and collapsing of the formula bar.
> ctrl+v
> Inserts the contents of the Clipboard at the insertion point and
> replaces any selection. Available only after you have cut or copied an
> object, text, or cell contents.
> ctrl+alt+v
> Displays the Paste Special dialog box. Available only after you have
> cut or copied an object, text, or cell contents on a worksheet or in
> another program.
> ctrl+w
> Closes the selected workbook window.
> ctrl+x
> Cuts the selected cells.
> ctrl+y
> Repeats the last command or action, if possible.
> ctrl+z
> Uses the Undo command to reverse the last command or to delete the
> last entry that you typed.
> ctrl+shift+z
> Uses the Undo or Redo command to reverse or restore the last automatic
> correction when AutoCorrect Smart Tags are displayed.
> tab
> Select the next element in a SmartArt graphic.
> shift+tab
> Select the previous element in a SmartArt graphic.
> ctrl+a
> Select all shapes.
> esc
> Remove focus from the selected shape.
> arrow up
> Nudge the selected shape up.
> arrow down
> Nudge the selected shape down.
> arrow left
> Nudge the selected shape left.
> arrow right
> Nudge the selected shape right.
> enter or f2
> Edit text in the selected shape.
> delete or backspace
> Delete the selected shape.
> ctrl+x or shift+delete
> Cut the selected shape.
> ctrl+c
> Copy the selected shape.
> ctrl+v
> Paste the contents of the Clipboard.
> ctrl+z
> Undo the last action.
> shift+arrow right
> Enlarge the selected shape horizontally. Add ctrl for moving pixel-by-pixel.
> shift+arrow left
> Reduce the selected shape horizontally. Add ctrl for moving pixel-by-pixel.
> shift+arrow up
> Enlarge the selected shape vertically. Add ctrl for moving pixel-by-pixel.
> shift+arrow down
> Reduce the selected shape vertically. Add ctrl for moving pixel-by-pixel.
> alt+arrow right
> Rotate the selected shape to the right. Add ctrl for moving pixel-by-pixel.
> alt+arrow left
> Rotate the selected shape to the left. Add ctrl for moving pixel-by-pixel.
> arrow left
> Move one character to the left.
> arrow right
> Move one character to the right.
> arrow up
> Move up one line.
> arrow down
> Move down one line.
> ctrl+arrow left
> Move one word to the left.
> ctrl+arrow right
> Move one word to the right.
> ctrl+arrow up
> Move one paragraph up.
> ctrl+arrow down
> Move one paragraph down.
> end
> Move to the end of a line.
> home
> Move to the beginning of a line.
> ctrl+end
> Move to the end of a text box.
> ctrl+home
> Move to the beginning of a text box.
> ctrl+x
> Cut selected text.
> ctrl+c
> Copy selected text.
> ctrl+v
> Paste selected text.
> ctrl+z
> Undo the last action.
> backspace
> Delete one character to the left.
> ctrl+backspace
> Delete one word to the left.
> delete
> Delete one character to the right.
> ctrl+delete
> Delete one word to the right.
> alt+shift+arrow right
> Promote the selected text.
> alt+shift+arrow left
> Demote the selected text.
> ctrl+arrow left or ctrl+arrow right
> Move forward or backward one word in the Search text box.
> alt+c
> Displays the Collection List task pane.
> alt+s
> Displays the Search task pane.
> alt+h
> Open Help.
> arrow keys
> Move left and right, up and down, among collections or clips.
> shift+arrow keys
> Select additional clips after one clip has been selected.
> ctrl+a
> Select all clips on the current page.
> ctrl+c
> Copy (select a clip and move it to the clipboard).
> ctrl+v
> Paste (paste from the clipboard to Clip Organizer).
> delete
> Delete selected clip or category.
> home
> Move to the beginning of a row and select the first item.
> end
> Move to the end of a row and select the last item.
> shift+f10
> Display a shortcut menu for a collection, clip, or link (same as right click).
> esc
> Exit a dialog box.
> tab and shift+tab
> Shift focus forward and backward between different areas of a dialog box.
> alt+spacebar
> Open the shortcut menu of a dialog box.
> alt or f10
> Select the active tab of the Ribbon and activate the access keys. .
> Press either of these keys again to move back to the document and
> cancel the access keys.
> alt or f10 to select the active tab, and then arrow left or arrow right
> Move to another tab of the Ribbon.
> ctrl+f1
> Minimize or restore the Ribbon.
> shift+f10
> Display the shortcut menu for the selected command.
> f6
> Move the focus to select either Active tab of the Ribbon, View Status
> bar at bottom of the window or document
> alt or f10, and then tab or shift+tab
> Move the focus to each command in the Ribbon, forward or backward.
> arrow down, arrow up, arrow left, or arrow right
> Move down, up, left, or right among the items in the Ribbon.
> spacebar or enter
> Activate the selected command or control in the Ribbon.
> spacebar or enter
> Open the selected menu or gallery in the Ribbon.
> enter
> Activate a command or control in the Ribbon so you can modify a value.
> enter
> Finish modifying a value in a control in the Ribbon, and move focus
> back to the document.
> f1
>
** To leave the list, click on the immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** jaws-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
