Numeric Details of Excel 03 and 07

Numeric Details of Excel 03 and 07

In Ms-Excel , Microsoft presenting yearly some changes in Excel

Some of the changes in Ms-Excel 2003 and 2007, i.e

Numeric Details in Excel-03 and Excel-07
Details	Excel-2003	Excel-2007
Number of Rows	65536	1048576
Number of Columns	256	16384
Amount of Memory Used	1 G Bytes	Maximum allowed by Windows
Number of Colors	56	4.3 Billion
Number of Conditional formats Per Cell	3	Unlimited
Number of Levels of Sorting	3	64
Number of Levels of Undo	16	100
Number of Items Shown in the Auto – Filter Dropdown	1000	10000
Number of Characters that can display in a cell	1000	32000
Number of Unique Styles in a Workbook	4000	64000
Number of Characters in a Formula	1000	8000
Number of Levels of Nesting in a Formula	7	64
Number of Function Arguments	30	255

Excel Tricks

Some Excel Tricks :

Just type on keyboard like

=char(64)   in excel  cell..... see what happens its appears as  @

code	Value
=char(33)	!
=char(34)	"
=char(35)	#
=char(36)	$
=char(37)	%
=char(38)	&
=char(39)	'
=char(40)	(
=char(41)	)
=char(42)	*
=char(43)	+
=char(44)	,
=char(45)	-
=char(46)	.
=char(47)	/
=char(48)	0
=char(49)	1
=char(50)	2
=char(51)	3
=char(52)	4
=char(53)	5
=char(54)	6
=char(55)	7
=char(56)	8
=char(57)	9
=char(58)	:
=char(59)	;
=char(60)	<
=char(61)	=
=char(62)	>
=char(63)	?
=char(64)	@
=char(65)	A
=char(66)	B
=char(67)	C
=char(68)	D
=char(69)	E
=char(70)	F
=char(71)	G
=char(72)	H
=char(73)	I
=char(74)	J
=char(75)	K
=char(76)	L
=char(77)	M
=char(78)	N
=char(79)	O
=char(80)	P
=char(81)	Q
=char(82)	R
=char(83)	S
=char(84)	T
=char(85)	U
=char(86)	V
=char(87)	W
=char(88)	X
=char(89)	Y
=char(90)	Z
=char(91)	[
=char(92)	\
=char(93)	]
=char(94)	^
=char(95)	_
=char(96)	`
=char(97)	a
=char(98)	b
=char(99)	c
=char(100)	d
=char(101)	e
=char(102)	f
=char(103)	g
=char(104)	h
=char(105)	i
=char(106)	j
=char(107)	k
=char(108)	l
=char(109)	m
=char(110)	n
=char(111)	o
=char(112)	p
=char(113)	q
=char(114)	r
=char(115)	s
=char(116)	t
=char(117)	u
=char(118)	v
=char(119)	w
=char(120)	x
=char(121)	y
=char(122)	z
=char(123)	{
=char(124)	|
=char(125)	}
=char(126)	~
=char(127)	
=char(128)	ﾀ
=char(129)	ﾁ
=char(130)	ﾂ
=char(131)	ﾃ
=char(132)	ﾄ
=char(133)	ﾅ
=char(134)	ﾆ
=char(135)	ﾇ
=char(136)	ﾈ
=char(137)	ﾉ
=char(138)	ﾊ
=char(139)	ﾋ
=char(140)	ﾌ
=char(141)	ﾍ
=char(142)	ﾎ
=char(143)	ﾏ
=char(144)	ﾐ
=char(145)	ﾑ
=char(146)	ﾒ
=char(147)	ﾓ
=char(148)	ﾔ
=char(149)	ﾕ
=char(150)	ﾖ
=char(151)	ﾗ
=char(152)	ﾘ
=char(153)	ﾙ
=char(154)	ﾚ
=char(155)	ﾛ
=char(156)	ﾜ
=char(157)	ﾝ
=char(158)	ﾞ
=char(159)	ﾟ
=char(160)	ﾠ
=char(223)	￟
=char(224)	￠
=char(225)	￡
=char(226)	￢
=char(227)	￣
=char(228)	￤
=char(229)	￥
=char(230)	￦
=char(231)	￧
=char(243)	￳
=char(244)	￴
=char(245)	￵
=char(246)	￶
=char(247)	￷
=char(248)	￸
=char(249)	
=char(251)	
=char(252)	
=char(253)	�

Excely Keyboard Sortcuts

Excel Keyboard Shortcuts

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 + 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
Ctrl + F1 Closes and reopens the current task pane (ribbon in 2007)
Ctrl + F2 Print Preview
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
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 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 Shortcut Characters in 2007
Ctrl + Shift + F12 Displays the (File > Print) dialog box
Ctrl + 0 Hides the columns in the current selection
Ctrl + 1 Displays the formatting dialog box
Ctrl + 2 Toggles bold on the current selection
Ctrl + 3 Toggles italics on the current selection
Ctrl + 4 Toggles underlining on the current selection
Ctrl + 5 Toggles the strikethrough of text on the current selection
Ctrl + 6 Toggles between hiding, displaying
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
Ctrl + A Displays formula palette given a function name or selects the whole worksheet or current date
Ctrl + B Toggles bold on the current selection
Ctrl + C Copies the current selection to the clipboard
Ctrl + D Copies the first cell in the selection downwards
Ctrl + F Displays the Find dialog box
Ctrl + G Displays the GoTo dialog box
Ctrl + H Displays the Replace dialog box
Ctrl + I Toggles italics on the current selection
Ctrl + K Displays the Insert Hyperlink dialog box
Ctrl + L Displays the Create Table dialog box
Ctrl + N Creates a new workbook
Ctrl + O Displays the Open dialog box
Ctrl + P Displays the Print dialog box
Ctrl + R Copies the leftmost cell in the selection to the right
Ctrl + S Saves, Displays the Save As dialog box if a new workbook
Ctrl + U Toggles underlining on the current selection
Ctrl + V Pastes the entry from the clipboard
Ctrl + W Closes the active workbook or window
Ctrl + X Cuts the current selection to the clipboard
Ctrl + Y Repeats the last workbook action Ctrl + Z Undo the last workbook action
Ctrl + Shift + F Activates the Font Tab of the format cells
Ctrl + Shift + O Selects all the cells with comments
Ctrl + Shift + P Activates the Font Size tab of the format cells
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 + Enter Enters a new line (or carriage return) into a cell
Ctrl + ' Enters the contents 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 + 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
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 Delete dialog box
Ctrl + Shift + = Displays the Cells dialog box
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 + 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 + 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
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
Alt + ' Displays the 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
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
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)
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
= Starts a Formula
Ctrl + ` Toggles between the value layer and the formula layer
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 + \ Select unequal cells
Alt Toggles the activation of the old 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 + Spacebar Activates the Control Box in the top left hand corner
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

