Strikethrough formatting in Excel provides a clear visual indicator that data has been completed, canceled, or requires revision. Learning how to put a line through text excel streamlines review processes and improves document clarity for teams analyzing financial records or inventory lists.
Using the Ribbon Shortcut
The most direct method to apply a line involves the Home tab. Select the cell or range containing the target text, then locate the Font group on the ribbon. Click the dialog launcher icon in the bottom-right corner to open the Format Cells window, navigate to the Border tab, and choose the center diagonal line preset before confirming.
Applying Keyboard Commands
Power users often prefer keyboard efficiency for repetitive tasks. Pressing Ctrl+Shift+7 applies a single horizontal line through the center of selected cells instantly. This shortcut functions identically whether you are working on Windows or macOS, though the command key replaces control on Apple devices.
Customizing the Quick Access Toolbar
For maximum speed, add the striethrough button to your Quick Access Toolbar. Right-click the icon in the Home tab, select Add to Quick Access Toolbar, and the action becomes a single click away. This customization reduces reliance on the ribbon and saves valuable time during intensive spreadsheet work.
Managing Multiple Selections
Consistency is critical when formatting large datasets. Hold the Ctrl key to select non-adjacent cells before applying the line to ensure uniform styling. Alternatively, click and drag to highlight an entire row or column, which is useful for marking completed tasks across wide project plans.
Adjusting Line Appearance
Default lines might not suit every visual requirement. Access the Format Cells menu to adjust the color, style, and angle of the strike. Changing the line color to grey or adjusting the angle can reduce visual noise while maintaining professionalism in dense spreadsheets.
Troubleshooting Common Issues
If the line does not appear, verify that the cell format is not set to Accounting. This format sometimes overrides standard font settings. Switching the format to General or Text usually resolves the conflict and allows the strikethrough to display correctly.
Preserving Data Integrity
Applying a line does not alter the actual cell value or formula results. This distinction ensures that calculations remain accurate even when items are visually marked as void. You can filter by cell color or text content to isolate marked entries without deleting any critical information.
