એક્સેલ કીબોર્ડ શૉર્ટકટ્સની પુષ્કળતાને સમર્થન આપે છે જે તમને કાર્યક્ષમ રીતે કાર્ય કરવામાં અને ઉત્પાદકતા વધારવામાં મદદ કરે છે. માઉસ વડે ટૂલબારને ઍક્સેસ કરવાને બદલે, નોંધપાત્ર કાર્યો કરવા માટે બે કે ત્રણ કીસ્ટ્રોકનો ઉપયોગ કરવામાં આવે છે. શું તે સરળ અને સમય બચત નથી? એક્સેલ શૉર્ટકટ્સનો ઉપયોગ કરવાથી ઝડપમાં ભારે વધારો થાય છે, અને આમ કામનો સમય ઓછો થાય છે.
- 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 Formula 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
- Shift+Ctrl+F6 - Previous 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+F1 - File Open
- Alt+F1 - Insert Chart
- Alt+F2 - Save As
- Alt+F4 - Exit
- Alt+F8 - Macro dialog box
- Alt+F11 - Visual Basic Editor
- 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
- 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++ - 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+( - 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
- Shift+Ctrl+Tab - In a workbook: activate previous workbook
- Tab - Next tool
- Shift+Tab - Previous tool
- Enter - Do the command
- Shift+Ctrl+F - Font Drop Down List
- Shift+Ctrl+F+F - Font tab of Format Cell Dialog box
- Shift+Ctrl+P - Point size Drop Down Undo
