สารพัดปุ่มลัด

Ctrl + A-Select All
Ctrl + B -Bold
Ctrl+ C-Copy
CtrI+D-Fill
CtrI + F-Find
Ctrl + G- Find next instance of text
Ctrl + H-Replace
Ctrl +l-Italic
Ctrl + k - Insert a hyperlink
CtrI+ N - New workbook
Ctrl+0-Open
Ctrl+P-Print
Ctrl+R- Nothing right
Ctrl+ S - Save
Ctrl+ U- Underlined
Ctrl +V-Paste
Ctrl +W - Close
Ctrl+ x-Cut
Ctrl + Y-Repeat
Ctrl + Z - Cancel
F1-Help
F2-Edition
F3 -Paste the name
F4 -Repeat the last action
F4 - When entering a formula, switch between absolute / relative
references
F5 -Goto
F6 - Next Pane
F7 -Spell Check
F8 - Extension of the mode
F9 -Recalculate all workbooks
F10- Activate Menubar
F11-New graph
F12-Save As
Ctrl +:- Insert the current time
Ctrl +; - Insert the current date
Ctrl + "- Copy the value of the cell above
Ctrl +'- Copy the formula from the cell above Shift - Offset
Adjustment for Additional Functions in the Excel Menu
Shift + F1 -Whatisit?
Shift + F2-Edit cell comment
Shift + F3 - Paste the function into the formula Shift + F4- Search
Next
Shift + F5 -Find
Shift + F6 - Previous Panel
Shift + F8 - Add to the selection
Shift + F9 - Calculate the active worksheet
Shift + F10-Popup menu display
Shift + F11-New spreadsheet
Shift + F12 - Save
Ctrl+ F3-Set name
Ctrl + F4 -Close
Ctrl + F5 -XL, size of the restore window
Ctrl + F6 - Next Workbook Window
Shift + Ctrl + F6 - Previous Workbook Window Ctrl + F7 -Move
window
Ctrl + F8 -Resize Window
Ctrl + F9 -Minimize the workbook
Ctrl + F10 -Maximize or Restore Window
Ctrl + F11 -Inset 4.0 Macro sheet
Ctrl + F1 - Open File
Alt + F1-Insert a graph
Alt + F2 - SaveAs
Alt+ F4- Output
Alt + F8- Macro dialog
Alt + F11 -Visual Basic Editor
Ctrl + Shift + F3 - Create a name using the names of row and
column labels
Ctrl + Shift + F6 - Previous Window
Ctrl + Shift + F12-Printing
Alt + Shift + F1 -New spreadsheet
Alt + Shift + F2 -Save
Alt +=-AutoSum
Ctrl + `- Toggle value / display of the formula Ctrl + Shift + A-
Insert the argument names in the formula
Alt + down arrow - automatic view format
Alt +'- Format Style Dialog
Ctrl + Shift +~ - General Format
แสดงความคิดเห็น
โปรดศึกษาและยอมรับนโยบายข้อมูลส่วนบุคคลก่อนเริ่มใช้งาน อ่านเพิ่มเติมได้ที่นี่