7 Shortcuts that makes you faster in Excel

1. Ctrl+R: Copies the closest left cell or cell formula

[{"selector":"#anim-dd259ce4-faa3-4368-8430-42b5e53b16ae [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-452860c0-7ee1-4184-8f5a-7458028d9ab7","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

2. Ctrl+D: Copies the closest above cell or cell formula

[{"selector":"#anim-0890f071-c3c5-4db9-805c-88747a85371d [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-47066829-9fa7-4013-9b41-02f0571febdc","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

3. F2: Edit the cell

[{"selector":"#anim-6f7aca01-4235-401d-878f-92f231627929 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-5d4ead06-1a35-494a-88c0-d80fa3693247","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

5. Use arrow buttons to move from cell to cell

[{"selector":"#anim-873ff198-a28f-4ffa-bb66-960018c041b0 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-4276ab54-cec5-4514-8d66-7162255a9b1d","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

6. Shift+arrow key: Select more than one number of cell

[{"selector":"#anim-3ddadecd-4de7-48b6-a823-becf067721f7 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-4c01f283-9e4a-468e-8f56-2af84d12c90a","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

7. Press the Alt key to see all shortcuts of the functions in the menubar Example: For merge and center cells Alt+H+M+C

[{"selector":"#anim-9ad20add-9d10-409b-b3d3-480849fa73f6 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-36aa3c39-329a-4729-9929-3ff5b3a7efe9","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Click here to visit the Blog excelabcd.co.in to become smart in Excel.

[{"selector":"#anim-53480a7b-f91f-4c01-bab9-f87f1693551f [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-e6454fb2-0f26-4c0e-8fe9-0e38da8e5f73","keyframes":{"opacity":[0,1]},"delay":0,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]