This will open a small window of options where you can insert a new row or column.

To insert a new row, highlight a cell or entire row and press CTRL + Shift + + on your keyword, literally pressing the plus sign after Shift.

The insert row shortcut in Excel will create a new row below a highlighted cell. To start, here are two featured rows-related shortcuts you might not have known about: Excel Insert Row Shortcut Save yourself the manual dragging and selecting rows and columns with these handy keyboard tricks. Show all values as currency (Note: Replace $ with your own country’s currency key)Īpply or remove bold formatting to selected cellsĪpply or remove italic formatting to selected cellsĪpply an outline border to selected cells (see screenshot below)ĬTRL + Shift + & (PC) Command + Option + 0 (Mac) To strike a line through a cell, highlight the cell and press CTRL + 5 on your keyboard. The Excel strikethrough shortcut will strike a line through the middle of the value or text in a highlighted cell. To start, here’s a featured formatting shortcut you might not have known about: Excel Strikethrough Shortcut

Here are a few shortcuts that will help you easily format your cells. Switch to the previous open worksheet (Mac)įill selected cell with the content in the cell above selected cellįill selected cell with the content in the cell to the left of selected cellįormatting in Excel can be difficult if you don’t know of what you’re doing. Jump to the corner of a selection (Note: Rotate to each corner by repeating this keystroke)ĬTRL + Shift + F6 (PC) Command + Shift + F6 (Mac) These simple shortcuts can help you navigate between workbooks, sheets, rows and columns: Move up through a selection There are tons of shortcuts in Excel, but here are the most frequently used ones: Navigation Shortcuts Nowadays life is so fast paced that we could all do with more time to get things done, so anything that can be streamlined should be! These really handy Excel shortcuts will save you some precious minutes (or hours!) so you can fit in the more important things.

Excel shortcut keys strikethrough