Keyboard Shortcuts

Keyboard Shortcuts

1    CTRL+C (Copy)
2    CTRL+X (Cut)
3    CTRL+V (Paste)
4    CTRL+Z (Undo)
5    DELETE (Delete)
6    SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)
7    CTRL while dragging an item (Copy the selected item)
8    CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
9    F2 key (Rename the selected item)
10    CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)
11    CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
12    CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
13    CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
14    CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
15    SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)
16    CTRL+A (Select all)
17    F3 key (Search for a file or a folder)
18    ALT+ENTER (View the properties for the selected item)
19    ALT+F4 (Close the active item, or quit the active program)
20    ALT+ENTER (Display the properties of the selected object)
21    ALT+SPACEBAR (Open the shortcut menu for the active window)
22    CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously)
23    ALT+TAB (Switch between the open items)
24    ALT+ESC (Cycle through items in the order that they had been opened)
25    F6 key (Cycle through the screen elements in a window or on the desktop)
26    F4 key (Display the Address bar list in My Computer or Windows Explorer)
27    SHIFT+F10 (Display the shortcut menu for the selected item)
28    ALT+SPACEBAR (Display the System menu for the active window)
29    CTRL+ESC (Display the Start menu)
30    ALT+Underlined letter in a menu name (Display the corresponding menu)
31    Underlined letter in a command name on an open menu (Perform the corresponding command)
32    F10 key (Activate the menu bar in the active program)
33    RIGHT ARROW (Open the next menu to the right, or open a submenu)
34    LEFT ARROW (Open the next menu to the left, or close a submenu)
35    F5 key (Update the active window)
36    BACKSPACE (View the folder one level up in My Computer or Windows Explorer)
37    ESC (Cancel the current task)
38    SHIFT when you insert a CD-ROM into the CD-ROM drive (Prevent the CD-ROM from automatically playing)

Dialog Box Keyboard Shortcuts

1.CTRL+TAB (Move forward through the tabs)
2.CTRL+SHIFT+TAB (Move backward through the tabs)
3.TAB (Move forward through the options)
4.SHIFT+TAB (Move backward through the options)
5.ALT+Underlined letter (Perform the corresponding command or select the corresponding option)
6.ENTER (Perform the command for the active option or button)
7.SPACEBAR (Select or clear the check box if the active option is a check box)
8.Arrow keys (Select a button if the active option is a group of option buttons)
9.F1 key (Display Help)
10.F4 key (Display the items in the active list)
11.BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open dialog box)

Microsoft Natural Keyboard Shortcuts

1.Windows Logo (Display or hide the Start menu)
2.Windows Logo+BREAK (Display the System Properties dialog box)
3.Windows Logo+D (Display the desktop)
4.Windows Logo+M (Minimize all of the windows)
5.Windows Logo+SHIFT+M (Restore the minimized windows)
6.Windows Logo+E (Open My Computer)
7.Windows Logo+F (Search for a file or a folder)
8.CTRL+Windows Logo+F (Search for computers)
9.Windows Logo+F1 (Display Windows Help)
10.Windows Logo+ L (Lock the keyboard)
11.Windows Logo+R (Open the Run dialog box)
12.Windows Logo+U (Open Utility Manager)

Accessibility Keyboard Shortcuts

1.Right SHIFT for eight seconds (Switch FilterKeys either on or off)
2.Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)
3.Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)
4.SHIFT five times (Switch the StickyKeys either on or off)
5.NUM LOCK for five seconds (Switch the ToggleKeys either on or off)
6.Windows Logo +U (Open Utility Manager)

Windows Explorer Keyboard Shortcuts

1.END (Display the bottom of the active window)
2.HOME (Display the top of the active window)
3.NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder)
4.NUM LOCK+Plus sign (+) (Display the contents of the selected folder)
5.NUM LOCK+Minus sign (-) (Collapse the selected folder)
6.LEFT ARROW (Collapse the current selection if it is expanded, or select the parent folder)
7.RIGHT ARROW (Display the current selection if it is collapsed, or select the first subfolder)

Shortcut Keys for Character Map

After you double-click a character on the grid of characters, you can move through the grid by using the keyboard shortcuts:
1.RIGHT ARROW (Move to the right or to the beginning of the next line)
2.LEFT ARROW (Move to the left or to the end of the previous line)
3.UP ARROW (Move up one row)
4.DOWN ARROW (Move down one row)
5.PAGE UP (Move up one screen at a time)
6.PAGE DOWN (Move down one screen at a time)
7.HOME (Move to the beginning of the line)
8.END (Move to the end of the line)
9.CTRL+HOME (Move to the first character)
10.CTRL+END (Move to the last character)
11.SPACEBAR (Switch between Enlarged and Normal mode when a character is selected)

Microsoft Management Console (MMC) Main Window Keyboard Shortcuts

