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 data from the original unfiltered data set is ignored. You are now ready to copy.
5. Press the Control-C keyboard combination to copy the data. Alternately, select the 'Copy' button on the Excel toolbar.
6. Click on the spreadsheet, file, or other document where you wish to paste the filtered data.
7. Press the Control-V keyboard combination to paste. The filtered data is pasted into the new file.

Read more ►

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 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 2003
6. 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 box.

Read more ►

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

Read more ►

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 title) in column B. To select it, left-click on the title, and drag the mouse to the bottom of the list.
6. Click the 'Insert' ribbon.
7. Click the 'Column' button in the Charts section of the Insert ribbon.
8. Click the first icon on the top left of the Column drop-down. It looks like a flat bar graph.

Read more ►

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 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 'OK.'
5. Select 'Format,' 'Row' and 'Height' from the toolbar. Type '20' into the 'Row Height' dialog box and click 'OK.'
6. Select 'Format,' 'Column' and 'Width' from the toolbar. Type '4' into the 'Column Width' dialog box and click 'OK.' The selected cells should now be square.
7. Select the 'Border' button from the 'Formatting' toolbar. Choose 'All Borders' to create a border around each selected cell.
Adding Content
8. Place your cursor in the cell where you want to add a number. Type in the number you want. Then press 'Enter' or use your arrow keys to move to the another cell in the crossword.
9. Insert additional numbers into the desired cells until they are all in.
10. Select any cells within the crossword puzzle that you want to shade (areas where letters/words will not be entered when printed). To select multiple cells at the same time, hold down the 'ctrl' key on your keyboard as you select each cell.
11. Click on the arrow beside the 'Fill (Color)' button in the 'Formatting' toolbar and choose black. The selected areas will be shaded.
Inserting the Clues
12. Place your cursor outside the crossword puzzle (below it) to insert the clues for the crossword puzzle. Type in 'ACROSS' and bold the text by using the 'Bold' button in the 'Formatting' toolbar. Then press 'Enter.'
13. Type in the number '1' and your first clue for the 'ACROSS' category and press 'Enter.' Continue typing in all of the other clues until you are finished.
14. Next to the Across clues, enter the Down clues in a different column. Type in the word 'DOWN' and bold it. Then press 'Enter.'
15. Type in each number and clue for the 'DOWN' category, pressing 'Enter' after each one. Continue typing in other numbers and clues until they are complete.
16. Save your work by selecting 'File' and 'Save' from the toolbar. Name your crossword puzzle file and click 'Save.'

