Category: INFO

WINDOWS SHORTCUTS

Posted on by PRADEEP KUMAR GUPTA in INFO
Windows system key combinations
F1: Help
CTRL+ESC: Open Start menu
ALT+TAB: Switch between open programs
ALT+F4: Quit program
SHIFT+DELETE: Delete item permanently
Windows Logo+L: Lock the computer (without using CTRL+ALT+DELETE)
Windows program key combinations
CTRL+C: Copy
CTRL+X: Cut
CTRL+V: Paste
CTRL+Z: Undo
CTRL+B: Bold
CTRL+U: Underline
CTRL+I: Italic
Mouse click/keyboard modifier combinations for shell objects
SHIFT+right click: Displays a shortcut menu containing alternative commands
SHIFT+double click: Runs the alternate default command (the second item on the menu)
ALT+double click: Displays properties
SHIFT+DELETE: Deletes an item immediately without placing it in the Recycle Bin
General keyboard-only commands
F1: Starts Windows Help
F10: Activates menu bar options
SHIFT+F10 Opens a shortcut menu for the selected item (this is the same as right-clicking an object
CTRL+ESC: Opens the Start menu (use the ARROW keys to select an item)
CTRL+ESC or ESC: Selects the Start button (press TAB to select the taskbar, or press SHIFT+F10 for a context menu)
CTRL+SHIFT+ESC: Opens Windows Task Manager
ALT+DOWN ARROW: Opens a drop-down list box
ALT+TAB: Switch to another running program (hold down the ALT key and then press the TAB key to view the task-switching window)
SHIFT: Press and hold down the SHIFT key while you insert a CD-ROM to bypass the automatic-run feature
ALT+SPACE: Displays the main window’s System menu (from the System menu, you can restore, move, resize, minimize, maximize, or close the window)
ALT+- (ALT+hyphen): Displays the Multiple Document Interface (MDI) child window’s System menu (from the MDI child window’s System menu, you can restore, move, resize, minimize, maximize, or close the child window)
CTRL+TAB: Switch to the next child window of a Multiple Document Interface (MDI) program
ALT+underlined letter in menu: Opens the menu
ALT+F4: Closes the current window
CTRL+F4: Closes the current Multiple Document Interface (MDI) window
ALT+F6: Switch between multiple windows in the same program (for example, when the Notepad Find dialog box is displayed, ALT+F6 switches between the Find dialog box and the main Notepad window)
Shell objects and general folder/Windows Explorer shortcuts
For a selected object:
F2: Rename object
F3: Find all files
CTRL+X: Cut
CTRL+C: Copy
CTRL+V: Paste
SHIFT+DELETE: Delete selection immediately, without moving the item to the Recycle Bin
ALT+ENTER: Open the properties for the selected object
To copy a file
Press and hold down the CTRL key while you drag the file to another folder.
To create a shortcut
Press and hold down CTRL+SHIFT while you drag a file to the desktop or a folder.
General folder/shortcut control
F4: Selects the Go To A Different Folder box and moves down the entries in the box (if the toolbar is active in Windows Explorer)
F5: Refreshes the current window.
F6: Moves among panes in Windows Explorer
CTRL+G: Opens the Go To Folder tool (in Windows 95 Windows Explorer only)
CTRL+Z: Undo the last command
CTRL+A: Select all the items in the current window
BACKSPACE: Switch to the parent folder
SHIFT+click+Close button: For folders, close the current folder plus all parent folders
Windows Explorer tree control
Numeric Keypad *: Expands everything under the current selection
Numeric Keypad +: Expands the current selection
Numeric Keypad -: Collapses the current selection.
RIGHT ARROW: Expands the current selection if it is not expanded, otherwise goes to the first child
LEFT ARROW: Collapses the current selection if it is expanded, otherwise goes to the parent
Properties control
CTRL+TAB/CTRL+SHIFT+TAB: Move through the property tabs
Accessibility shortcuts
Press SHIFT five times: Toggles StickyKeys on and off
Press down and hold the right SHIFT key for eight seconds: Toggles FilterKeys on and off
Press down and hold the NUM LOCK key for five seconds: Toggles ToggleKeys on and off
Left ALT+left SHIFT+NUM LOCK: Toggles MouseKeys on and off
Left ALT+left SHIFT+PRINT SCREEN: Toggles high contrast on and off
Microsoft Natural Keyboard keys
Windows Logo: Start menu
Windows Logo+R: Run dialog box
Windows Logo+M: Minimize all
SHIFT+Windows Logo+M: Undo minimize all
Windows Logo+F1: Help
Windows Logo+E: Windows Explorer
Windows Logo+F: Find files or folders
Windows Logo+D: Minimizes all open windows and displays the desktop
CTRL+Windows Logo+F: Find computer
CTRL+Windows Logo+TAB: Moves focus from Start, to the Quick Launch toolbar, to the system tray (use RIGHT ARROW or LEFT ARROW to move focus to items on the Quick Launch toolbar and the system tray)
Windows Logo+TAB: Cycle through taskbar buttons
Windows Logo+Break: System Properties dialog box
Application key: Displays a shortcut menu for the selected item
Microsoft Natural Keyboard with IntelliType software installed
Windows Logo+L: Log off Windows
Windows Logo+P: Starts Print Manager
Windows Logo+C: Opens Control Panel
Windows Logo+V: Starts Clipboard
Windows Logo+K: Opens Keyboard Properties dialog box
Windows Logo+I: Opens Mouse Properties dialog box
Windows Logo+A: Starts Accessibility Options (if installed)
Windows Logo+SPACEBAR: Displays the list of Microsoft IntelliType shortcut keys
Windows Logo+S: Toggles CAPS LOCK on and off
Dialog box keyboard commands
TAB: Move to the next control in the dialog box
SHIFT+TAB: Move to the previous control in the dialog box
SPACEBAR: If the current control is a button, this clicks the button. If the current control is a check box, this toggles the check box. If the current control is an option, this selects the option.
ENTER: Equivalent to clicking the selected button (the button with the outline)
ESC: Equivalent to clicking the Cancel button
ALT+underlined letter in dialog box item: Move to the corresponding item
Advertisements

POWERPOINT SHORTCUTS

Posted on by PRADEEP KUMAR GUPTA in INFO
Command Shortcut
Group objects Ctrl+Shift+G
Ungroup objects Ctrl+Shift+H
Show or hide grid Shift+F9
Show or hide guides Alt+F9
Change grid or guide settings Ctrl+G
Show AutoShape menu and insert shape Alt+U -> Ctrl+ENTER
Insert perfect squares Press shift first, start drawing figure
Move selection in specific direction Ctrl+ARROW
Zoom Ctrl+mouse wheel
Duplicate selectedshapes Ctrl+D
Insert new slide Ctrl+M
Draw multiple similar figures Double-click corresponding toolbar icon
Repeatlast action F4
Activate menu bar F10
Context menu Shift+F10 or Windows special key
Work with presentations Shortcut
Create new presentation Ctrl+N
Insertnew slide Ctrl+M
Duplicate selected slide Ctrl+D
Open a presentations Ctrl+O
Close presentation Ctrl+W
Print presentation Ctrl+P
Save presentation Ctrl+S
Quit PowerPoint Alt+F4
Find text Ctrl+F
Replace text Ctrl+H
Repeat the last find action Shift+F4
Insert a hyperlink Ctrl+K
Undo an action Ctrl+Z
Redo or repeat an action Ctrl+Y
Switch to the next pane F6
Switch to the previous pane Shift+F6
Cancel an action ESC
Carry out Save As command F12
Carry out Save command Shift+F12
Carry out Open command Ctrl+F12
Carry out Print command Ctrl+Shift+F12
Display Visual Basic code Alt+F11
Text operations Shortcut
Delete one word to the left Ctrl+BACKSPACE
Delete one word to the right Ctrl+DELETE
Cut selected object Ctrl+X
Copy selected object Ctrl+C
Paste cut or copied object Ctrl+V
Move cursor one word to the left Ctrl+LEFT ARROW
Move cursor one word to the right Ctrl+RIGHT ARROW
Changecase letters (toggles through sentence case, lowercase, and uppercase) Shift+F3
Center paragraph Ctrl+E
Justify paragraph Ctrl+J
Left align paragraph Ctrl+L
Right align paragraph Ctrl+R
Promoteparagraph Alt+Shift+LEFT ARROW
Demote paragraph Alt+Shift+RIGHT ARROW
Move selected paragraphs up Alt+Shift+UP ARROW
Move selected paragraphs down Alt+Shift+DOWN ARROW
Format font style Ctrl+T
Changefont size Ctrl+Shift+P
Increasefont size Ctrl+Shift+>
Decrease font size Ctrl+Shift+<
Apply bold formatting Ctrl+B
Apply an underline Ctrl+U
Apply italic formatting Ctrl+I
Apply subscript formatting Ctrl+EQUAL SIGN
Apply superscript formatting Ctrl+Shift+PLUS SIGN
Remove manual character formatting Ctrl+SPACEBAR
Copy formats Ctrl+Shift+C
Paste formats Ctrl+Shift+V
Insert a tab in a table cell Ctrl+TAB
Addnew row at the bottom of a table TAB at the end of the last row
Check spelling F7
Find next misspelling (Automatic Spell Checking enabled) Shift+F7
Selection Shortcut
Select next object (with an object selected) TAB or Shift+TAB
Select text within selected object ENTER
Select all objects Ctrl+A (in slide pane)
Select all slides Ctrl+A (in slide sorter view)
Select all text Ctrl+A (in text field)
Move to the end of a line END
Move to the beginning of a line HOME
Move up one paragraph Ctrl+UP ARROW
Move down one paragraph Ctrl+DOWN ARROW
Control slide shows Shortcut
Start slideshow from current slide Shift+F5
Slideshow from beginning F5
Perform next animation or advance tonext slide ENTER, PAGE DOWN, RIGHT ARROW, DOWN ARROW, SPACEBAR, or mouse click
Perform previous animation or return toprevious slide P, PAGE UP, LEFT ARROW, UP ARROW, or BACKSPACE
Go to slide <number>+ENTER
Display a black screen, or return to slide show from black screen B or PERIOD
Display a white screen, or return to the slide show from a white screen W or COMMA
Stop or restartautomatic slide show S or PLUS SIGN
End slide show ESC, Ctrl+BREAK, or HYPHEN
Erase on-screen annotations E
Go to next hidden slide H
Set new timings while rehearsing T
Use original timings while rehearsing O
Use mouse-click to advance while rehearsing M
Return to first slide HOME or both mouse buttons for 2 seconds
Redisplay hidden pointer and/or change the pointer to a pen Ctrl+P
Redisplay hidden pointer and/or change the pointer to an arrow Ctrl+A
Hidepointer and button immediately Ctrl+H
Hidepointer and button in 15 seconds Ctrl+U
Display shortcut menu Shift+F10 or right-click or special windows key
Go to first or next hyperlink on slide TAB
Go to last or previous hyperlink on slide Shift+TAB
Perform “mouse click” behavior of selected hyperlink ENTER while hyperlink is selected
Perform “mouse over” behavior of selected hyperlink Shift+ENTER while hyperlink is selected
Display list of controls F1

WORD 2010 SHORTCUTS

Posted on by PRADEEP KUMAR GUPTA in INFO
Display and use windows
To Do This Press
Switch to the next window. ALT+TAB
Switch to the previous window. ALT+SHIFT+TAB
Close the active window. CTRL+W or CTRL+F4
Restore the size of the active window after you maximize it. ALT+F5
Move to a task pane from another pane in the program window (clockwise direction). You may need to press F6 more than once. F6
Move to a task pane from another pane in the program window (counterclockwise direction). SHIFT+F6
When more than one window is open, switch to the next window. CTRL+F6
Switch to the previous window. CTRL+SHIFT+F6
Maximize or restore a selected window. CTRL+F10
Copy a picture of the screen to the Clipboard. PRINT SCREEN
Copy a picture of the selected window to the Clipboard. ALT+PRINT SCREEN
Use dialog boxes
To Do This Press
Move to the next option or option group. TAB
Move to the previous option or option group. SHIFT+TAB
Switch to the next tab in a dialog box. CTRL+TAB
Switch to the previous tab in a dialog box. CTRL+SHIFT+TAB
Move between options in an open drop-down list, or between options in a group of options. Arrow keys
Perform the action assigned to the selected button; select or clear the selected check box. SPACEBAR
Select an option; select or clear a check box. ALT+ the letter underlined in an option
Open a selected drop-down list. ALT+DOWN ARROW
Select an option from a drop-down list. First letter of an option in a drop-down list
Close a selected drop-down list; cancel a command and close a dialog box. ESC
Run the selected command. ENTER
Use edit boxes within dialog boxes
An edit box is a blank in which you type or paste an entry, such as your user name or the path of a folder.
To Do This Press
Move to the beginning of the entry. HOME
Move to the end of the entry. END
Move one character to the left or right. LEFT ARROW or RIGHT ARROW
Move one word to the left. CTRL+LEFT ARROW
Move one word to the right. CTRL+RIGHT ARROW
Select or unselect one character to the left. SHIFT+LEFT ARROW
Select or unselect one character to the right. SHIFT+RIGHT ARROW
Select or unselect one word to the left. CTRL+SHIFT+LEFT ARROW
Select or unselect one word to the right. CTRL+SHIFT+RIGHT ARROW
Select from the insertion point to the beginning of the entry. SHIFT+HOME
Select from the insertion point to the end of the entry. SHIFT+END
Use the Open and Save As dialog boxes
To Do This Press
Display the Open dialog box. CTRL+F12 or CTRL+O
Display the Save As dialog box. F12
Open the selected folder or file. ENTER
Open the folder one level above the selected folder. BACKSPACE
Delete the selected folder or file. DELETE
Display a shortcut menu for a selected item such as a folder or file. SHIFT+F10
Move forward through options. TAB
Move back through options. SHIFT+TAB
Open the Look in list. F4 or ALT+I
Undo and redo actions
To Do This Press
Cancel an action. ESC
Undo an action. CTRL+Z
Redo or repeat an action. CTRL+Y
Access and use task panes and galleries
To Do This Press
Move to a task pane from another pane in the program window. (You may need to press F6 more than once.) F6
When a menu is active, move to a task pane. (You may need to press CTRL+TAB more than once.) CTRL+TAB
When a task pane is active, select the next or previous option in the task pane. TAB or SHIFT+TAB
Display the full set of commands on the task pane menu. CTRL+SPACEBAR
Perform the action assigned to the selected button. SPACEBAR or ENTER
Open a drop-down menu for the selected gallery item. SHIFT+F10
Select the first or last item in a gallery. HOME or END
Scroll up or down in the selected gallery list. PAGE UP or PAGE DOWN

TALLY 9 SHORTCUTS

Posted on by PRADEEP KUMAR GUPTA in INFO
GENERAL
Alt+2 Duplicate Voucher
Alt+A Add voucher / To Alter the column in columnar report
Alt+C Create a master at a voucher screen (if it has not been already assigned a different function, as in reports like Balance Sheet, wh
Alt+D Delete a voucher To delete Accounting or Inventory master which is not used by any voucher or elsewhere in the alteration mode. To
Alt+E Export the report in ASCII, HTML OR XML format
Alt+I Insert a voucher / To toggle between Item and Accounting invoice
Alt+N To view the report in automatic columns (Multiple Columns at all reports, Trial Balance, Cash/bank books, Group Summary & Journal Reg
Alt+P Print the report
Alt+R Remove a line in a report
Alt+S Bring back a line you removed using Alt+R
Alt+U Retrieve the last line which is deleted using Alt+R
Alt+W To view the Tally Web browser.
Alt+X Cancel a voucher in Day Book/List of Vouchers
Alt+Y Register Tally
Ctrl+A Accept a form – wherever you use this key combination, that screen or report gets accepted as it is.
Ctrl+Alt+B Check the Company Statutory details
Ctrl+G Select Group
Alt+I Import statutory masters
Ctrl+Q Abandon a form – wherever you use this key combination, it quits that screen without making any changes to it.
Ctrl+Alt+R Rewrite data for a Company
Alt+H Help Shortcut
Alt+F2 Maintain Date for Multiple Years by changing period on Gateway of Tally / Change of Period for Setting Period
Ctrl+M Switches to Main Area of Tally Screen
Ctrl+N Switches to Calculator / ODBC Section of Tally Screen
Alt+R Recalls the last narration saved for the first ledger in the voucher, irrespective of the voucher type
Ctrl+R Repeat narration in the same voucher type irrespective of Ledger Account
Ctrl+T Mark any voucher as Post Dated Voucher
Alt+D Delete any voucher in Day Book/ Deleting
Alt+O To upload the report to the webe
Alt+M Email the report
Alt+F1 Close a Company (At All Menu Screens). View detailed Report (Report Screens). Explore a line into its details (At Almost all Screens)
Alt+F3 Select the company info menu (At Gateway of Tally Screen). Create/ alter / shut a company (At Gateway of Tally Screen)
Alt+F5 View sales and purchase register summary on a quarterly basis
Alt+F12 View the filters screen where the range of information can be specified
Alt+Z Zoom
Ctrl+Alt+C Copy the text from Tally (At creation and alternation screens)
Ctrl+Alt+V To paste the text from Tally (At creation and alternation screens)
Shift+Enter To view the next level of details and / or condense the next level of details
F2 Change the date
F4 Contra Voucher (All voucher creation and alteration screens). View list of Groups (Reports groups summary, group voucher screen, cash/ bank summary)
F5 Select Payment Voucher. Switch between Grouped and Ledger-wise Display
F6 Select Receipt Voucher
F7 Select Journal Voucher
F8 Select Sales Voucher
F9 Select Purchase Voucher
Ctrl+F9 Select Debit Note Voucher
F10 Navigate between Accounting Reports
F11 Modify Company features specific to current company only
F12 Master Configurations, which will affect all companies in same data directory.
Ctrl+L Mark a voucher as Optional or Regular
Ctrl+Alt+c (for copy) Ctrl+Alt+v (for paste) Duplicate narration in many Vouchers
INVENTORY VOUCHERS
Alt+F4 Purchase Order Voucher
Alt+F5 Sales Order Voucher
Ctrl+F6 Rejection In
Alt+F7 Stock Journal / Manufacturing Journal
Alt+F8 Delivery Note
Alt+F9 Receipt Note
Alt+F10 Physical Stock
Esc Clear entry

EXCEL SHORTCUTS

Posted on by PRADEEP KUMAR GUPTA in INFO
Function Short cut
Select All Ctrl+A
Bold Ctrl+B
Copy Ctrl+C
Fill Down Ctrl+D
Find Ctrl+F
Goto Ctrl+G
Replace Ctrl+H
Italic Ctrl+I
Insert Hyperlink Ctrl+K
New Workbook Ctrl+N
Open Ctrl+O
Print Ctrl+P
Fill Right Ctrl+R
Save Ctrl+S
Underline Ctrl+U
Paste Ctrl+V
Close Ctrl W
Cut Ctrl+X
Repeat Ctrl+Y
Undo Ctrl+Z
Help F1
Edit F2
Paste Name F3
Repeat last action F4
While typing a formula, switch between absolute/relative refs F4
Goto F5
Next Pane F6
Spell check F7
Extend mode F8
Recalculate all workbooks F9
Activate Menubar F10
New Chart F11
Save As F12
Insert Current Time Ctrl+:
Insert Current Date Ctrl+;
Copy Value from Cell Above Ctrl+”
Copy Formula from Cell Above Ctrl+’
Hold down shift for additional functions in Excel’s menu Shift
What’s This? Shift+F1
Edit cell comment Shift+F2
Paste function into formula Shift+F3
Find Next Shift+F4
Find Shift+F5
Previous Pane Shift+F6
Add to selection Shift+F8
Calculate active worksheet Shift+F9
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. Ctrl+Alt+F9
Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. Ctrl+Alt+Shift+F9
Display shortcut menu Shift+F10
New worksheet Shift+F11
Save Shift+F12
Define name Ctrl+F3
Close Ctrl+F4
XL, Restore window size Ctrl+F5
Next workbook window Ctrl+F6
Previous workbook window Shift+Ctrl+F6
Move window Ctrl+F7
Resize window Ctrl+F8
Minimize workbook Ctrl+F9
Maximize or restore window Ctrl+F10
Inset 4.0 Macro sheet Ctrl+F11
File Open Ctrl+F12
Insert Chart Alt+F1
Save As Alt+F2
Exit Alt+F4
Macro dialog box Alt+F8
Visual Basic Editor Alt+F11
Create name by using names of row and column labels Ctrl+Shift+F3
Previous Window Ctrl+Shift+F6
Print Ctrl+Shift+F12
New worksheet Alt+Shift+F1
Save Alt+Shift+F2
AutoSum Alt+=
Toggle Value/Formula display Ctrl+`
Insert argument names into formula Ctrl+Shift+A
Display AutoComplete list Alt+Down arrow
Format Style dialog box Alt+’
General format Ctrl+Shift+~
Comma format Ctrl+Shift+!
Time format Ctrl+Shift+@
Date format Ctrl+Shift+#
Currency format Ctrl+Shift+$
Percent format Ctrl+Shift+%
Exponential format Ctrl+Shift+^
Place outline border around selected cells Ctrl+Shift+&
Remove outline border Ctrl+Shift+_
Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report. Ctrl+Shift+*
Insert Ctrl++
Delete Ctrl+-
Format cells dialog box Ctrl+1
Bold Ctrl+2
Italic Ctrl+3
Underline Ctrl+4
Strikethrough Ctrl+5
Show/Hide objects Ctrl+6
Show/Hide Standard toolbar Ctrl+7
Toggle Outline symbols Ctrl+8
Hide rows Ctrl+9
Hide columns Ctrl+0
Unhide rows Ctrl+Shift+(
Unhide columns Ctrl+Shift+)
Activate the menu Alt or F10
In toolbar: next toolbar Ctrl+Tab
In a workbook: activate next workbook
In toolbar: previous toolbar Shift+Ctrl+Tab
In a workbook: activate previous workbook
Next tool Tab
Previous tool Shift+Tab
Do the command Enter
Start a new line in the same cell. Alt+Enter
Fill the selected cell range with the current entry. Ctrl+Enter
Font Drop Down List Shift+Ctrl+F
Font tab of Format Cell Dialog box Shift+Ctrl+F+F
Point size Drop Down List Shift+Ctrl+P
Select the entire column Ctrl+Spacebar
Select the entire row Shift+Spacebar
Select the array containing the active cell. CTRL+/
Select all cells that contain comments. CTRL+SHIFT+O
In a selected row, select the cells that don’t match the formula or static value in the active cell. CTRL+\
In a selected column, select the cells that don’t match the formula or static value in the active cell. CTRL+SHIFT+|
Select all cells directly referenced by formulas in the selection. CTRL+[
Select all cells directly or indirectly referenced by formulas in the selection. CTRL+SHIFT+{
Select cells that contain formulas that directly reference the active cell. CTRL+]
Select cells that contain formulas that directly or indirectly reference the active cell. CTRL+SHIFT+}
Select the visible cells in the current selection. ALT+;
With multiple cells selected, select only the active cell. SHIFT+BACKSPACE
Selects the entire worksheet. CTRL+SHIFT+SPACEBAR
If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet.
When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet
Reapply the filter and sort on the current range so that changes you’ve made are included Ctrl+Alt+L
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+Alt+V