How to Improve the Print Resolution of Excel Charts

File Prep
1. Finish drawing up your Microsoft Excel chart as you would normally.
2. Expand the size of the chart if necessary by grabbing a corner of the image with your mouse and dragging it outward.
3. Position the chart on the page exactly as you want it to look when it is printed. Confirm that the chart is positioned inside of the printable page by choosing 'Print Preview' from your menu.
Acrobat Method
4. Go to your Acrobat tab in Excel. Select 'Preferences' and then 'Advanced Settings' to check the resolution. If you are using Adobe's online PDF creation tool, called 'CreatePDF,' go to 'Set Options' and then 'Document Options' under your preferences. Select 'Print' as your desired profile. Click 'Edit Settings' and then 'Edit' once more to make changes to the resolution.
5. Assure that the resolution is set to at least 300 dpi (600 if you want a high-quality print).
6. Convert the file to PDF. Print your Excel chart from the PDF file to get a high-resolution print.
Photoshop Method
7. Install a postscript printer driver to your computer (see direct link in the Resources section).
8. Go to 'Print' on your Excel menu and find the postscript printer, which will likely be named 'General Postscript' or similar.
9. Click 'Properties' to the right of the printer name in your dialog box then 'Advanced.' Scroll down to 'Document Options' and click the plus sign beside 'PostScript Options.' Under 'PostScript Output Option' change the selection to 'Encapsulated PostScript (EPS).'
10. Press 'OK' to go back to the main print dialog box and select 'Print.' Save the file in a name that you will remember with the extension '.eps' at the end. (To find the file you may have to do a search of your computer files and folders.)
11. Open the EPS file in Adobe Photoshop. You will be prompted to enter the desired resolution before the file is opened. Set it to a minimum of 300 dpi and then open the file.
12. Save the file as either a PDF or TIF file in CMYK format (go to 'Image' and then 'Mode,' and choose 'CMYK Color' on the Photoshop menu). Print the Excel chart from Photoshop or another image-editing program.

Read more ►

How to Sort a Row or Column in Excel 2003

1. Open your Excel worksheet after logging on to your computer. 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. Click on any cell within the range of cells you would like to sort. Go to 'Data'. Select 'Sort' from the appearing menu.
3. Choose 'Options'.
4. Select 'Sort Left to Right' from the displayed 'Orientation' menu. Choose 'OK'.
5. Select the rows to sort from the 'Sort By' and 'Then By' boxes. Sort one column without affecting others by clicking the column heading of the column to sort.
6. Choose 'Sort Ascending' or 'Sort Descending'. A 'Sort Warning' will be displayed.
7. Select 'Continue with the Current Selection'. Then click 'Sort'.

Read more ►

How to Disable a Hyperlink Warning in Excel 2003

1. Click 'Start.' Select 'Programs' or 'All Programs' and click 'Run' in the 'Accessories' folder. The 'Run' pop-up dialog window will open.
2. Type 'regedit' in the 'Run' dialog box and click 'OK.' The 'Registry Editor' will open.
3. Navigate to 'Hkey_Current_User >Software >Microsoft >Office >11.0 >Common.' Click 'Edit' at the top of of the 'Registry Editor' window and select 'New,' then 'Key.'
4. Type 'Security' in the 'New Folder' field and press 'Enter.' Click 'Edit' at the top of of the 'Registry Editor' window and select 'New,' then 'DWORD Value.'
5. Type 'DisableHyperlinkWarning' in the 'DWORD' name field. Right-click 'DisableHyperlinkWarning' and click 'Modify' from the pop-up menu. Select the 'Decimal' radio button in the 'Edit DWORD Value' dialog box
6. Type '1' in the data value field. Click 'OK.'

Read more ►

How to Calculate PMT in Excel

1. Open Excel 2010, and click the 'fx' button on the formula bar. Type 'PMT' to locate the PMT function. Press 'Enter' on the keyboard. Click the 'PMT' function.
2. Add the variables to the PMT function. Enter the current interest rate for the loan in the 'Rate' section. Enter the number of payments in the 'Nper' section.
3. Enter the present value of the loan in the 'PV' section. Click 'Ok' to see the loan payment appear in the Excel worksheet.

Read more ►

How to Set a Default Format for Excel Charts

