Pages - Menu

▼
Saturday, September 28, 2013

How to Unlock a Chart in Excel

›
1. Open Excel 2010 and the chart that is locked. 2. Click 'Unprotect Sheet,' which is located in the 'Changes' grouping ...

How to Do an OHLC Chart in Excel

›
1. Open the Excel worksheet. 2. Type the data with four series of values in this order: open, high, low and close. For example, row 1 ca...

How to Import XML to XL

›
Import XML Data as an External File 1. Open Microsoft Excel. Click on the 'Data' tab and locate the 'Get External Data' gr...
Friday, September 27, 2013

How to Change Default Colors in Excel

›
Adjust the Color in a Worksheet 1. Change the font color. Click on one cell to select it or click on the first cell in a group and drag th...
Thursday, September 26, 2013

How to Unsync Split Pane in Excel

›
1. Open the spreadsheet that has the split screens. 2. Click the 'Synchronous Scrolling' button in the 'Window' group on...

How to Replace Blank Cells With Value in Excel 2003

›
1. Select the range of cells that contain the blank cells you want to replace. Do this by clicking on the uppermost cell on the left side,...

How to Create a Pivot Table in Excel 2003

›
1. Create a spreadsheet in Excel with all of the data you want to place in your PivotTable. 2. Open a new a workbook for your PivotTable...

How to Use the Auto Filter in Microsoft Excel 2003

›
1. Highlight the cells and columns you wish to apply the auto filter to. Click and hold the mouse button in as you scroll the cursor over ...

How to Move the Excel 2007 Pivot Table Field List

›
1. Open the Microsoft Excel 2007 application on your computer. Click on the 'Microsoft Office' button and the select the 'Open...

How to Set Excel Macro Security to Medium

›
1. Open Microsoft Excel. Go to Start–Programs–Microsoft Office–Microsoft Office Excel. Please note that in some versions of Microsoft Of...
Wednesday, September 25, 2013

How to Restore MS Excel Toolbar

›
1. Access the toolbar setting in Microsoft Excel 2008 by going to the “View” menu and selecting “Customize Toolbars and Menus.” 2. Resto...

How to Copy an Excel Spreadsheet Into PowerPoint

›
Copy Entire Worksheet 1. Select the PowerPoint slide in which you want to insert the Excel worksheet. If the slide has multiple content bo...

How to Get a Percent of a Total on Microsoft Office Excel 2007

›
1. Use the SUM function to total the values of the cells you want to include in the total. For example, if you want to determine the total...

How to Make a Chart in Excel 2003

›
1. Open your workbook in Microsoft Excel 2003 and select the spreadsheet containing the data you want to chart. 2. Highlight the cells c...

Copy Pasting in Excel 2007 Freezes My Computer

›
Detect and Repair 1. Open a new document in Microsoft Excel 2007. 2. Click on the 'Help' tab on the program's task bar. In t...