Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've used Visio in the past and it is definitely powerful. But I can't
justify purchase in my new place of work so I guessed I'd use Excel. I have a template with narrow columns to make a convenient grid, the "SnapToGrid" macro run-on-opening that this thread was originally concerned with, and a custom toolbar. I like this setup because it's very convenient combining with Word - a flowchart down the right and explanations down the left. A double-click activates my flowchart and gives me my toolbar and I can still see the whole Word doc. If I remember correctly, this is something Visio didn't do - double-clicking a chart embedded in Word would open Visio fully and you work on your chart seperately. -- David M WinXP - Office2003 (Italian) "LAK" wrote: Hi, I am a novice in flowcharting. 1) Should I use Excel, or, Powerpoint, or other Microsoft Office program? I appreciate your comments. 2) On locking shapes to grid, your instruction here still holds true? Thanks, -- "LAK" wrote "ShaneDevenshire" wrote: Hi, First I would display the flowchart shapes toolbar. (Assuming you are using Excel 2003 or earlier): 1. On the Standard toolbar click Drawing. 2. On the Drawing toolbar open AutoShapes, and open Flowchart, drag the Flowchart submenu away from the AutoShapes menu by grabbing its title bar, the gray dotted line at the top of the pop out menu. 3. To get the shapes to lock the the grid on the Drawing toolbar choose Draw, Snap to, Grid. This will make snap to grid the default. On a case by case basis you can activate snap to grid by press the Alt key as you drag a shape around. But once you have set the default to Snap to Grid, then the Alt key will temporarily turn off snap to grid as you drag. -- Cheers, Shane Devenshire "#DIV/0" wrote: Good morning, I do a lot of flowcharting and would love to find a way to get Excel to open with shapes set to lock to the cell grid by default (excuse me if the terms aren't always correct - I'm translating from the Italian version of Excel2003). -- David M WinXP - Office2003 (Italian) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
How do I set caps lock as default? | Excel Worksheet Functions | |||
When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
Make default insert sheet to have grid lines | New Users to Excel |