Microsoft Excel Viewer

I guess you could try there steps to edit this excel spreadsheet since you don't have office excel. One is copy excel from autocad to openoffice.org, then edit excel in your openoffice, finally, copy it back to autocad.

Step 1. copy excel from autocad

1. Open that dwg file in autocad. Select the object using whichever method best suits.
2. Right click your mouse after the objects are selected. A contextual sub menu will appear. Select "Clipboard" and "Paste" and the object will be placed on the clipboard.

Step 2. import to openoffice

1. Open an OpenOffice database file. Click on the "Tables" icon on the left-side navigation pane to go to the "Tables" view. Select "Edit" from the menu bar then select "Paste." The "Copy Table" dialog will appear. Enter a name for the table in the "Table Name" field. In the Options section, make sure "Definition and Data" is selected. If the data you selected in the spreadsheet has column names at the top, be sure to check the "Use first line as column names" check box. This will copy the column headers into the field names of the new table.
2. Click the "Next" button to go to the "Apply Columns" dialog box. This dialog lets you select which columns of the copied data you want to create in the new database table. In most case, you will want to click the ">>" button to select all columns. If you want to copy over only selected columns, click the column name on the left side then click the ">" button to move it to the right side of the dialog. When you have selected all the columns you want, click "Create." You may be asked if you want to create a primary key for the table. Click "Yes" unless you want to use one of the existing columns as the primary key.

Step 3. after editing, paste it back to autocad.

hope it works. If you find one solution, please share it here. Thanks.

1. Start Microsoft Excel and open an existing spreadsheet that contains range names that you would like to manage, filter, edit, delete or create additional range names.

2. Choose the "Formulas" tab to display the "Formulas" ribbon. Click the "Name Manager" button to open the "Name Manager" dialog box.

3. Click the "New" button in the "Name Manager" dialog box to open the "New Name" dialog box. In this dialog box, you can provide a name, scope, comment, and cell reference for the new range name that you create.

4. Select a range name you would like to edit from the "Name Manager" list and click "Edit" to open the "Edit Name" dialog box. Here you can rename the range, change the scope, edit the comment or change the cell reference.

5. Identify a range name you would like to delete from the "Name Manager" list and click the "Delete" button. A dialog box will come up and ask you to confirm that you want to delete the name range. Click the "OK" button to delete the name range from the "Name Manager" dialog box.

6. Highlight and click the "Filter" button on the top right of the "Name Manager" dialog box to display the filter options available for the name manager. You can filter to find range names that are located in the current workbook, that are located in the current worksheet, that have errors, that don't have any errors, defined names and table names.

7. Complete the process by clicking on the "Close" button. This will close the "Name Manager" dialog box after you have finished managing the range names.

1. Start Microsoft Excel 2007 and open an existing workbook that contains range names that you would like to use in a formula.

2. Click on the cell where you would like to enter a formula using one of the range names you have already identified.

3. Begin typing the formula you want to use inside of the cell until you come to the part of the formula that requires you to reference a group of cells that you have created a range name for.

4. Choose the "Formulas" tab to display the "Formulas" ribbon. Click the "Use in Formula" drop-down list button in the "Defined Names" category. You will see the range names that you have defined in your current Excel workbook.

5. Select the range name that you would like to use in the formula you are typing. The range name will be inserted into the formula you are typing.

6. Continue typing the rest of your formula. Press the "Enter" key when you are finished to enter the formula into Excel. The result of your calculation will now be displayed.

1. Start Microsoft Excel 2007 and open an existing workbook that contains a chart that you would like to change the display of the axes.

2. Click the chart that you want to change the display of the axes so it is selected. The chart will have a light blue border surrounding it, indicating that it is selected.

3. Choose the "Axes" button in the "Axes" section of the "Layout" ribbon. A drop-down menu will appear.

4. Point to "Primary Horizontal Axis" to view the options for changing the display of the primary horizontal axes. The display options for your primary horizontal axis will be displayed in a menu. Click on the title and description that you want to apply to your primary horizontal axis.

5. Select the "Axes" button in the "Layout" ribbon once again and point to "Primary Vertical Axis." Click on a title and description for the display option you want to apply your primary vertical access.

1. Open Microsoft Excel 2007, and start a new, blank spreadsheet or open an existing spreadsheet from your files into which you want to generate a random number.

2. Click the cell you want to generate a random number into so it is selected. The cell will have a thick black line outlining it.

3. Type "=RAND()" (no quotations) into the "Formula" text box near the top of the Excel screen. This is the function that instructs Excel to enter a random number between 0 and 1 into the selected cell.

4. Press the "Enter" key on your keyboard. The random number will be generated into the selected cell and you will be taken to the cell beneath it.

