Ms excel shortcut keys - CTRL Combinations in Excel 2007

Table of Contents:

1.     Navigating in Worksheets and Selecting Cells
2.     Format Cells
3.     Function keys in Excel 2007
4.     CTRL Combinations in Excel 2007
5.     Smart-Art Graphics: Work with shapes
6.     Smart-Art Graphics : Work with Text
7.     Microsoft Clip Organizer main
8.     Work with the Excel Ribbon

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.

Share This :

Tags: