Program Shortcut Keys
The contents of this page has the keyboard shortcut keys that cover Microsoft Office
The 10 most useful shortcut keys in Word
F5 |
Displays the (Edit > GoTo) dialog box |
F9 |
Updates all the field codes in the selection |
Shift + Enter |
Enters a line break (Soft break) |
Ctrl + 1 |
Adjusts the line spacing to Single for the current selection |
Ctrl + R |
Right aligns the current selection |
Ctrl + Enter |
Enters a normal page break |
Ctrl + Alt + 1 |
Applies the Heading 1 style to the selection |
Ctrl + Shift + N |
Applies the Normal style to the selection |
Alt + Ctrl + N |
Displays the active document in Normal view |
Alt + 5 |
Selects the whole table (5 on Numerical keypad) |
FUNCTION KEYS :
F1 |
Displays the Office Assistant or (Help > Microsoft Word Help) |
F2 |
Moves text ?? |
F3 |
Replaces an AutoText entry from the preceeding word |
F4 |
Repeats the last document action (Edit > Repeat) |
F5 |
Displays the (Edit > GoTo) dialog box |
F6 |
Moves to the next pane in a document (if the window is split) |
F7 |
Displays the (Tools > Spelling) dialog box |
F8 |
Toggles whether to extend a selection with the arrow keys |
F9 |
Updates all the field codes in the current selection |
F10 |
Toggles the activation of the Menu Bar / Subscript ??? |
F11 |
Moves to the next Field |
F12 |
Displays the (File > Save As) dialog box |
SHIFT AND FUNCTION KEYS :
Shift + F1 |
Activates the context sensitive Whats this ? prompt (Help > Whats This) |
Shift + F2 |
Copies ? |
Shift + F3 |
Toggles between lowercase, mixedcase and uppercase on the selection |
Shift + F4 |
Repeats the last Find, the same as (Edit > Find Next) |
Shift + F5 |
Moves to the previous revision \ Goto Previous insertion point when document was last opened |
Shift + F6 |
Moves to the previous pane in a document (if the window is split) |
Shift + F7 |
Displays the (Tools > Language > Thesaurus) dialog box |
Shift + F8 |
Shrink / reduce selection |
Shift + F9 |
Toggles between displaying field codes and field results |
Shift + F10 |
Displays the (Shortcut) menu for the selected item |
Shift + F11 |
Moves to the previous Field |
Shift + F12 |
Saves, Displays the (File > Save As) dialog box if a new document |
CONTROL AND FUNCTION KEYS :
Ctrl + F2 |
Displays the Print Preview (same as File > Print Preview) |
Ctrl + F3 |
Spike / cut to spike (multiple cuts to clipboard) |
Ctrl + F4 |
Closes the active document or window (File > Close) |
Ctrl + F5 |
Restores the size of the active document or window |
Ctrl + F6 |
Moves to the next open document or window |
Ctrl + F7 |
Activates the Move window command |
Ctrl + F8 |
Activates the Resize window command |
Ctrl + F9 |
Inserts a blank Field containing two curly brackets |
Ctrl + F10 |
Maximise the active document or window |
Ctrl + F11 |
Locks a Field code |
Ctrl + F12 |
Displays the (File > Open) dialog box |
OTHER AND FUNCTION KEYS :
Alt + F2 |
Displays the (File > Save As) dialog box |
Alt + F3 |
Create an AutoText entry for the current selection |
Alt + F4 |
Closes the active document (saving first) and exits Word (File > Exit) |
Alt + F5 |
Restores the size of the active window ?? |
Alt + F6 |
Toggles between all the documents that are currently open |
Alt + F7 |
next spoll ? Similar to right mouse click ?? Move to the next misspelling ?? |
Alt + F8 |
Displays the (Tools > Macros > Macro) dialog box |
Alt + F9 |
Toggles between displaying field codes and field results |
Alt + F10 |
Maximise the active window |
Alt + F11 |
Toggles between the Visual Basic Editor window and the Word window |
Alt + F12 |
Activate Print Preview ?? |
Alt + Shift + F2 |
Displays the (File > Save As) dialog box |
Alt + Shift + F4 |
Closes the active document (saving first) and exits Word (File > Exit) |
Alt + Shift + F10 |
Displays the drop-down menu for the corresponding smart tag |
Alt + Ctrl + F2 |
Displays the (File > Open) dialog box |
Ctrl + Shift + F3 |
Unspike / paste the spike contents |
Ctrl + Shift + F5 |
Displays the (Insert > Bookmark) dialog box |
Ctrl + Shift + F6 |
Moves to the previous open document or window |
Ctrl + Shift + F7 |
Updates Selection ?? |
Ctrl + Shift + F8 |
Allows you to vertically select text / Selects a column in a table |
Ctrl + Shift + F9 |
Unlinks a Field code |
Ctrl + Shift + F11 |
Unlocks a Field code |
Ctrl + Shift + F12 |
Displays the (File > Print) dialog box |
CONTROL AND NUMBERS :
|
CONTROL AND LETTERS :
Ctrl + A |
Selects all the text in the active document |
Ctrl + B |
Toggles bold on the current selection |
Ctrl + C |
Copies the current selection to the clipboard (Edit > Copy) |
Ctrl + D |
Display the (Format > Font) dialog box |
Ctrl + E |
Centre aligns the current selection |
Ctrl + F |
Displays the (Edit > Find) dialog box |
Ctrl + G |
Displays the (Edit > GoTo) dialog box / unhand an indent ?? |
Ctrl + H |
Displays the (Edit > Replace) dialog box / toggles hidden text ?? |
Ctrl + I |
Toggles italics on the current selection |
Ctrl + J |
Justifies the current selection / ie full paragraph justification |
Ctrl + K |
Inserts hyperlink / Toggles between (smallcaps / lowercase) ??? |
Ctrl + L |
Left aligns the current selection |
Ctrl + M |
Indents the paragraph / Un Nest / left indent, increase indent ?? |
Ctrl + N |
Creates a new document based on Normal.dot template |
Ctrl + O |
Displays the (File > Open) dialog box |
Ctrl + P |
Displays the (File > Print) dialog box |
Ctrl + Q |
Resets the formatting back to the original paragraph style. Removes character formatting from the selection |
Ctrl + R |
Right aligns the current selection |
Ctrl + S |
Saves, Displays the (File > Save As) dialog if new document |
Ctrl + T |
Inserts a Hanging Indent |
Ctrl + U |
Toggles (continuous) underlying on the current selection |
Ctrl + V |
Pastes the entry from the clipboard (Edit > Paste) |
Ctrl + W |
Closes the active document or window (File > Close) |
Ctrl + X |
Cuts the current selection to the clipboard (Edit > Cut) |
Ctrl + Y |
Repeats the last document action (Edit > Repeat) |
Ctrl + Z |
Undo the last document action (Edit > Undo) |
OTHERS AND LETTERS :
Ctrl + Shift + A |
Toggles between Capitals and Lowercase on the selection |
Ctrl + Shift + C |
Copies only the formatting from the current selection |
Ctrl + Shift + D |
Toggles (double) underlining on the selection |
Ctrl + Shift + F |
Activates the Font drop-down list on the Formatting toolbar |
Ctrl + Shift + H |
Toggles whether to make the current selection hidden |
Ctrl + Shift + K |
Toggles smallcaps on the selection |
Ctrl + Shift + L |
Applies the built-in List Bullet style to the selection |
Ctrl + Shift + M |
Unindents the paragraph, decreases indent ?? |
Ctrl + Shift + N |
Applies the built-in Normal style to the selection |
Ctrl + Shift + P |
Activates the Point drop-down list on the Formatting toolbar |
Ctrl + Shift + Q |
Applies the Symbol format / Changes the selection to symbol font ?? |
Ctrl + Shift + S |
Activates the Style drop-down list on the Formatting toolbar |
Ctrl + Shift + T |
Reduces / removes a hanging indent |
Ctrl + Shift + V |
Pastes only the formatting. Used in conjunction with (Ctrl + Shift + C) |
Ctrl + Shift + W |
Toggles underlining on the selection (words only not spaces) |
Alt + A |
Displays the (Table) menu |
Alt + E |
Displays the (Edit) menu |
Alt + F |
Displays the (File) menu |
Alt + H |
Displays the (Help) menu |
Alt + O |
Displays the (Format) menu |
Alt + T |
Displays the (Tools) menu |
Alt + V |
Displays the (View) menu |
Alt + W |
Displays the (Window) menu |
Alt + Shift + D |
Insert Date field with current Date (format ??) |
Alt + Shift + E |
Edit Merge data source ?? |
Alt + Shift + F |
Insert Merge field |
Alt + Shift + N |
Merge to a new document ?? |
Alt + Shift + M |
Merge to a printer ?? |
Alt + Shift + P |
Insert Page field with current Page |
Alt + Shift + T |
Insert Time field with current Time |
Alt + Ctrl + A |
All in capitals |
Alt + Ctrl + C |
Enters the Copyright symbol (©) |
Alt + Ctrl + D |
Enters the current date as a field. Format "mm/dd/yy" |
Alt + Ctrl + E |
Enters an Endnote |
Alt + Ctrl + F |
Enters an Footnote |
Alt + Ctrl + I |
Displays the Print Preview (same as File > Print Preview) |
Alt + Ctrl + K |
Start Autoformat ??? |
Alt + Ctrl + N |
Displays the active document in Normal view |
Alt + Ctrl + P |
Displays the active document in Page Layout view |
Alt + Ctrl + R |
Enters the Registered symbol (®) |
Alt + Ctrl + T |
Enters the Trademark symbol (™) |
Alt + Ctrl + V |
Replaces an AutoText entry from the preceeding word |
Alt + Ctrl + Y |
Goto the top of the next page ?? |
Alt + Ctrl + Z |
Goto the previous Insertion point ?? |
ENTERING DATA :
Enter |
Enters a new paragraph |
Ctrl + Enter |
Enters a normal page break |
Shift + Enter |
Enters a line break (Soft break) |
Ctrl + Shift + Enter |
Enters a column break or splits the table |
Delete |
Deletes the selection or one character to the right |
Backspace |
Deletes the selection or one character to the left |
Ctrl + - |
Enters an En Dash (number pad) (shorter) basically a hyphen ?? |
Alt + Ctrl + - |
Enters an Em Dash (number pad) (longer) |
Alt + 0152 |
Enters the ?? symbol |
Alt + 0175 |
Enters the ?? symbol |
Ctrl + Tab |
Enters a tab in a table cell |
Ctrl + Shift + Spacebar |
Enters a non breaking space / hard space, ie prevents word wrap at undesirable places ?? |
EXTENDING DATA :
Shift + Home |
Extends the selection to the beginning of the line |
Shift + End |
Extends the selection to the end of the line |
Shift + Up Arrow |
Extends the selection one line up |
Shift + Down Arrow |
Extends the selection one line down |
Shift + Left Arrow |
Extends the selection one character to the left |
Shift + Right Arrow |
Extends the selection one character to the right |
Ctrl + Shift + Home |
Extends the selection to the beginning of the document |
Ctrl + Shift + End |
Extends the selection to the end of the document |
SELECTING DATA :
Ctrl + Shift + Up Arrow |
Selects to the beginning of the current paragraph |
Ctrl + Shift + Down Arrow |
Selects to the end of the current paragraph |
Ctrl + Shift + Left Arrow |
Selects the beginning of the current word |
Ctrl + Shift + Right Arrow |
Selects the end of the current word |
Ctrl + Shift + Home |
Selects to the beginning of the document |
Ctrl + Shift + End |
Selects to the end of the document |
Shift + Page Up |
Selects to the top of the previous screen |
Shift + Page Down |
Selects to the bottom of the next screen |
F8, F8 |
Selects the current sentence ?? |
F8, F8, F8 |
Selects the current word ?? |
Ctrl + Backspace |
Deletes one word to the left of the cursor |
Ctrl + Delete |
Deletes one word to the right of the cursor |
FORMATTING DATA :
Ctrl + ] |
Increases the font size of the current selection by 1 point |
Ctrl + [ |
Decreases the font size of the current selection by 1 point |
Ctrl + Shift + ] |
Increases the font size of the current selection by 1 point |
Ctrl + Shift + [ |
Decreases the font size of the current selection by 1 point |
Ctrl + Shift + > |
Increases the font size to the next size in the font drop-down list |
Ctrl + Shift + < |
Decreases the font size to the previous size in the font drop-down list |
Ctrl + Shift + - |
Inserts a non breaking hyphen (ie grammer note 2 hyphens = 1 dash) |
Ctrl + = |
Applies Subscript to the selection (automatic spacing ??) |
Ctrl + Shift + = |
Applies Superscript to the selection |
Ctrl + Spacebar |
Resets the formatting back to the original style (removes any manual formatting) |
Alt + Shift + Right Arrow |
Demotes the paragraph to the previous heading style |
Alt + Shift + Left Arrow |
Promotes the paragraph to the next heading style |
MANOUVERING :
Arrow Keys |
Moves one character in the corresponding direction |
Tab |
Moves to the next cell in a table (or inserts a normal tab) |
Home |
Moves to the beginning of the line |
End |
Moves to the end of the line |
Page Up |
Moves to the previous screen |
Page Down |
Moves to the next screen |
Ctrl + Home |
Moves to the beginning of the document |
Ctrl + End |
Moves to the end of the document |
Ctrl + Up Arrow |
Moves to the beginning of the paragraph or the previous paragraph |
Ctrl + Down Arrow |
Moves to the end of the paragraph or the next paragraph |
Ctrl + Left Arrow |
Moves one word at a time to the left |
Ctrl + Right Arrow |
Moves one word at a time to the right |
Ctrl + Page Up |
Moves to the top of the previous page (paragraph / end of column) ?? |
Ctrl + Page Down |
Moves to the top of the next page |
Alt + Ctrl + Page Up |
Moves to the top of the current window |
Alt + Ctrl + Page Down |
Moves to the bottom of the current window |
OTHER :
Alt + Ctrl + Home |
Activates the Document Browser |
Alt + Enter |
Repeats the last action (Edit > Repeat) ?? |
Shift + Delete |
Cuts the selection to the clipboard |
Ctrl + Insert |
Copies the selection to the clipboard |
Shift + Insert |
Pastes the entry from the clipboard |
Alt + Tab |
Toggles between all your open applications |
Alt + Shift + Tab |
Toggles backwards between all your open applications |
Alt + Print Screen |
Copies just the active window / application to the clipboard ?? |
Alt + Spacebar |
Activates the Control Box in the top left hand corner |
Alt + Backspace |
Undo the last action (Edit > Undo) ?? |
Ctrl + Escape |
Activates the Windows Start menu |
Alt + Escape |
Toggles between all your open applications on the taskbar |
Ctrl + Spacebar |
Resets the formatting back to the original paragraph style. Removes character formatting from the selection |
Ctrl + Up Arrow + F9 |
Converts a field to text ?? |
Esc |
Cancels the action or closes the dialog box |
MICROSOFT EXCEL 2003 :
The 10 most useful shortcut keys in Excel :
End + Home |
Moves to the last used cell on the active worksheet* |
F11 |
Creates a chart (on a chart sheet) using the highlighted range |
Shift + F9 |
Calculates just the active worksheet |
Ctrl + 1 |
Displays the (Format > Cells) dialog box |
Ctrl + D |
Copies the first cell in the selection downwards (Edit > Fill > Down) |
Ctrl + Page Down |
Moves to the next worksheet in the active workbook |
Ctrl + Tab |
Moves to the next workbook or window |
Ctrl + Shift + Down Arrow |
Selects all the cells to the end of the current region |
Alt + Shift + F1 |
Inserts a new worksheet into the active workbook |
Alt + Down Arrow |
Displays the Pick From List drop-down list |
FUNCTION KEYS :
F1 |
Displays the Office Assistant or (Help > Microsoft Excel Help) |
F2 |
Edits the active cell, putting the cursor at the end* |
F3 |
Displays the (Insert > Name > Paste) dialog box |
F4 |
Repeats the last worksheet action (Edit > Repeat) |
F5 |
Displays the (Edit > GoTo) dialog box |
F6 |
Moves to the next pane in a workbook (if the window is split) |
F7 |
Displays the (Tools > Spelling) dialog box |
F8 |
Toggles whether to extend a selection with the arrow keys |
F9 |
Calculates All the worksheets in All the open workbooks |
F10 |
Toggles the activation of the Menu Bar |
F11 |
Displays the (Insert > Chart) dialog box that creates a chart (on a chart sheet) using the highlighted range |
F12 |
Displays the (File > Save As) dialog box |
SHIFT AND FUNCTION :
Shift + F1 |
Activates the context sensitive Whats this ? prompt (Help > Whats This) |
Shift + F2 |
Inserts or edits a cell comment (Insert > Comment) |
Shift + F3 |
Displays the (Insert > Function) dialog box |
Shift + F4 |
Repeats the last Find, the same as (Edit > Find Next) |
Shift + F5 |
Displays the (Edit > Find) dialog box |
Shift + F6 |
Moves to the previous pane in a workbook (if the window is split) |
Shift + F8 |
Toggles between switching Add Mode on or off* |
Shift + F9 |
Calculates just the active worksheet |
Shift + F10 |
Displays the (Shortcut) menu for the selected item |
Shift + F11 |
Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet) |
Shift + F12 |
Saves, Displays the (File > Save As) dialog box if a new workbook |
CONTROL AND FUNCTION :
|
OTHER AND FUNCTION:
Alt + F1 |
Creates a chart (on a chart sheet) using the highlighted range |
Alt + F2 |
Displays the (File > Save As) dialog box |
Alt + F4 |
Closes all the workbooks (saving first) and exits Excel (File > Exit) |
Alt + F8 |
Displays the (Tools > Macro > Macros) dialog box |
Alt + F11 |
Toggles between the Visual Basic Editor window and the Excel window |
Alt + Ctrl + F9 |
Calculates All cells on All worksheets in All workbooks |
Alt + Shift + F1 |
Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet) |
Alt + Shift + F2 |
Displays the (File > Save As) dialog box |
Alt + Shift + F4 |
Closes all the workbooks (saving first) and exits Excel (File > Exit) |
Alt + Shift + F10 |
Displays the drop-down menu for the corresponding smart tag |
Alt + Shift + F11 |
Activates the Microsoft Script Editor window |
Ctrl + Shift + F3 |
Displays the (Insert > Name > Create) dialog box |
Ctrl + Shift + F6 |
Moves to the previous open workbook or window |
Ctrl + Shift + F10 |
Activates the Menu Bar or Displays the (View > Toolbars) dialog box |
Ctrl + Shift + F12 |
Displays the (File > Print) dialog box |
Insert + F4 |
Read spelling errors and suggestions ?? |
CONTROL AND NUMBERS :
Ctrl + 0 |
Hides the columns in the current selection (Format > Column > Hide) |
Ctrl + 1 |
Displays the (Format > Cells) dialog box |
Ctrl + 2 |
Toggles bold on the current selection |
Ctrl + 3 |
Toggles italics on the current selection |
Ctrl + 4 |
Toggles underlying on the current selection |
Ctrl + 5 |
Toggles the strikethrough of text on the current selection |
Ctrl + 6 |
Toggles between hiding, displaying or displaying just placeholders (objects) |
Ctrl + 7 |
Toggles the display of the Standard toolbar |
Ctrl + 8 |
Toggles the display of Outline symbols on the active worksheet |
Ctrl + 9 |
Hides the rows in the current selection (Format > Row > Hide) |
Ctrl + Shift + 0 |
Unhides the columns in the current selection |
Ctrl + Shift + 2 |
Enters the value from the cell directly above into the active cell |
Ctrl + Shift + 8 |
Selects the current region (surrounded by blank rows and columns) |
Ctrl + Shift + 9 |
Unhides the rows in the current selection |
CONTROL AND LETTERS :
Ctrl + A |
Displays the formula palette given a function name or selects the whole worksheet |
Ctrl + B |
Toggles bold on the current selection |
Ctrl + C |
Copies the current selection to the clipboard (Edit > Copy) |
Ctrl + D |
Copies the first cell in the selection downwards (Edit > Fill > Down) |
Ctrl + E |
Goto current Error ?? |
Ctrl + F |
Displays the (Edit > Find) dialog box |
Ctrl + G |
Displays the (Edit > GoTo) dialog box |
Ctrl + H |
Displays the (Edit > Replace) dialog box |
Ctrl + I |
Toggles italics on the current selection |
Ctrl + J |
Toggles calculation between Manual and Automatic ?? |
Ctrl + K |
Displays the (Insert > Hyperlink) dialog box |
Ctrl + L |
(Added in 2003) Displays the Create List dialog box |
Ctrl + N |
Creates a new workbook (File > New) |
Ctrl + O |
Displays the (File > Open) dialog box |
Ctrl + P |
Displays the (File > Print) dialog box |
Ctrl + R |
Copies the leftmost cell in the selection to the right (Edit > Fill > Right) |
Ctrl + S |
Saves, Displays the (File > Save As) dialog box if a new workbook |
Ctrl + U |
Toggles underlining on the current selection |
Ctrl + V |
Pastes the entry from the clipboard (Edit > Paste) |
Ctrl + W |
Closes the active workbook or window (File > Close) |
Ctrl + X |
Cuts the current selection to the clipboard (Edit > Cut) |
Ctrl + Y |
Repeats the last workbook action (Edit > Repeat) |
Ctrl + Z |
Undo the last workbook action (Edit > Undo) |
OTHER AND LETTERS:
Alt + C |
Move the selected field into the Column area (Pivot Table) |
Alt + D |
Displays the (Data) menu |
Alt + E |
Displays the (Edit) menu |
Alt + F |
Displays the (File) menu |
Alt + H |
Displays the (Help) menu |
Alt + I |
Displays the (Insert) menu |
Alt + L |
Displays the Pivot Table Field dialog box ?? |
Alt + O |
Displays the (Format) menu |
Alt + P |
Move the selected field into the Page area (Pivot Table) |
Alt + R |
Move the selected field into the Row area (Pivot Table) |
Alt + T |
Displays the (Tools) menu |
Alt + U |
Activates the AutoShapes submenu on the Drawing toolbar* |
Alt + V |
Displays the (View) menu |
Alt + W |
Displays the (Window) menu |
Alt + Shift + B |
Report on the cell borders ?? |
Alt + Shift + G |
Report the gridline status ?? |
Ctrl + Shift + A |
Inserts argument names given a function in the formula bar. |
Ctrl + Shift + C |
List cells in current column ??? |
Ctrl + Shift + F |
Activates the Font Name drop-down list on the Formatting toolbar |
Ctrl + Shift + H |
Selects all the hyperlinks ?? where |
Ctrl + Shift + O |
Selects all the cells with comments |
Ctrl + Shift + P |
Activates the Font Size drop-down list on the Formatting toolbar |
Ctrl + Shift + R |
List cells in the current row ??? |
Ctrl + Shift + S |
List all the worksheets ?? |
ENTERING DATA :
|
EDITING DATA :
|
SELECTING DATA :
Ctrl + \ |
Selects the cells in a selected row that do not match the value in the active cell |
Ctrl + Shift + \ |
Selects the cells in a selected column that do not match the value in the active cell |
Ctrl + / |
Selects the array containing the active cell ?? |
Alt + ; |
Selects the visible cells in the current selection |
Ctrl + Enter |
Selects the first object / chart ?? |
Ctrl + Shift + (8 or *) |
Selects the current region (surrounded by blank rows and columns) |
Ctrl + * |
Selects the current region (using the * on the number keyboard) |
Ctrl + [ |
Selects all the cells that are directly referred to by the formula in the active cell (precedents) |
Ctrl + Shift + [ |
Selects all the cells that are directly (or indirectly) referred to by the formula in the active cell |
Ctrl + ] |
Selects all the cells that directly refer to the active cell (dependents) |
Ctrl + Shift + ] |
Selects all the cells that directly (or indirectly) refer to the active cell |
Ctrl + Shift + Page Down |
Selects the active worksheet and the one after it |
Ctrl + Shift + Page Up |
Selects the active worksheet and the one before it |
Ctrl + Shift + Spacebar |
Selects all the objects on the worksheet when an object is selected or selects the whole worksheet |
Ctrl + Backspace |
Selects the current active cell (scrolling if necessary) |
Ctrl + Spacebar |
Selects the current column |
Shift + Arrow keys |
Selects the active cell and the cell in the given direction |
Shift + Backspace |
Selects the active cell when multiple cells are selected |
Shift + Spacebar |
Selects the current row |
EXTENDING DATA :
Ctrl + Shift + Arrow Key |
Extends the selection to the next cell adjacent to a blank cell in that direction |
Ctrl + Shift + End |
Extends the selection to the last used cell on the worksheet |
Ctrl + Shift + Home |
Extends the selection to the beginning of the worksheet |
Shift + Arrow Keys |
Extends the selection by one cell in that direction |
Shift + Home |
Extends the selection to the first column |
Shift + Page Down |
Extends the selection down one screen |
Shift + Page Up |
Extends the selection up one screen |
End, Shift + Arrow Keys |
Extends the selection to the next non-blank cell in that direction |
End, Shift + End |
Extends the selection to the last cell in the current row* |
End, Shift + Home |
Extends the selection to last used cell on the worksheet |
FORMATTING DATA :
Alt + ' |
Displays the (Format > Style) dialog box |
Ctrl + Shift + ( ' or ¬) |
Applies the Time format "hh:mm" to the selection |
Ctrl + Shift + (1 or !) |
Applies the Comma separated format "#,##0.00" to the selection |
Ctrl + Shift + (4 or $) |
Applies the Currency format "£#,##0.00" to the selection |
Ctrl + Shift + (5 or %) |
Applies the Percentage format "0%" to the selection |
Ctrl + Shift + (6 or ^) |
Applies the Exponential format "#,##E+02" to the selection |
Ctrl + Shift + (# or ~) |
Applies the General format to the selection |
Ctrl + (# or ~) |
Applies the Custom Date format "dd-mmm-yy" to the selection |
Ctrl + Shift + (7 or &) |
Applies the outline border to the selection |
Ctrl + Shift + (- or _ ) |
Removes all the borders from the selection |
MANOEUVRING :
Arrow Keys |
Moves to the next cell in that direction |
Ctrl + Tab |
Moves to the next open workbook or window |
Alt + Tab |
Moves to the next application open on your computer |
Alt + Shift + Tab |
Moves to the previous application open on your computer |
Enter |
Moves to the cell directly below |
Tab |
Moves to the next cell on the right (or unprotected cell) |
Home |
Moves to the first column in the current row |
End, Arrow Keys |
Moves to the next non empty cell in that direction |
End, Enter |
Moves to the last cell in the current row that is not blank |
End + Home |
Moves to the last used cell on the active worksheet* |
End, Home |
Moves to the last used cell on the active worksheet* |
Page Down |
Moves to the next screen of rows down |
Page Up |
Moves to the previous screen of rows up |
Shift + Enter |
Moves to the cell directly above (opposite direction to Enter) |
Shift + Tab |
Moves to the cell directly to the left (opposite direction to Tab) |
Alt + Page Down |
Moves you one screen of columns to the right |
Alt + Page Up |
Moves you one screen of columns to the left |
Ctrl + Home |
Moves to cell "A1" on the active sheet |
Ctrl + End |
Moves to the last used cell on the active worksheet* |
Ctrl + Up Arrow |
Moves to the first row in the current region |
Ctrl + Down Arrow |
Moves to the last row in the current region |
Ctrl + Left Arrow |
Moves to the first column in the current region |
Ctrl + Right Arrow |
Moves to the last column in the current region |
Ctrl + Page Up |
Moves to the previous worksheet in the workbook |
Ctrl + Page Down |
Moves to the next worksheet in the workbook |
Ctrl + Shift + Tab |
Moves to the previous open workbook or window |
Ctrl + Backspace |
Moves to the display the active cell |
Scroll Lock + Arrow Keys |
Moves the workbook or window one cell the corresponding direction |
Scroll Lock + End |
Moves to the last cell in the current window |
Scroll Lock + Home |
Moves to the first cell in the current window |
Scroll Lock + Page Down |
Moves you down one screen (current selection unchanged) |
Scroll Lock + Page Up |
Moves you up one screen (current selection unchanged) |
MANOEUVRING (within a selection):
Enter |
Moves from top to bottom within a selection |
Tab |
Moves from left to right within a selection |
Ctrl + . |
Moves clockwise to the next corner within a selection |
Shift + Tab |
Moves from right to left within a selection (opposite direction to Tab) |
Alt + Ctrl + Left Arrow |
Moves to the left between non adjacent cells in a selection |
Alt + Ctrl + Right Arrow |
Moves to the right between non adjacent cells in a selection |
OTHER :
|
[Back to top ]
Additional information: If you would like more information, you can email us at our email address no.mouse@hotmail.co.uk .

backlinks