If you would prefer to click your way to a strikethrough, you can do so using the Format Cells launcher in the Home tab of the Excel desktop application.
Add Strikingthroughs Using The Format Cells Launcher You can select a single cell to apply this formatting to with the shortcut, or you can select multiple cells at once and press the same keyboard shortcut to add strikethrough to all of them.
Excel keyboard shortcuts drop down lists how to#
Start by selecting the cell or cells within which you would like to add your strikethrough, and then press CTRL + 5.ĬTRL + 5 is how to add a strikethrough to cells in an Excel worksheet.
If you want to use a keyboard shortcut to add a strikethrough in Excel, it’s one of the easier keyboard shortcuts you’ll encounter. Keyboard Shortcut for Excel Strikethrough If you want to learn about using an Excel strikethrough shortcut, you’re in the right place. If shortcuts feel overwhelming, just try to learn a few at a time, and before you know it, you’ll be cruising around your sheets using nothing but your keyboard, and it can be a lot more quick and productive when you get really good at it. Well, since Excel isn’t focused on word processing or text editing to the same degree, it’s not quite as simple to add a strikethrough but learning the shortcuts will make it easy and fast. If you’ve used just about any word processor, you would expect to see a strikethrough option right there in the top menu, right? It gives you an instant visual cue of your progress, and you can do fun things like setting up a checkbox with tasks next to it that automatically adds a strikethrough when you check the box. That’s where using a strikethrough works nicely, it lets you know visually that this particular text can be ignored for the time being, but it’s still readable if you give it a closer look.īut this style choice isn’t only useful to help simplify more complex documents, it’s also perfect for very simple sheets like a checklist or a to-do list.Īdding a strikethrough as you complete a task is incredibly rewarding, much more so than simply moving on to the next item or task. There is also a bug for chrome: Not able to open view/open drop-down list using keyboardĪlso, the ribbon UI and settings dialogs in Excel 2010 do open the drop down when pressing just the up/down arrow keys.Īre the Alt+ Up Arrow / Alt+ Down Arrow shortcuts widely know/used? I'm debating whether to just add a polyfill for Chrome or write something to mimic the Office Ribbon behaviour in all browsers.Spreadsheets can become incredibly complex, and sometimes taking a bit of information off the table when it’s no longer needed is useful, but you don’t want to hide it completely. It doesn't work in Chrome but there is a workaround. However, in Firefox and IE pressing Alt+ Up Arrow or Alt+ Down Arrow opens the drop down for web pages and settings dialogs. When pressing Up Arrow or Down Arrow drop downs stay closed in web pages on Chrome, Firefox and IE9, and in those browsers settings dialogs. But as selecting options in the list may change the form in this app I'd like to have a way to open the drop down so you can see the entire list and pick one of the options whilst viewing the entire list (or as much as will fit on screen).ĪHA! Found something that works for some browsers. I'm aware that Up Arrow and Down Arrow can change the selection, and pressing a letter key will cycle through the items starting with that letter (or typing a pattern will jump to the item starting with that sequence). I'm going to write some JavaScript to make the drop down lists (select and option tags) in a web app accessible via the keyboard. Are there any standard keyboard shortcuts for making drop down lists appear? (in any kind of software, not just web based.)
0 kommentar(er)
