Display full version of the post: Excel in AutoCAD, turn off grid lines?

cheddarthief
25.08.2011, 20:37
I posted this earlier but after reading it, I might have made it too confusing.  Let's try this again...
 
When I embed an Excel sheet into AutoCAD for the purpose of being a bill of material, all grid lines are plotting out.  This includes the grid lines that have NOT been activated in Excel.  Do I need to make my settings change in Excel or AutoCAD so that only the grid lines I've turned on print and how?
 
Thanks in advance,
CheddarThief
 
SOLVED:  I figured it out.  Thank you Google.  :)
 cheddarthief2011-08-25 22:22:25

John Connor
27.08.2011, 17:37
Would you care to share your new found knowledge with the rest of us?


cheddarthief
29.08.2011, 14:13
LOL....absolutely. 
 
For clarity, I have Office 2010.  In Excel, there is the "ribbon" at the top which is basically large toolbars with drop downs.  From the "Page Layout" tab go to the "Sheet Options" drop down.  In there you find the "Gridlines" and you can either check the Print or View option.  By default, Excel has a check in the view box.  Uncheck this option.  Then highlight the cells to copy, link them to your CAD file and not only do they not plot out but you don't even see them in your file.
 
Hopefully that helps.
 
CheddarThief

John Connor
31.08.2011, 12:11
While it may not help me directly it may help others who come here seeking assistance with the same problem.  Thanks.