Keyboard shortcuts | Excel I

 

As you spend more time getting familiar with Microsoft Excel, you may start to wonder if you can automate some of the more repetitive tasks or make navigating the software easier. Fortunately, there are a great number of shortcuts that you can use in Excel that can help you do just that and more. Knowing these shortcuts and implementing them in your everyday use will help you save time and optimize your workflow. 

Users who take advantage of these shortcuts often find them much more intuitive than constantly toggling a mouse. Those living with mobility or vision limitations will also appreciate shortcuts, as they can be easier to use than touchscreens. Whether you’re a student, data analyst, or someone who uses Excel on an irregular basis, you’ll likely form a shortlist of shortcuts that you use often. This tutorial will serve as an introduction to new Excel shortcuts that you can add to your wheelhouse, as well as a reference point so that you don’t have to memorize shortcuts that you may not use as frequently.

Select the whole column

Select the whole row

Select table

save

Select visible cells only

Select entire region

Select range from start cell to far left

Select range from start cell to end in direction of arrow.

Select a continuous range of data (e.g. pivot), no matter where your cursor is.

Select blank cells.

Previous sheet/Next sheet.

Launch GO TO Dialog (from here you can select special or jump to a cell or range).

Go to top left (will go to top left of freeze pane if set).

Go to last non-blank cell.

Toggle between workbooks in a given session of excel.

Change the type of cell reference from relative to absolute or semi-absolute.

Repeat whatever you did last.

Debug portions of a formula (select and press).

Sum range.

Enter array formula.

Select array formula range.

Display range names (can be used when typing formulas).

Copy a formula from above cell and edit.

Alternate between displaying cell values and displaying cell formulas.

We will finalize this cheat sheet later on next blog check that here..............

𝕿𝖍𝖆𝖓𝖐𝖘 & 𝕽𝖊𝖌𝖆𝖗𝖉𝖘...

Share on Facebook Share on Twitter Share on Google Plus

About Freaky Analyst

A Passionate Data analyst working with large amounts of data and to turn this data into information, information into insight and insight into valuable decisions. I also have a keen interest in the field of data analysis, data visualization and am fascinated by the power to compress complex datasets into approachable and appealing graphics.