Help create an autoshape?

hemmi1

New Member
Joined
Apr 8, 2009
Messages
21
A guy at work showed me a spreadsheet where he created an "x" that is sized for a cell, and by his copying it, it'll resize to fit whatever cell he likes. One can type into the cell, and the 'x' stays, connecting the four corners of the cell. Please see the pic below. http://www.hemmi.us/temp.jpg
He went so fast that I couldn't see what he did to get that.
I tried autoshapes with no luck. This 'x' doesn't have a value, so that's why I think it's an autoshape.
He created the shape in a fraction of a second.
Any ideas? I really would like to use this. Googling has been no help, probably because I don't know what I'm looking for (Catch 22).
Thanks, Louis
temp.jpg
How do I create this?:eek:
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
- Right click the cell
- Choose "Format Cells..."
- Click the "Border" tab
- Click the button on the bottom left and click the button on the bottom right. (they look like forward and backward slashes)
- Click OK
 
Upvote 0
I did not think of that, and was embarrassed to ask:LOL:

It's amazing I can get sidetracked by such a small thing. I did right click and format cells, but it showed "General" and I did not think to look at the other tabs.

You have helped, believe me. THANKs :)
 
Upvote 0

Forum statistics

Threads
1,215,059
Messages
6,122,917
Members
449,093
Latest member
dbomb1414

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top