Results 1 to 4 of 4

Can Excel Strikethrough an entire cell?

This is a discussion on Can Excel Strikethrough an entire cell? within the Excel Questions forums, part of the Question Forums category; I apologize for the elementary question I am posting, but for the life of me I can't figure out a ...

  1. #1
    Board Regular
    Join Date
    Apr 2006
    Location
    Phoenix, AZ
    Posts
    78

    Default Can Excel Strikethrough an entire cell?

    I apologize for the elementary question I am posting, but for the life of me I can't figure out a way to get excel to strike through an entire cell. I want the strike through to be continuous, even through cells that have no text or numbers. Similar to a how I would border the cells below or above. Is there some excel trick to get this to work?

    Thanks!

  2. #2
    Board Regular Gary's Student's Avatar
    Join Date
    Aug 2012
    Location
    Lakehurst, NJ, USA
    Posts
    911

    Default Re: Can Excel Strikethrough an entire cell?

    Because strikethrough is a property of the font rather than the cell, you need to completely fill the cell with either spaces or visible characters rather than empty space.

    you can then specify strikethrough via Format Cells
    Have a Great Day!

  3. #3
    Board Regular
    Join Date
    Apr 2006
    Location
    Phoenix, AZ
    Posts
    78

    Default Re: Can Excel Strikethrough an entire cell?

    Thanks for the response. I've figured that out as well, and although I can fill the spaces with characters to get the effect on the computer, when I print, it still shows broken lines between the cells. If a border can be made continuous, why not strike throughs?

  4. #4
    shg
    shg is offline
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    14,047

    Default Re: Can Excel Strikethrough an entire cell?

    You will always see a gap between cells with strikethrough. It's just not something Excel does.
    Microsoft MVP - Excel

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com