Pages - Menu

▼
Thursday, November 28, 2013

How to Make a Chart in the Same Sheet in VBA

›
1. Open Excel 2010 and show the Developer tab if it isn't already showing. Click on 'File' and then 'Options.' Click o...

How to Capitalize Everything in a Row in Microsoft Excel 2003

›
Capitalizing a Row of Cells 1. Start Microsoft Excel 2003, and open your spreadsheet. 2. Click the row number, not the cell, of the row ...

How to Add Buttons to an Excel Spreadsheet

›
1. Access the Button tool. In Excel 2003 and earlier versions, do this by clicking 'View,' 'Toolbars,' 'Forms' and...

How to Use Data Analysis for Random Number Generation in Excel

›
Activate the Data Analysis Tool Pack 1. Launch Excel from the 'Start' menu or shortcut icon. 2. Click on the Microsoft Office or...
Wednesday, November 27, 2013

How to Convert Office 2007 to Excel 2003

›
1. Open your Web browser, then go to the Microsoft Office Compatibility Pack download page. 2. Click the blue 'Download' button ...

How to Scroll on Microsoft Excel

›
Turning on Scroll Bars in Excel 2010 1. Open Microsoft Excel 2010. 2. Select 'Open' from the 'File' menu. 3. Navigate ...
Tuesday, November 26, 2013

How to Convert Corel Quattro Pro to Microsoft Excel

›
1. Click 'File,' then 'Open' in Microsoft Excel 2003 or earlier. In Microsoft Excel 2007, click the 'Office' butto...

How to Merge Center in Excel

›
1. Open Outlook by double-clicking on an Excel file. Alternatively, click 'Start,' then 'All Programs,' then 'Microsof...

How to Make Negative Numbers Red in Excel

›
1. Highlight the cells containing your data. Note that Excel allows you to apply special formatting for different types of numerical data,...

How to Create a Fillable Order Form

›
Microsoft Excel 2010 1. Open Excel 2010 and select the 'File' tab. Click 'New' and type 'order form' in the searc...

How to Take the Label 'Sum of' Out of a Pivot Table

›
1. Click on a cell in the PivotTable in the column from which you want to remove 'Sum of.' 2. Click the 'Options' tab on...
Monday, November 25, 2013

How to Use Excel's VARP Function

›
1. Learn the syntax of VARP. It is VARP(number1,number2,...) where number1, number2,... are up to 30 arguments which evaluate to numbers a...
Sunday, November 24, 2013

How to Extract Tables From Multiple Word Documents Import Them to Excel

›
1. Use Windows Explorer to copy a Word file containing at least one table to the folder 'C:\.' Rename the file as 'table.docx....

How to Create a Form in Microsoft Excel 2007

›
1. Launch Excel from the start menu or from the desktop. Click the small drop-down arrow at the very top of the screen, to the right of th...

How to Paste Special HTML in Microsoft Excel 2003

›
1. Create the desired HTML that you wish to paste special into Excel with. 2. Copy the HTML code. You can easily copy the HTML by highli...