How to Delete Comments in Excel 2007

Deleting Comments
1. Open the Excel workbook and worksheet containing the comment to be deleted.
2. Highlight the cells that contain comments you wish to delete. You may need to hold down the 'Ctrl' key while clicking if you are selecting several cells that are not adjacent to each other.
3. Left-click once on the 'edit' menu at the top of the screen. Then select 'Clear,' followed by 'Comments.'
Deleting All Comments
4. Open the workbook and worksheet containing the comments to be deleted.
5. Left-click on the 'Find Select' button at the top of the screen in the editing tool bar and choose 'Comments.'
6. Left-click 'Clear' and then 'Comments' in the 'Edit' tool bar.

Read more ►

How to Protect Cells From Modification in Excel 2003

1. Open Windows and pull up your Excel spreadsheet. You should be able to locate the program by using your 'Start' button. When you cannot find it there, use your 'Search' or 'Find' function.
2. Highlight the cells to be protected. Choose 'Cells' from the 'Format' menu. Select the 'Protection' tab. Check the box to the left of 'Locked'.
3. Go to 'Tools'. Hold the mouse on 'Protection'. Then click 'Protect Sheet'.
4. Enter a password if you want to use one. If you do not want a password, just click 'OK'.

Read more ►

How to Add a Background Color or Pattern to Cells in Excel 2003

1. Open Microsoft Excel on your computer. You should be able to locate the program by using the 'Start' button. If you can not find it there, use the 'Search' or 'Find' function, or just look for the icon on your desktop.
2. Highlight the cells that you want to emphasize. You can click and drag or click on each cell individually while holding down the 'Ctrl' button. Using the 'Ctrl' button and clicking will allow you to select non-adjacent cells.
3. Look for the tiny paint bucket icon on your tool bar. Use this icon to fill in a cell with a single color. Choose the color by hitting the down arrow on the right of the paint bucket. To select the last color you used or the default color, just click on the paint bucket icon. If you only need one color, you'll be done after clicking 'OK.'
4. Left-click on your cell selection to reveal a drop-down Formatting menu if you want to add a pattern.
5. Choose a color and then click on 'Add Pattern' to customize the color and pattern for the chosen cell(s). Then click 'OK.'
6. Repeat the above steps for all of the different color and pattern combinations that you need. When you want to remove a color or fill pattern, just highlight the cells, click the arrow next to the paint bucket icon and select 'No Fill.'

Read more ►

How to Have Excel Solver Give Only Whole Numbers

1. Go to the 'Data' tab in Excel, and click the 'Solver' button to launch the Solver dialogue box.
2. Click the 'Add' button under Constraints to launch the 'Add Constraints' dialogue box.
3. Enter the name of the cell in the 'Cell Reference' box, or highlight a range of cells with your cursor to fill this box automatically.
4. Click the drop-down menu in the middle of the 'Add Constraints' dialogue box, and select 'int' from the menu. The word 'integer' will appear in the Constraint box.
5. Click 'OK'

Read more ►

How to Make Columns Wider in Excel

Click Drag
1. Place your mouse pointer on the top row where the column letters are displayed.
2. Move the cursor over the lines separating the columns and notice that the cursor becomes a cross.
3. Place the cursor over the line to the right of the column that you want to make wider. Be sure that it turns into a cross before going to the next step.
4. Click and drag the column over until it is the width that you want.
Use the Toolbar
5. Go to 'Format.'
6. Select 'Column' and then 'Width.'
7. Enter the width that you want the column to be in the 'Column Width' box.
8. Click 'OK.' The column's width will change.

Read more ►

How to Get the Row Number of a Cell in VBA

1. Open the Visual Basic Editor (VBE) by clicking on the 'Developer' tab and then clicking on 'Visual Basic.'
2. Click on the 'Insert' tab and then click 'Module.' This opens a blank window.
3. Copy and paste the following code into the blank window:Sub myActiveRow()myRow=ActiveCell.RowMsgBox myRowEnd Sub
4. Press 'F5' to run the routine.

Read more ►

How to Create a Button in Excel 2007

1. Click the 'Microsoft Office' button located in the top left corner of Excel.
2. Click 'Excel Options' (a rectangular button on the bottom right of the panel).
3. Click the 'Customize' category from the selection list on the left. Select 'All Commands' from the 'Choose commands from' drop-down list. Scroll down the list to select the type of button you want to add to your Excel 2007 spreadsheet. For example, if you want to add a macro to a button, choose 'Option Button (Form Control)' and click 'OK.' This adds a button to the 'Quick Launch' toolbar (located above the ribbon).
4. Click the button on the Quick Launch toolbar. Left-click anywhere on the spreadsheet and drag the mouse to create a box.
5. Right click-on the button to format the button or assign a macro.

Read more ►

How to Print Continuing Row and Column Headings for an Excel Worksheet

