Skip to: Site menu | Main content

the nomouse logo wit image of a computer mouse with a cross out over it and the tag line is computer literacy and information technology without the use of a mouse.

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 :

Ctrl + 1

Adjusts the line spacing to Single for the current selection

Ctrl + 2

Adjusts the line spacing to Double for the current selection

Ctrl + 5

Adjusts the line spacing to 1.5 for the current selection

Ctrl + 0

Toggles adding a 12 point line spacing before the current selection

Ctrl + Shift + 8

Toggles the display of paragraph formatting (non printable characters)

Alt + Ctrl + 1

Applies the built-in Heading 1 style to the current selection

Alt + Ctrl + 2

Applies the built-in Heading 2 style to the current selection

Alt + Ctrl + 3

Applies the built-in Heading 3 style to the current selection

 

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 :

Ctrl + F1

Closes and reopens the current task pane

Ctrl + F3

Displays the (Insert > Name > Define) dialog box

Ctrl + F4

Closes the selected workbook window

Ctrl + F5

Restores the size of the active workbook or window

Ctrl + F6

Moves to the next open workbook or window

Ctrl + F7

Activates the Move window command

Ctrl + F8

Activates the Resize window command

Ctrl + F9

Minimises the size of the active workbook or window

Ctrl + F10

Maximises the size of the active workbook or window

Ctrl + F12

Displays the (File > Open) dialog box

 

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 :

Enter

Enters the contents of the active cell and moves to the cell below (by default)

Shift + Enter

Enters the contents of the active cell and moves to the cell above (by default)

Tab

Enters the contents of the active cell and moves one cell to the right

Shift + Tab

Enters the contents of the active cell and moves one cell to the left

Alt + =

Enters the SUM() function (AutoSum) to sum the adjacent block of cells

Alt + 0128

Enters the euro symbol (€) (using Number keypad)

Alt + 0162

Enters the cent symbol (¢) (using Number keypad)

Alt + 0163

Enters the pound sign symbol (£) (using Number keypad)

Alt + 0165

Enters the yen symbol (¥) (using Number keypad)

Alt + Enter

Enters a new line (or carriage return) into a cell

Ctrl + '

Enters the formula from the cell directly above into the active cell

Ctrl + Shift + 2

Enters the value from the cell directly above into the active cell

Ctrl + ;

Enters the current date into the active cell

Ctrl + Enter

Enters the contents of the active cell to the selected region

Ctrl + Shift + ;

Enters the current time into the active cell

Ctrl + Shift + Enter

Enters the formula as an Array Formula

Shift + Insert

Enters the data from the clipboard

Alt + Down Arrow

Displays the Pick From List drop-down list

Esc

Cancels the cell entry and restores the original contents

 

EDITING DATA :

Delete

Deletes the selection or one character to the right

Backspace

Deletes the selection or one character to the left

Shift + Delete

Cuts the selection to the clipboard

Ctrl + Delete

Deletes text to the end of the line

Ctrl + -

Displays the (Edit > Delete) dialog box

Ctrl + Shift + =

Displays the (Insert > Cells) dialog box

 

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 :

=

Starts a Formula

Ctrl + `

Toggles between the value layer and the formula layer

Ctrl + Delete

Deletes to the end of the line

Ctrl + Insert

Copies the current selection to the clipboard

Ctrl + Shift + (

Unhides any hidden rows within the selection

Ctrl + Shift + )

Unhides any hidden columns within the selection

Ctrl + Shift + /

Copy value from cell above / select the array ??

Ctrl + Shift + \

Select unequal cells

Alt

Toggles the activation of the Menu Bar

Alt + Shift + Left Arrow

Displays the (Data > Group and Outline > UnGroup) dialog box

Alt + Shift + Right Arrow

Displays the (Data > Group and Outline > Group) dialog box

Alt + Backspace

Undo the last action (Edit > Undo) ??

Alt + Spacebar

Activates the Control Box in the top left hand corner

Alt + -

Displays the Excel application control menu

End

Toggles between switching End Mode on or off

Scroll Lock

Toggles between switching Scroll Lock on or off

Shift + Insert

Pastes the entry from the clipboard

[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
backlinks