How to select non

1. Select your first cell by clicking your mouse button on it. The cell will now be shaded grey. If you want to select an entire row or column, click its heading (such as 'B' or '13') in the frame around the spreadsheet.
2. Hold the control key (command key on an Apple computer) and click the mouse button on another cell. Both cells will now be shaded grey. Any action, such as copy, will now apply to both cells. An unlimited number of cells can be selected as long as the control key is held down.
3. Re-click an already-selected cell with the control key pressed down to unselect it without affecting the selection of other cells. Letting go of the control key and clicking an unselected cell with select it and remove any existing selections from the clipboard.

Read more ►

How to Extract Information From Cells in Excel 2003

1. Open your Excel 2003 workbook file.
2. Highlight the cells from which you want to extract data. You can do this by either placing the cell in one corner of the block you want to work with, holding the 'Shift' key down and using the arrow keys to expand the block; or you can click and drag across the block.
3. Click 'Edit' and 'Copy' using the top menu. You have now extracted a copy of all the data in the cells including formulas, formatting and values (the actual numerical values that show on your spreadsheet).
4. Navigate to where you want to place and review the extracted information. Click 'Edit' and 'Paste Special' from the top menu.
5. Choose 'Values' from the pop up box to paste the numerical values of the extracted cells. This choice will ignore the formulas that produce the values.
6. Choose 'Formulas' to copy the formulas for each cell. This will ignore the values of each cell, and produce new values when you insert new data into the cells that apply to the formulas.
7. Choose 'Formats' to copy shading, borders and other formatting features from cells and ignore the contents of the cells.

Read more ►

How to Create a Drop

1. Create the list of selections that you want listed in the drop-down box. Select a tab other than the one on which the drop-down box will appear. Type each selection in an individual cell. The cells in which the selections are listed should be sequential. For example, selections 'A,' 'B' and 'C' would be listed in cells A1, A2 and A3. A list of selections may also be created in the same tab on which the drop-down box will be created.
2. Select the cell in which you want to create the drop-down box. Click the 'Data' tab and locate the 'Data Tools' group. Select the 'Data Validation' option. This action will open a separate dialog window.
3. Click the 'Settings' tab on the Data Validation window. Select the 'List' option from the 'Allow' menu. Click the 'In-Cell Drop-Down' check box.
4. Click the 'Source' field. Click the tab that contains the list of options you created in Step 1. Click once in the first cell of the selection string and drag to the last cell while holding down the mouse button. Click the 'OK' button on the Data Validation window.

Read more ►

How to Sort a Table in Word 2003

1. Open Microsoft Word 2003.
2. Create a table or modify an existing table. It should contain several columns with every cell filled.
3. Place your cursor inside the table and left-click anywhere on it.
4. Click 'Table,' and then 'Sort.' You may have to click the arrow to expand your options.
5. Choose a column heading to sort in the drop-down menu under 'Sort.'
6. Choose a type. 'Text' is for sorting alphabetically. With 'Number,' you sort by value. 'Date' lets you sort chronologically.
7. Choose ascending or descending. Ascending will arrange text from A to Z, numbers from least to greatest, and dates from earliest to latest. Descending does the opposite.
8. Choose 'Using,' and then select which fields or words you want to sort by.
9. Repeat steps 5 through 8 for 'Then by.' Do this if you only want to include more than one column as a basis for sorting.
10. Indicate whether you have a header column. Select 'Header row' to exclude the first row in sorting.

Read more ►

How to Switch to Manual Calculation in Excel

1. Open Microsoft Excel and start a new blank workbook or open an existing workbook from your files.
2. Choose the 'Formulas' tab to display the 'Formulas' ribbon at the top of the screen.
3. Click the 'Calculation Options' button in the 'Calculation' section of the 'Formulas' ribbon to view the drop-down list of options. Choose 'Manual' from the list of options to switch to manual calculation. This will tell Excel that you want to switch from automatic calculation to manual calculation.
4. Enter your formulas into your Excel workbook as usual. When you press the 'Enter' key after typing a formula, it will no longer automatically calculate your formula without you specifically instruction it to.
5. Select the 'Calculate Now' button in the 'Calculations' section of the 'Formulas' ribbon. Every formula that you have entered into the current Excel workbook will now be calculated.

Read more ►

