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 on the command Ribbon.4. Click the 'Sort Filter' button in the 'Editing' group. A list of options appears.5. Click the 'Custom Sort' option. A dialog window opens. The categories include 'Column,' 'Sort On' and 'Order'6. Select or deselect the check box for 'My data has headers.'7. Click the arrow next to the 'Sort by' text box in the 'Column' category. Select the 'Column.'8. Click the arrow in the text box under 'Sort On.' Select the preferred option, such...
Browse » Home » All posts
Saturday, January 28, 2012
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 example, '1.875.' Press 'Enter.' The number should show up exactly as you entered it.3. Click the cell again and then click the 'Home' tab on the menu ribbon. Click the down arrow in the text formatting window in the 'Number' group. The text formatting window might display 'General' initially or something else. Click 'Fraction' from the drop-down list. The number displays as a fraction now.4. Add, subtract, multiply, divide or otherwise create any equation...
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 the column you want locked. This highlights the entire column. Highlight a group of columns by clicking on the first column and dragging the mouse, with the left button depressed, across the desired columns to highlight.3. Click on the 'View' tab if using Microsoft Excel 2007. Under the Window group item in the menu, click on the arrow for 'Freeze Panes.' Select the option to 'Freeze First Column' to lock only the one column highlighted. Select the option to...
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 type in 'Bin Range.'2. Click on cell 'A2' and type in the first value in your data set. Enter the rest of the data set into the cells down the first column.3. Select cell 'B2' and enter your bins down the second column. Each actual bin number will stand for the top value in that bin's range. So, if you enter bins of '20,' '40' and '60,' the ranges will be anything below 20, 21 to 40, and 41 to 60, respectively. Excel will automatically add an additional bin called 'More,' which...
How to Unlock an Excel Workbook
1. Open the Excel workbook you want to unlock.2. Select 'Tools,' 'Protection' and 'Unlock Workbook' from the toolbar. If you added a password initially (when you locked the file), you will be prompted to type it in. Click on 'OK' in the 'Unprotect Workbook' box. The workbook will be unlocked.3. Select 'Tools,' 'Protection' and 'Unprotect Shared Workbook' from the toolbar to unlock a shared workbook. Enter the password into the 'Unprotect Sharing' box if you inserted one initially. Then click on 'OK.' Click on 'Yes' to remove the workbook's shared settings if you are prompted to.4. Select...
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 and change file properties from this menu.2. Click 'Edit' to view common options for performing Excel edits. This menu contains options that allow you to copy and paste data, find and replace text strings and delete cells or cell contents.3. Click 'View' to change the Excel 2003 display. You can use this menu to change the Excel toolbars, document headers and footers and change the screen view.4. Click 'Insert' to add something new to your document. You can...
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 to compare. In the new spreadsheet, make headers across the top: 'Original List,' 'Comparison List' and 'Missing?'2. Copy and paste the original list into the new spreadsheet. Move over a column and paste the comparison list into the spreadsheet.3. Move your cursor to cell C2, the first empty cell in the 'Missing?' column. Type the function into this cell. Type in '=isna(match(' then either click the first cell in the 'Comparison' list or type B2 (if that's the cell number)....
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 'F5' button on your computer keyboard, if you are using Excel 2007 or later. A pop-up window will appear. Alternately, you can click the 'Go To' button in the 'Find Select' section of the Excel toolbar. This step is not necessary for versions of Excel prior to 2007.3. Click the 'Special' button on the pop-up window.4. Click the 'Visible cells only' option, and press 'OK'. This instructs Excel to only select the data included in the filtered results. Hidden...
Friday, January 27, 2012
How to Copy a Microsoft Excel Sheet
Excel 20071. Click on the tab of the worksheet you want to copy.2. Right-click with your mouse on the tab, then choose 'Move or Copy.'3. Select where you want the worksheet to go. Use the drop-down menu to select a workbook.4. Click on the check box next to 'Create a Copy.'5. Click on 'OK.'Excel 20036. Open the worksheet you want to copy.7. Click on 'Edit,' then click on 'Move or Copy worksheet.'8. Click on 'Create a Copy' in the dialog option b...
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 cell that contains the number you want to display in the currency format.3. Click 'Cells' on the 'Format menu.'4. Click 'Currency' in the 'Category' box on the 'Number' tab.5. Click the currency symbol you choose in the 'Symbol' list.6. Enter the number of decimal places that you want to display in the 'Decimal Places.'7. Select the display style for negative numbers in the 'Negative Numbers'.8. Click 'File' and then click 'Save' to apply the change to your Excel spr...
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 each histogram bucket in column A, under the word 'Bins.' For example, in cell A2 begin with '0.2,' and continue down the column with increasingly large numbers.4. Enter the number of data items that belong in each given bin in column B, under the word 'Frequencies.' For example, if the first two bins are 0.2 and 0.3, and there are 12 data items that fall between the values 0.2 and 0.3, then type '12' to the right of 0.2 in column B.5. Select all the data (including the header...
How to Design a Crossword Puzzle With Excel 2003
Designing the Crossword Puzzle1. Open a new document in Microsoft Excel 2003.2. Select the area of your spreadsheet where the crossword puzzle will go. (Make sure to keep this same area highlighted throughout all of the steps in this first section.) Then right-click over the selected area and choose 'Format Cells' from the pop-up list.3. Select the 'Alignment' tab. Then choose 'Right Indent' for the horizontal text alignment and 'Top' for the vertical text alignment.4. Select the 'Font' tab. Then pick 'Arial' for the font, '10' for the font size and 'Superscript' for the effects and click...
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 the worksheet in which you want to enter a formula.3. Click an empty cell to insert a formula. Type an equal sign, an Excel function and an open parenthesis to begin building your formula. For example, if you want to add numbers from different worksheets, enter:=SUM(4. Enter a cell number or another function from the current worksheet you want to work with. For example, if you are adding a number from cell A2 in the first worksheet to a number in cell A2...
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 you do not have a header row, you can right-click the number on the left side of your data's top row and choose 'Insert' from the pop-up menu. Type headers for each column into the new row. You also need to remove any subtotal cells from the middle of the data field, as the PivotTable can't handle these types of cells.3. Click the 'Data' menu at the top of the screen and choose 'PivotTable and PivotChart Report.' This launches the PivotTable wizard. Select...
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 'Import and Export' from the subsequent menu. Select 'Export to a file' from the next page and click the 'Next' tab at the bottom of the window.2. Select 'Microsoft Excel' from the list of programs and click the 'Next' button. Select the 'Calendar' folder from the list of options on the next page and click the 'Next' button at the bottom of the screen.3. Select a name for the calendar file and type it into the text box. This will be the name of the file used for the...
Subscribe to:
Posts (Atom)