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:
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

lionpants

Board Regular
Joined
Nov 11, 2009
Messages
117
- 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
 

hemmi1

New Member
Joined
Apr 8, 2009
Messages
21
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 :)
 

Watch MrExcel Video

Forum statistics

Threads
1,123,492
Messages
5,601,994
Members
414,490
Latest member
Rip181

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
Top