Excel
Pages - Menu
(Move to ...)
Home
▼
Saturday, January 28, 2012
How to Create a Custom Sort in MS Excel
›
1. Open the Excel worksheet. 2. Click and drag to select the range of cells you wish to custom sort. 3. Click the 'Home' tab o...
How to Calculate Fractions in Excel 2007
›
1. Open the Excel spreadsheet you want to use to calculate fractions. 2. Click an empty cell and enter a number in decimal format, for e...
How to Lock Column Headers on Microsoft Excel
›
1. Open a worksheet in Microsoft Excel. Add row and column header text as desired. 2. Click on the column letter on the right side of th...
How to Make a Histogram From a List of Data in Excel
›
1. Open a new Microsoft Excel 2010 spreadsheet. Select cell 'A1' and type in 'Input Range.' Select cell 'B1' and t...
How to Unlock an Excel Workbook
›
1. Open the Excel workbook you want to unlock. 2. Select 'Tools,' 'Protection' and 'Unlock Workbook' from the to...
Excel 2003 Menu Bar Tutorial
›
1. Click 'File' to view options that are related to file operations. You can create new files, open files, save files, print files...
How to Compare Two Lists in Excel 2007
›
1. Open a new workbook (click the 'Office' button, 'New' and 'Blank Workbook') as well as the two lists you intend...
How to Copy Paste Filtered Data
›
1. Drag your mouse over the filtered data so it is highlighted. This identifies to the program which data you wish to copy. 2. Press the...
Friday, January 27, 2012
How to Copy a Microsoft Excel Sheet
›
Excel 2007 1. Click on the tab of the worksheet you want to copy. 2. Right-click with your mouse on the tab, then choose 'Move or Co...
How to Format Number Currency in Excel 2003
›
1. Click 'Start' in Windows, select 'Microsoft Office' and then click 'Microsoft Office cell 2003.' 2. Click the...
How to Draw a Histogram in Excel 2007
›
1. Type the word 'Bins' into cell A1. 2. Type the word 'Frequencies' into cell B1. 3. Enter the minimum values for eac...
How to Design a Crossword Puzzle With Excel 2003
›
Designing the Crossword Puzzle 1. Open a new document in Microsoft Excel 2003. 2. Select the area of your spreadsheet where the crosswor...
How to Use a Reference in a Different Worksheet in Excel
›
1. Open the Excel workbook with multiple worksheets that you want to use. 2. Click the tab at the bottom of the Excel window to select t...
How to Work With Pivot Tables in Excel 2003
›
1. Open the Excel 2003 file that contains the data you want to work with. 2. Ensure that each column of data has a header at the top. If...
Thursday, January 26, 2012
How to Export the Outlook Calendar to Excel
›
1. Open Microsoft Outlook and allow the main screen to fully load. Click on the 'File' menu at the top of the page and select ...
‹
›
Home
View web version