1. Open Microsoft Excel and the file you want to change.
2. Open the File menu and select Page Setup.
3. Select the Sheet tab.
4. Enter the cell numbers you want to use as your row headings in the Row to Repeat box. Enter the first cell number for the heading, then a colon, then the last cell number. For example: B4:F4.
5. Enter the cell numbers you want to use for your column headings in the Columns to Repeat box. Enter the first cell number for the heading, then a colon, then the last cell number. For example: A1:A2.
6. Click Print Preview to see how your document will look.
7. Select Close to exit from the Print Preview function.
8. Click OK to accept your changes.

Read more ►

How to Convert XLSM to XLS

1. Open the 2007 version of Excel or later. Click “Open” in the “File” drop-down menu. Open the .XLSM file from the folder tree that opens up.
2. Click “Save As…” in the “File” drop-down menu. Select “Excel Workbook” as the format. Check the portability notes of the format at the bottom of the Save panel to confirm the format has adequate backward portability for your needs.
3. Convert the XLSM file using an older version of Excel the same way by first downloading the converter titled “Microsoft Office Compatibility Pack for 2007 Office Word, Excel and PowerPoint File Formats.” Before downloading the converter, it is important that you update your version of Microsoft Office to the latest service pack (see Resources).

Read more ►

How to Insert Charts in Microsoft Excel 2003

1. To create a chart, you first need to select the cells you wish to be contained within that chart. To do this, left-click and hold the mouse button, then drag the cursor over the groups of cells you wish to include. Then let go of the mouse button, and the cells will remain highlighted.
2. Access the chart tool. Scroll to the “Insert” tab on the command bar and select “Charts.”
3. Select the chart for your spreadsheet. A Charts Properties menu will open, in which you can select the style of the chart you want from a drop-down menu. Select the desired chart and click “Next” to continue.
4. In the next menu, you can specify the specific columns and rows to include in the chart. If you have already highlighted the cells and columns from Step 1, you can click “Next” to continue; otherwise, type in the series of charts and rows by entering their corresponding column letters and row numbers.
5. You can label the chart, name the fields and adjust the categories, gridlines and table information simply by selecting the corresponding tab and entering the required information into the fields. Click the “Next” button to continue after making the desired entries.
6. Select where to place the chart. Choose by selecting the corresponding radial button to place the chart in a new sheet or inside of the current sheet; after making your selection, click on the “Finish” button to implement your completed chart.

Read more ►

How to Change Security Settings in Excel 2010

1. Open Microsoft Excel 2010.
2. Click the 'File' tab menu.
3. Click 'Options' to open the 'Excel Options' window.
4. Click 'Trust Center' on the left side bar.
5. Click the 'Trust Center Settings' button under 'Microsoft Excel Trust Center.'
6. Click 'Add-ins' on the left side bar to disable add-ins or require them to be signed by trusted publisher.
7. Click 'ActiveX Settings' to enable, disable or prompt before enabling ActiveX.
8. Click 'Macro Settings' to enable or disable macros with or without notifications.
9. Click 'Protected View' to select options to enable when opening potentially dangerous files. With protected view, you can open unknown files in restricted mode, which disables unknown macros, ActiveX controls or add-ins.
10. Click 'File Block Settings' to choose which file types you want to block or file types you want to open in 'Protected View.'
11. Click 'OK' to close and accept all settings.

Read more ►

How to Paste Special With Word Documents in Microsoft Excel 2003

1. Open your Word document and copy the desired portions of text you wish to paste special into Excel.
2. Open your spreadsheet and scroll to the “Edit” tab on the command bar. Select “Paste Special.”
3. Select the options to paste special. Under the “As” menu, left-click on 'Microsoft Office Word Document Object,' which will paste the copied contents from the Word document into the spreadsheet as a movable object.
4. Left-click on the 'OK' button to paste the Word document into Excel as an object.

Read more ►

How to Disable Automatic Refresh on Office Excel 2003

1. Log onto your computer and open Microsoft Excel 2003. Open the spreadsheet you want to recalculate.
2. Click the 'Options' menu. Choose 'Tools' from the list.
3. Go to the 'Calculation' tab. Choose the 'Manual' calculation option. Click 'OK' when you are done.

Read more ►

How to Merge Workbooks in Excel 2003

1. Create a shared workbook by enabling the Track Changes option. Then send it out to others to make changes.
2. Find the copy of the workbook on which you will merge the changes. In Excel, go to 'File > Open' and find the file.
3. Click 'Tools > Compare' and 'Merge Workbooks.'
4. Look for the files you want to merge and add them into the current file.
5. Click 'OK' to merge the files. This is your master copy of this workbook.
6. Save the file.

Read more ►

How to Remove Duplicates in Excel 2003

1. Open Excel 2003 and copy your two (or more) columns of data into the spreadsheet.
2. Highlight the titles of the columns from which you want to remove the duplicates then click 'Data' and then click 'Filter.'
3. Click 'Advanced Filter' and then click 'OK' if necessary.
4. Click on the 'Copy to another location' option and then click 'Unique records only.'
5. Highlight the records that you want to remove the duplicates from, repeat this process when requested and then select an empty column in the 'Copy to' section.
6. Click 'OK' and your data set is copied into the column you indicated as the 'Copy to' column, excluding any duplicate values found in the data.

Read more ►