1.CTRL+O (Open a saved console)
2.CTRL+N (Open a new console)
3.CTRL+S (Save the open console)
4.CTRL+M (Add or remove a console item)
5.CTRL+W (Open a new window)
6.F5 key (Update the content of all console windows)
7.ALT+SPACEBAR (Display the MMC window menu)
8.ALT+F4 (Close the console)
9.ALT+A (Display the Action menu)
10.ALT+V (Display the View menu)
11.ALT+F (Display the File menu)
12.ALT+O (Display the Favorites menu)
13.MMC Console Window Keyboard Shortcuts
14.CTRL+P (Print the current page or active pane)
15.ALT+Minus sign (-) (Display the window menu for the active console window)
16.SHIFT+F10 (Display the Action shortcut menu for the selected item)
17.F1 key (Open the Help topic, if any, for the selected item)
18.F5 key (Update the content of all console windows)
19.CTRL+F10 (Maximize the active console window)
20.CTRL+F5 (Restore the active console window)
21.ALT+ENTER (Display the Properties dialog box, if any, for the selected item)
22.F2 key (Rename the selected item)
23.CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console)


 

Remote Desktop Connection Navigation

1.CTRL+ALT+END (Open the m*cro$oft Windows NT Security dialog box)
2.ALT+PAGE UP (Switch between programs from left to right)
3.ALT+PAGE DOWN (Switch between programs from right to left)
4.ALT+INSERT (Cycle through the programs in most recently used order)
5.ALT+HOME (Display the Start menu)
6.CTRL+ALT+BREAK (Switch the client computer between a window and a full screen)
7.ALT+DELETE (Display the Windows menu)
8.CTRL+ALT+Minus sign (-) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.)
9.CTRL+ALT+Plus sign (+) (Place a snapshot of the entire client window area on the Terminal server clipboard and provide the same functionality as pressing ALT+PRINT SCREEN on a local computer.)

Microsoft Internet Explorer Navigation

1.CTRL+B (Open the Organize Favorites dialog box)
2.CTRL+E (Open the Search bar)
3.CTRL+F (Start the Find utility)
4.CTRL+H (Open the History bar)
5.CTRL+I (Open the Favorites bar)
6.CTRL+L (Open the Open dialog box)
7.CTRL+N (Start another instance of the browser with the same Web address)
8.CTRL+O (Open the Open dialog box, the same as CTRL+L)
9.CTRL+P (Open the Print dialog box)
10.CTRL+R (Update the current Web page)
11.CTRL+W (Close the current window)

Shortcuts - Excel

1. Apply the outline border to the selected cells. [ Ctrl-Shift-& ]

2. Apply the Date format with the day, month, and year.[ Ctrl-Shift-# ]

3. Copy the same in down cell [Ctrl-d]

4. Enter the current time. [ Ctrl-Shift-: ]

5. Enter the current date. [ Ctrl-; ]

6. Hide the selected rows. [ Ctrl-9 ]

7. Hide the selected columns. [ Ctrl-0 ]

8. Alternate between displaying cell values and displaying formulas in the worksheet. [ Ctrl-` ]

9. Display the Find and Replace dialog box, with the Replace tab selected. [ Ctrl-H ]

10. Display the Insert Hyperlink dialog box for new hyperlink. [ Ctrl-K ]

11. Display the Print Preview window. [ Ctrl-F2 ]

12. Switch to the next workbook window. [ Ctrl-F6 ]

13. Display the Macro dialog box to create, run, edit, or delete a macro. [ Alt-F8 ]

This Excel contains a flash trick..

Designed to test your Concentration.

Click the below link to view


Check ur Concentration

Shortcut Keys MS EXCEL

As a professional in your field, you already know the benefits of using Microsoft Excel. There is a way to make it an even more powerful tool in the management of your business. The benefit of additional Microsoft Excel training for your employees will give you a more efficient vision of your operation as well as improve your bottom line.

Taking advantage of the information available on the use of MS Excel shortcuts can enable one to develop an understanding of the different excel hotkeys and save valuable time.   However, you don’t need to memorize them all in order to become an excel expert.  Take note of the tasks that you repeat often, and then search the list below to see if Microsoft programmed in a quicker way for you to complete that task by using a shortcut.

 Below is a listing of all the major shortcut keys in Microsoft Excel. See the computer shortcut page if you are looking for other shortcut keys used in other programs.


Click to Download

Description   Daily & Monthly Expense Sheet. You could catch up even minute unwanted expenditure from your pocket. Very useful for middle class people. This is basically just a strip version of my household budget spreadsheet where it is only can be used to track and record your expenses without budget consideration. It consist of three worksheets, category worksheet, daily income and expenses worksheet and monthly expenses worksheet. 
The beauty of budgeting sheet is that, once you have started to cut down, you can see your savings in black and white.
Keep your completed monthly budgets in a file folder.  At the end of the year, total up your monthly spending to find out how much you spend per year, how much you earn, and how much your yearly expenses are by category.
 


Click to View or download

Translate English to 10 Indian Languages

Translate English to 10 Indian Languages!!!


This excel translates English to ten Indian languages

1. Hindi                

2. Telugu

3. Urdu

4. Kannada

5. Marathi

6. Gujarati

7. Bengali

8. Tamil

9. Malayalam

10. Odia 
 

Tom & Jerry

Have a nice fun...

 Click to play this interesting game : Tom & Jerry - Game

Benefits of Microsoft Excel

excel helps us to make our calculations faster and we can draw conclusions faster by making graphs, pie charts.
The layout of Rows and Columns makes it very useful for Accounting calculations and bookkeeping. The columns can be summed for a total or added to other columns.
The data can be sorted easily. This is useful for lists of addresses and other type of data banks.