93 ปุ่มคีย์ลัด (Excel Shortcut Key) ที่ขึ้นต้นด้วยปุ่ม "Ctrl" ง่ายสะดวกต่อการใช้งาน | xcel-guru
"ปุ่มคีย์ลัด" ที่ขึ้นต้นด้วย Ctrl
สวัสดีครับ ผมชื่อเล้งครับ วันนี้ผมจะนำเคล็ดลับการใช้งานโปรแกรมเอ็กเซล(Excel program) ที่มีประโยชน์มา share ให้ท่านที่สนใจได้รับความรู้และเอาไปใช้ในชีวิตการทำงานประจำวันกัน โดยท่านสามารถเข้ามาอ่านได้ที่บล็อก "เผยเคล็ดลับเอ็กเซล : XCEL-GURU" ได้ตลอดเวลาที่นี่ครับ
Xcel Tip Quiz
ท่านทราบหรือไม่ว่าปุ่มคีย์ลัดอะไรใช้ย่อแผ่นหน้าต่างเอ็กเซลปัจจุบัน(Minimize)ให้อยู่ในรูปไอคอน?
The Excel shortcut key will return the results displaying as in the table beneath:
Shortcut key / ปุ่มคีย์ลัด
|
Results / ผล
|
|---|---|
| ctrl+ - | Delete cell/row/column menu. |
| ctrl+' (apostrophe) | Fill cell formulas down and edit (copy above cell formulas). |
| ctrl+- with row/ column selected | Delete row / delete column. |
| ctrl+" | Fill cell values down and edit (copy above cell values). |
| ctrl+. (period) | Move clockwise to the next corner of the selection. |
| ctrl+; (semicolon) | Insert the current date. |
| ctrl+` (grave accent) | Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark. |
| ctrl+0 (zero) | Hide the selected columns. |
| ctrl+1 | Format cells dialog. |
| ctrl+1, then ctrl+arrow right/arrow left | Access border menu in 'format cell' dialog. Once border was selected, it will show up directly on the next ctrl+1. |
| ctrl+5 | Apply or remove strikethrough formatting. |
| ctrl+6 | Alternate between hiding and displaying objects. |
| ctrl+6 | Alternate between hiding objects, displaying objects, and displaying placeholders for objects. |
| ctrl+8 | Display or hides the outline symbols. |
| ctrl+9 | Hide the selected rows. |
| ctrl+A | Display formula window after typing formula name. |
| ctrl+A (or ctrl+shift+spacebar) | Select the entire worksheet or the data-containing area. Pressing "ctrl+a" a second time then selects an entire worksheet. |
| ctrl+alt+arrow right/ctrl+alt+arrow left | Move to the right / to the left between non-adjacent selections (with multiple ranges selected). |
| ctrl+alt+F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
| ctrl+alt+shift+F9 | Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. |
| ctrl+alt+v | If data exists in clipboard: display the paste special dialog box. |
| ctrl+arrow keys | Move to the edge of the next data region (cells that contain data). |
| ctrl+arrow left/ctrl+arrow right | Inside a cell: move one word to the left / to the right. |
| ctrl+b (or ctrl+2) | Apply or remove bold formatting. |
| ctrl+backspace | Show active cell within the selection. |
| ctrl+c | Copy contents of selected cells. |
| ctrl+d | Fill complete cell down (copy above cell). |
| ctrl+delete | Delete text to the end of the line. |
| ctrl+end | Move to the last cell with content on a worksheet. |
| ctrl+f | Display the find and replace dialog box (with find selected). |
| ctrl+f1 | Select the active tab of the ribbon and activate the access keys. Press either of these keys again to move back to the document and cancel the access keys. And then arrow left or arrow right. |
| ctrl+f10 | Move workbook windows which are not maximized. |
| ctrl+f3 | Create names from a row and column labels. |
| ctrl+f4 | Create a new blank workbook (excel file). |
| ctrl+f7 | Perform size command for workbook windows which are not maximized. |
| ctrl+f8 | Close excel. |
| ctrl+f9 | Maximize or restores the selected workbook window. |
| ctrl+g (or f5) | Display the 'go to' dialog box. |
| ctrl+h | Display the find and replace dialog box (with replace selected). |
| ctrl+home | Move to the beginning of a worksheet. |
| ctrl+i (or ctrl+3) | Apply or remove italic formatting. |
| ctrl+k | Insert a hyperlink. |
| ctrl+l | Insert a table (display create table dialog box). |
| ctrl+n | Move to next/previous workbook window. |
| ctrl+o | Save the active file with its current file name, location, and file format. |
| ctrl+p | Display the excel help task pane. |
| ctrl+page down | Move to the first record. |
| ctrl+page down/ctrl+page up | Select the current and next sheet(s) / select and previous sheet(s). |
| ctrl+page up | Move to the beginning/end of a field. |
| ctrl+R | Fill complete cell to the right (copy cell from the left). |
| ctrl+S | Display the save as dialog box. |
| ctrl+shift+! | Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values. |
| ctrl+shift+# | Apply the date format with the day, month, and year. |
| ctrl+shift+$ | Apply the currency format with two decimal places. |
| ctrl+shift+% | Apply the percentage format with no decimal places. |
| ctrl+shift+& | Apply outline border from cell or selection. |
| ctrl+shift+* (asterisk) | Display the list for the current field in a PivotTable report. |
| ctrl+shift+* (asterisk) | Select the current region around the active cell. |
| ctrl+shift+: (colon) | Insert current time. |
| ctrl+shift+@ | Apply the time format with the hour and minute and indicate a.m. Or p.m. |
| ctrl+shift+[+] | If data exists in clipboard: display the insert dialog box to insert blank cells. |
| ctrl+shift+^ | Apply the scientific number format with two decimal places. |
| ctrl+shif+_ (underscore) | Remove outline borders from cell or selection. |
| ctrl+shift+~ | Apply the general number format. |
| ctrl+shift+ | Display order menu for insert cell/row and column. |
| ctrl+shift+with row selected | Insert row |
| ctrl+shift+ with column selected | Insert column. |
| ctrl+shift+0 (zero) | Unhide any hidden columns within the selection*. |
| ctrl+shift+9 | Unhide any hidden rows within the selection. |
| ctrl+shift+A | Insert arguments in formula after typing formula name. |
| ctrl+shift+arrow key | Extend the selection to the last cell with content in row or column. |
| ctrl+shift+arrow left/ctrl+shift+arrow right | Select or unselect one word to the left / to the right. |
| ctrl+shift+end | Extend the selection to the last used cell on the worksheet (lower-right corner). |
| ctrl+shift+enter | Enter a formula as an array formula. |
| ctrl+shift+F | Display the format cells with fonts tab active. Press tab 3x to get to font-size. Used to bectrl+shift+p, but that seems just get to the font tab in 2010. |
| ctrl+shift+F3 | Paste a defined name into a formula. |
| ctrl+shift+home | Extend the selection to the beginning of the worksheet. |
| ctrl+shift+o | Select all cells with comments. |
| ctrl+shift+page up | Select the current and previous sheet in a workbook. |
| ctrl+shift+u | Toggle expands or collapses formula bar. |
| ctrl+space | Select the entire column. |
| ctrl+tab ctrl+shift+tab | On a field button: select the area you want to move the selected field to. |
| ctrl+tab/ctrl+shift+tab | Display the control menu for the main Excel window. |
| ctrl+tab/ctrl+shift+tab | In a dialog box: perform the action for the selected button, or select/clear a checkbox. |
| ctrl+u (or ctrl+4) | Apply or remove an underline. |
| ctrl+V | Paste content from the clipboard into the selected cell. |
| ctrl+X | Cut the contents of selected cells. |
| ctrl+Y | Redo last action (multiple levels). |
| ctrl+Z | Undo last action (multiple levels). |
Xcel Tip Answer
ลิ้งค์แนะนำ👉 : พูดภาษาอังกฤษเป็นด่วน! : English Fast Serve!
ลิ้งค์แนะนำ👉 : นับเลขภาษาอังกฤษจาก 0 ถึง 1,000,000
สุดท้ายนี้ ผมหวังว่าสิ่งที่เราสืบค้น เลือกสรรค์ และทดลองใช้ก็ดี สิ่งที่ทางเรามีภูมิความรู้ด้านนี้อยู่แล้วก็ดี ซึ่งเราได้นำมาเขียนเพื่อ share ให้กับท่านในวันนี้นั้น จะมีประโยชน์ต่อธุรกิจ กิจการงานต่อหน่วยงานของท่าน หรือว่าต่อตัวท่านเองไม่มากก็น้อยนะครับ
แล้วพบกันใหม่ครับ
Thanks for reading.
Posted by: Michael Leng
I've known, then I've grown.
-- ดูเคล็ดลับอื่นๆเพิ่มเติม
ความคิดเห็น
แสดงความคิดเห็น