How to Convert XLS to PRN Files

1. Use Microsoft Excel to open the XLS file you want to convert.
2. Select Print from the File menu. Do not use the Print button on the toolbar because the toolbar button will bypass the print dialog window.
3. In the Print dialog window check the Print to file checkbox. Normally this checkbox is off, in which case Excel would print to the printer. Click the OK button.
4. In the Print to File dialog window type the Output file name. This will be the name of your file on the disk. Excel does not automatically add the '.prn' to the file name so you must type that in yourself; it will still be a PRN file even if you don't give it the '.prn' extension. Click the OK button. You now see a dialog window that tells you that you are printing; when that window disappears the conversion is complete.

Read more ►

How to Add ActiveX Control in Excel 2007

1. Open the Microsoft Excel 2007 application from your computer and then click on the “Microsoft Office” button.
2. Click on the “Excel Options” button and then click on the box next to the “Show Developer tab in the Ribbon” field. Click on the “OK” button.
3. Click on the “Developer” tab and then click on the “Insert” option from the “Controls” group. Click on the “More Controls” option below the “ActiveX Controls” group.
4. Click on the ActiveX Control that you want to add from the list of controls in the More Controls dialog box.
5. Click the location on your worksheet where you want the ActiveX control to appear. The control will then appear in your worksheet.

Read more ►

How to Remove Duplicate Lines in Excel

Excel 2003
1. Open the Excel file that has the duplicate data that you need to remove.
2. Highlight the data that you want to work with, then right-click and select 'Copy.' Click on an empty cell on your worksheet, right-click and choose 'Paste.' This step creates a backup copy of all the data.
3. Highlight the original data again.
4. Click the 'Data' menu and then click 'Filter.' Scroll over and click 'Advanced Filter.'
5. Place the radio button next to 'Filter the list, in place' in the 'Advanced Filter' window. Put a check mark next to 'Unique records only.'
6. Click the 'OK' button.
7. Delete the backup copy of your data once you are satisfied with the filtered list.
Excel 2007
8. Open the Excel file with the duplicate data.
9. Highlight the data you want to work with, then right-click and select 'Copy.' Move to an empty cell, right-click and choose 'Paste.' This step creates a backup copy of all your original data.
10. Highlight the original data again.
11. Click to select the 'Data' tab. Click the 'Remove Duplicates' button.
12. Choose the rows from which you want duplicates removed. Click the 'OK' button, then 'OK' again in the information box that appears indicating how many duplicates Excel found.
13. Delete the backup copy of your data once you are satisfied with the filtered list.

Read more ►

How to Resize Cells in Excel 2007

1. Click on the cell(s) from the columns you want resized.
2. Click on the 'Home' ribbon, and then click 'Format' in the 'Cells' group.
3. Click the 'Width' option in the 'Cell Size' graph that appears.
4. Type the length you would like the cells to be in the box that appears.
5. Click 'OK' to resize the cells.

Read more ►

How to Password Protect Excel Worksheets

1. Go to 'Tools' on the main menu.
2. Select 'Options.'
3. Select the 'Security' tab.
4. Under 'File encryption options for this document,' enter the password in the field called 'Password to open' and click 'OK.'
5. In the Confirm Password window, enter the password in the field called 'Reenter password to open' and click 'OK.' In the Confirm Password window, Excel gives two cautionary notes: first, that a lost or forgotten password cannot be recovered; second, that passwords are case-sensitive. This means that a password such as 'abcd' is not the same as 'Abcd.'
6. Save the password by saving the document. To do this, click the 'Save' icon.
7. If you want to set a password so that only authorized personnel can modify the worksheet, go to 'Tools' on the main menu, select 'Options,' select the 'Security' tab, and under 'File sharing options for this document,' enter the password in the 'Password to modify' field and click 'OK.'
8. Notify authorized personnel of the password required to open and/or modify the worksheet.

Read more ►

How to Make Excel 2007 Your Default Program

1. Hold the Windows orb key, and press 'R' to open the 'Run' dialog window.
2. Type the exact phrase in the Run dialog window, including quotation marks:'C:\Program Files\Microsoft Office\Office12\excel.exe' /regserverIf you installed Excel 2007 in a different folder, adjust the path accordingly. If you are using a 64-bit version of Windows 7, change 'Program Files' to 'Program Files (x86)'.
3. Click 'OK' to have Excel register itself as the default program.

Read more ►

How to Recover an Excel Work File That Wasn't Saved

File Never Saved
1. Reopen Excel.
2. Click on 'File' in the upper-left hand corner of the screen. Then click 'Recent.'
3. Select 'Recover Unsaved Workbooks.' This will display a list of any workbooks you worked on that were not saved.
4. Select your file you were working on. Excel will record the time that the file was last worked on, so you can tell which file is the one you want if the time is close to when you closed Excel without saving or Excel crashed.
5. Click 'Open.'
6. Click 'Save As' to save your file. You need to name the file and then click 'Save.'
Files Previously Saved
7. Open the document you were working on.
8. Click 'File' in the upper left-hand corner of the window.
9. Click 'Info.'
10. Under Versions, click the version labeled '(when I closed without saving)'.
11. Click 'Restore.'

