Pages - Menu

▼
Thursday, June 28, 2012

How to Round Up in Excel 2007

›
1. Open the spreadsheet that contains the data that you want to round up. 2. Right-click the column heading of the column directly to th...

How to Merge Cells With Different Formulas in Excel

›
Concatenate Function 1. Open the Excel file in which you want merge cells. 2. Right-click on the column header directly to the right of ...
Wednesday, June 27, 2012

How to Import Data From MS Word to MS Excel

›
1. Open the Microsoft Word document. Click the 'File' tab in Word 2010, 'Microsoft Office Button' in Word 2007 or 'Fil...
Tuesday, June 26, 2012

How to Use a ListView Control

›
1. Open Microsoft Excel. 2. Click 'Tools,' 'Macro' and then 'Visual Basic.' This will open the VBA editor. 3. ...

How to Use the BINOMDIST Function in Microsoft Excel

›
1. Start Microsoft Excel. You can do this by clicking on Start, highlighting Programs, and clicking Microsoft Excel, or double-clicking th...
Monday, June 25, 2012

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 grabbin...

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' but...
Sunday, June 24, 2012

How to Disable a Hyperlink Warning in Excel 2003

›
1. Click 'Start.' Select 'Programs' or 'All Programs' and click 'Run' in the 'Accessories' folder....

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...

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' folde...
Saturday, June 23, 2012

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 ...

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.' ...

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' opt...

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 'O...

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...