How to Make a Calendar in Excel 2007

Add Calendar Control to Worksheet
1. Display the 'Developer' tab of the ribbon. Click the 'Office Button.' Click the 'Excel Options' button. Select the 'Show Developer Tab in the Ribbon' check box under 'Popular Options.' Click 'OK.'
2. Go to the 'Developer' tab. Click Insert and choose 'ActiveX Controls.'
3. Click 'More Controls' and select 'Calendar Control' in the 'More Controls' list. Click 'OK.' Excel inserts a calendar control in 'Design View,' which allows you to edit and customize the control.
4. Right-click the Calendar Control and click 'Calendar Object.' Select 'Properties' to open the 'Calendar Controls Properties' dialog box. Select options for the font, color and other aspects of the control. Click onto the worksheet when finished.
5. Click on the calendar control and click on the date you want to add to the worksheet. Excel automatically enters the date into the selected cell.
Make Printable Calendar from Template
6. Click the 'Office Button' and select 'New.'
7. Type 'calendar' into the 'Search Templates on Office Online' box. Press the 'Enter' key. A gallery of template options opens.
8. Select the calendar template you want to use. Click the 'Download' button. The calendar opens as a new Excel file.
9. Click inside of a date on the calendar to which you want to add a note or reminder. Type directly into the empty space on that date. Go to the 'Page Layout' tab. Click 'Themes.' Click the 'Colors' drop-down arrow to select a different color scheme. Select 'Fonts' to change the fonts on the calendar.
10. Click the 'Save' button on the 'Quick Access Toolbar,' enter a name for the calendar and click 'Save.' Print the calendar if desired.

Read more ►

How to Make a Drop

1. Open Excel and select a range of cells to which you want to apply the data validation. For example, select cells A1 through A10. With the cells selected, click the “Data” menu and choose “Validation.”
2. Change the Allow criteria to “List” in the validation criteria. In the Source field, add the values you want to see in the drop-down list. Enter the values separated by a comma only. Do not include spaces. For example, enter “Yes,No,Maybe” to see those three options in the drop-down list.
3. Modify the input message so other users see a friendly reminder telling them what you are looking for in these cells. Click on the “Input Message” tab. Make sure the “Show Input Message When Cell is Selected” option is checked. In the title field, add a title for your custom message. Type your custom message in the “Input Message” field.
4. Modify the error alert message so users see a error alert if they input the wrong type of information. Click on the “Error Alert” tab. Place a check mark in the “Show Error Alert After Invalid Data Is Entered” option. Change the style to “Stop” if you want the message to stop users from inputting invalid data. In the title field, add a title for your custom message. Type your custom message in the “Error Message” field. Click “OK.”
5. Test your data validation by clicking on cell A1. You will see a drop-down list appear with the options Yes, No and Maybe. You should see the input message you specified. Try typing in the word “PDF.” The custom error message will appear. The invalid value will not be retained and you will get the prompt to “Retry” and enter a correct value.

Read more ►

How to Wrap Text in Microsoft Excel 2003

1. Highlight the cells in which you want to wrap the text. If you want more than one cell, drag your cursor to the cells.
2. Find the 'Format' tab on the menu bar and click 'Cells.' Then click the 'Alignment' tab.
3. Click on 'Text control' and choose the 'Wrap text' option. Click 'OK.'

Read more ►

How to Print Two Excel Worksheets on Opposite Sides of a Paper

1. Click the 'Start' button in the bottom-left of the desktop. Click 'All Programs' and then click 'Microsoft Excel 2007' to launch the program.
2. Click the 'Microsoft Office Button' from the upper-left of the Excel program and then click 'Open.' Click the Excel workbook of choice and then click 'Open.'
3. Click the 'Microsoft Office Button,' and then select 'Print' from the drop-down menu. Then click 'Print' again, and click 'Properties.'
4. Click the 'Layout' tab and click 'Duplex' or turn on whatever two-sided printing option is available.
5. Click 'OK' to print.
6. Repeat the steps for each worksheet that you wish to print duplex in Excel.

Read more ►

How to Insert Functions in Excel 2007

