Do you get annoyed when you copy a formula and the borders get copied along with the formula? Episode 342 shows you a cool trick to prevent the borders from being copied as you extend a formula.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Welcome back to the MrExcel podcast, I'm Bill Jelen.
Today I have something that is one of the most annoying things in Excel.
I have a table set up here in Excel with Date, Units, Dollars, and I've just entered a formula in cell D4, and I want to copy this formula down to all the other rows.
Well, you know my favorite trick, double-clicking the fill handle will copy that down.
But the really annoying thing is that, because cell D4 had a top border, when I copy that formula down, every cell gets the top border, and all of a sudden my table looks absolutely horrible!
I'm going to hit Ctrl+Z, undo that, and this time I will use Ctrl+C to select my entire range, and use Edit, Paste Special!
And in the Paste Special dialogue I'm going to choose All except borders, that will copy the formula and the numeric formatting down, but it won't bring the borders along.
That way I have a worksheet that looks absolutely like I wanted to look.
Anytime the borders starts to drive you crazy every time that you copy, just do an undo, and then copy, Paste Special, All except borders.
Hey thanks for stopping by, we'll see you next time for another podcast from MrExcel!
Today I have something that is one of the most annoying things in Excel.
I have a table set up here in Excel with Date, Units, Dollars, and I've just entered a formula in cell D4, and I want to copy this formula down to all the other rows.
Well, you know my favorite trick, double-clicking the fill handle will copy that down.
But the really annoying thing is that, because cell D4 had a top border, when I copy that formula down, every cell gets the top border, and all of a sudden my table looks absolutely horrible!
I'm going to hit Ctrl+Z, undo that, and this time I will use Ctrl+C to select my entire range, and use Edit, Paste Special!
And in the Paste Special dialogue I'm going to choose All except borders, that will copy the formula and the numeric formatting down, but it won't bring the borders along.
That way I have a worksheet that looks absolutely like I wanted to look.
Anytime the borders starts to drive you crazy every time that you copy, just do an undo, and then copy, Paste Special, All except borders.
Hey thanks for stopping by, we'll see you next time for another podcast from MrExcel!