5. Continue the process of generating random numbers into your Excel cells using the same method as outlined above.

1. Start Microsoft Excel 2007, and open an existing spreadsheet from your files or create a new blank spreadsheet into which you want to generate a random number within a range that you designate.

2. Select the cell or multiple cells that you want to generate the random number into. You can use the SHIFT or CTRL keys on your keyboard to select multiple cells at the same time. The cells that random numbers will be generated into will be outlined by a black heavy line.

3. Type "=RANDBETWEEN" (no quotes) into the "Formula" textbox near the top of the Excel screen.

4. Continue to type the rest of the function that specifies the range you want the random numbers to fall into. "([Bottom],[Top])" (no quotes) should be inserted after "=RANDBETWEEN" (no quotes) with numbers replacing the word "Bottom" and "Top." The "Bottom" number should be the lowest random number you want to be generated ant the "Top" number should be the highest number you want to be generated.

5. Press the "Enter" key on your keyboard if you selected one cell or the "CTRL+ENTER" if you have selected multiple cells. You will now see random numbers have been generated in the range that you have specified.

1. Start Microsoft Excel 2007 and open a workbook from your files that contains data you want to use to get a random sample.

2. Verify that column A is empty, so you can use it to generate random numbers into. If you have data in column A, then you will need to add a number column so column A becomes empty and can be used to store the random numbers.

3. Click and drag to select the cells in column A that correspond with the records in the other cells. You want to select an empty cell for each row of information you have in the spreadsheet.

4. Type "=RAND()" (no quotes) in the "Formula" textbox. Press the "Enter" key on your keyboard to generate the random numbers into column A.

5. Select all of the data in your spreadsheet along with the corresponding random numbers. Do not select any titles or headings.

6. Use the "Data" tab at the top of the screen and click the "Sort" button from the "Sort and Filter" group in the "Data" ribbon. The "Sort" dialog box will open onto the screen.

7. Choose "Column A" from the "Sort by Column" drop-down list and "Smallest to Largest" from the "Sort by Order" drop-down list. Click the "OK" button to close the dialog box and return to your spreadsheet. Choose the top number of rows to make up your random sample.

1. Start Microsoft Excel 2007, and open an existing workbook from your files in which you want to insert a static time into one of the cells. Alternatively, you can start a new, blank workbook to insert the static time.

2. Select the cell in the workbook you want to insert the static time into by clicking on it. The selected cell will now have a thick black box around it, indicating that it is selected and ready for the next step.

3. Hold down the "Ctrl," "Shift" and ":" keys at the same time on the keyboard. This keyboard shortcut will instruct Excel to enter a static time into the selected cell.

4. Look at the cell, and see the current time to be inserted into the selected cell. This time will not change at any point unless you manually change it yourself. It will not update on its own at any time.

5. Insert the static time into any other cells in the open Excel workbook using the same procedure that is outlined in the previous steps.

1. Open Microsoft Excel 2007 and start a new workbook and insert at least one picture into it, or open an existing workbook from your files that contains at least one picture you would like to compress.

2. Click to select the picture that you want to compress. After you have clicked the picture it will be surrounded by white sizing handles indicating that it is selected.

3. Choose the "Format" tab at the top of the screen to display the Format ribbon. The Format ribbon contains all the commands you can use to format a picture in Excel.

4. Select the "Compress Pictures" button in the "Adjust" section of the Format ribbon. The "Compress Pictures" dialog box will open.

5. Click to add a checkmark so you compress only the selected pictures and click the "Options" button in the "Compress Pictures" dialog box. The "Compression Settings" dialog box will open.

6. Choose your compression options and target output for the selected picture in the "Compression Settings" dialog box. You can choose for the compression to occur on saved and for any cropped areas of the picture to be deleted. You can also choose to for the picture to compress depending on whether you intend to print it, view it in Excel or email it. Click the "OK" button after you have made your selections to close the dialog box.

7. Click "OK" to close the "Compress Pictures" dialog box and compress the selected picture.

1. Start Microsoft Excel 2007, and open an existing workbook from your files that contains at least one picture that you want to replace.

2. Click to select the picture that you want to replace. You will see white sizing handles surrounding the picture, indicating that it is selected and ready to be replaced.

3. Choose the pink "Format" tab at the top of the Excel screen to display the Format ribbon. The Format ribbon contains all the commands that can be used to format a picture in Excel.

4. Click the "Change Picture" button from the "Adjust" section of the Format ribbon. The "Insert Picture" dialog box will open.

5. Use the "Look in" drop-down list and large white area in the center of the "Insert Picture" dialog box to browse for a replacement picture. Click to select that picture and click the "Insert" button in the bottom right corner of the dialog box. The dialog box will close and the picture you selected from the workbook will be replaced with the picture you just chose.