1. Insert a function into an Excel cell manually by clicking in the cell, typing it in and pressing the 'Enter' key. The AutoComplete menu will pop up as you begin to type the formula. If you do not need it, ignore it. If you are unsure how to enter a function without assistance, use the 'Formulas' menu.
2. Insert a function into an Excel cell by selecting the 'Formulas' tab on the Top menu. This is especially helpful if you are unsure what function to use.
3. Click the button that most closely describes the action you are trying to perform with the function. A pull-down list of functions opens. Hover over each function with your mouse and a box describing the function appears.
4. Left-click the function to automatically insert it in the cell. A box opens that tells you exactly what the function does and how to properly structure the variables. Enter the variables and select the 'OK' button.
5. Click in the cell to make any changes to the function. A structure guide for the formula will automatically appear below the cell as long as you have the Formula AutoComplete tool turned on.
6. Turn on the Formula AutoComplete option if it is not already on. Click the 'Microsoft Office Button,' click 'Excel Options' and then click the 'Formulas' category. Under 'Working with formulas,' check the box next to 'Formula Auto Complete' and click the 'OK' button. You can enter a formula with the assistance of the Formula AutoComplete tool.
7. Start typing the formula. When you reach the first letter of the function you would like to use, it triggers Formula AutoComplete. Using the SUM function, for the example, when you type in '=s,' Excel filters the Formula AutoComplete list by all the functions and active cell references that begin with 's.' Typing in the next letter ('=su') filters the list to all options that begin with 'su' and the filtering continues as you type in more letters.
8. Navigate the AutoComplete menu using the arrows on your keyboard or selecting each one by left-clicking with your mouse. As you land on each option, Excel displays a Screen Tip designed to help you choose the best option.
9. Double-click your selection and the function will be entered with the left parenthesis in place ('=sum(') and a description of what the formula should look like underneath. For the SUM function, this looks like 'SUM(number 1, [number 2], [number 3], ...).' Review the description if necessary to ensure that your formula is correctly constructed.
10. Now enter your data and close the formula with the right parenthesis: ').' Using the SUM function, your function could look like this: '=sum(5, B1:B25, c23, c1, b1 b2).' You have inserted a function into Excel.
11. Understand your formula.This formula states, 'five (5) plus the sum value of the range b1 to b25 (B1:B25) plus the value in cell C23 (C23) plus the value of cell B1 plus the value of cell B25 (B1 B25).This formula demonstrates some of the structures defined as numbers by Excel.

Read more ►

How do I Recover an Overwritten Excel File?

1. Locate the document that overwrote the old one you want to retrieve. Right-click the file name, then select 'Rename.' A box will pop up with the file name. Add the word 'new' or today's date to make it easier to tell it apart from the file you want to recover. Once you've edited the name, click 'OK' or 'Continue.'
2. Download XLS Regenerator (see 'Resources'). This program is made specifically to recover Excel files. Start with the free trial by clicking 'Free trial' on the main page, then following the instructions to download for your operating system. Once it's downloaded, double-click on the icon to install.
3. Run the program XLS Regenerator by double-clicking on the icon once it's installed. When the main screen pops up, select 'Recover files,' then 'Recover overwritten files.' The program will now ask for information on the file to be recovered. If you remember the date it was last open, select the date. Then type in whatever you remember from the file name. Click 'Start.'
4. Wait for the program to search your computer for overwritten files. Usually this is in the form of an automatic save--often a hidden file--made before the first overwrite. When it finishes searching, look at the list for the document or documents you want to retrieve. Select all of the documents you want (avoiding the newly named file from step 1) and click 'Retrieve' in the lower right corner.
5. Move the retrieved files to a new folder once they've finished. Open each file to see if it has the correct information you need. If not, repeat steps 3 and 4 with different search parameters until you locate the overwritten documents.

Read more ►

How to Name a Column in Excel 2007

Using Name Box
1. Click the column heading, such as 'A,' 'B' or 'C,' to select the column you want to name in Excel 2007.
2. Go to the 'Name Box' just above column A.
3. Type the column's name into the box and press 'Enter.' The column's name displays when you select the column header.
Using R1C1 Reference Style
4. Click the Customize Quick Access Toolbar button and select 'More Commands' in Excel 2007.
5. Select the 'Formulas' tab in the Excel Options window.
6. Check 'R1C1 reference style' under the 'Working with formulas' section. Click 'OK.'

Read more ►

How to Split Excel Data Into Two Columns

