Excel Ninja Shortcuts

By on October 24, 2018 in 

Among other celebrations during this month, October is also a national computer learning month. additionally, Oct. 17 is national spreadsheet day, compounding the desire for people everywhere to brush up on their Excel skills, share their knowledge and gain some new tricks.

Spreadsheets? I Excel at them.

Excel has become synonymous with spreadsheets and is still the program of choice for working with them. Becoming proficient in Excel can increase salary, productivity and save hours of time with the use of functions, short-cuts, and programming. The tips in this article can help you become a spreadsheet ninja in Excel and impress your boss and coworkers.


Excel Shortcuts

Ctrl+Home
Move to cell A1.
Ctrl+End
Move to last cell on worksheet.
Ctrl+Shift+:
Enters the current time.
Ctrl+;
Enters the current date.
Ctrl+Shift+=
Inserts a new column or row.
Ctrl+Shift+&
Places border around selected cells.
Ctrl+Shift+(
Unhide rows.
Ctrl+Shift+)
Unhide columns.
Alt+=
Creates a formula to sum all of the above cells.

Selection Shortcuts

Ctrl+Shift+*
Selects the current region around the active cell.
Ctrl+[
Selects all cells referenced by formulas in the highlighted section.
Ctrl+]
Selects cells that contain formulas that reference the active cell.
Ctrl+Shift+|
Selects the cells within a column that don’t match the formula or static value in the active cell.
Ctrl+Spacebar
Selects the entire column.
Ctrl+Shift+Spacebar
Selects the entire worksheet.
Ctrl+Shift+O
Selects all of the cells that contain comments.

Wrangling and manipulating data in excel can seem intimidating, especially when the numbers of rows and columns begin to approach the five and six digit mark. At these points, dragging and scrolling become fairly useless, but this is where keyboard shortcuts shine.

Navigate Excel With Keyboard Commands

Some of these are probably refreshers for many readers but they are none the less powerful. Try them out and you will quickly discover how these commands can be used and chained together to order and arrange data in Excel no matter how large or small it may be.


Excel Shortcuts

Ctrl+Z
Undo the last action.
Ctrl+Y
Repeats the last entry.
Ctrl+9
Hides rows.
Ctrl+0
Hides columns.
F11
Creates a chart from selected data.

Excel Shortcuts

Ctrl+D
Fill down. Fills the cell beneath with the contents of the selected cell.
Ctrl+G
Go to a certain area.
Ctrl+H
Find and replace.
Ctrl+N
Creates a new workbook.
F7
Spell check selected text or document.

While these only scratch the surface of what excel can do they do help in speeding up the process of getting there. Excel still holds all the power found in PivotTables, Formulas and the programming power of VBA. The lastest Excel 2019 has even more functions and features like map and funnel charts, SVG visuals and the ability to publish to Power BI.

Enhancing your Excel ninja skills will still take time. But, the more time and practice you devote to it will pay off, and pay you more salary hopefully. Be sure to check out the latest version of excel at MyChoiceSoftware and test out these shortcuts. If we missed your favorite one leave it in the comments below to help others in there computer learning for October and throughout the year.

Bonus Gif for keyboard pivot table
Generate Pivot Table With Keyboard Commands

Link to sample data used https://www.contextures.com/xlSampleData01.html

 

5 responses to “Excel Ninja Shortcuts

    1. Check with your library. Get a card. I’m in Thurston county, WA. This gives you access to Lynda.com that has all the training for any class you want. I’m doing Excel now. All free.

Leave a Reply

Your email address will not be published. Required fields are marked *

Buy from your trusted source

The latest and greatest Microsoft products with friendly customer service. What more could you ask for?

Get My Savings