CARA MENGATUR SKALA DI EXCEL

Autocad is a software that is used for designing and drafting purposes. It is widely used in a variety of fields such as architecture, engineering, and construction. One of the important aspects of using Autocad is the ability to scale the drawings. This article will provide a step-by-step guide on how to scale in Autocad using the Perintah Scale command. Additionally, we will also discuss how to set the scale in Excel.

How to scale in Autocad using Perintah Scale command?

Scaling in Autocad is a relatively simple process. Here is a step-by-step guide on how to do it:

CARA MENGATUR SKALA DI EXCEL

Step 1. Open Autocad and select the object you want to scale

Open the file containing the object you want to scale and select it using the mouse or keyboard. You can select multiple objects if you wish to scale them together.

Baca Juga :  Cara Menghitung Peluang Lewat Ms.excel

Step 2. Type ‘scale’ into the Command prompt

Once you have selected the object, type ‘scale’ into the command prompt and press Enter. This will bring up the Scale command.

Step 3. Select the base point

The base point is the point from which the scale is going to occur. You can either select a point on the object or type in the Cartesian coordinates for this point.

Step 4. Enter the scale factor

The scale factor is the multiplier or ratio by which the object is going to be scaled. Type in the value you want to scale the object by and press Enter.

Step 5. Select the destination point

The destination point is the point where the base point is going to be moved to once the scaling operation is complete. You can either select a point on the object or type in the Cartesian coordinates for this point.

Step 6. Check the scaling operation

Once you have selected the destination point, the object should have been scaled correctly. Check the scaling operation by measuring the object with the measurement tool.

How to set the scale in Excel?

Excel is a powerful spreadsheet program that is used for a variety of purposes such as keeping track of finances, managing data, and creating charts and graphs. Here is a step-by-step guide on how to set the scale in Excel.

Setting the scale in Excel

Step 1. Open Excel and select the worksheet you want to scale

Open the Excel file that you want to scale and select the worksheet you want to scale. You can select multiple worksheets if you want to scale them together.

Baca Juga :  cara membuat mail merge di microsoft word dan excel Cara mail merge excel ke word

Step 2. Click on ‘Page Layout’ tab

Click on the ‘Page Layout’ tab in the Excel ribbon. This will bring up the ‘Page Setup’ dialog box.

Step 3. Click on ‘Scale to Fit’

In the ‘Page Setup’ dialog box, click on ‘Scale to Fit’ under the ‘Page’ tab.

Step 4. Enter the scale values

Under ‘Scale to Fit’, select the ‘Custom Scaling Options’ radio button and enter the scaling values for both ‘Width’ and ‘Height’.

Step 5. Click on ‘OK’

Once you have entered the scaling values, click on ‘OK’ to apply the scaling to the worksheet.

FAQ

1. Can I scale an object in Autocad without using the Perintah Scale command?

Yes, you can scale an object in Autocad without using the Perintah Scale command. One way to do this is to use the ‘Stretch’ command.

2. Can I set the scale in Excel automatically?

Yes, you can set the scale in Excel automatically by using a formula. One way to do this is to use the ‘SCALE’ function.

Tutorial Video

Watch the video below to learn more about how to scale objects in Autocad and set the scale in Excel:

In conclusion, scaling is an important aspect of designing and drafting in both Autocad and Excel. Knowing how to scale objects in these programs can help you create more accurate and precise designs. By using the Perintah Scale command in Autocad and the ‘Scale to Fit’ option in Excel, you can easily scale your objects to the desired size.