Print Page | Close Window

Excel in AutoCAD, turn off grid lines?

Printed From: CAD Forum
Category: EN
Forum Name: AutoCAD
Forum Description: Discussion about AutoCAD and AutoCAD LT, viewers, DWG and DWF formats, Design Review, AutoCAD 360, add-ons
URL: https://www.cadforum.cz/forum_en/forum_posts.asp?TID=6486
Printed Date: 16.May.2026 at 12:20


Topic: Excel in AutoCAD, turn off grid lines?
Posted By: cheddarthief
Subject: Excel in AutoCAD, turn off grid lines?
Date Posted: 25.Aug.2011 at 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.  :)
 


-------------
The Cheddarthief



Replies:
Posted By: John Connor
Date Posted: 27.Aug.2011 at 17:37
Would you care to share your new found knowledge with the rest of us?

-------------
"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance."

<<AutoCAD 2015>>



Posted By: cheddarthief
Date Posted: 29.Aug.2011 at 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


-------------
The Cheddarthief


Posted By: John Connor
Date Posted: 31.Aug.2011 at 12:11
While it may not help me directly it may help others who come here seeking assistance with the same problem.  Thanks.

-------------
"Humans have a strength that cannot be measured. This is John Connor. If you are reading this, you are the resistance."

<<AutoCAD 2015>>




Print Page | Close Window