Excel Shortcuts

Excel Keyboard Shortcuts

Shortcut Keys to Display and Use Windows
Press Keys	To Do
Alt+Tab	Switch to the next program.
Alt+Shift+Tab	Switch to the previous program.
Ctrl+ESC	Display the Windows Start menu.
Ctrl+W or Ctrl+F4	Close the selected workbook window.
Ctrl+F5	Restore the window size of the selected workbook window.
F6	Switch to the next pane in a worksheet that has been split (Window menu, Split command).
Shift+F6	Switch to the previous pane in a worksheet that has been split.
Ctrl+F6	When more than one workbook window is open, switch to the next workbook window.
Ctrl+Shift+F6	Switch to the previous workbook window.
Ctrl+F7	When a workbook window is not maximized, perform the Move command (on the Control menu for the workbook window). Use the arrow keys to move the window, and when finished press ESC.
Ctrl+F8	When a workbook window is not maximized, perform the Size command (on the Control menu for the workbook window). Use the arrow keys to resize the window, and when finished press Enter.
Ctrl+F9	Minimize a workbook window to an icon.
Ctrl+F10	Maximize or restore the selected workbook window.
Print Screen	Copy a picture of the screen to the Clipboard.
Alt+Print Screen	Copy a picture of the selected window to the Clipboard.