Read more ►

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 in the second worksheet, click or type cell 'A2.' Follow that with an operator. For example:=SUM(A2
5. Click a different worksheet tab at the bottom of the Excel application window. Click the cell you want to add to the formula next or type the cell address. Excel will insert the name of the worksheet you are referencing along with the cell number. For example:=SUM(A2 Sheet2!A2
6. Type a closing parenthesis when you are finished building the formula and press 'Enter.' Excel will return you to the original worksheet. Your complete formula might look like this:=SUM(A2 Sheet2!A2)

Read more ►

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 the 'Next' button on the first screen of wizard.
4. Click the small box next to the 'Range' field and the wizard will minimize. Select the data that you want to include in the PivotTable. Click the top-left cell of your desired data range, then hold down 'Shift' and click the bottom-right cell. Don't include any subtotal cells on the bottom or the right side of the data area. Click the small box again to bring the wizard back up, and choose 'Next.'
5. Choose between placing the PivotTable on a new worksheet, or an existing worksheet. If you choose to use an existing worksheet, you will have to select the cell where you want the PivotTable to start. The table will expand down and to the right of your selected cell. Click 'Finish' to complete the wizard and create your PivotTable. You will see an empty PivotTable along with a field list that contains the names of all your column headers.
6. Click an item in the field list, then drag and drop it to one of the four areas of the PivotTable. The first area sits just above the actual PivotTable and acts as a global filter for the data in the table. Then, there are the two areas that make up the rows and columns of the PivotTable. Finally, there is a large area in the middle of the PivotTable that comprises the main data for the table. Each area can have multiple fields, as they will just stack onto one another automatically.
7. Rearrange the PivotTable by clicking the name of the field in the PivotTable and dragging that name to a different area. You can also drag and drop the field name off the PivotTable to remove it.
8. Click the arrows next to any of the field names on the PivotTable to filter the report. Remove check marks from any item you want to remove from the table, or add check marks to bring any item back onto the table. By using this feature on the page field area above the PivotTable, you can filter the entire table based on the elements in this list.
9. Double-click any data or subtotal cell in the PivotTable to see a list of all the source data that Excel used to create that number. The list will appear on a new worksheet that Excel adds to the workbook.

Read more ►

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 calendar in Excel. Click the 'Finish' tab at the bottom of the screen to share the calendar with Excel.

Read more ►

How to Use the Pivot Table Wizard in Excel

1. Start Excel and open the workbook file where you want to create the pivot table.
2. Format your data as straight lists of values. For example, you might have month, type of product, salesperson, or income.
3. Select the data you want in the pivot table.
4. Open the Data menu and select Pivot Table and Pivot Chart Report.
5. Click the radio button in the first section for 'Microsoft Excel list.'
6. Decide if you want just a table for your data, or if you also want charts. Then Click Next.
7. Verify that the range of cells you selected is listed in the Range field.
8. Click Next.
9. Decide whether you want the pivot table in a new or existing worksheet, then click Finish.

Read more ►

How to Turn on Worksheet Gridlines Row Headings Using VBA in Excel 2003

1. Launch Office Excel 2003, click the “Tools” menu, click “Macro” and click “Visual Basic Editor” window. Click the “Tools” menu and click “Project Explorer.”
2. Click “ThisWorkbook module” and copy and paste the following code to hide the gridlines and headings:Private Sub hideGridLines()
ActiveWindow.DisplayGridlines = False
ActiveWindow.DisplayHeadings = False
End Sub
3. Press “F5” to run the procedure.
4. Copy and paste the following code to your module to show the gridlines and headings:Private Sub showGridLines()
ActiveWindow.DisplayGridlines = True
ActiveWindow.DisplayHeadings = True
End Sub
5. Press “F5” to run the procedure.

Read more ►

How to Open an MS Excel File Without Excel

1. Locate the Excel file you would like to open on your computer. It may be on your desktop, in a folder or in a portable disk drive. The file extension (portion of the file name after the period) will be '.xls' for spreadsheets created in Excel 2003 and earlier versions. For Excel 2007 and later spreadsheets, the extension will be '.xlsx.'
2. Right-click on the file name if you use a PC or press 'Ctrl' and click on the file name if you use a Mac. This will cause a menu, known as a context menu, to pop up with options.
3. Select 'Open with...' from the context menu. This will open a list of programs you can use to view the spreadsheet. In some versions of Windows, you may need to click 'Choose default program' to get the list of programs.
4. Find the recommended programs at the top of the list. If you have any other spreadsheet programs on your computer, they should be listed here. Microsoft Works, Apple's Numbers, Lotus 1-2-3 and OpenOffice Calc can all open Excel spreadsheets, although you may lose some formatting. If you have any of these programs, just click the program name and the computer will open the spreadsheet in that application.
5. Click 'Cancel' if you do not have any spreadsheet programs on your computer, or if you try the recommended programs and they do not work.
6. Open an Internet browser, such as Internet Explorer, Safari or Chrome, and visit Microsoft.com to download the free Excel Viewer software. (A direct link is listed under this article's Resources section.) This software will allow you to open and view an Excel spreadsheet, but you will not be able to edit the data.

Read more ►

How to Rename a Worksheet in Excel 2003

1. On your computer, locate the folder that contains the worksheet you want to rename.
2. Right-click on the worksheet file name. This will summon a small pop-up menu with options.
3. Click the 'Rename' option. A small box will appear around the text.
4. Type in the new name for your Excel 2003 worksheet.
5. Click outside of the text box. This will save the new name.

Read more ►

How to Delete Comments in Excel 2007

Deleting Comments
1. Open the Excel workbook and worksheet containing the comment to be deleted.
2. Highlight the cells that contain comments you wish to delete. You may need to hold down the 'Ctrl' key while clicking if you are selecting several cells that are not adjacent to each other.
3. Left-click once on the 'edit' menu at the top of the screen. Then select 'Clear,' followed by 'Comments.'
Deleting All Comments
4. Open the workbook and worksheet containing the comments to be deleted.
5. Left-click on the 'Find Select' button at the top of the screen in the editing tool bar and choose 'Comments.'
6. Left-click 'Clear' and then 'Comments' in the 'Edit' tool bar.

Read more ►

How to Protect Cells From Modification in Excel 2003

1. Open Windows and pull up your Excel spreadsheet. You should be able to locate the program by using your 'Start' button. When you cannot find it there, use your 'Search' or 'Find' function.
2. Highlight the cells to be protected. Choose 'Cells' from the 'Format' menu. Select the 'Protection' tab. Check the box to the left of 'Locked'.
3. Go to 'Tools'. Hold the mouse on 'Protection'. Then click 'Protect Sheet'.
4. Enter a password if you want to use one. If you do not want a password, just click 'OK'.

Read more ►

How to Add a Background Color or Pattern to Cells in Excel 2003

1. Open Microsoft Excel on your computer. You should be able to locate the program by using the 'Start' button. If you can not find it there, use the 'Search' or 'Find' function, or just look for the icon on your desktop.
2. Highlight the cells that you want to emphasize. You can click and drag or click on each cell individually while holding down the 'Ctrl' button. Using the 'Ctrl' button and clicking will allow you to select non-adjacent cells.
3. Look for the tiny paint bucket icon on your tool bar. Use this icon to fill in a cell with a single color. Choose the color by hitting the down arrow on the right of the paint bucket. To select the last color you used or the default color, just click on the paint bucket icon. If you only need one color, you'll be done after clicking 'OK.'
4. Left-click on your cell selection to reveal a drop-down Formatting menu if you want to add a pattern.
5. Choose a color and then click on 'Add Pattern' to customize the color and pattern for the chosen cell(s). Then click 'OK.'
6. Repeat the above steps for all of the different color and pattern combinations that you need. When you want to remove a color or fill pattern, just highlight the cells, click the arrow next to the paint bucket icon and select 'No Fill.'

Read more ►