Computer by apon

কাজের চাপে দীর্ঘদিন পেইজে আসা হয় নাই।আশা করি আজ থেকে কম্পিউটারের বিভিন্ন তথ্য নিয়ে যায় হাজির হবো।

Text shortcuts

CTRL+F : Find

CTRL+H : Replace

Backspace : Delete one character to the left

CTRL+Backspace : Delete one word to the left

SHIFT+F10 : Contextual menu (=right click)

F7 : Run a Spelling and Grammar Check

Selection shortcuts

CTRL+A : Select all

CTRL+Left/Right Arrows : Move one block of cells to the left/right

CTRL+Up/Down Arrows : Move one block of cells up or down

SHIFT+Left/Right Arrows : Extend selection by one cell to the left/right

SHIFT+Up/Down Arrows : Extend selection by one cell up/down

CTRL+SHIFT+Left/Right Arrows : Extend selection by one block of cells to the left/right

CTRL+SHIFT+Up/Down Arrows : Extend selection by one block of cells up/down

ALT+SHIFT+Up/Down Arrows : Move items up or down in a bulleted or numbered list

F8 : Activate Selection Mode

SHIFT+Space : Select current row

CTRL+Space : Select current column

CTRL+SHIFT+9 : Hide active row

Formatting shortcuts

CTRL+B : Bold

CTRL+U : Underline

CTRL+I : Italic

Alt,H,H,N : Remove fill color

Alt,H,B,N : Remove borders

Alt,H,B,A : Add borders (all)

Alt,H,B,S : Add borders (external)

Alt,H,B,T : Add borders (thick)

CTRL+SHIFT+% : Format as percentage

CTRL+SHIFT+F : Open the format dialog box

Alt,H,O,I : Autofit columns

Alt,H,O,A : Autofit rows

Copy and paste

CTRL+C : Copy

CTRL+V : Paste

CTRL+R : Paste to the right

CTRL+D : Paste down

CTRL+X : Cut

Alt,H,V,F : Paste as formula

Alt,H,V,V : Paste as value

CTRL+- : Delete selection

CTRL++ : Insert cells/rows/columns



Cancel and repeat

CTRL+Z : Cancel

CTRL+Y : Cancel cancellation

F4 : Repeat last action

management

CTRL+N : Create new workbook

CTRL+O : Open new workbook

CTRL+S : Save

F12 : Save as

CTRL+W : Close workbook

ALT+F4 : Close application

CTRL+NextPage / PreviousPage : Move to the next / previous sheet

SHIFT+Alt+F1 : Add new sheet

Alt,H,O,R : Rename active sheet

Alt,H,D,S : Delete active sheet

36. To select the entire row

Shift + Space

37. To select the entire column

Ctrl + Space

38. To delete a column

Alt+H+D+C

39. To delete a row

Shift + Space, Ctrl + -

40. To hide selected row

Ctrl + 9

41. To unhide selected row

Ctrl + Shift + 9

42. To hide a selected column

Ctrl + 0

43. To unhide a selected column

Ctrl + Shift + 0

44. To group rows or columns

Alt + Shift + Right arrow

45. To ungroup rows or columns

Alt + Shift + Left arrow

26. To add a comment to a cell Shift + F2

27. To delete a cell comment Shift + F10 + D

28. To display find and replace Ctrl + H

29. To activate the filter Ctrl + Shift + L

Alt + Down Arrow
30. To insert the current date Ctrl + ;
31. To insert current time Ctrl + Shift + :
32. To insert a hyperlink Ctrl + k
33. To apply the currency format Ctrl + Shift + $
34. To apply the percent format Ctrl + Shift + %
35. To go to the “Tell me what you want to do” box Alt + Q

11. To edit a cell F2

12. To copy and paste cells Ctrl + C, Ctrl + V

13. To italicize and make the font bold Ctrl + I, Ctrl + B

14. To center align cell contents Alt + H + A + C

15. To fill color Alt + H + H

16. To add a border Alt + H + B

17. To remove outline border Ctrl + Shift + _

18. To add an outline to the select cells Ctrl + Shift + &

19. To move to the next cell Tab

20. To move to the previous cell Shift + Tab

21. To select all the cells on the right Ctrl + Shift + Right arrow

22. To select all the cells on the left Ctrl + Shift + Left Arrow

23. To select the column from the selected cell to the end of the table Ctrl + Shift + Down Arrow

24. To select all the cells above the selected cell Ctrl + Shift + Up Arrow

25. To select all the cells below the selected cell Ctrl + Shift + Down Arrow

চলুন, এক্সেলের কাজ করতে করতে কখনো কখনো ভুলে যেতে পারি এমন কিছু কোড সংগ্রহ করে টাইম লাইনে রেখে দেই যাতে করে প্রয়োজনে এখান থেকে সহায়তা নিতে পারি।

1. To create a new workbook Ctrl + N
2. To open an existing workbook Ctrl + O
3. To save a workbook/spreadsheet Ctrl + S
4. To close the current workbook Ctrl + W
5. To close Excel Ctrl + F4
6. To move to the next sheet Ctrl + PageDown
7. To move to the previous sheet Ctrl + PageUp
8. To go to the Data tab Alt + A
9. To go to the View tab Alt + W
10. To go the Formula tab Alt + M