Technology Blog | Technology News

1 CTRL+B Applies or removes bold formatting.
2 ALT+DOWN ARROW opens a selected drop-down list. 
3 ALT+ENTER starts a new line in the same cell. 
4 ALT+F1 creates a chart of the data in the current range. 
5 ALT+F11 opens the Visual Basic Editor, in which you can create a macro by
using Visual Basic for 
6 ALT+F8 displays the Macro dialog box to run, edit, or delete a macro. 
7 ALT+PAGE DOWN moves one screen to the right in a worksheet. 
8 ALT+PAGE UP moves one screen to the left in a worksheet.
9 ALT+SHIFT+F1 inserts a new worksheet. 
10 ALT+SHIFT+F10 displays the menu or message for a smart tag. If more than
one smart tag is present, it 
11 ALT+SHIFT+F11 opens the Microsoft Script Editor, where you can add text,
edit HTML tags, and modify any 
12 ALT+SPACEBAR displays the Control menu for the Excel window. 
13 Applications (VBA). 
14 ARROW KEYS Move one cell up, down, left, or right in a worksheet.
15 as the active cell. 
16 Available only after you cut or copied an object, text, or cell contents. 
17 BACKSPACE Deletes one character to the left in the Formula Bar. 
18 CTRL Alternates between displaying cell values and displaying formulas in
the worksheet. 
19 CTRL+ Apostrophe - Copies a formula from the cell above the active cell
into the cell or the Formula Bar. 
20 CTRL+- Displays the Delete dialog box to delete the selected cells. 
21 CTRL+ Quote -Copies the value from the cell above the active cell into the
cell or the Formula Bar. 
22 CTRL+ semicolon Enters the current date. 
23 CTRL+! Applies the Number format with two decimal places, thousands
separator, and minus sign (-) for 
24 CTRL+# Applies the Date format with the day, month, and year. 
25 CTRL+$ Applies the Currency format with two decimal places (negative
numbers in parentheses). 
26 CTRL+% Applies the Percentage format with no decimal places. 
27 CTRL+& Applies the outline border to the selected cells. 
28 CTRL+( Unhides any hidden rows within the selection. 
29 CTRL+) Unhides any hidden columns within the selection. 
30 CTRL+* Selects the current region around the active cell (the data area
enclosed by blank rows and blank columns). 
31 CTRL+: Enters the current time. 
32 CTRL+@ Applies the Time format with the hour and minute, and AM or PM. 
33 CTRL+^ Applies the Exponential number format with two decimal places. 
34 CTRL+_ Removes the outline border from the selected cells. 
35 CTRL+~ Applies the General number format. 
36 CTRL++ Displays the Insert dialog box to insert blank cells. 
37 CTRL+0 Hides the selected columns. 
38 CTRL+1 Displays the Format Cells dialog box. 
39 CTRL+2 Applies or removes bold formatting. 
40 CTRL+3 Applies or removes italic formatting. 
41 CTRL+4 Applies or removes underlining. 
42 CTRL+5 Applies or removes strikethrough.
43 CTRL+6 Alternates between hiding objects, displaying objects, and
displaying placeholders for objects. 
44 CTRL+7 Displays or hides the Standard toolbar. 
45 CTRL+8 Displays or hides the outline symbols. 
46 CTRL+9 Hides the selected rows. 
47 CTRL+A Selects the entire worksheet. With Data- CTRL+A Selects the entire
worksheet. 
48 CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of
whether they have changed 
49 CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all
cells in all open workbooks, 
50 CTRL+ARROW KEY
moves to the edge of the current data region (data region: A
range of cells that contains