Mega Offer Avail 65% Off in CA IPCC and 50% Off in all CA CS CMA subjects.Coupon- IPCEXAM65 & EXAM50. Call: 088803-20003

CA Final Online Classes
CA Classes

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Learning Excel: Shortcut keys using Ctrl Tab

CA ANURAG 
on 15 March 2021

LinkedIn


Excel is one of the most powerful spreadsheets for your calculation, graphing tools, pivot tables, and macro programming needs.

Learning Excel: Shortcut keys using Ctrl Tab

In this article, we will discuss 41 shortcuts on excel that can be done using the Ctrl Tab

1. Ctrl+A : Select all contents of a worksheet.

2. Ctrl+B : Bold all cells in the highlighted section.

3. Ctrl+C : Copy

4. Ctrl+V : Paste

5. Ctrl+O :Open an existing workbook.

6. Ctrl+N : Create a new workbook.

7. Ctrl+S : Save

8. Ctrl+W : Close a workbook.

9. Ctrl+F : Search the current sheet.

10. Ctrl+H : Find and replace.

11. Ctrl+Z : Undo a section

12. Ctrl+Y : Redo a section.

13. Ctrl+K : Inserts a hyperlink

14.Ctrl+X : Cuts the contents of a cell or a selected content.

15. Ctrl+B : Do/redo Bold.

16. Ctrl+I : Do/Redo Italics

17. Ctrl+U : Underline

18.Ctrl+F1 : Show or hide the ribbon.

19. Ctrl+F2 : Open Print preview

20. Ctrl+F4 : Close Excel.

21. Ctrl+F9 : Minimize workbook.

22. Ctrl+F10 : Restore workbook.

23. Ctrl+Shift+; : Insert the time in the active cell.

24. Ctrl+Shift+# : Insert the date format in dd/mm/year format

25. Ctrl+Shift+( : Unhides any rows in the selected area.

26. Ctrl+Shift+) : Unhides any column in the selected area.

27.Ctrl+9 : Hide Row.

28. Ctrl+0 : Hide column.

29.Ctrl+Shift+$ : Currency format.

30. Ctrl+Shift+% : Percentage format.

31. Ctrl+Shift+& : Apply Outline border.

32. Ctrl+Shift+_ : Remove Outline border.

33. Ctrl+Space : Select the entire column

34.Ctrl+Shift+Space : Select the entire workbook

35. Shift+Space : Select the entire row.

36. Ctrl+Home : Move to the beginning of the workbook.

37. Ctrl+PgUp : Move to the previous sheet.

38. Ctrl+PgDn : Move to the next sheet.

39. Ctrl+End : Move to the most bottom right used cell. :

40. Ctrl+UP arrow : Move to the top cell of the column.

41.Ctrl+Down arrow : Move to the bottom of the column.

 
 

Tags :



Category Students
Other Articles by -
CA ANURAG 

Report Abuse

LinkedIn



Comments


update