คีย์ลัดสำหรับผู้ที่ทำงานคอมพิวเตอร์
คีย์ลัดสำหรับผู้ที่ทำงานคอมพิวเตอร์
Ctrl + E - Select all
Ctrl + N - Bold
Ctrl + C - Copy
Ctrl + D - Fill
Ctrl + B - Search
Ctrl + G - Save
Ctrl + L - Replace
Ctrl + K - Italic
Ctrl + U - New workbook
Ctrl + A - Open
Ctrl + P - Print
Ctrl + R - Nothing good
Ctrl + S - Underline
Ctrl + V - Paste
Ctrl W - Close
Ctrl + X - Cut
Ctrl + Y - Repeat
Ctrl + Z - Undo
F1 - Help
F2 - Edit
F3 - Paste the name
F4 - Repeat the last action.
F4 - When entering a formula, switch between absolute/relative references
F5 - Go To
F6 - Next Panel
F7 - Spell Check
F8 - Magnification mode.
F9 - Recalculate all books
F10 - Activate the menu bar
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
Change - Offset setting for additional functions in Excel menu
Shift + F1 - What is it?
Shift + F2 - Edit cell comment
Shift + F3 - Paste the function into the formula
Shift + F4 - Find Next
Shift + F5 - Find
Shift + F6 - Previous Panel
Shift + F8 - Add to selection
Shift + F9 - Calculate the active spreadsheet
Shift + F10 - Popup menu display
Shift + F11 - New spreadsheet
Shift + F12 - Save
Ctrl + F3 - Set 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 the workbook
Ctrl + F10 - Maximize or restore window
Ctrl + F11 - Insert 4.0 macro sheet
Ctrl + F1 - Open file
Alt + F1 - Insert a chart
Alt + F2 - Save As
Alt + F4 - Exit
Alt + F8 - Macro dialog
Alt + F11 - Visual Basic Editor
Alt + 64 - @
CTRL + Esc. You can quickly return to the home screen. And here nothing has happened.
Ctrl + Shift + F3 - Create a name using the row and column label names
Ctrl + Shift + F6 - Previous window
Ctrl + Shift + F12 - Print
Alt + Shift + F1 - New spreadsheet
Alt + Shift + F2 - Save
Alt + = - AutoSum
Ctrl + `- Change value / formula display
Ctrl + Shift + A - Insert the names of the arguments in the formula
Alt + down arrow - auto view list
Alt + ' - Format style dialog
Ctrl + Shift + ~ - General formatting
Ctrl+Shift+! - Comma format
Ctrl + Shift + @ - Time format
Ctrl + Shift + # - Date format
Ctrl + Shift + $ - Currency format
Ctrl + Shift +% - Format percentage
Ctrl + Shift + ^ - Exponential format
Ctrl + Shift + & - Place the outline border around the selected cells
Ctrl + Shift + _ - Delete the outline border
Ctrl + Shift + * - Select the current region
Ctrl ++ - Insert
Ctrl + - - Delete
Ctrl + 1 - Format cell dialog
Ctrl + 2 - Bold
Ctrl + 3 - italics
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 lines
Ctrl + 0 - Hide columns
Ctrl + Shift + (- Show Lines
Ctrl + Shift +) - Show columns
Alt or F10 - Activate the menu
Ctrl + Tab - On the toolbar: Next toolbar
Shift + Ctrl + Tab - On the toolbar: Previous toolbar
Ctrl + Tab - In a book: activate the next book
Shift + Ctrl + Tab - In a folder: activate the previous folder
Tab - Next Tool
Shift + Tab - Previous Tool
Login - Order
Shift + Ctrl + F - Font dropdown list
Shift + Ctrl + F + F - Format Cells Dialog Tab Font
Shift + Ctrl + P - Point size dropdown list.