How to Find and Remove Duplicates in Excel! (2 Easy Tricks!)

Learn how to Find And Delete Duplicate cells in Excel

Duplicate information might be useful sometimes, but in most of the cases, it makes the understanding of our data hard and not usable. Here we will take a look at how to easily spot Duplicate Data and Remove it from our Excel Spreadsheet! Highlight Duplicate Cells First, we are going to look at How to … Read more

Remove Polyline Vertexes (Remove Multiple Vertexes at Once!!)

Remove Vertexes from Polylines!

Polylines are one of the most frequently used objects in AutoCAD. I personally can’t imagine working without using one, that is why it is really important for all drafters to know how to edit them as fast as they can. One of the common tasks for us while working with polylines is to remove an existing … Read more

Draw Order Shortcuts! (Bring to Front and Send to Back)

Create Shortcuts for Draw Order commands! (bring to front send to back)

Two of the most commonly used commands by me are Bring to Front and Send to Back. This is because our drawings often times are overcrowded and they can become hard for understanding. By using display settings we can make our drawings more readable and professional looking. The problem with this commands is that there is … Read more

Multiple Text to MText Without Moving! (Convert Text to Mtext Without any Formatting!)

Text to Mtext without moving !

Are you trying to convert Text to Mtext Without any Formatting? I was trying to do just that a lot of times and finally, I found a solution! Here we will take a look at it. The reason why I wanted to convert several Text objects to single line Mtext objects is that I wanted to … Read more

Change The Layer of Multiple Blocks to Layer 0! (Using one simple command!)

Change layer of multiple blocks to layer 0!

The problem? Today I received one architectural site plan with really poor linework. I assume that the Architect had used Revit or other similar software and then exported his drawing to AutoCAD. But the result was really bad for me. All the objects were blocks and all the objects in the blocks had different layers … Read more

How to Automatically Set Elevations to Polyline in AutoCAD

Set Elevations to polyline Automatically!

If you are working in the field of Civil Engineering or Land Surveying you probably faced the problem of Assigning Elevations to Polylines. The most common situation is when you have to use someone’s existing drawing and they exploded everything. Or have flattened the contours and now all the polylines have Elevation 0. The second … Read more

Grip Issue Editing Polylines and Labels Civil 3d 2018!

Grip Issues with AutoCAD Civil 3d and Map 3d

At the beginning of 2018 at work, we moved to AutoCAD Civil 3d 2018, there is some cool new stuff but we faced some really annoying Grip issues. Issues Label and Arc Grips Issues in Civil 3d The first problem we faced was the grips of Spot Elevation Surface Labels. Whenever we try to move … Read more

.wp-container-core-social-links-is-layout-1.wp-container-core-social-links-is-layout-1{flex-wrap:nowrap;justify-content:flex-start}.wp-container-core-social-links-is-layout-2.wp-container-core-social-links-is-layout-2{flex-wrap:nowrap;justify-content:flex-start}