10 Basic Excel Keyboard Shortcuts You Should Know

Ctrl + W Close a Workbook

[{"selector":"#anim-b113da3d-d20b-4d1e-b96e-e3f914802493 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(29.967023786107617%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-5684768e-6379-464b-9d44-8fd71d2137de","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9fe644fb-558e-4414-9562-efac851a7b8e","keyframes":{"transform":["translate3d(0px, 89.89291%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-483ce3b1-9349-4212-b8c9-0fc650533ec2","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-bcf54b53-f442-4b2c-a799-cff1f9c91b47","keyframes":{"transform":["translate3d(0px, 159.78842%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}]

Ctrl + O Open a Workbook

[{"selector":"#anim-b19c3dc0-cd25-4844-9bba-ede1c6985f37","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ef7d4883-834d-4383-9f95-d032ab81170a","keyframes":{"transform":["translate3d(0px, 89.89291%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f5da7bca-da8c-47b0-9064-89a24741c65e","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f19644d2-e6d4-4f47-931d-213081405d1e","keyframes":{"transform":["translate3d(0px, 110.92746%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-76ff9e48-598d-4472-b117-7ce404c31a7c [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-15.592892851656703%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

Alt + H Go to the Home Tab

[{"selector":"#anim-36a20c92-b1e1-4c9d-9e25-169794ab4639","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-829cdcd1-ecb3-4b6a-925a-c466507cf972","keyframes":{"transform":["translate3d(0px, 89.89291%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-60aa99f6-9671-4cfe-8e20-7cddb6f7b823","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f0bebc4b-3cce-4683-8d93-4a35b3d0ca78","keyframes":{"transform":["translate3d(0px, 159.78842%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-858e3cdd-e680-4871-aa84-4aee030aabf9 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(31.247700965172054%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

Alt + N Go to the Insert Tab

[{"selector":"#anim-c00647fb-74c0-4ab9-a6bc-5b1058e58e22","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-497c0a4f-c875-4c40-84da-3d10b0cf255c","keyframes":{"transform":["translate3d(0px, 89.89291%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3789a8cf-77d1-4c9a-bafb-28eefe7c9b9a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9c7050dc-bbbd-4e37-aadc-a85feab593f6","keyframes":{"transform":["translate3d(0px, 159.78842%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-91cfa467-c67c-4f42-b549-b9002541aaec [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-59.64588983175424%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

Alt + A Go to the Data Tab

[{"selector":"#anim-5070a215-b937-4f2a-af1f-22398984ed1d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-bdf8bb80-db2d-4d81-aea7-9111ae02217c","keyframes":{"transform":["translate3d(0px, 89.89291%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-317bb23c-347e-4324-b332-04686ee08740","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5fa46d73-b927-437a-86ad-ddccb9032de1","keyframes":{"transform":["translate3d(0px, 159.78842%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d3c4c095-bfe0-4c3e-a80b-f9d4930af66f [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(2.6729723204129585%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

Alt + W Go to the View Tab

[{"selector":"#anim-003a8acb-61ca-44c3-bc8a-6c3ccb0982a4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-55ba3ab3-5411-4e59-8975-47c5e3829914","keyframes":{"transform":["translate3d(0px, 89.89291%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9b2ba19a-0d4d-4ee7-814c-351524272ac9","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c5023dd0-94de-4dc2-8c78-030f66ff8860","keyframes":{"transform":["translate3d(0px, 110.92746%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-82392ca1-150a-47e9-a3c8-f2326a414e77 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-31.783184174026985%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

Alt + M Go to the Formula Tab

[{"selector":"#anim-a84c3e89-d0b3-4f0e-8d45-f16d039851fb","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5ba16760-f0a9-4252-affa-209644698e11","keyframes":{"transform":["translate3d(0px, 89.89291%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-94b0832c-00b6-447a-8054-aa445c01ce62","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6d096b94-c1f7-4561-b9b0-f6819f1e5a7e","keyframes":{"transform":["translate3d(0px, 110.92746%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-017fc056-f3af-473f-9a7d-7de302e4ace1 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(7.5195311220039365%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

Ctrl + 9 Hide the selected Rows

[{"selector":"#anim-5df90d1d-2c65-4575-896e-4cfa0ef81c4f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e8535dc7-14d2-469d-9215-aa0061cb8c33","keyframes":{"transform":["translate3d(0px, 89.89291%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-51ec5d3a-24c0-4734-887f-b2fadc437d38","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-01f414aa-1dcc-4b57-aa06-b70b39504de9","keyframes":{"transform":["translate3d(0px, 139.55032%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-825a4b91-8f23-428c-9e22-5466a1fae4fe [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-31.249999886225726%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

Ctrl + 0 Hide the selected Columns

[{"selector":"#anim-69b52d6a-249d-438d-bd73-1631c0865f85","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-797fda3f-99a6-4cc7-b7b1-8ec4c7c5193a","keyframes":{"transform":["translate3d(0px, 89.89291%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1f72ae53-0dbc-4748-ba47-bd58dc772ba3","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f5a414b6-505f-4e09-9687-f6fa229ff13d","keyframes":{"transform":["translate3d(0px, 149.07414%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-86de4631-2765-4946-bb95-0bdf648c6f3a [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-31.249999886225726%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

Shift + F10 Open the context Menu

[{"selector":"#anim-7666032d-050e-4e3b-9fd2-8a5018f2ee35","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-34ae2ddd-1f98-40a4-a0c3-b0ffc35abf16","keyframes":{"transform":["translate3d(0px, 89.89291%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-94d918d5-3a10-49d2-a0cb-abc88bfa8561","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e9ef685a-204f-437d-9b64-73afe389729f","keyframes":{"transform":["translate3d(0px, 149.07414%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e12447e0-7a39-457d-a2bb-36413eff9694 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-7.812499744007886%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}]

Thanks For Reading

[{"selector":"#anim-934680bc-061e-4e7f-98ba-3e8dbaf325ad","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0b7d394d-b89b-49b9-be39-ddb44026e80b","keyframes":{"transform":["translate3d(0px, 190.75318%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8e7cb67b-6cb8-43bd-90a1-c8e6c3390171","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-92f8aaf9-4fec-4ddf-847e-cdd7bf9dcefb","keyframes":{"transform":["translate3d(0px, 677.49292%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-47ad006b-e380-48d6-a120-932c5ba0a7e4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a6d3fbf0-b09a-4592-9099-a9d6d1da15df","keyframes":{"transform":["translate3d(0px, 236.96137%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Learn more