Read more ►

How to Sort Alphabetically in Excel 2003

1. Enter your data into a column or row in Excel.
2. Click on the column letter on the top of the spreadsheet or the row number on the side of the spreadsheet that you want to alphabetize.
3. Click the button with an A on top of a Z near the top of the window if you want to sort from A to Z or click the button with a Z on top of an A if you want to sort from Z to A.

Read more ►

How to Save Print Settings in Excel 2007

1. Open Microsoft Excel from the Windows Start Menu by clicking 'Start' > 'Program Files' > 'Microsoft Excel'. The application will start in a new window.
2. Open your spreadsheet from the top pull-down menu. Click 'File' and 'Open...', and then select your spreadsheet file using the file browser window.
3. Select the cells you want to print by clicking and dragging your mouse on the spreadsheet to highlight the cells of your choice.
4. Open your Page Setup settings from the top menu by clicking 'File' > 'Page Setup...'. Adjust the margins and page orientation to fit what you are printing through your custom view.
5. Click on 'View' > 'Custom Views' from the top menu to open a new dialog box which will allow you to add a new custom view for printing. Click on the 'Add...' button in the Custom Views dialog box.
6. Type in the name you want to use for your new custom view in the 'Name:' text field. Keep the 'Print Settings' and 'Hidden Rows, Columns and Filter Settings' options selected and click the 'OK' button to add your new print view.
7. Click on 'Views' > 'Custom Views' again to list the created custom views in your document. To load the view, click the 'Show' button. When you print your document, the print settings that were saved with your custom view will be used.

Read more ►

How to Stop Excel Windows From Maximizing

1. Click 'Start' and open 'All Programs.'
2. Right-click on 'Microsoft Excel.'
3. Click 'Properties' and choose 'Shortcut.'
4. Open the 'Run' pull-down menu and click 'Minimized.'
5. Click 'Apply.' Click 'OK' to save your changes. Excel windows will now stay minimized.

Read more ►

How to Add Borders to Cells in Microsoft Excel 2007

1.
Select the cell or region of cells you would like to add borders to.
2.
Click on the 'Border' icon located on the Home tab of the Ribbon. The Ribbon is the group of icons and tools located directly above the work area.
3.
Select the style of border you would like applied to your selected cells.
4.
Select the cell or range of cells you would like to edit the formatting on. For example, you can change the color of a selected border.

Read more ►

How to Compress Pictures in Excel

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.

Read more ►

How to Change Text to Uppercase in Excel 2007

1. Insert a blank column to the left of the column with cells that need to be converted to uppercase text by right-clicking on the column-header of the source cells and choosing 'Insert' from the shortcut menu that appears.
2. Use the UPPER function to convert the text by clicking in the first cell of the new column and typing the following formula: =UPPER(A1) where A1 is the cell reference of the first cell with lowercase text. Use your keyboard to hit the Shift Enter keys. You will see the result of the formula while staying in the active cell.
3. Fill the formula down to all additional cells in the new column as needed to convert lowercase text from the source column. To fill down easily, position the mouse over the bottom right-hand corner of the current cell, and when the solid, black cross-pointer appears, click and drag the mouse downward. You should now have a new column of uppercase text.
4. Delete the old column of lowercase text by right-clicking on the column header and choosing 'Delete' from the shortcut menu that appears. If this is not convenient because of your spreadsheet's layout, then copy the cell containing the first UPPER formula and then right-click on top of the first lowercase cell, choose 'Paste Special' from the shortcut menu and then choose the 'Values' option and click the 'OK' button.
5. Fill down the formula to the rest of the lowercase cells as needed. This option will overwrite any cells in the range which happen to contain a formula.

Read more ►

How to Edit Macros in Excel

1. Open an existing spreadsheet or workbook in Excel that has at least one macro already created. Go to the 'Tools' menu bar and select 'Macro' and then 'Macros.'
2. Type the name of the macro you wish to edit into the 'Macro Name' box. Click on the desired macro if multiple appear.
3. Click the 'Edit' button. The Visual Basic editor will be displayed in a separate window with the code for that macro displayed.
4. Make the desired changes to the macro. Leave the first line starting with 'Sub' and the last line should remain 'End Sub.'
5. Close the box with the edited information. The changes are saved automatically. Test the macro changes by going back to the spreadsheet you wish to use it on, and highlighting the cells it is to be used on.
6. Select 'Tools', then 'Macro' and 'Macros.' Choose the macro you just edited and click the 'Run' button. Save the spreadsheet again to save the changes to the macro.

Read more ►

How to Remove Recent Documents From Excel 2007

1. Click 'Start,' 'All Programs,' 'Microsoft Office' and then select 'Microsoft Office Excel 2007.'
2. Click the 'Office' button in the upper left corner of the screen and select 'Excel Options' at the bottom of the window.
3. Select 'Advanced' from the column on the left side of the 'Excel Options' window.
4. Scroll to the 'Display' section and then adjust the number to '0' next to 'Show This Number of Recent Documents.'
5. Click 'OK' to close the window and apply your changes.

Read more ►