Shortcut Keys for Print and Print Preview
Press Keys	To Do
Ctrl+P or Ctrl+Shift+F12	Display the Print dialog box
Work with Worksheets
Shift+F11 or Alt+Shift+F1	Insert a new worksheet.
Ctrl+Page Down	Move to the next sheet in the workbook.
Ctrl+Page Up	Move to the previous sheet in the workbook.
Shift+Ctrl+Page Down	Select the current and next sheet. To cancel selection of multiple sheets, press Ctrl+Page Down or, to select a different sheet, press Ctrl+Page Up.
Shift+Ctrl+Page Up	Select the current and previous sheet.
Alt+O, H, R	Rename the current sheet (Format menu, Sheet submenu, Rename command).
Alt+E, M	Move or copy the current sheet (Edit menu, Move or Copy Sheet command).
Alt+E, L	Delete the current sheet (Edit menu, Delete Sheet command).

Shortcut Keys to Move and Scroll within a Worksheet
Press Keys	To Do
Arrow keys	Move one cell up, down, left, or right.
Tab	Move one cell to the right.
Shift+Tab	Move one cell to the left.
Ctrl+Arrow key	Move to the edge of the current data region (A range of cells that contains data and that is bounded by empty cells or worksheet borders).
Home	Move to the beginning of the row.
Ctrl+Home	Move to the beginning of the worksheet
Ctrl+End	Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column.
Page Down	Move down one screen.
Page Up	Move up one screen.
Alt+Page Down	Move one screen to the right.
Alt+Page Up	Move one screen to the left.
F6	Switch to the next pane in a worksheet that has been split (Window menu, Split command).
Ctrl+Backspace	Scroll to display the active cell.
F5	Display the Go To dialog box.
Shift+F5	Display the Find dialog box.
Shift+F4	Repeat the last Find action (same as Find Next).
Tab	Move between unlocked cells on a protected worksheet.

Shortcut Keys to Move within a Selected Range
Press Keys	To Do
Enter	Move from top to bottom within the selected range
Shift+Enter	Move from bottom to top within the selected range
Tab	Move from left to right within the selected range. If cells in a single column are selected, move down.
Shift+Tab	Move from right to left within the selected range. If cells in a single column are selected, move up.
Ctrl+PERIOD	Move clockwise to the next corner of the selected range.
Ctrl+Alt+Right Arrow	In nonadjacent selections, switch to the next selection to the right.
Ctrl+Alt+Left Arrow	Switch to the next nonadjacent selection to the left.

Shortcut Keys for Selecting Data and Cells
Press Keys	To Do
Ctrl+Spacebar	Select the entire column.
Shift+Spacebar	Select the entire row.
Ctrl+A	Select the entire worksheet. If the worksheet contains data, Ctrl+A selects the current region. Pressing Ctrl+A a second time selects the entire worksheet.
Shift+Backspace	With multiple cells selected, select only the active cell.
Ctrl+6	Alternate between hiding objects, displaying objects, and displaying place-holders for objects.

Shortcut Keys to Extend Selection
Press Keys	To Do
F8	Turn extend mode on or off. In extend mode, EXT appears in the status line, and the arrow keys extend the selection.
Shift+F8	Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range.
Shift+Arrow Key	Extend the selection by one cell
Ctrl+Shift+Arrow key	Extend the selection to the last non-blank cell in the same column or row as the active cell
Shift+Home	Extend the selection to the beginning of the row.
Ctrl+Shift+Home	Extend the selection to the beginning of the worksheet.
Ctrl+Shift+End	Extend the selection to the last used cell on the worksheet (lower-right corner).
Shift+Page Down	Extend the selection down one screen.
Shift+Page Up	Extend the selection up one screen.
End+Shift+Arrow key	Extend the selection to the last non-blank cell in the same column or row as the active cell.
End+Shift+Home	Extend the selection to the last used cell on the worksheet (lower-right corner).