1. Open Microsoft Excel by opening the 'Start' menu, clicking 'All Programs,' opening the 'Microsoft Office' folder and then clicking on the Microsoft Excel icon.
2. Click the tab labeled 'Insert' at the top of the Microsoft Excel window.
3. Click the 'Create Chart' button on the bottom-right of the 'Charts' section on the Insert tab, below 'Other Charts.'
4. Select the chart type that you would like to use from the preset templates.
5. Click 'Set As Default Chart' to set the selected chart as the default format of all created charts. Click 'OK' to save your changes and to exit the window.

Read more ►

How to Use Excel for Project Timelines

1. Open the Excel worksheet.
2. Click the 'Insert' tab on the command ribbon.
3. Click the 'SmartArt' button in the 'Illustrations' group. A dialog box with a list of commands and timeline diagrams appears.
4. Click 'Process' in the list.
5. Click the preferred timeline diagram.
6. Click 'OK.' A 'SmartArt Tools' ribbon appears. The timeline template appears on the worksheet.
7. Type the text in the '[Text]' area. A text pane appears to the side. If the text pane does not display, click the left-arrow control on the side of the timeline to open. The text box can display dates, events or other project news for your timeline.
8. Click the 'Design' or 'Format' tabs on the ribbon for more options, such as changing the layout or color. For example, the timeline can appear at an angle when you click the 'Bird's Eye Scene' button in the 'SmartArt Styles' group in the 'Design' tab.
9. Move or re-size the template by pulling on the frame handles.

Read more ►

How to Record a Macro in Excel 2003

1. Open Excel. Either open the program itself or open an existing file.
2. Set your security level. Go to 'Tools > Options.' Go to the Security tab and click on 'Macro Security.' Go to the Security Level tab and change the level to medium or low.
3. Go to 'Tools > Macro.' Choose 'Record New Macro' from the options.
4. Type a name into the macro name box.
5. Type the location of the macro into the box labeled 'Store Macros In.' Click 'OK.'
6. You are ready to begin recording your macro. Perform the series of tasks you would like to create the macro for.
7. When you are finished, click 'Stop Recording' on the toolbar. You may make as many macros as you need.

Read more ►

How to Turn a Picture into a background or watermark

1. Open the MS Word program.
2. Click the 'Page Layout' tab on the command ribbon.
3. Click the 'Custom Watermark' option. A 'Printed Watermark' dialog box opens.
4. Select the 'Picture watermark' option. The 'Select Picture' button becomes accessible.
5. Select the 'Picture watermark' option. The 'Select Picture' button becomes accessible.
6. Click the 'Select Picture' button. The picture library file opens.
7. Select the picture file.
8. Click 'Insert.'
9. Select the scale value. For example, 50 percent.
10. Select the check box for 'Washout' if you prefer a very faint watermark effect.
11. Click 'OK.' The picture file becomes a watermark on the Word document.

Read more ►

How To Freeze All Top Cells In Excel 2003

1. Open your Excel spreadsheet. You can open a spreadsheet by double-clicking the XLS file on your computer, or you can open in the 'Open' dialog box when you click the 'Open' icon at the top of your window.
2. Click the row letter on the left of the spreadsheet to highlight the row you want to freeze. To highlight more than one row, hold the 'Ctrl' key and click each row letter with your mouse.
3. Click the 'Window' menu item. Click 'Freeze Panes' to freeze the rows. Scroll down the spreadsheet. Notice the rows you froze are always displayed at the top of your workspace.

Read more ►

How to Compare Multiple Groups of Cells in Excel

1. Open the Excel 2010 spreadsheet that holds the cell groups you want to compare.
2. Decide which group of cells will be the main group, which all other groups will be compared against.
3. Click the top left cell in the second group of cells. Hold the 'Shift' key and click the bottom right cell from that group. This will highlight the entire group of cells.
4. Click the 'Home' tab at the top of the screen, then click the 'Conditional Formatting' button and choose 'New Rule' from the drop-down menu.
5. Click 'Use a formula to determine which cells to format' at the top of the New Formatting Rule window. Enter the following into the 'Format values...' box:=not(a1=d1)Change 'a1' to the top left cell in your master group of cells and change 'd1' to the top left cell in the current selection. Click the 'Format' button in the lower right corner of the window, choose the 'Fill' tab and select a color that you want to use to highlight the differences in the groups. Click 'OK' when you are done. The differences in the second group will now appear highlighted.
6. Repeat this process for every group of cells that you want to compare against the original group.

