Text Box Gridline Alignment

ewicatcher

New Member
Joined
Feb 4, 2005
Messages
17
Can anyone please tell me how to get the gridlines in a text box to align perfectly within the established gridlines in Excel? I took an Excel class a few years ago, and remember there was a way to get the text box lines to align perfectly with the other gridlines.

I believe it involved holding the Alt or control key down while double clicking on the text box gridlines?? I have tried every combination imaginable and the lines are not matching up perfectly. Microsoft Help is no help, because everything refers to aligning the text not the gridlines…

Thanks,


Shawn
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

indiantrix

Well-known Member
Joined
Oct 17, 2002
Messages
943
Have you tried this? Select the textbox, then click the DRAW icon near bottom left of sheet, choose SNAP, TO GRID.
Anyone else? /s/ Larry
 

ewicatcher

New Member
Joined
Feb 4, 2005
Messages
17
Yes, Thank you. The Alt key trick seems to work fine. I am not sure where to find the snap to grid button/menu item that you refer to. I don't see any similiar choise on the drawing toolbar either?


Shawn
 

Forum statistics

Threads
1,141,680
Messages
5,707,788
Members
421,527
Latest member
Tamiwsw

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