In this Excel training video, we will guide you through the process of applying a strikethrough formatting to text using a keyboard shortcut. Also, the guide will cover the different shortcuts for both Windows and Mac computers.
Be sure to check the bonus tip at the end of the video, where we’ll show you how to create a custom strikethrough button using an Office script.
PSST, HEY, YOU
(YEAH, YOU!)
Want in on insightful videos, the latest tech developments, and epic exclusive content? Get all this and more as a member of our mailing list.
Resources
Windows Shortcut (Desktop):
Ctrl + 5
Windows Shortcut (Web)
Ctrl + 5 (Chrome & Edge)
Ctrl + Alt + 5 (FireFox)
Mac shortcut (Desktop):
Command + Shift + X
Office script for Shortcut button:
async function main(workbook: ExcelScript.Workbook) {
// Get the used range of the current worksheet.
let currentSheet = workbook.getActiveWorksheet();
let usedRange = currentSheet.getUsedRange();
// Get the RangeFont object.
let font = usedRange.getFormat().getFont();
// Toggle the strikethrough property.
let hasStrikethrough = font.getStrikethrough();
font.setStrikethrough(!hasStrikethrough);
}