Shortcut Keys to Entering Data in Cells
Press Keys	To Do
Enter	Complete a cell entry and select the cell below.
Alt+Enter	Start a new line in the same cell.
Ctrl+Enter	Fill the selected cell range with the current entry.
Shift+Enter	Complete a cell entry and select the previous cell above.
Tab	Complete a cell entry and select the next cell to the right.
Shift+Tab	Complete a cell entry and select the previous cell to the left.
ESC	Cancel a cell entry.
Arrow keys	Move one character up, down, left, or right.
Home	Move to the beginning of the line.
F4 or Ctrl+Y	Repeat the last action.
Ctrl+Shift+F3	Create names (A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) from row and column labels.
Ctrl+D	Fill down.
Ctrl+R	Fill to the right.
Ctrl+F3	Define a name.
Ctrl+K	Insert a hyperlink.
Ctrl+Shift+: (colon)	Enter the time.
Alt+Down Arrow	Display a drop-down list of the values in the current column of a range.
Ctrl+Z	Undo the last action.

Shortcut Keys to Enter and Calculate Formulas
Press Keys	To Do
= (equal sign)	Start a formula.
F2	Move the insertion point into the Formula Bar when editing in a cell is turned off.
Backspace	In the Formula Bar, Delete one character to the left.
ESC	Cancel an entry in the cell or Formula Bar.
Shift+F3	In a formula, display the Insert Function dialog box.
Ctrl+A	When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box.
Alt+= (equal sign)	Insert an AutoSum formula with the SUM function.
Ctrl+Shift+" (quotation mark)	Copy the value from the cell above the active cell into the cell or the Formula Bar.
Ctrl+' (apostrophe)	Copies a formula from the cell above the active cell into the cell or the Formula Bar.
Ctrl+` (single left quotation mark)	Alternate between displaying cell values and displaying formulas.
F9	Calculate all worksheets in all open workbooks.

Shortcut Keys to Edit Data
Press Keys	To Do
F2	Edit the active cell and position the insertion point at the end of the cell contents.
Alt+Enter	Start a new line in the same cell.
Backspace	Edit the active cell and then clear it, or Delete the preceding character in the active cell as you edit cell contents.
Delete	Delete the character to the right of the insertion point, or Delete the selection.
Ctrl+Delete	Delete text to the end of the line.
F7	Display the Spelling dialog box.
Shift+F2	Edit a cell comment
Enter	Complete a cell entry and select the next cell below.
Ctrl+Z	Undo the last action.
ESC	Cancel a cell entry.
Ctrl+Shift+Z	When the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction.

Shortcut Keys to Insert, Delete or Copy Cells
Press Keys	To Do
Ctrl+C	Copy the selected cells.
Ctrl+C, immediately followed by another Ctrl+C	Display the Microsoft Office Clipboard (multiple copy and paste).
Ctrl+X	Cut the selected cells.
Ctrl+V	Paste copied or cut cells
Delete	Clear the contents of the selected cells.
Ctrl+Hyphen	Delete the selected cells.
Ctrl+Shift+Plus Sign	Insert blank cells.

Shortcut Keys to Format Data
Press Keys	To Do
Alt+' (apostrophe)	Display the Style dialog box.
Ctrl+1	Display the Format Cells dialog box.
Ctrl+Shift+~	Apply the General number format.
Ctrl+Shift+$	Apply the Currency format with two decimal places (negative numbers in parentheses).
Ctrl+Shift+%	Apply the Percentage format with no decimal places.
Ctrl+Shift+^	Apply the Exponential number format with two decimal places.
Ctrl+Shift+#	Apply the Date format with the day, month, and year.
Ctrl+Shift+@	Apply the Time format with the hour and minute, and AM or PM.
Ctrl+Shift+!	Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
Ctrl+B	Apply or remove bold formatting.
Ctrl+I	Apply or remove italic formatting.
Ctrl+U	Apply or remove underlining.
Ctrl+5	Apply or remove strikethrough.
Ctrl+9	Hide the selected rows.
Ctrl+Shift+( (opening parenthesis)	Unhide any hidden rows within the selection.
Ctrl+0 (zero)	Hide the selected columns.
Ctrl+Shift+) (closing parenthesis)	Unhide any hidden columns within the selection.
Ctrl+Shift+&	Apply the outline border to the selected cells.
Ctrl+Shift+_	Remove the outline border from the selected cells.