साइवरसंसार:
किबोड सामन्दि जान्कारि:
Action ______
____________Menu equipvalent
Ctrl+A __________________Select All
Ctrl+B __________________Bold
Ctrl+C __________________Copy
Ctrl+D __________________Fill Down
Ctrl+F __________________Find
Ctrl+G __________________Goto
Ctrl+H __________________Replace
Ctrl+I __________________Italic
Ctrl+K __________________Insert Hyperlink
Ctrl+N __________________New Workbook
Ctrl+O __________________Open
Ctrl+P __________________Print
Ctrl+R __________________Fill Right
Ctrl+S __________________Save
Ctrl+U __________________Underline
Ctrl+V __________________Paste
Ctrl W __________________Close
Ctrl+X __________________Cut
Ctrl+Y __________________Repeat
Ctrl+Z __________________Undo
F1 __________________Help
F2 __________________Edit
F3 __________________Paste Name
F4 __________________Repeat last action
F4 __________________While typing a formula, switch between absolute/relative refs
F5 __________________Goto
F6 __________________Next Pane
F7 __________________Spell check
F8 __________________Extend mode
F9 __________________Recalculate all workbooks
F10 __________________Activate Menubar
F11 __________________New Chart
F12 __________________Save As
Ctrl+: __________________Insert Current Time
Ctrl+; __________________Insert Current Date
Ctrl+” __________________Copy Value from Cell Above
Ctrl+’ __________________Copy Fromula from Cell Above
Shift __________________Hold down shift for additional functions in Excel’s menu
Shift+F1 __________________What’s This?
Shift+F2 __________________Edit cell comment
Shift+F3 __________________ Paste function into formula
Shift+F4 __________________Find Next
Shift+F5 __________________ Find
Shift+F6 __________________Previous Pane
Shift+F8 __________________Add to selection
Shift+F9 __________________Calculate active worksheet
Shift+F10 __________________Display shortcut menu
Shift+F11 __________________New worksheet
Shift+F12 __________________Save
Ctrl+F3 __________________Define name
Ctrl+F4 __________________ Close
Ctrl+F5 __________________XL, Restore window size
Ctrl+F6 __________________Next workbook window
Ctrl+F7 __________________Move window
Ctrl+F8 __________________Resize window
Ctrl+F9 __________________ Minimize workbook
Ctrl+F10 __________________ Maximize or restore window
Ctrl+F11 __________________Inset 4.0 Macro sheet
Ctrl+F12 __________________ File Open
Alt+F1 __________________ Insert Chart
Alt+F2 __________________Save As
Alt+F4 __________________Exit
Alt+F8 __________________Macro dialog box
Alt+F11 __________________ Visual Basic Editor
Ctrl++ __________________Insert
Ctrl+- __________________ Delete
Ctrl+1 __________________ Format cells dialog box
Ctrl+2 __________________ Bold
Ctrl+3 __________________ Italic
Ctrl+4 __________________ Underline
Ctrl+5 __________________ Strikethrough
Ctrl+6 __________________ Show/Hide objects
Ctrl+7 __________________ Show/Hide Standard toolbar
Ctrl+8 __________________Toggle Outline symbols
Ctrl+9 __________________Hide rows
Ctrl+0 __________________ Hide columns
Ctrl+Shift+F3 __________________Create name by using names of row and column labels
Ctrl+Shift+F6 __________________Previous Window
Ctrl+Shift+F12 __________________Print
Alt+Shift+F1 __________________New worksheet
Alt+Shift+F2 __________________Save
Shift+Ctrl+F6 __________________Previous workbook window
Alt+= __________________AutoSum
Ctrl+` __________________ Toggle Value/Formula display
Ctrl+Shift+A __________________Insert argument names into formula
Alt+Down arrow__________________ Display AutoComplete list
Alt+’ __________________ Format Style dialog box
Ctrl+Shift+~ __________________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 current region
Ctrl+Shift+( __________________Unhide rows
Ctrl+Shift+) __________________Unhide columns
Alt or F10 __________________Activate the menu
Ctrl+Tab __________________In toolbar: next toolbar
Shift+Ctrl+Tab __________________In toolbar: previous toolbar
Ctrl+Tab __________________ In a workbook: activate next workbook
1 comment:
upayogi jaankaari dinubhakomaa dhanaye waada
Post a Comment