Excel Mystery: Someone reports they have 7 cells with data. One of them has a mystery line at the bottom of the cell. It is not a border. What else could it be?
Transcript of the video:
All right gang, I'm stumped.
Let's Crowdsource this one. Hey, I have one cell with a rogue line at the bottom. Can't find out how to get rid of it.
I don't get to see the spreadsheet. So first thing, is it a border?
Press Ctrl+1 and you'll see that there's borders there.
Click none and it should go away. That's not it, they say.
How about this line here? This line is a page break.
But the only way you could do this is page layout, print area, set print area.
And then add a page break there with Alt I B. This line. This line is a drawing object.
How would we ever find that? I guess you could try and click on it or home, find and select select objects. Draw a big box around the range and right there that one shows up as a drawing object. This one is evil.
You'd have to have a cell with the top border. Copy that and then over here paste linked picture.
I don't know what else could it be.
Let's Crowdsource this one. Hey, I have one cell with a rogue line at the bottom. Can't find out how to get rid of it.
I don't get to see the spreadsheet. So first thing, is it a border?
Press Ctrl+1 and you'll see that there's borders there.
Click none and it should go away. That's not it, they say.
How about this line here? This line is a page break.
But the only way you could do this is page layout, print area, set print area.
And then add a page break there with Alt I B. This line. This line is a drawing object.
How would we ever find that? I guess you could try and click on it or home, find and select select objects. Draw a big box around the range and right there that one shows up as a drawing object. This one is evil.
You'd have to have a cell with the top border. Copy that and then over here paste linked picture.
I don't know what else could it be.
