STEPS TO ENABLE HIDDEN THEME IN WINDOW 7

HELLO FRIENDS, TODAY WE LEARN HOW TO ENABLE HIDDEN THEME IN WINDOW 7 , THESE THEME MAKE YOUR WINDOW 7 MUCH MORE BEAUTIFUL AND GOOD LOOKING. JUST FOLLOW SOME STEPS BELOW AND ENJOY,,, BEAUTIFUL THEME.

Simple steps to enable hidden themes in Windows 7, Just follow these steps :

1. Open windows explorer .

2. Click organize and go to folder and search option .

3. From View tab above ,check on “show hidden files and folder” and uncheck “hide protected operating system files” and apply the changes.

4. Now search and browse to the folder: Windows\Globalization\MCT
You will get five folder with name: MCT-AU,MCT-US,MCT-ZA,MCT-CA,MCT-GB , which represent globalization setting for each region .

5. Go to theme folder , which is inside every folder mentioned above and double click on **.theme (** – AU/US /ZA / CA/GB) file to execute and activate the theme .Once activated  it automatically gets saved and available in the personalization settings ,so that user can select this theme later directly from personalization settings.
 

7. Go back to folder option to check “hide protected operating system files and folder ” option, .It is recommended.

Now Your task is over. enjoy....................

Read More

SHORT-CUT KEYS OF TALLY ERP9 FREE DOWNLOAD

These contents are share from other site.

The shortcut keys available in Tally ERP 9 are listed in the table below:

Windows	Functionality	Availability
F1	To select a company To select Accounts Button and inventory Buttons	At all masters menu screen At the Accounting / Inventory vouchers creation and alteration screen
F2	To change the menu period	To change the menu period
F3	To select the company	To change the menu period
F4	To select the Contra voucher	At Accounting / Inventory Voucher creation and alteration screen
F5	To select the Payment voucher	At Accounting / Inventory Voucher creation and alteration screen
F6	To select the Receipt voucher	At Accounting / Inventory Voucher creation and alteration screen
F7	To select the Journal voucher	At Accounting / Inventory Voucher creation and alteration screen
F8	To select the Sales voucher	At Accounting / Inventory Voucher creation and alteration screen
F8 (CTRL+F8)	To select the Credit Note voucher	At Accounting / Inventory Voucher creation and alteration screen
F9	To select the Purchase voucher	At Accounting / Inventory Voucher creation and alteration screen
F9 (CTRL + F9)	To select the Debit Note voucher	At Accounting / Inventory Voucher creation and alteration screen
F10	To select the Reversing Journal voucher	At Accounting / Inventory Voucher creation and alteration screen
F10	To select the Memorandum voucher	At Accounting / Inventory Voucher creation and alteration screen
F11	To select the Functions and Features screen	At almost all screens in TALLY
F12	To select the Configure screen	At almost all screens in TALLY
ALT + 2	To Duplicate a voucher	At List of Vouchers – creates a voucher similar to the one where you positioned the cursor and used this key combination
ALT + A	To Add a voucher	At List of Vouchers – adds a voucher after the one where you positioned the cursor and used this key combination.
ALT + C	To create a master at a voucher screen (if it has not been already assigned a different function, as in reports like Balance Sheet, where it adds a new column to the report)	At voucher entry and alteration screens, at a field where you have to select a master from a list. If the necessary account has not been created already, use this key combination to create the master without quitting from the voucher screen.
ALT + D	To delete a voucher To delete a master (if it has not been already assigned a different function, as explained above)	At Voucher and Master (Single) alteration screens. Masters can be deleted subject to conditions, as explained in the manual.
ALT + C	To create a master at a voucher screen (if it has not been already assigned a different function, as in reports like Balance Sheet, where it adds a new column to the report)	At voucher entry and alteration screens, at a field where you have to select a master from a list. If the necessary account has not been created already, use this key combination to create the master without quitting from the voucher screen.
ALT + D	To delete a voucher To delete a master (if it has not been already assigned a different function, as explained above)	At Voucher and Master (Single) alteration screens. Masters can be deleted subject to conditions, as explained in the manual.
ALT + E	To export the report in ASCII, SDF, HTML OR XML format	At all reports screens in TALLY
ALT + I	To insert a voucher	At List of Vouchers – inserts a voucher before the one where you positioned the cursor and used this key combination.
ALT + R	To remove a line in a report	At all reports screens in TALLY
ALT + S	To bring back a line you removed using ALT + R	At all reports screens in TALLY
ALT + X	To cancel a voucher in Day Book/List of Vouchers	At all voucher screens in TALLY
CTRL + A	To accept a form – wherever you use this key combination, that screen or report gets accepted as it is.	At almost all screens in TALLY, except where a specific detail has to be given before accepting.

