ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003, is there a "snap to" function? (https://www.excelbanter.com/excel-discussion-misc-queries/453745-excel-2003-there-snap-function.html)

jbclem[_3_]

Excel 2003, is there a "snap to" function?
 
I'm drawing lines, making rectangles for house plans on grid paper I've set
up. It's very tedious trying to get a horizontal line to be exactly
horizontal, sometimes my hand isn't steady enough, or the mouse doesn't have
good enough resolution.

I'd like to have a "snap to" function so that a line I'm drawing will do two
things: first, snap to a perfect horizontal or vertical orientation if
that's what I'm trying for, and second, snap to the nearest grid
intersection for it's starting and ending point.

Is this possible in Excel 2003, and if not, is there a subsequent version
that has this capability?




GS[_6_]

Excel 2003, is there a "snap to" function?
 
I'm drawing lines, making rectangles for house plans on grid paper I've set
up. It's very tedious trying to get a horizontal line to be exactly
horizontal, sometimes my hand isn't steady enough, or the mouse doesn't have
good enough resolution.

I'd like to have a "snap to" function so that a line I'm drawing will do two
things: first, snap to a perfect horizontal or vertical orientation if that's
what I'm trying for, and second, snap to the nearest grid intersection for
it's starting and ending point.

Is this possible in Excel 2003, and if not, is there a subsequent version
that has this capability?


Why not use borders instead of drawing vertical/horizontal/diagonal lines.

Optionally, use a drawing app!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

GS[_6_]

Excel 2003, is there a "snap to" function?
 
I forgot to mention LibreOffice Calc has that feature.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


All times are GMT +1. The time now is 05:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com