Here is the keyboard shortcut that will automatically apply the strikethrough formatting in Excel. Just select the cell where you want to apply the strikethrough format and press Control 5. If you want to apply this to a range of cells, select the entire range of cells, and use this keyboard shortcut. You can also select non-adjacent ranges and then apply the strikethrough format.
Add Icon in QAT to Access Strikethrough in Excel. While the icon is not available in the ribbon or Quick Access Toolbar QAT by default, you can add it easily. Here are the steps to add strikethrough icon in the QAT. Right-click on any existing QAT icon or the ribbon tabs and select Customize Quick Access Toolbar. In the Excel Options dialogue box, select All Commands from the drop-down. Click on Add.
This will add the strikethrough icon in the quick access toolbar. Access Strikethrough Format from Format Cells Dialogue. There is another way you can access strikethrough in Excel Using Format Cells dialogue box. Scroll down and select Strikethrough from the list. While the earlier mentioned techniques keyboard shortcut and icon are faster ways to access strikethrough formatting, using format cells dialogue box gives you access to a lot of other formatting options as well.
Here are the steps to access Strikethrough in Excel using the Format Cells dialogue box. Select the cells where you want to apply the strikethrough format. Press Control 1 or right click and select Format Cells. In the format cells dialogue box, select the font tab and check the Strikethrough option. This would apply the strikethrough format to the selected cells.
While this option is longer as compared to a keyboard shortcut or using the icon, it also gives access to many other formatting options at a single place. For example, you can also change color, font type, font size, border, number format, etc.using this dialogue box. Examples of Using Strikethrough in Excel. Strikethrough in Excel can be used to show completed tasks.
Here are three practical examples where you can use the strikethrough format in excel. EXAMPLE 1 Using Conditional Formatting. We can use conditional formatting to strikethrough a cell as soon as it is marked as completed. Something as shown below. Download Example File. EXAMPLE 2 Using Checkboxes to show completed tasks. You can also use check-boxes to cross off items. EXAMPLE 3 Using Double Click VBA. If you are cool with using Excel VBA macros, you can also use the double-click event to cross off items simply by double-clicking on it.
This method disables getting into the edit mode on double click and simply applies the strikethrough format as soon as you double click in the cell VBA code available in the download file. While the idea behind applying the strikethrough format in excel remains the same, you can get as creative as you want. Here is a creative example where I used the strikethrough format in a Task Prioritization Matrix template.
Hope you found this tutorial useful. Let me know your thoughts in the comments section. You May Also Like the Following Excel Tutorials. FREE EXCEL BOOK. Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster. sir its all usefull for me. i have improve my self along without completing any course. It may sound odd, but I still use old school pen and paper scrape paper to write off my tasks in office. But many times the paper on which I had written my task gets misplaced, and with it all my plans for that day.
I was procrastinating on using any new software to manage my simple to do list, but yours strikethrough has inspired me to use excel as my to do list instead of paper because I m quite familiar with it, plus strikethrough will give me the satisfaction I get when I cross items off my list. Thanks for sharing it Sumit. It is really a temptation to use strike-through to cross out records visually.
However, we have to use it with caution in Excel. It is a good practice to accompany it with a remark, like what you did in Example 1. Why am I saying that. Because we cannot filter records with strike-through. Think about if you are maintaining a table of more than 1000 records with hundreds of strike-through that indicates completed job then one day your boss asks you a simple question How many records have been completed.
Without a supplementary remark, it could be a nightmare to get the answer for a simple question. Of course, there is a workaround, which requires a combination of simple techniques. but still a column with appropriate remarks is more handy and useful to majority of user. Thanks for commenting and sharing. A good workaround to count filter hide the number of strike through cells would be to use find and replace and apply a color to it. That ways you can now filter sort it using that color.
This can also quickly answer how many records have been completed. While it is a good option to have a complimentary column, I guess most the people would not create one while checking off items. BEST EXCEL TUTORIALS. In most cases, it means that the task or activity has been completed and has been checked off. thank you to all special admin. Recently Super key has become an alternative name for the Windows key 1 or Apple key 2 when using Linux or BSD operating systems or software that originated on these systems.
Super key keyboard button. The Super key refers to several different keys throughout keyboard history. Tom Knight created both the Knight keyboard and the space-cadet keyboard. 1 Knight keyboard to the space-cadet keyboard 2 Linux and BSD 3 macOS 4 References. The improvement from the Knight keyboard to the space-cadet keyboard was the presence of two more modifiers for the bucky bits, Hyper and Super ; the Super key modified the third bucky bit representing a 4.
3 From the usage of the space-cadet keyboard on Lisp machines the Super key was inherited by Emacs as one of several supported modifier keys; however most modern systems have to emulate the Super key using another. Initially on PC hardware it was just impossible to produce these shift states as there was no key to push for them. The only software that commonly used these modifiers was Emacs. Due to being designed at the time of the space-cadet keyboard, X11 defined the shift states MetaSuperand Hyper along with Shift and Control and Alt which were commonly available on keyboards.
With the appearance of keyboards with the Windows key there was now a key available on standard keyboards that could be used for one of these. Initially, circa 1996, it was most common to make this key be the Meta shift key. However, due to the high number of Emacs commands using Metathere were already long-established replacements the Alt key acted as Meta, or typing Escape,X acted like Meta-Xso adding an actual Meta key did not provide much added functionality.
This made Super the first key of interest in emulating, and therefore it became the standard assignment after a few years. To avoid using a Microsoft trademark, much Linux documentation refers to the key as Super. This can confuse some users who still consider it a Windows key. In KDE Plasma documentation it is called the Meta key even though the X11 Super shift bit is used.
Most Linux desktop environments use the key similar to how Windows uses it, for window management and application launching, rather than commands used by applications. A popular non-Windows style use is to modify mouse drags so that they move or resize windows from inside them, rather than requiring clicking on the window borders. In GNOME 3, letting go of the Super key defaults to showing the activities window. In Openbox the Super key is an available modifier key, but is not used in any default shortcuts.
Under Unity, the key is used to control launcher and manage windows. In elementary OS, the Super key shows a shortcut overlay and is used for several system, window, and workspace functions. If a Windows keyboard is connected to macOS it will use the Windows key as the Command key, therefore Super is still on the Windows key for macOS. X11 emulation on macOS puts the Super shift state on the Command or Apple key.
Originally the Super key was a modifier key on the space-cadet keyboard. Share All sharing options for Surface keyboard update to restore basic Windows shortcuts, improve function keys. Microsoft s Surface Type and Touch Covers swapped out traditional keyboard F keys for quick access to volume, media, and other controls, but that has left a gap for those used to function keys and Windows keyboard shortcuts.
Microsoft Surface RT Touch Cover large 875px. In an update that will be made available on June 11th, Microsoft is adding options to its function keys for Surface keyboards. Surface RT and Pro owners will be able to lock F1-F12 function keys to use them as regular shortcuts for actions like alt F4 to close apps. At present, you need to hold the function key alt F4 to activate the regular Windows keyboard shortcut. The update will also make some functions a little easier to complete with one hand, including function key del to increase the display brightness, or function key spacebar to take a screenshot.
It s a fairly minor addition, but coupled with the ongoing monthly updates to Surface it demonstrates that Microsoft is serious about keeping its own tablets up-to-date with new features and functionality. Surface keyboard update to restore basic Windows shortcuts, improve function keys. Windows Alt codes. You can always copy paste symbols, but you can even type some of these text signs, symbols and emoji via keyboard.
You press Alt and, while holding it, type a code on Num Pad. It s very easy, but not as practical for long-term usage as Shift States. Also, you can type many frequently used symbols with this method, but not all like with Shift States. Shift states. Configure your keyboard layout in Windows so that you can type all additional symbols you want as easy as any other text.
Takes about 5-10 minutes to set things up, but you ll be typing like a boss. Character map. CharMap allows you to view and use all characters and symbols available in all fonts some examples of fonts are ArialTimes New RomanWebdings installed on your computer. iOS Emoji keyboard. For Emojis only there is a special preinstalled keyboard. You can make frequently used technical non-fancy symbols like π æ and åccénted letters on Mac using Option key.
MacOS Keyboard viewer. Shortcut technique that works on Desktops and some Laptops running MS Windows. I ve compiled a list of shortcuts in my article and explained how to open keyboard viewer. You can also use your Keyboard Viewer as an alternative to my list. Character Palette allows you to view and use all characters and symbols available in all fonts some examples of fonts are ArialTimes New RomanWebdings installed on your computer. MacOS Character palette. Keyboard codes.
On non-handheld Linux not Android mobile there are 3 great ways to type Unicode symbols with keyboard. You can code all symbols with Unicode hex codes, type lots of symbols in the most easy way with Third and fourth level choosers, and easily compose useful signs with Compose key sequences. To find out how, read references that I made. Character map allows you to view and use all characters and symbols available in all fonts some examples of fonts are ArialTimes New RomanWebdings installed on your computer.
It can also help you lookup Unicode codes for entering symbols with keyboard.