DOWNLOAD KEYS FROM BELOW LINK

SHORT-CUT KEY TALLY ERP9 

THANKS

Read More

TALLY SHORTCUT KEYS FREE DOWNLOAD

HELLO FRIENDS, 

HERE U CAN DOWNLOAD TALLY SHORTCUT KEYS.
HERE U CAN FIND FUNCTION KEY COMBINATION, SPECIAL KEY COMBINATION, SPECIAL FUNCTION KEY COMBINATION AND NAVIGATION KEY COMBINATION AND MUCH MORE. FOR THIS U HAVE TO DOWNLOAD FILE FROM BELOW LINK.

DOWNLOAD KEY FROM BELOW LINK

 TALLY SHORTCUT KEYS FREE DOWNLOAD
THANKS

Read More

SHORTCUT KEYS FOR WINDOW XP FREE DOWNLOAD

Keyboard Shortcuts for Windows Xp

To	Press
Set focus on a notification.	Windows Key+B
View properties for the selected item.	ALT+ENTER
Displays the properties of the selected object.	ALT+Enter
Cycle through items in the order they were opened.	ALT+ESC
"Close the active item, or quit the active program.	ALT+F4
Opens the shortcut menu for the active window.	ALT+SPACEBAR
Display the System menu for the active window.	ALT+SPACEBAR
Switch between open items.	ALT+TAB
Carry out the corresponding command or select the corresponding option in a dialog box.	ALT+Underlined letter
Display the corresponding menu.	ALT+Underlined letter in a menu name
Select a button if the active option is a group of option buttons in a dialog box.	Arrow keys
View the folder one level up in My Computer or Windows Explorer.	BACKSPACE
Open a folder one level up if a folder is selected in the Save As or Open dialog box in a dialog box.	BACKSPACE
Copy selected item.	CTRL while dragging an item
Select all.	CTRL+A
Copy.	CTRL+C
Move the insertion point to the beginning of the next paragraph.	CTRL+DOWN ARROW
Display the Start menu.	CTRL+ESC
Close the active document in programs that allow you to have multiple documents open simultaneously.	CTRL+F4
Move the insertion point to the beginning of the previous word.	CTRL+LEFT ARROW
Move the insertion point to the beginning of the next word.	CTRL+RIGHT ARROW
Create shortcut to selected item.	CTRL+SHIFT while dragging an item
Highlight a block of text.	CTRL+SHIFT with any of the arrow keys
Move backward through tabs in a dialog box.	CTRL+SHIFT+TAB
Move forward through tabs in a dialog box.	CTRL+TAB
Move the insertion point to the beginning of the previous paragraph.	CTRL+UP ARROW
Paste.	CTRL+V
Search for computers.	CTRL+Windows Key+F
Cut.	CTRL+X
Undo.	CTRL+Z
Delete.	DELETE
Display the bottom of the active window.	END
Carry out the command for the active option or button in a dialog box.	ENTER
Cancel the current task.	ESC
Display Help in a dialog box.	F1
Activate the menu bar in the active program.	F10
Rename selected item.	F2
Search for a file or folder.	F3
Display the Address bar list in My Computer or Windows Explorer.	F4
Display the items in the active list in a dialog box.	F4
Refresh the active window.	F5
Cycle through screen elements in a window or on the desktop.	F6
Display the top of the active window.	HOME
Switch MouseKeys on and off.	Left ALT +left SHIFT +NUM LOCK
Switch High Contrast on and off.	Left ALT +left SHIFT +PRINT SCREEN
Open the next menu to the left, or close a submenu.	LEFT ARROW
Collapse current selection if it's expanded, or select parent folder.	LEFT ARROW
Display the items in the active list in a dialog box.	F4
Refresh the active window.	F5
Cycle through screen elements in a window or on the desktop.	F6
Display the top of the active window.	HOME
Switch MouseKeys on and off.	Left ALT +left SHIFT +NUM LOCK
Switch High Contrast on and off.	Left ALT +left SHIFT +PRINT SCREEN
Open the next menu to the left, or close a submenu.	LEFT ARROW
Collapse current selection if it's expanded, or select parent folder.	LEFT ARROW
Display the items in the active list in a dialog box.	F4
Refresh the active window.	F5
Cycle through screen elements in a window or on the desktop.	F6
Display the top of the active window.	HOME
Switch MouseKeys on and off.	Left ALT +left SHIFT +NUM LOCK
Switch High Contrast on and off.	Left ALT +left SHIFT +PRINT SCREEN
Open the next menu to the left, or close a submenu.	LEFT ARROW
Collapse current selection if it's expanded, or select parent folder.	LEFT ARROW
Display the shortcut menu for the selected item.	Menu key
Switch ToggleKeys on and off.	NUM LOCK for five seconds
Display all subfolders under the selected folder.	NUM LOCK+ASTERISK on numeric keypad (*)
Collapse the selected folder.	NUM LOCK+MINUS SIGN on numeric keypad (-)
Display the contents of the selected folder.	NUM LOCK+PLUS SIGN on numeric keypad (+)
Open the next menu to the right, or open a submenu.	RIGHT ARROW
Display current selection if it's collapsed, or select first subfolder.	RIGHT ARROW
Switch FilterKeys on and off.	Right SHIFT for eight seconds
Display the items in the active list in a dialog box.	F4
Refresh the active window.	F5
Cycle through screen elements in a window or on the desktop.	F6
Display the top of the active window.	HOME
Switch MouseKeys on and off.	Left ALT +left SHIFT +NUM LOCK
Switch High Contrast on and off.	Left ALT +left SHIFT +PRINT SCREEN
Open the next menu to the left, or close a submenu.	LEFT ARROW
Collapse current selection if it's expanded, or select parent folder.	LEFT ARROW
Display the shortcut menu for the selected item.	Menu key
Switch ToggleKeys on and off.	NUM LOCK for five seconds
Display all subfolders under the selected folder.	NUM LOCK+ASTERISK on numeric keypad (*)
Collapse the selected folder.	NUM LOCK+MINUS SIGN on numeric keypad (-)
Display the contents of the selected folder.	NUM LOCK+PLUS SIGN on numeric keypad (+)
Open the next menu to the right, or open a submenu.	RIGHT ARROW
Display current selection if it's collapsed, or select first subfolder.	RIGHT ARROW
Switch FilterKeys on and off.	Right SHIFT for eight seconds
Switch StickyKeys on and off.	SHIFT five times
Prevent the CD from automatically playing.	SHIFT when you insert a CD into the CD-ROM drive
Select more than one item in a window or on the desktop, or select text within a document.	SHIFT with any of the arrow keys
Delete selected item permanently without placing the item in the Recycle Bin.	SHIFT+DELETE
Display the shortcut menu for the selected item.	SHIFT+F10
Move backward through options in a dialog box.	SHIFT+TAB
Select or clear the check box if the active option is a check box in a dialog box.	SPACEBAR
Move forward through options in a dialog box.	TAB
Carry out the corresponding command.	Underlined letter in a command name on an open menu
Display or hide the Start menu.	Windows Key
Lock your computer if you are connected to a network domain, or switch users if you are not connected to a network domain.	Windows Key+ L
Display the System Properties dialog box.	Windows Key+BREAK
Show the desktop.	Windows Key+D
Open My Computer.	Windows Key+E
Search for a file or folder.	Windows Key+F
Display Windows Help.	Windows Key+F1
Minimize all windows.	Windows Key+M
Open the Run dialog box.	Windows Key+R
Restores minimized windows.	Windows Key+Shift+M
Opens Utility Manager.	Windows Key+U  DOWNLOAD FROM BELOW LINK WINDOW XP SHORTCUT KEYS FREE

