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.
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);
}