Microsoft Excel ব্যবহারকারীদের দ্রুত কাজ করার জন্য Excel Shortcut জানা প্রয়োজন। কারণ শর্টকাট জানা থাকলে দ্রুত কাজ করা যায়।
আমরা MS Excel এর উপর একটি সিরিজ টিউটোরিয়াল শুরু করেছি।
MS Excel এ ব্যবহৃত এমন সব গুরুত্বপূর্ণ শর্টকাট নিয়ে আলোচনা করা হয়েছে যা শিখে আপনি খুব দ্রুততার সাথে কাজ করতে পারবেন।
A to Z Microsoft Excel Shortcut Part-I
যারা A to Z Microsoft Excel Shortcut Part-I পড়েননি তারা এ লিংকে ক্লিক করে পড়ে নিতে পারেন।
এ টু জেড এমএস এক্সেল শর্টকাট পার্ট-২
ক্রমিক | শর্টকাট | ব্যবহার |
1. | Ctrl+0 | Hide the selected columns. |
2. | Ctrl+9 | Hide the selected rows. |
3. | Ctrl+1 | Open the Format Cells dialog box. |
4. | Ctrl+2 or Ctrl+B | Bold text or remove bold formatting. |
5. | Ctrl+3 or Ctrl+I | Italicize text or remove italic formatting. |
6. | Ctrl+4 or Ctrl+U | Underline text or remove underline. |
7. | Ctrl+5 | Apply or remove strikethrough formatting. |
8. | Ctrl+6 | Switch between hiding objects, displaying objects, and displaying placeholders for objects. |
9. | Ctrl+8 | Display or hide the outline symbols. |
10. | Alt+F1 | Create an embedded chart of the data in the current range. |
11. | F2 | Edit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use the arrow keys to create a reference. |
12. | Shift+F2 | Insert a note.
Open and edit a cell note. |
13. | Ctrl+Shift+F2
| Insert a threaded comment.
Open and reply to a threaded comment. |
14. | Shift+F3 | Insert a function. |
15. | F4 | Cycle through all combinations of absolute and relative references in a formula if a cell reference or range is selected. |
16. | F7 | Check spelling in the active worksheet or selected range. |
17. | F9 | Calculate all worksheets in all open workbooks. |
18. | Shift+F9 | Calculate the active worksheet. |
19. | Ctrl+Alt+F9 | Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
20. | F11 | Create a chart of the data in the current range in a separate Chart sheet. |
21. | Ctrl+Shift+F or Ctrl+Shift+P | Format fonts in the Format Cells dialog box. |
22. | Ctrl+End | Move to the last cell on a worksheet, to the lowest used row of the rightmost used column. |
23. | Ctrl+Shift+End | Extend the selection of cells to the last used cell on the worksheet (lower-right corner). |
24. | Ctrl+Home | Move to the beginning of a worksheet. |
25. | Page down | Move one screen down in a worksheet. |
26. | Ctrl+Page down | Move to the next sheet in a workbook. |
27. | Alt+Page down | Move one screen to the right in a worksheet. |
28. | Page up | Move one screen up in a worksheet. |
29. | Alt+Page up | Move one screen to the left in a worksheet. |
30. | Ctrl+Page up | Move to the previous sheet in a workbook. |
31. | Tab key | Move one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked cells. |
32. | Alt+Down arrow key | Open the list of validation choices on a cell that has data validation option applied to it. |
33. | Esc | Exit the floating shape navigation and return to the normal navigation. |
Cancel an entry in the cell or formula bar. | ||
34. | Ctrl+Alt+Equal sign ( = ) | Zoom in.
|
35. | Ctrl+Alt+Minus sign (-) | Zoom out. |
36. | Ctrl+Shift+Plus sign (+) | Open the Insert dialog box to insert blank cells.
|
37. | Ctrl+Minus sign (-) | Open the Delete dialog box to delete selected cells. |
38. | Ctrl+Spacebar | Select an entire column in a worksheet. |
39. | Ctrl+Shift+Spacebar | Select all objects on a worksheet when an object is selected. |
40. | Shift+Page down | Select all cells from the current location to the last cell of the column. |
41. | Shift+Page up | Select all cells from the current location to the first cell of the column. |
42. | Shift+End | Select all cells from the current location to the last cell of the row. |
43. | Shift+Home
| Select all cells from the current location to the first cell of the row. |
44. | Ctrl+Page up | Move to the previous table. |
45. | Ctrl+Left arrow key | Move to the first cell of the selected row. |
46. | Ctrl+Right arrow key | Move to the last cell of the selected row.
|
47. | Ctrl+Up arrow key | Move to the first cell of the selected column. |
48. | Ctrl+Down arrow key | Move to the last cell of selected column. |
49. | Ctrl+Esc | Close a dialog box or cancel a process, such as a paste operation. |
50. | Alt+Down arrow key | Open the AutoFilter Menu dialog box. |
51. | Ctrl+Shift+Home | Extend the selection of cells to the beginning of the worksheet. |
52. | Ctrl+Shift+U | Expand or collapse the formula bar. |
53. | Enter
| Complete an entry in the formula bar and select the cell below. |
Move to the first field in the next record of a data form. | ||
54. | Ctrl+End | Move the cursor to the end of the text when in the formula bar. |
55. | Ctrl+Shift+End | Select all text in the formula bar from the cursor position to the end. |
56. | Alt+Equal sign ( = ) | Insert the AutoSum formula |
এমএস এক্সেল শর্টকাট ডাউনলোড করুন
Download MS Excel Shortcut from here
Download MS Excel Shortcut from here