संगणक

 

Advance Keyboard shortcuts

Function keys चा ms excel मधे वापर ( shortcuts keys) मायक्रोसॉफ्ट एक्सेल मधील काही Advance Keyboard shortcuts  संगणकाच्या कीबोर्ड वर बारा function keys असतात.  या function keys चा वापर एक्सेलमध्ये  shortcut म्हणून कसा करावा ?............. F1 HELP / मदत  चा शॉर्टकट F2 सिलेक्ट केलेल्या सेल मध्ये EDIT करण्यासाठी (Double click) F3 फॉर्म्युला ठरावीक नावांच्या सहाय्याने मांडणे F4 शेवटची Command वा Action पुन्हा करणे F5 Go to Dialogue box चा शॉर्टकट F6 स्प्लिट विंडोमधील प्रत्येक भागामध्ये जाण्याकरीता F7 स्पेलींग तपासण्याकरीता शॉर्टकट F8 एकापेक्षा अधिक cells सिलेक्ट करण्याकरीता F9 फॉर्म्युला व त्यामधील किंमती तपासण्याकरीता F10 मेनुबार मधील विविध पर्याय निवडण्याकरीता F11 Column type chart बनविण्याकरीता F12 "Save As" Dialogue box चा शॉर्टकट

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)  12 CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)  13 CTRL+Shift with any of the arrow keys (Highlight a block of text)  14 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)  15 CTRL+A (Select all)  16 F3 key (Search for a file or a folder)  17 Alt+Enter (View the properties for the selected item)  18 Alt+F4 (Close the active item, or quit the active program)  19 Alt+Enter (Display the properties of the selected object)  20 Alt+Spacebar (Open the shortcut menu for the active window)  21 CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously)  22 Alt+Tab (Switch between the open items)  23 Alt+ESC (Cycle through items in the order that they had been opened)  24 F6 key (Cycle through the screen elements in a window or on the desktop)  25 F4 key (Display the Address bar list in My Computer or Windows Explorer)  26 Shift+F10 (Display the shortcut menu for the selected item)  27 Alt+Spacebar (Display the System menu for the active window)  28 CTRL+ESC (Display the Start menu)  29 Alt+Underlined letter in a menu name (Display the corresponding menu)  30 Underlined letter in a command name on an open menu (Perform the corresponding command)  31 F10 key (Activate the menu bar in the active program)  32 RIGHT ARROW (Open the next menu to the right, or open a submenu)  33 LEFT ARROW (Open the next menu to the left, or close a submenu)  34 F5 key (Update the active window)  35 Backspace (View the folder one level up in My Computer or Windows Explorer)  36 ESC (Cancel the current task