Read more ►

How to Turn Anchor Text Into URL in Excel

1. Open Excel 2010. Click on one of the sheet tabs that appear at the bottom of the worksheet. Click into one of the cells and select the 'Insert' tab. Click 'Hyperlink.'
2. Select 'Existing File or Web Page' in the 'Link To' section.
3. Add the anchor text in the 'Text To Display' box. For example, if you are linking to cnn.com, enter 'CNN.' Type the web address in the 'Address' box. Click 'Ok' to save the changes. The hyperlink, or anchor text, appears in the Excel worksheet.

Read more ►

How to Remove Auto

1. Open Excel 2007, then open the document for which you want to remove the automatic publishing feature.
2. Click the round 'Microsoft Office' menu in the upper-left corner of Excel and select 'Save As.' Click the 'Save As Type' drop-down list and select 'Web Page' if the option isn't already selected. Click the 'Publish' button near the bottom of the dialog box to open the 'Publish As Web Page' dialog box.
3. Clear the box beside 'AutoRepublish Every Time This Document Is Saved' under 'Publish As' to disable automatic publishing for the open document. To disable the feature for other documents you previously published, click the 'Choose' drop-down list and select 'Previously Published Items.' Click the document's name under the menu and click the 'Remove' button.
4. Click the 'Close' button at the bottom of the dialog box, then press 'Ctrl' and 'S' to save your current document.

Read more ►

How to Turn off Filter Keys in Excel 2003

1. Click 'Start.' Click 'Control Panel.' Type 'access' into the Search box and press 'Enter.'
2. Click 'Change How Your Keyboard Works' from the results. Click 'Set up Filter Keys' from the Make It Easier to Type section.
3. Uncheck the 'Turn on Filter Keys' and 'Turn on Filter Keys When Right Shift Is Pressed for 8 Seconds' boxes.
4. Click 'Apply' to turn off Filter Keys for all applications, including Excel 2003. Click 'OK' to exit from Control Panel.

Read more ►

How to Make a Bar Graph Using Microsoft Excel 2003

1.
Label the data you want to graph in Microsoft Excel 2003. In Row 1, type the labels for each piece of data you plan to graph. For example, type “Month” in cell A1 and “Units” in cell B1.
2.
Enter the data that you want to graph. Microsoft Excel 2003 needs you to provide the data that will be included in the bar graph. Under the labels you have set up in each row, type the information you want to graph. For example, type the months of the year under the heading in Column A (“Jan” in A2), and the units under the heading in Column B to correspond with the months in Column A.
3. Open the chart wizard window. From the menu bar, select Insert>Chart.
4.
Select the type of bar graph you want to make. Under Chart Type, select 'Bar'. Then, click to select the particular type of bar graph you want to make under Chart sub-type. Click “Next.”
5.
Select the range for the data to be included in the bar graph. Microsoft Excel 2003 defaults to capture the data in the spreadsheet. If Microsoft Excel 2003 does not default to capture the data, then click and drag your mouse over the data to be included in the bar graph. Click “Next.”
6.
Define bar graph options. Microsoft Excel 2003 provides several tabs to define bar graph options, such as to define where to put the legend, what information should be tracked on which axis and what the title of the bar graph should be. Make your selections and then click “Next.”
7.
Define where to save the bar graph. The default is to save the bar graph in the current spreadsheet. Click the radio button for your choice and then click 'Finish'. The bar graph appears where you told Microsoft Excel 2003 to make it.
8. Change the text on the bar graph if needed. If you want to change the title or other text on the bar graph, click on the text you want to change and then type in your changes.

Read more ►

How to Change the Default Email in Excel 2003 Groupwise

1. Close the Microsoft Excel program if it is currently open or running.
2. Open the Start menu and click on 'Control Panel.'
3. Double-click on the 'Internet Options' icon.
4. Go to the 'Programs' tab at the top of the 'Internet Options' pop-up window.
5. Open the drop-down menu labeled 'Email' and choose 'Novell GroupWise' from the list of applications.
6. Hit the 'OK' or 'Apply' button to save the settings and change your default email client.
7. Relaunch Microsoft Excel and click on an email hyperlink to test the new settings.

Read more ►