#Excel shortcut keys strikethrough how to#
#Excel shortcut keys strikethrough for mac#
#Excel shortcut keys strikethrough manual#
#Excel shortcut keys strikethrough Pc#

#Excel shortcut keys strikethrough Pc#

press the 'equals' sign PC and Mac)ĭisplay the Formula Builder after you type a valid function name in a formula Here are a few shortcuts that'll make you a formula wiz: Start a formula (e.g. Select only the visible cells in the current selectionįormulas are a huge part of every marketer's Excel toolkit.

#Excel shortcut keys strikethrough how to#

We will show you how to apply a strikethrough using the shortcut keys and how to apply a strikethrough from the Format Cells dialog box. You can apply a strikethrough quickly and easily by using the shortcuts we will show you. Expand the selection by one cell either upward (↑) or downward (↓)Įxpand the selection to the last non-empty cellĬTRL + Shift + Arrow Key (PC) Command + Shift + Arrow Key (Mac) Excel has a strikethrough feature that draws a line in the middle of text or value to indicate that it has been canceled. 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 shortcut keys strikethrough manual#

Save yourself the manual dragging and selecting rows and columns with these handy keyboard tricks. Here's what cells look like with (left) and without (right) a border: 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: Here are a few shortcuts that to 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

#Excel shortcut keys strikethrough for mac#

( Note for Mac users: To access the F keys (F1–F12), you'll have to hold the Fn key before pressing any F key - unless you've enabled those keys as standard function keys.) 43 Excel Shortcuts You'll Definitely Want to Bookmark Navigation Shortcuts Although you can do all of these maneuvers manually, knowing these tricks will help save you time so you can focus on the stuff that really matters.Īll of these shortcuts can be accessed on PC and Mac, so we've included both types below where applicable. We’ve put together a list of 43 keyboard shortcuts for Microsoft Excel. How can we spend a little less time navigating, formatting, selecting, and entering formulas for our data? Wouldn't it be great if there were keyboard shortcuts that could help us get our work done faster? If you have any more shortcuts please leave a comment.Many marketers use Microsoft Excel every day, whether it's to create a chart, analyze data, or run a report to present at the next team meeting.Ĭreating reports like these in Excel is time-consuming enough. Now, under Effects, you need to check the box for strikethrough and press OK.

Now click on format cells, and the Format Cell dialog box will appear as below. I have included most used shortcuts of excel. Step 1 Right-click on the selected cell/cells and then select the Format Cells option in the drop-down menu. Use Excel 2013 for best experience and all the shortcuts works with excel 2013. Here is the list of the shortcuts that can make your life easy while using excel.