EXCEL to SLDDWG with no grid lines...

[TateJ]

I have a portion of a spreadsheet with some calculations that I want to copy/paste to my drawing. Works fine, but it shows up with grid lines. How can I make them go away?

Windows XP / Logitech "Premium" Optical mouse
SolidWorks 2006 SP4.1 / SpaceBall 5000
Lava Lamp
www.Tate3d.com​

 

[smcadman]

Double-click the grid on the SW drawing > Right-click a cell and pick "Format Cells" > Border TAB > Choose "None" for the presets.



Flores
SW06 SP4.1

 

[TateJ]

There's no border on the cells. I think it has to do with the sheet formating in EXCEL...

Windows XP / Logitech "Premium" Optical mouse
SolidWorks 2006 SP4.1 / SpaceBall 5000
Lava Lamp
www.Tate3d.com​

 

[TateJ]

The PRINT PRIEVIEW in the EXCEL file shows with no grid lines.

Windows XP / Logitech "Premium" Optical mouse
SolidWorks 2006 SP4.1 / SpaceBall 5000
Lava Lamp
www.Tate3d.com​

 

[smcadman]

Gotcha, then turn off the gridlines in Excel before pasting into SW. In Excel: Tools > Options > Gridlines (lower left).

Flores
SW06 SP4.1

 

[CorBlimeyLimey]

Open the spreadsheet in Excel, then go to Tools > Options > View and deselect Gridlines.

​

Helpful SW websites faq559-520​

How to find answers ... faq559-1091​

 

[TateJ]

BINGO...

thanks

Windows XP / Logitech "Premium" Optical mouse
SolidWorks 2006 SP4.1 / SpaceBall 5000
Lava Lamp
www.Tate3d.com​