Prepare Your Columns
1. Open the Excel file with data that you want to split.
2. Insert a blank column to the right of the column with data you want to split. For example, if the column you want to split is column F and data exist in column G that you do not want overwritten, insert a new column between columns F and G. To insert a column, click any cell in the column to the right of your data column.
3. Click the 'Home' tab on the ribbon.
4. Click the 'Insert' button in the Cells group.
5. Select 'Insert Sheet Columns' to create a blank column to the left of your cursor, that is, to the right of your data column. For example, if your data reside in column F, you would click on any cell in column G before inserting the column. Excel creates a new column to the left of column G.
Split Your Column
6. Click the 'Data' tab in the ribbon.
7. Select the column you want to split by highlighting the column. To highlight the column, click on the column letter.
8. Click the 'Data' tab on the ribbon. Click 'Text to Columns.' You will see a wizard pop up that will guide you through the process.
9. Select either 'Delimited' or 'Fixed Width,' and click 'Next.'
10. Select the kind of delimiters you want if you selected 'Delimited' in the previous screen. The most common delimiter is a space. Select as many delimiters as apply. Excel will use this information to determine where one piece of data ends and another begins so it can split the data appropriately. If you selected 'Fixed Width,' you will see a ruler above your data. Click on the ruler at the desired points to create a break.
11. Click 'Next.' You will see the third step in the process.
12. Select a format for each of your two columns if you want. However, this is not necessary, and you can always adjust the formats later. Excel will assign the General format for each column as the default.
13. Click 'Finish.'

Read more ►

How to Do a Comparative Chart in Excel

1. Open the Excel worksheet that contains the data for the chart.
2. Click and drag to select the data values and categories.
3. Click the “Insert” tab on the command ribbon.
4.
A column chart can display different categories or data seriesin different colors.
Click the arrow for a preferred chart type in the 'Charts' group. For example, a “2-D Column” chart type can display two or more data series as different colors or shades. A gallery of chart sub-types appears.
5. Click the preferred chart sample. The worksheet data converts to the selected chart type. The chart appears with the worksheet. Each data series displays a different color. The “Chart Tools” ribbon displays.
6. Customize the chart with the “Chart Tools” command. For example, click the “Design” tab to display the “Chart Layouts” and “Chart Styles.” Click the “Chart Styles” to convert the colors of the data series.

Read more ►

Excel Graph Tutorials

1. Open the Excel 2010 spreadsheet that contains the data that you want to use in a graph.
2. Organize your data so that you have headers at the top of each column, and, if necessary, at the left end of each row. If you need to create a header row or column, just right-click the top or leftmost row or column and click 'Insert' from the pop-up menu. A blank row or column will appear, and you can use that to enter your column or row headers.
3. Click on any cell in the data field, and then click the 'Insert' tab at the top of the screen. Click the small button in the lower-right corner of the 'Charts' area of the ribbon to open up a new window will all of the Excel chart options.
4. Click the type of chart that you want to use from the list on the left side of the window. Excel offers 11 different chart types, ranging from a standard column or bar chart to more exotic doughnut and radar charts.
5. Click the exact chart that you want from the list on the right side of the screen. Each chart type has several different variants that have slightly different appearances and may handle information in a slightly different way. Next, click 'OK.' Excel automatically expands your selection on the spreadsheet to include all the cells adjacent to your selected cell and the chart will appear on the spreadsheet.
6. Click the chart and then click the 'Design' tab at the right side of the ribbon. This tab gives you access to buttons that will change the color and shape of the chart. You can also click the 'Select Data' button to reselect the data that will make up the chart.
7. Click the 'Layout' tab at the top of the screen to change the chart's appearance. The buttons in the 'Labels' section will change how the axis titles, chart title and data labels appear. The 'Axes' area holds buttons that will add or remove axes labels and grid lines on the chart. You can also click the 'Insert' button to add a picture, text box or shape to your chart.
8. Click the 'Format' tab at the top of the screen to get access to the controls that change the overall look of the chart. The 'Shape' area contains buttons that change the appearance of the chart window, including the color of the border and any effects on the border. The 'WordArt Styles' area contains buttons that change the color and effects for the text within the chart. Finally, the 'Size' area contains the length and width of the chart, which you can change to your liking.

Read more ►