Read More

MS OFFICE WORD 2007 & 2003 SHORTCUT KEYS

ShortCut key of office 2007 and 2003 Some key are not work in Office 2003 

 Command Name                  Keyboard shortcuts
   ------------------------------------------------------------------------

   All Caps                      CTRL+SHIFT+A
   Annotation                    ALT+CTRL+M
   App Maximize                  ALT+F10
   App Restore                   ALT+F5
   Apply Heading1                ALT+CTRL+1
   Apply Heading2                ALT+CTRL+2
   Apply Heading3                ALT+CTRL+3
   Apply List Bullet             CTRL+SHIFT+L
   Auto Format                   ALT+CTRL+K
   Auto Text                     F3 or ALT+CTRL+V
   Bold                          CTRL+B or CTRL+SHIFT+B
   Bookmark                      CTRL+SHIFT+F5
   Browse Next                   CTRL+PAGE DOWN
   Browse Previous               CTRL+PAGE UP
   Browse Sel                    ALT+CTRL+HOME
   Cancel                        ESC
   Center Para                   CTRL+E
   Change Case                   SHIFT+F3
   Char Left                     LEFT
   Char Left Extend              SHIFT+LEFT
   Char Right                    RIGHT
   Char Right Extend             SHIFT+RIGHT
   Clear                         DELETE
   Close or Exit                 ALT+F4
   Close Pane                    ALT+SHIFT+C
   Column Break                  CTRL+SHIFT+ENTER
   Column Select                 CTRL+SHIFT+F8
   Copy                          CTRL+C or CTRL+INSERT
   Copy Format                   CTRL+SHIFT+C
   Copy Text                     SHIFT+F2
   Create Auto Text              ALT+F3
   Customize Add Menu            ALT+CTRL+=
   Customize Keyboard            ALT+CTRL+NUM +
   Customize Remove Menu         ALT+CTRL+-
   Cut                           CTRL+X or SHIFT+DELETE
   Date Field                    ALT+SHIFT+D
   Delete Back Word              CTRL+BACKSPACE
   Delete Word                   CTRL+DELETE
   Dictionary                    ALT+SHIFT+F7
   Do Field Click                ALT+SHIFT+F9
   Doc Close                     CTRL+W or CTRL+F4
   Doc Maximize                  CTRL+F10
   Doc Move                      CTRL+F7
   Doc Restore                   CTRL+F5
   Doc Size                      CTRL+F8
   Doc Split                     ALT+CTRL+S
   Double Underline              CTRL+SHIFT+D
   End of Column                 ALT+PAGE DOWN
   End of Column                 ALT+SHIFT+PAGE DOWN
   End of Doc Extend             CTRL+SHIFT+END
   End of Document               CTRL+END
   End of Line                   END
   End of Line Extend            SHIFT+END
   End of Row                    ALT+END
   End of Row                    ALT+SHIFT+END
   End of Window                 ALT+CTRL+PAGE DOWN
   End of Window Extend          ALT+CTRL+SHIFT+PAGE DOWN
   Endnote Now                   ALT+CTRL+D
   Extend Selection              F8
   Field Chars                   CTRL+F9
   Field Codes                   ALT+F9
   Find                          CTRL+F
   Font                          CTRL+D or CTRL+SHIFT+F
   Font Size Select              CTRL+SHIFT+P
   Footnote Now                  ALT+CTRL+F
   Go Back                       SHIFT+F5 or ALT+CTRL+Z
   Go To                         CTRL+G or F5
   Grow Font                     CTRL+SHIFT+.
   Grow Font One Point           CTRL+]
   Hanging Indent                CTRL+T
   Header Footer Link            ALT+SHIFT+R
   Help                          F1
   Hidden                        CTRL+SHIFT+H
   Hyperlink                     CTRL+K
   Indent                        CTRL+M
   Italic                        CTRL+I or CTRL+SHIFT+I
   Justify Para                  CTRL+J
   Left Para                     CTRL+L
   Line Down                     DOWN
   Line Down Extend              SHIFT+DOWN
   Line Up                       UP
   Line Up Extend                SHIFT+UP
   List Num Field                ALT+CTRL+L
   Lock Fields                   CTRL+3 or CTRL+F11
   Macro                         ALT+F8
   Mail Merge Check              ALT+SHIFT+K
   Mail Merge Edit Data Source   ALT+SHIFT+E 
   Mail Merge to Doc             ALT+SHIFT+N
   Mail Merge to Printer         ALT+SHIFT+M
   Mark Citation                 ALT+SHIFT+I
   Mark Index Entry              ALT+SHIFT+X
   Mark Table of Contents Entry  ALT+SHIFT+O
   Menu Mode                     F10
   Merge Field                   ALT+SHIFT+F
   Microsoft Script Editor       ALT+SHIFT+F11
   Microsoft System Info         ALT+CTRL+F1
   Move Text                     F2
   New                           CTRL+N
   Next Cell                     TAB
   Next Field                    F11 or ALT+F1
   Next Misspelling              ALT+F7
   Next Object                   ALT+DOWN
   Next Window                   CTRL+F6 or ALT+F6
   Normal                        ALT+CTRL+N
   Normal Style                  CTRL+SHIFT+N or ALT+SHIFT+CLEAR (NUM 5)
   Open                          CTRL+O or CTRL+F12 or ALT+CTRL+F2
   Open or Close Up Para         CTRL+0
   Other Pane                    F6 or SHIFT+F6
   Outline                       ALT+CTRL+O
   Outline Collapse              ALT+SHIFT+- or ALT+SHIFT+NUM -
   Outline Demote                ALT+SHIFT+RIGHT
   Outline Expand                ALT+SHIFT+=
   Outline Expand                ALT+SHIFT+NUM +
   Outline Move Down             ALT+SHIFT+DOWN
   Outline Move Up               ALT+SHIFT+UP
   Outline Promote               ALT+SHIFT+LEFT
   Outline Show First Line       ALT+SHIFT+L
   Overtype                      INSERT
   Page                          ALT+CTRL+P
   Page Break                    CTRL+ENTER
   Page Down                     PAGE DOWN
   Page Down Extend              SHIFT+PAGE DOWN
   Page Field                    ALT+SHIFT+P
   Page Up                       PAGE UP
   Page Up Extend                SHIFT+PAGE UP
   Para Down                     CTRL+DOWN
   Para Down Extend              CTRL+SHIFT+DOWN
   Para Up                       CTRL+UP
   Para Up Extend                CTRL+SHIFT+UP
   Paste                         CTRL+V or SHIFT+INSERT
   Paste Format                  CTRL+SHIFT+V
   Prev Cell                     SHIFT+TAB
   Prev Field                    SHIFT+F11 or ALT+SHIFT+F1
   Prev Object                   ALT+UP
   Prev Window                   CTRL+SHIFT+F6 or ALT+SHIFT+F6
   Print                         CTRL+P or CTRL+SHIFT+F12
   Print Preview                 CTRL+F2 or ALT+CTRL+I
   Proofing                      F7
   Redo                          ALT+SHIFT+BACKSPACE
   Redo or Repeat                CTRL+Y or F4 or ALT+ENTER
   Repeat Find                   SHIFT+F4 or ALT+CTRL+Y
   Replace                       CTRL+H
   Reset Char                    CTRL+SPACE or CTRL+SHIFT+Z
   Reset Para                    CTRL+Q
   Revision Marks Toggle         CTRL+SHIFT+E
   Right Para                    CTRL+R
   Save                          CTRL+S or SHIFT+F12 or ALT+SHIFT+F2
   Save As                       F12
   Select All                    CTRL+A or CTRL+CLEAR (NUM 5) or CTRL+NUM 5
   Select Table                  ALT+CLEAR (NUM 5)
   Show All                      CTRL+SHIFT+8
   Show All Headings             ALT+SHIFT+A
   Show Heading1                 ALT+SHIFT+1
   Show Heading2                 ALT+SHIFT+2
   Show Heading3                 ALT+SHIFT+3
   Show Heading4                 ALT+SHIFT+4
   Show Heading5                 ALT+SHIFT+5
   Show Heading6                 ALT+SHIFT+6
   Show Heading7                 ALT+SHIFT+7
   Show Heading8                 ALT+SHIFT+8
   Show Heading9                 ALT+SHIFT+9
   Shrink Font                   CTRL+SHIFT+,
   Shrink Font One Point         CTRL+[
   Small Caps                    CTRL+SHIFT+K
   Space Para1                   CTRL+1
   Space Para15                  CTRL+5
   Space Para2                   CTRL+2
   Spike                         CTRL+SHIFT+F3 or CTRL+F3
   Start of Column               ALT+PAGE UP
   Start of Column               ALT+SHIFT+PAGE UP
   Start of Doc Extend           CTRL+SHIFT+HOME
   Start of Document             CTRL+HOME
   Start of Line                 HOME
   Start of Line Extend          SHIFT+HOME
   Start of Row                  ALT+HOME
   Start of Row                  ALT+SHIFT+HOME
   Start of Window               ALT+CTRL+PAGE UP
   Start of Window Extend        ALT+CTRL+SHIFT+PAGE UP
   Style                         CTRL+SHIFT+S
   Subscript                     CTRL+=
   Superscript                   CTRL+SHIFT+=
   Symbol Font                   CTRL+SHIFT+Q
   Thesaurus                     SHIFT+F7
   Time Field                    ALT+SHIFT+T
   Toggle Field Display          SHIFT+F9
   Toggle Master Subdocs         CTRL+\ 
   Tool                          SHIFT+F1
   Un Hang                       CTRL+SHIFT+T
   Un Indent                     CTRL+SHIFT+M
   Underline                     CTRL+U or CTRL+SHIFT+U
   Undo                          CTRL+Z or ALT+BACKSPACE
   Unlink Fields                 CTRL+6 or CTRL+SHIFT+F9
   Unlock Fields                 CTRL+4 or CTRL+SHIFT+F11
   Update Auto Format            ALT+CTRL+U
   Update Fields                 F9 or ALT+SHIFT+U
   Update Source                 CTRL+SHIFT+F7
   VBCode                        ALT+F11
   Web Go Back                   ALT+LEFT
   Web Go Forward                ALT+RIGHT
   Word Left                     CTRL+LEFT
   Word Left Extend              CTRL+SHIFT+LEFT
   Word Right                    CTRL+RIGHT
   Word Right Extend             CTRL+SHIFT+RIGHT
   Word Underline                CTRL+SHIFT+W

****************************************************************************************

DOWNLOAD FILE FROM BELOW LINK

OFFICE 2007& 2003 KEYS FREE DOWNLOAD 

Read More

OFFICE 2007 POWERPOINT SHORTCUT KEYS

 OFFICE 2007 POWERPOINT SHORTCUT KEYS

Action	PowerPoint shortcut
Bold	Ctrl-B
Close	Ctrl-W
Close	Ctrl-F4
Copy	Ctrl-C
Find	Ctrl-F
Italics	Ctrl-I
Menu bar	F10
New slide	Ctrl-N
Next window	Ctrl-F6
Open	Ctrl-O
Paste	Ctrl-V
Print	Ctrl-P
Repeat Find	Shift-F4
Repeat/Redo	Ctrl-Y
Replace	Ctrl-H
Save	Ctrl-S
Slide Show: Begin	F5
Slide Show: Black screen show/hide	B
Slide Show: End	Esc
Slide Show: Erase annotations	E
Slide Show: Go to next hidden slide	H
Slide Show: Hide pointer and button always	Ctrl-L
Slide Show: Hide pointer and button temporarily	Ctrl-H
Slide Show: Mouse pointer to arrow	Ctrl-A
Slide Show: Mouse pointer to pen	Ctrl-P
Slide Show: Next slide	N
Slide Show: Previous slide	P
Slide Show: Set new timings while rehearsing	T
Slide Show: Stop/restart automatic slide show	S
Slide Show: Use mouse-click to advance (rehearsing)	M
Slide Show: Use original timings	O
Slide Show: White screen show/hide	W
Spelling and Grammar check	F7
Switch to the next presentation window	Ctrl-F6
Switch to the next tab in a dialog box	Ctrl-Tab / Ctrl-Page Down
Switch to the previous presentation window	Ctrl-Shift-F6
Switch to the previous tab in a dialog box	Ctrl-Shift-Tab / Ctrl-Page Up
Turn character formatting on or of	Num /
Underline	Ctrl-U
Undo DOWNLOAD KEY FREE IN PDF FORMAT	Ctrl-Z

Read More

OFFICE 2007 EXECL SHORTCUT KEY

Key	Description
CTRL+PgUp	Switches between worksheet tabs, from left-to-right.
CTRL+PgDn	Switches between worksheet tabs, from right-to-left.
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+Plus (+)	Displays the Insert dialog box to insert blank cells.
CTRL+Minus (-)	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. When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box. 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. SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action. CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.
CTRL+G	Displays the Go To dialog box. F5 also displays this 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.

Function keys

Key	Description
F1	Displays the Microsoft Office Excel Help task pane. CTRL+F1 displays or hides the Ribbon, a component of the Microsoft Office Fluent user interface. ALT+F1 creates a chart of the data in the current range. ALT+SHIFT+F1 inserts a new worksheet.
F2	Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off. SHIFT+F2 adds or edits a cell comment. CTRL+F2 displays the Print Preview window.
F3	Displays the Paste Name dialog box. SHIFT+F3 displays the Insert Function dialog box.
F4	Repeats the last command or action, if possible. When a cell reference or range is selected in a formula, F4 cycles through the various combinations of absolute and relative references. CTRL+F4 closes the selected workbook window.
F5	Displays the Go To dialog box. CTRL+F5 restores the window size of the selected workbook window.
F6	Switches between the worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been split (View menu, Manage This Window, Freeze Panes, Split Window command), F6 includes the split panes when switching between panes and the Ribbon area. SHIFT+F6 switches between the worksheet, Zoom controls, task pane, and Ribbon. CTRL+F6 switches to the next workbook window when more than one workbook window is open.
F7	Displays the Spelling dialog box to check spelling in the active worksheet or selected range. CTRL+F7 performs the Move command on the workbook window when it is not maximized. Use the arrow keys to move the window, and when finished press ENTER, or ESC to cancel.
F8	Turns extend mode on or off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the selection. SHIFT+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys. CTRL+F8 performs the Size command (on the Control menu for the workbook window) when a workbook is not maximized. ALT+F8 displays the Macro dialog box to create, run, edit, or delete a macro.
F9	Calculates all worksheets in all open workbooks. SHIFT+F9 calculates the active worksheet. CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. CTRL+F9 minimizes a workbook window to an icon.
F10	Turns key tips on or off. SHIFT+F10 displays the shortcut menu for a selected item. ALT+SHIFT+F10 displays the menu or message for a smart tag. If more than one smart tag is present, it switches to the next smart tag and displays its menu or message. CTRL+F10 maximizes or restores the selected workbook window.
F11	Creates a chart of the data in the current range. SHIFT+F11 inserts a new worksheet. ALT+F11 opens the Microsoft Visual Basic Editor, in which you can create a macro by using Visual Basic for Applications (VBA).
F12	Displays the Save As dialog box.

Other useful shortcut keyS

Key	Description
ARROW KEYS	Move one cell up, down, left, or right in a worksheet. CTRL+ARROW KEY moves to the edge of the current data region in a worksheet. SHIFT+ARROW KEY extends the selection of cells by one cell. CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell. LEFT ARROW or RIGHT ARROW selects the tab to the left or right when the Ribbon is selected. When a submenu is open or selected, these arrow keys switch between the main menu and the submenu. When a Ribbon tab is selected, these keys navigate the tab buttons. DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open. When a Ribbon tab is selected, these keys navigate up or down the tab group. In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options. DOWN ARROW or ALT+DOWN ARROW opens a selected drop-down list.
BACKSPACE	Deletes one character to the left in the Formula Bar. Also clears the content of the active cell. In cell editing mode, it deletes the character to the left of the insertion point.
DELETE	Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments. In cell editing mode, it deletes the character to the right of the insertion point.
END	Moves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on. Also selects the last command on the menu when a menu or submenu is visible. CTRL+END moves to the last cell on a worksheet, in the lowest used row of the rightmost used column. If the cursor is in the formula bar, CTRL+END moves the cursor to the end of the text. CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet (lower-right corner). If the cursor is in the formula bar, CTRL+SHIFT+END selects all text in the formula bar from the cursor position to the end—this does not affect the height of the formula bar.
ENTER	Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default). In a data form, it moves to the first field in the next record. Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command. In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the OK button). ALT+ENTER starts a new line in the same cell. CTRL+ENTER fills the selected cell range with the current entry. SHIFT+ENTER completes a cell entry and selects the cell above.
ESC	Cancels an entry in the cell or Formula Bar. Closes an open menu or submenu, dialog box, or message window. It also closes full screen mode when this mode has been applied, and returns to normal screen mode to display the Ribbon and status bar again.
HOME	Moves to the beginning of a row in a worksheet. Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on. Selects the first command on the menu when a menu or submenu is visible. CTRL+HOME moves to the beginning of a worksheet. CTRL+SHIFT+HOME extends the selection of cells to the beginning of the worksheet.
PAGE DOWN	Moves one screen down in a worksheet. ALT+PAGE DOWN moves one screen to the right in a worksheet. CTRL+PAGE DOWN moves to the next sheet in a workbook. CTRL+SHIFT+PAGE DOWN selects the current and next sheet in a workbook.
PAGE UP	Moves one screen up in a worksheet. ALT+PAGE UP moves one screen to the left in a worksheet. CTRL+PAGE UP moves to the previous sheet in a workbook. CTRL+SHIFT+PAGE UP selects the current and previous sheet in a workbook.
SPACEBAR	In a dialog box, performs the action for the selected button, or selects or clears a check box. CTRL+SPACEBAR selects an entire column in a worksheet. SHIFT+SPACEBAR selects an entire row in a worksheet. CTRL+SHIFT+SPACEBAR selects the entire worksheet. If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the current region and its summary rows. Pressing CTRL+SHIFT+SPACEBAR a third time selects the entire worksheet. When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet. ALT+SPACEBAR displays the Control menu for the Microsoft Office Excel window.
TAB	Moves one cell to the right in a worksheet. Moves between unlocked cells in a protected worksheet. Moves to the next option or option group in a dialog box. SHIFT+TAB moves to the previous cell in a worksheet or the previous option in a dialog box. CTRL+TAB switches to the next tab in dialog box. CTRL+SHIFT+TAB switches to the previous tab in a dialog box. DOWNLOAD 2007 EXECL SHORTCUT KEY

Read More