Shlomo sends in a great tip to solve the Cartesian coordinate numbering problem from last week's Episode 876. The solution involves the camera tool. In Episode 883, we will take a look at where Microsoft moved this tool in Excel 2007.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, alright, welcome back. It's another "Where Is It Wednesday".
Want to thank George Wood for that great theme.
We have a cool tip today sent by Shlomo.
Shlomo saw our podcast last week, where we talked about creating a Cartesian Grid and how to get the numbers from the Cartesian Grid to appear directly on the grid lines.
Now I proposed some solutions back there but Shlomo reminded me about the camera tool.
Hold down the Ctrl key here, and drag this down to create the Numbers 1 through 10.
And basically, I'm going to copy that range, but I'm not going to copy it normally; I'm going to copy it as a picture.
Now, in Excel 2003, we would've used the camera tool for this; in Excel 2007 it's kind of weird-- they put it here underneath Paste as Picture, and then Copy as Picture.
Isn't that the weirdest thing you've ever seen?
Where the Copy as Picture is now actually under the Paste drop-down.
Go figure.
But anyway, when we do that we get a picture of those cells and then we can come over here and paste that picture.
I'll use Ctrl+V to paste, and what you're going to see is that I can basically now take that picture and just offset it by about a half a row.
And when I click outside, I now have a picture of the cells and the picture lines up perfectly with the Cartesian grid.
Now let's quickly take a look in Excel 2003 to see how we would achieve this exact same effect.
In Excel 2003, the grid lines are a bit darker, so we actually might want to go to another worksheet; Insert, Worksheet; add the numbers there; and on this particular worksheet we're going to say that we don't want to see grid lines-- so Tools, Options, on the View tab uncheck Gridlines, click OK.
Now I want to Copy as Picture, so you could use the camera tool or you can just hold down the Shift key-- hold down the Shift key-- go to the Edit menu, and a brand new Option appears with Copy Picture, click OK.
And then I'll go back to my worksheet and I can paste-- Ctrl+V to paste-- and just kind of drag this down a little bit so that way it's about a half a row offset, and now the lines do go perfectly through each individual number.
A couple of cool tricks using the old camera tool, although it's a bit harder to find in Excel 2007.
Actually, you know, that really is a toss-up-- is it harder to find?
They just hid it underneath where no one would ever look, as opposed to in Excel 2003-- you had to know how to hold down the Shift key.
Both are, admittedly, fairly obscure; so we went from one obscure location, holding on a Shift key, to another obscure location, underneath the Paste icon.
Who would look under Paste for the copy.
But anyway, that's how you do it.
Thanks to Shlomo for sending in that great tip, and thanks to you for stopping by.
We'll see you next time for another netcast from MrExcel.
Want to thank George Wood for that great theme.
We have a cool tip today sent by Shlomo.
Shlomo saw our podcast last week, where we talked about creating a Cartesian Grid and how to get the numbers from the Cartesian Grid to appear directly on the grid lines.
Now I proposed some solutions back there but Shlomo reminded me about the camera tool.
Hold down the Ctrl key here, and drag this down to create the Numbers 1 through 10.
And basically, I'm going to copy that range, but I'm not going to copy it normally; I'm going to copy it as a picture.
Now, in Excel 2003, we would've used the camera tool for this; in Excel 2007 it's kind of weird-- they put it here underneath Paste as Picture, and then Copy as Picture.
Isn't that the weirdest thing you've ever seen?
Where the Copy as Picture is now actually under the Paste drop-down.
Go figure.
But anyway, when we do that we get a picture of those cells and then we can come over here and paste that picture.
I'll use Ctrl+V to paste, and what you're going to see is that I can basically now take that picture and just offset it by about a half a row.
And when I click outside, I now have a picture of the cells and the picture lines up perfectly with the Cartesian grid.
Now let's quickly take a look in Excel 2003 to see how we would achieve this exact same effect.
In Excel 2003, the grid lines are a bit darker, so we actually might want to go to another worksheet; Insert, Worksheet; add the numbers there; and on this particular worksheet we're going to say that we don't want to see grid lines-- so Tools, Options, on the View tab uncheck Gridlines, click OK.
Now I want to Copy as Picture, so you could use the camera tool or you can just hold down the Shift key-- hold down the Shift key-- go to the Edit menu, and a brand new Option appears with Copy Picture, click OK.
And then I'll go back to my worksheet and I can paste-- Ctrl+V to paste-- and just kind of drag this down a little bit so that way it's about a half a row offset, and now the lines do go perfectly through each individual number.
A couple of cool tricks using the old camera tool, although it's a bit harder to find in Excel 2007.
Actually, you know, that really is a toss-up-- is it harder to find?
They just hid it underneath where no one would ever look, as opposed to in Excel 2003-- you had to know how to hold down the Shift key.
Both are, admittedly, fairly obscure; so we went from one obscure location, holding on a Shift key, to another obscure location, underneath the Paste icon.
Who would look under Paste for the copy.
But anyway, that's how you do it.
Thanks to Shlomo for sending in that great tip, and thanks to you for stopping by.
We'll see you next time for another netcast from MrExcel.
