1. Open on your computer the Microsoft Excel 2003 file that contains the hyperlinks you want to remove.2. Click any blank cell in your worksheet and type '1' into the cell. Click your mouse outside the cell.3. Right-click the cell with the '1' in it, and then select the 'Copy' option from the shortcut menu.4. Hold down the 'CTRL' key on your keyboard while selecting each hyperlink you want to remove. Make sure to not click the one link you want to keep.5. Select the 'Edit' menu option from the top toolbar, and then click the 'Paste Special' option. Select the 'Multiply' option and then...
Browse » Home » Archives for February 2013
Thursday, February 28, 2013
How to Change the Chart Axis Using the Graph Standard Toolbar in MS Word
1. Double-click the chart you want to modify in MS Word to make the 'Chart' toolbar visible.2. Click the 'Category Axis Gridlines' button in the Standard toolbar to make gridlines on the X axis visible.3. Click the 'Value Axis Gridlines' button in the standard toolbar to make gridlines on the Y axis visible.4. Select 'Chart' and 'Chart Options' from the menu. The 'Chart Options' dialog box appears.5. Select the 'Titles' tab to add or modify the titles for the axes on your chart.6. Go to the text field for the axis' title you want to modify, such as 'Category (X) axis,' 'Series (Y)...
Wednesday, February 27, 2013
How to Make a Crossword Puzzle Using Excel
1. Open a blank work sheet in Excel.2. Enter 'Ctrl A' to select all cells. While all cells are selected, place the cursor on the border between two columns of cells and drag them until the cells show a width of 3.75 (35 pixels). Place the cursor between two rows of cells and drag until the row height is 24.75 (35 pixels). This will give you a printable grid with squares that are about 0.3' by 0.3', large enough to write in comfortably.3. Define the grid area you want to print out. For a 20 cell by 20 cell crossword, select 20 columns by 20 rows. Select all of the cells you want to assign...
How to Locate a Path to MS Excel 2003
1. Click the circular Windows 'Start' button in the bottom-left corner of the desktop. Type 'Excel.exe' in the search box at the bottom of the Start menu. Right-click on the Excel file after it appears at the top of the menu under Programs. Select 'Properties' from the pop-up menu, which opens another dialog box.2. Select the 'General' tab.3. Find the 'Location' section in the middle of the tab. The path to the location of Excel 2003 displays similar to the following string of text: 'C:\Program Files\Microsoft Office\Office11.' The Excel 2003 file is within the Office11 folder on the 'C'...
How to Extract the Last Word in a String of Text in Microsoft Excel
1. Open the Microsoft Excel worksheet that has the column of text from which you want to extract the last word. As an example, you want to extract the last name from a list of names in column A and insert it into column C.2. Click in cell “C2.” Enter the following formula and press the “Enter” key:=MID(SUBSTITUTE(A2,' ','^',LEN(A2)-LEN(SUBSTITUTE(A2,' ',''))),FIND('^',SUBSTITUTE(A2,' ','^',LEN(A2)-LEN(SUBSTITUTE(A2,' ','')))) 1,256)You can copy and paste this formula, adjusting the C2 cell reference as necessary. The entire formula goes into one cell.3. Once you have entered the formula,...
Tuesday, February 26, 2013
How to Split Text in Excel 2007
Procedure1. Highlight the data you want to separate.2. Click the 'Data' tab at the top of the page, then 'Text to Columns.'3. Select 'Delimited.' Click 'Next.'4. Choose your delimiter, such as a space or comma. This is where Excel separates the data. Click 'Next.'5. Select the 'Column data format' that is appropriate for your data. Click 'Next.'6. Select where you want the split data to go to and click 'Finis...
How to Remove Capital Letters in Excel 2007
1. Confirm that you have a block of adjacent empty cells, preferably to the right of your data, that you can use for the reformatted cells. If you don't have room on your spreadsheet, highlight the column of cells directly to the right of your original cells, click 'Insert' on the Ribbon -- not the 'Insert' tab -- and select 'Insert Cells' to add a column of empty cells.2. Click the cell directly to the right of the cell you want to change. For example, if the text you want to change is in cell A1, click cell B1. Enter '=PROPER(A1)' in cell B1 and hit the 'Enter' key. This will change the...
How to Encrypt an Excel 2007 File
1. Open the Excel workbook you want to encrypt.2. Click the 'Microsoft Office' button in the top-left corner of the screen.3. Place your mouse cursor over the 'Prepare' entry on the left side of the menu to bring up its options. Click 'Encrypt Document' on the right side of the menu. A password pop-up window will open.4. Enter a password for the document. Make sure you can remember it since you will not be able to recover the spreadsheet if you forget it.5. Click 'OK,' re-enter the password and click 'OK' to close the wind...
Monday, February 25, 2013
How to Merge Cell Contents in Excel 2007
1. Open the Excel worksheet.2. Click the 'Home' tab on the command Ribbon.3. Click and drag on the two or more cells to merge. A heavy black outline will form around the selected cells. The column headers above the outlined cells will turn a different color.4. Click the down-arrow for the 'Merge Center' command in the 'Alignment' group. The drop-down menu offers three merge formats: Merge Center, Merge Across, Merge Cells. 'Merge Center' centers the text within the larger cell. 'Merge Across' retains the left-aligned text in the row. 'Merge Cells' unites the cells and keeps the data...
Sunday, February 24, 2013
How to Convert a Workbook in Excel 2007 to a PowerPoint Slide
1. Open the Excel workbook you want to copy to PowerPoint. On the first worksheet press 'Ctrl A' then 'Ctrl C' on the keyboard.2. Open a PowerPoint presentation. Click on the slide where you want to insert the worksheet. Don't click in a text box, but just a blank area on the slide. Press 'Ctrl V' to paste the table into PowerPoint. Press 'Ctrl M' to create a new slide.3. Switch back to Excel then click the tab for the next worksheet in the workbook.4. Select and copy the contents of that sheet and paste them into the new slide in PowerPoint. Repeat this process for each worksheet in the...
How to Convert Excel Macro to Open Office
1. Find a suitable utility program to convert macros in the Excel Visual Basic language to the CalcBasic code necessary for Open Office. A free option is the online conversion program offered by Business Spreadsheets (see link in 'References'). This convenient web page allows the user to paste existing Visual Basic code into a text box and automatically convert it into CalcBasic. While no automatic conversion between the two programming languages will be thorough, this process is a good primer for the tweaking that is inevitably necessary to ensure full functionality in Open Office. This utility...
How to Graph Linear Equations Using Excel
Excel 20071. Highlight the data you want to graph by clicking at the top left of the data and dragging the mouse to the bottom right.2. Click on the 'Insert' tab.3. Select 'Line graph' and choose '2-D Line.' Excel will draw the graph for the linear equation based on the table of values you input.Excel 20034. Highlight the data you want to graph by clicking at the top left of the data and dragging the mouse to the bottom right.5. Click on the 'Chart Wizard' in the toolbar.6. Choose 'Line.'7. Check the 'Chart subtype' box and click 'Next' three times to move through the rest of the...
How to Unlock a Cell in Excel If Information Is Entered into Another Cell
1. Open the Excel spreadsheet that you want to work with.2. Select the cell that you want to allow someone to enter information into. Right-click the selected cell, and choose 'Format Cells.' Click the 'Protection' tab at the top of the window, and clear the 'Locked' check box. Click 'OK.'3. Click the 'Review' tab at the top of the Excel window, and then click the 'Protect Sheet' button. Type in a password, if you need one, and click 'OK.' If you entered a password, you will have to type it in again. Be sure to write the password down so that you won't forget it. All of the cells except...
Saturday, February 23, 2013
How to Troubleshoot Microsoft Excel
1. Start Excel from the main program. Sometimes a shortcut to a program can become corrupt and cause the application to have problems opening. Go to the 'Start' menu, click on 'All Programs' and find Microsoft Excel in the program list. If it opens properly, delete the problematic shortcut by right clicking it and selecting 'Delete.' You can make a new shortcut by right clicking the main application and choosing 'Send to Desktop.'2. Disable add-ins. Sometimes these optional programs are problematic. In Excel 2007, click the 'Office' button. Click on 'Excel Options' and select 'Add-Ins.' In...
How to Make a Graph on Excel That Shows Names for the the Y
1. Open a new Microsoft Excel 2010 spreadsheet. Click on cell 'B1' and type in the name of your first data series. This name will appear in your graph's legend. Then click on cell 'C1' and enter the name for your second data series.2. Click on cell 'A2' and enter the names that will appear down your 'Y' axis into column 'A.' Continue to enter names until you have added them all.3. Select cell 'B2' and type in the first data point that falls under the column and row names. Then select cell 'C2' and repeat the process. Continue until you have entered all of your data into columns 'B' and 'C.'4....
How Do I Change Data in Vertical Columns to Horizontal Columns in Excel or Access?
Transposing Data in Excel1. Highlight the columns you want to transpose into rows. Press “Control C” to copy the data.2. Open a new worksheet for the transposed data. Select an empty worksheet tab from the bottom of the Excel window, or press “Shift F11” to create a new worksheet. Rename the worksheet “Transposed Data.”3. Right-click on cell “A1” to open the context menu. Select “Paste Special” from the menu to open the “Paste Special” dialog.4. Check the “Transpose” box at the bottom of the “Paste Special” dialog to transpose the data. Click “OK.” Your data will be pasted into the...
Friday, February 22, 2013
How to Make a Schedule in Excel
1. Open Microsoft Excel. click the 'File' menu and choose 'New.'2. Go to the 'Available Templates' section and the Office.com Templates area.3. Preview a schedule template by clicking on it. Once you have found the one that fits your requirements, click the 'Download' button. The schedule will open as a new Excel worksheet.4. Change existing text in the schedule template by double-clicking on the cell that contains the text you want to alter. Select the existing text using your mouse or the keyboard shortcut 'Ctrl-A.' Type over the existing sample text with the information you need on...
How to Activate the Excel Help Button
1. Open Microsoft Excel.2. Click the 'Help' button, which is the blue circle with a question mark in the middle of it in the upper-right corner of the worksheet just below the 'Maximize'and 'Minimize' buttons. The 'Excel Help' window is activated and pops up on the screen.3. Click one of the links in the 'Getting started with Excel 2010' area or type a search term into the help text box at the top of the window. Close the help box by clicking the 'X' in its top-right corn...
How to Stop Auto Recalculation Upon Data Entry in Excel
1. Open Microsoft Excel, and then open a new or previously saved workbook.2. Click 'File' at the top of the screen. Click on 'Options' in the drop-down menu that appears. The 'Excel Options' window opens.3. Click 'Formulas' on the left side of the window. Under 'Workbook Calculation,' click 'Manual.'4. Click the 'Recalculate workbook before saving' check box if you want to turn this option off as well. Click 'OK' to close the wind...
How to Format Dates in Descending Order in Microsoft Excel
1. Confirm that the dates exist in a single column, running vertically. Excel can only sort data in the columns, not the horizontal rows, of a spreadsheet.2. Highlight the data you want to sort.3. Right click any highlighted cell and select 'Format Cells.'4. Select 'Date' from the 'Category' column, choose your preferred format from the adjacent 'Type' column, and then click 'OK.'5. Click 'Data' in the top menu bar and select 'Sort.' If you use Excel 2007 or later, select the 'Data' tab near the top of the window and click the 'Sort' icon instead.6. Click the drop-down menu below the...
How to Use V
1. Open Excel and open a spreadsheet that you plan to use the vlookup on. Make sure the spreadsheet has column headers and at least three columns. Each column should have at least 10 lines of varying data so you can see how vlookup works. For example, your spreadsheet could have three columns with the title of 'Employee ID number,' 'Name,' and 'Hire Date.' The first column, employee ID, should be sorted in ascending order. This is a requirement of Vlookups.2. Review the components of a vlookup. Your vlookup will be comprised of four parts: lookup value, table array, column index number,...
How to Make Microsoft Excel 2007 Talk
1. Open the spreadsheet that you want Excel to dictate.2. Click the 'Customize Quick Access Toolbar' drop-down arrow located next to the 'Quick Access Toolbar.' The 'Quick Access Toolbar' contains the 'Save,' 'Undo' and 'Redo' buttons.3. Click 'More Commands' and click 'All Commands' from under the 'Choose Commands From' drop-down list.4. Scroll down the list, click 'Speak Cells' and click the 'Add' button.5. Click 'Speak Cells -- Stop Speaking Cells' and click the 'Add' button. Click 'OK.'6. Highlight the cells that you want Excel to dictate and click the 'Speak Cells' button in the...
Thursday, February 21, 2013
How to Open Excel 2003 in Safe Mode
1. Locate the icon for opening Excel 2003 by clicking the 'Start' button and selecting 'All Programs,' then 'Microsoft Office,' then 'Microsoft Office Excel 2003.' Don't click the icon yet.2. Hold down the 'Control' key on your keyboard while you left-click 'Microsoft Office Excel 2003.' You should click the left mouse button normally, but continue to hold down the 'Control' key until you see a Windows message prompt.3. Select 'Yes' when Windows prompts you for confirmation of running Excel in safe mode. Excel will open after you click 'Ye...
How to Make a Combo Box in Excel 2003
1. Open Excel on your computer, and open a new spreadsheet. Somewhere in the spreadsheet, enter the data that will appear in the combo box. For example, you might enter data between cells C4 to C10.2. Go to the 'Forms' toolbar, and select 'Combo Box.'3. Drag your mouse over the cells that you want the combo box to encompass. Once you release your mouse click, the combo box will appear.4. Right-click on the new combo box,, and choose 'Format Control' from the menu. Specify the cell range of your data in the 'Input Range' field; in the above example, you would enter C4:C10, because those...
How to Execute a Macro in Excel 2003
1. Open Excel 2003 and select the workbook that will use the macro. Click 'File' on the menu bar and select 'Open.' Browse your files and locate the workbook. Click the workbook and select 'Open.'2. Click 'Tools' on the menu bar and select 'Macro.' Select 'Macros.' Select your macro from the list of available macros.3. Click 'Run.' The macro is executed on the workbo...
How to Calculate the Percent of a Quarter Passed in Excel
1. Open a new Microsoft Excel spreadsheet.2. Click on cell 'A1' and enter the first day of the quarter. Then click on cell 'A2' and enter the last day of the quarter. Finally, click on cell 'A3' and enter in the date with which you want to determine the percentage of the quarter passed.3. Click cell 'B1' and enter in the following:=A3-A1This will tell you how many days into the quarter you are. Click cell 'B2' and enter the following:=A2-A1This will tell you how many total days there are in the quarter.4. Click on cell 'B3' and enter the following:=B1/B2This will give you your percentage...
How to Make the Lines Print When Working With Excel 2003
1. Open the spreadsheet you're working on in Excel 2003 and highlight the cells you want to print.2. Go to the 'Formatting' toolbar and click the arrow beside the 'Borders' button to expand it. Select 'All Borders' from the list. If the 'Borders' button is not visible in the 'Formatting' toolbar, click the 'Toolbar Options' arrow at the end of the toolbar to expand it. Choose 'Add or Remove Buttons,' 'Formatting' and 'Borders.' Alternatively, you can select 'Format' and 'Cells' from the menu to open the 'Format Cells' dialog box. Select the 'Border' tab and click 'Inside' from 'Presets.' Select...
Wednesday, February 20, 2013
How to Set Page Break Views in Microsoft Excel 2003
1. Create a page break. To create a page break, left-click on the cell rows that you wish for a page break to occur by clicking on the corresponding row number to the left; the entire row will become highlighted when you left-click on the row number.2. Access the “View” menu. Scroll to the “File” tab on the command bar and then select “Page Break Preview.”3. Use the page break preview menu. Once inside of the page break preview menu, you will be able to see where page break occurs on the spreadsheet, because it will have a double grey line highlighting it.4. Adjust where page breaks are...
How to Convert Excel 2007 to Dbf
1. Download a converter program designed to save Excel 2007 files to dbf format. There are a number of such programs on the market. Some of them are free and others are available at a reasonable cost. Please see the Resources section for links to some of these converter programs.2. Open Microsoft Excel 2007 and create the spreadsheet you want to convert. Save the file in Excel 2007 format to your hard drive or to your network shared drive.3. Close the Excel spreadsheet and open your conversion program. Choose 'import data into database.' You can choose to import the data from the Excel 2007...
How to Make an Invoice in Access
1. Open Microsoft Access. Go to 'File,' 'Time Billing' under the 'Office.com Templates' section. You can also type “Office.com Templates” in the search box, in the upper right corner.2. Open the 'Time Billing' folder. Select the 'Time Billing' template to show the 'Project List' window.3. Select the “Reports” drop-down menu and click “Invoice.” A new window will open with Microsoft Access default information. Delete or add pertinent information relating to your organization in the fields to create your invoi...
How to Connect Excel to SQL Using Visual Basic
1. Open Excel, then type a list of names in one column and ages in an adjacent column. Label the tops of these columns with the text 'Names' and 'Ages.' This step creates a database of sample data for your SQL program to fetch. You can create a table with different data if you'd like.2. Drag a selection region around the table, then type 'MyTable' in the text box to the left of the formula bar. This creates a range name for the sample data, which your program will need to access the data.3. Save the file as 'C:\MyDatabase.xlsx,' then close the file.4. Press 'Control,' followed by 'N' to...
Tuesday, February 19, 2013
How to Make Column Titles in Excel 2007
1. Open an Excel worksheet.2. Click on a cell above a column. The selected cell will show a heavy black outline. The column and row headers will change to a different color.3. Enter the column title.4. Edit or format the title for a custom look. For example, you can change the font, font color, size and alignment. Click on the 'Home' tab and use the commands in the 'Font' and 'Alignment' groups to change the format of your column title.5. Save the workshe...
How to Use Radio Buttons in Excel
Using Radio Buttons in Excel 20031. Open the worksheet to which you want to add radio buttons. Open the 'Control Toolbox' by going to the 'View' menu, pointing to 'Toolbars' and selecting 'Control Toolbox.' The toolbox appears as a floating toolbar.2. Click the radio button control in the 'Control Toolbox.' If you are not sure which control this is, hover your mouse over each button in the 'Control Toolbox' and click on the one that says 'Option Button.'3. Click onto the worksheet where you want to place the first radio button and drag the box to 'draw' the size you want it to be.4. Right-click...
Monday, February 18, 2013
How to Merge Two Columns in Excel 2007
1. Open Excel and search for a spreadsheet that contains two columns you want to merge. Select 'Open' on the Quick Access Toolbar and search for the spreadsheet on your computer. Locate the spreadsheet and click 'Open.'2. Insert a blank column beside the columns you want to merge. Select the column beside the columns you want to merge and click on the column header. For example, if you want to combine Column A and B, click on the column header C. Once the column header is selected, the entire column is highlighted. Right click on the column header, and select 'Insert.'3. Use the concatenate...
How to Calculate Daily Percentage Change in Excel 2007
1. Type 'Beginning of Day' in cell A1, 'End of Day' in cell B1 and 'Percent Change' in cell C1 in Excel 2007.2. Type the day's beginning value in cell A2. For example, if a stock's price is $40 at the start the day, type '40.'3. Type the day's ending value in cell B2. In the example, assume the stock closed at $45. In this case, type '45' in cell B2.4. Type '=(B2-A2)/A2)' in cell C2. In the example, you get the result '0.125.'5. Select the 'Home' tab, and click the 'Number' box.6. Select 'Percentage' under 'Category.'7. Choose the amount of decimal places you want your percentage...
Sunday, February 17, 2013
How to Make a Alphabetized Mailing List in Microsoft Excel
1. Launch Microsoft Excel 2010.2. Type 'First Name' in the top cell in the first column (Cell 'A1') and press 'Tab' on the keyboard to save the contents of the cell and move to the top cell in the second column (Cell 'B1').3. Type 'Last Name' in the top cell in the second column and press 'Tab' to save the contents of the cell and move to the top cell in the third column. Continue this pattern for 'Address 1,' 'Address 2,' 'City,' 'State' and 'Zip.' Add other fields as needed and add their title to the top row.4. Right-click on the letter at the top of the column which contains the zip...
How to Highlight Alternating Rows in Excel
Using Excel Table Style1. Open the Excel worksheet with the data you want to highlight.2. Click the 'Home' tab on the ribbon, then click 'Format as Table.' Excel asks you where the data for your table is. Click 'OK' to accept the range Excel highlighted, or enter the range manually. Click back to 'Home' if the 'Design' tab opens. Click 'Format as Table' again.3. Select the alternate shading that you want. You can select from the 'Light,' 'Medium' or 'Dark' shading groups. Your table should now have alternating rows highlighted.Using Conditional Formatting4. Open the Excel worksheet with...
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...
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....
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....
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,...
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...
Saturday, February 16, 2013
How to Make a Calendar in Excel 2007
Add Calendar Control to Worksheet1. 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...
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...
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 'O...
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...
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...
Friday, February 15, 2013
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...
How to Name a Column in Excel 2007
Using Name Box1. 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 Style4. 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 'O...
How to Split Excel Data Into Two Columns
Prepare Your Columns1. 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...
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....
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...
How to Highlight Minimum Maximum Values in Excel
1. Click the cell at one end of the range that you are analyzing.2. Drag the mouse to the cell at the other end, selecting the entire range.3. Click 'Conditional Formatting' from the 'Styles' tab of the 'Home' ribbon. A drop-down menu will open.4. Click 'New Rule...' from the bottom of the list.5. Click 'Format only top or bottom ranked values' from the 'Select a Rule Type' pane.6. Select 'Top' from the first of the drop-down boxes in the 'Edit the Rule Description' pane.7. Type '1' into the text box in the 'Edit the Rule Description' pane.8. Click the 'Format' button, which opens...
Thursday, February 14, 2013
How to Make a Coordinate Plane in MS Excel
1. Open a new, blank Excel document. Click the rectangle in the upper-left corner of the spreadsheet located at the intersection of column A and row 1. This will select the entire spreadsheet. Click the View tab. In the Show/Hide group, deselect 'Gridlines'.2. Place your cursor on a line between any two column headers. Your cursor will change to a vertical line crossed by a horizontal arrow. Drag the line left until the column width is exactly 20 pixels. When you release the mouse, all cells will be square. Click in cell A1 to remove the highlighting.3. Click cell C3 and drag and highlight...
How to Create a Stacked Chart in Excel 2003
1. Enter your data in column 'A,' with the label for the data in cell 'A1,' and each data value put into cells 'A2,' 'A3' and so on, until you've entered all of the data needed for the chart.2. Select the range of cells from cell 'A1' through the last cell with a data value in it.3. Click the 'Insert' menu and select 'Chart.' This will start the Chart Wizard.4. Click 'Column' for the Chart Wizard from the options under 'Chart Type.' A 'Chart sub-type' menu will show up.5. Click '100% Stacked Column' and click 'Next.' This selects the stacked chart subtype.6. Click 'Rows' on the next...
How to Use Indirect in Excel to Link to an External Spreadsheet
1. Create two spreadsheets. One will be named PullData.xlsx. The other will be ReviewData.xlsx.2. Enter the following into cell A1 of Sheet1 of PullData.xlsx: 'Shazam!'3. Enter the following formula into cell A2 of PullData.xlsx: '=27 54'4. Switch to ReviewData.xlsx. Enter the following text into the following cells: In cell B1, enter 'PullData.xslx'. In cell B2, enter 'Sheet1'. In cell B3, enter 'A1' and in cell B4, enter 'A2'.5. Enter the following formula in cell A1 on ReviewData.xlsx: '=INDIRECT(''['B1']'B2''!'B3)'. Note that there are both double quotes (') and single quotes...
How to Insert a Title Into a Table in Excel 2007
1. Click on the table.2. Click 'Design.' This is a tab near the top of Microsoft Excel.3. Select 'Table Name' in the 'Properties' group.4. Type your title in the text box that appea...
How to Lock Specific Cells in Excel 2007
1. Highlight the entire sheet by clicking the 'Select All' button in the top-right corner of the sheet. It's just to the left of the A column and immediately above the 1 line.2. Right-click anywhere on the sheet and select 'Format Cells.' The Format Cells pop-up window will open.3. Click the 'Protection' tap at the top of the window.4. Click the block next to 'Locked' to clear the check mark, and click 'OK' to close the window.5. Click anywhere on the sheet to remove the highlighting. Select all the cells you want to lock. You can drag to select cells that are connected. To select individual...
How to Create a Histogram in Microsoft Word
1. Open a blank Word document, or open the document in which you want to create a histogram. Insert a table onto the document. In Word 2007, go to the 'Insert' tab, click the 'Table' dropdown and select 'Insert Table.' In earlier versions of Word, go to the 'Table' menu, point to 'Insert' and click on 'Table.' Choose the number of columns you need in your chart, including a column to label the rows, and enough rows to present your data.2. Enter the y-axis data for the histogram into the first column of the table. For example, if you are making a histogram showing how much money employees earned...
How to Create an Amortization Table in Excel
1. Use the loan APR, amount and term in Excel's 'PMT' function to calculate the monthly payment. If you have a 30-year mortgage for $200,000 at a 6 percent APR, type the following in cell A1.=-PMT(0.06/12,30*12,200000)2. Type in column headings for the amortization table. In cell A3, type 'Unpaid Balance.' In cell B3, type 'Principal.' In cell C3, type 'Interest.' Adjust the column widths as necessary.3. In cell A4, type the initial loan value. For the previous example, you would type '200000.'4. Calculate the interest on the first month's payment. In cell C4, based on the previous example,...
Wednesday, February 13, 2013
How to Do Multicolor Column Charts in Excel 2010
1. Open the Excel worksheet that contains the data for the column chart.2. Click and drag to select the categories and data values for the column chart.3. Click the “Insert” tab on the command ribbon.4. Click the arrow for the “Column” chart in the “Charts” group.5. Click the preferred column chart to add a chart representing the selected worksheet data.6. Click in the chart area to display the Chart Tools ribbon.7. Click the “Format” tab in the Chart Tools ribbon.8. Click one column in the plot area. All the columns will appear highlighted.9. Click the same column once again....
How to Compare Columns With VBA
1. Click the 'Developer' tab in Excel, and then click 'Visual Basic.'2. Click 'Insert.' Click 'Module' to open a new module window.3. Cut and paste the following code into the window:Sub CompareColumns()Dim Column1 As RangeDim Column2 As Range'Prompt user for the first column range to compare...'----------------------------------------------------Set Column1 = Application.InputBox('Select First Column to Compare', Type:=8)'Check that the range they have provided consists of only 1 column...If Column1.Columns.Count > 1 ThenDo Until Column1.Columns.Count = 1MsgBox 'You can only select 1...
How to Unlock Excel 2007 Password Protection
Unlock Document Password1. Open the Excel file in Excel 2007. You will need to enter the correct password to open the file.2. Click on the Microsoft Office Button, located in the upper right corner of the Excel 2007 program. Move your mouse over 'Prepare' on the left hand side of the window. Choose 'Encrypt Document' from the list of options on the right.3. Place your cursor to the right of the password in the box. Use the backspace key to erase the password. Click 'OK' when you are done. The Excel 2007 document is no longer password protected.Unlock Worksheet Password4. Open the Excel...
How to Change the Color Scheme in an Excel Chart
Change Chart Colors in Excel 20071. Open the spreadsheet containing the chart you want to edit.2. Single-click the chart once to select it.3. Single-click the individual piece of the chart you want to change to select the piece.4. Right-click the selected piece and choose the 'Format Data Point' option.5. Click 'Fill' in the left-hand menu, and then choose the fill option that meets your design needs. Select your desired color, gradient, picture or texture and the selected chart shape is updated immediately. Click 'Close' to close the Format Data point window.Change Chart Colors in Excel...
Tuesday, February 12, 2013
How to Remove Security From an Excel Spreadsheet
1. Open the Excel spreadsheet and enter your password.2. Click the 'Review' tab on the Excel toolbar.3. Click the 'Unprotect Sheet' button to remove security from the spreadsheet. Make sure you do not click 'Unprotect Workbook' unless you want to remove security from the entire workbook.4. Enter the password for the spreadsheet if prompted and click 'O...
How to Create a Distribution List to Import Into Outlook 2007
1. Open a blank Excel worksheet. Enter 'First Name' into cell A1. Enter 'Last Name' into cell B1. Enter 'Email Address' into cell C1.2. Enter the first name of the first person you want to add to the distribution list into cell A2. Enter that person's last name and email address into B2 and C2. Enter the names and email addresses of all of the contacts you want to add to the distribution list into the cells in the appropriate columns.3. Click the 'File' tab in Excel 2010. Click 'Save As.' Enter a name for the file, such as 'Distribution List,' into the File Name field. Change the 'Save as...
How to Split a Cell Diagonally
Microsoft Word1. Click anywhere within the table to make the 'Design' tab visible in Microsoft Word.2. Click the 'Design' tab under 'Table Tools.'3. Go to the 'Draw Borders' group and select 'Draw Table.'4. Place your cursor at the top corner of the cell you want to split.5. Click, hold and drag your mouse from the top, right corner of the cell to the opposite corner to split it diagonally.6. Click the 'Draw Table' button to deactivate the 'Draw Table' option.Microsoft Excel or PowerPoint7. Click the 'Insert' tab in Microsoft Excel.8. Go to the 'Illustrations' group and click 'Shapes'...
How to Add a Second Y
1. Create an Excel graph for all the rows and columns. At the end of this step you will have a graph with some very high lines and the rest flat along the bottom.2. Select one of the lines which are causing the skewing of the graph. If more than one line is the culprit, select the highest.3. With the lines selected, right click on the graph and select 'Format Data Series.' This will open another box. In the new box, select 'Secondary Axis.' Then click the Close button.4. Your graph will now display the second Y-axis on the right of the graph and your lines will be spaced o...
How to Disable Cell Drag in Excel
1. Open Excel and click the 'File' menu tab in the top-left corner of the screen.2. Click 'Options' on the bottom-left of the menu to open the Excel Options window.3. Click 'Advanced' in the left window pane.4. Click the box next to 'Enable Fill Handle and Cell Drag-and-Drop' to clear the check mark.5. Click 'OK' to close the window and save the chang...
How to Move Data on an Excel 2007 Worksheet
1. Open the worksheet you want to change. Find the document in your saved documents and select it--double click twice on it. The worksheet will then open in Excel.2. Decide what actions you want to do. For example, you may have made a file that is your address book. When you first put the file together, you put in columns in the following order: first name, last name, phone number, address, city, state and zip code. You now see that it would be easier if you had arranged the data this way: last name, first name, address, city, state, zip code and phone number.3. Add a column. Put your cursor...
Monday, February 11, 2013
How to Retrieve Values From Another Excel 2007 Workbook
1. Determine the location of the workbook you want to retrieve values from. For example, the workbook might be in the same directory as the one you want to display the values in, and it might be named 'other_workbook.xlsx.'2. Find the the row and column of the value you want to bring in from the other workbook. For example, you may be looking for a 'total' that is sitting in cell G4 on Sheet1 in other_workbook.xlsx.3. Type the following formula into the cell you want to display the value from the other workbook on:=[other_workbook.xlsx]Sheet1!A14. Change 'A1' in the formula from Step 3...
How to Extract Pivot Table Data
1. Type the '=' sign, without the quotes, into an empty cell.2. Click on a cell in the pivot table. A formula will appear next to the equal sign.3. Press the 'Enter' key. The cell will now display the data from the Pivot tab...
How to Wrap Text in a Cell
1. Highlight the cells you want the text to be wrapped in. Use your computer's mouse to left-click in the first cell you wish to select and continue to drag it over the desired cells. Release it when the cells are highlighted.2. Click on 'Format' in the Excel task-bar or right-click on the cell block you have highlighted.3. Click on 'Format Cells' and a pop-up window will appear.4. Click on the 'Alignment' tab and check the 'Wrap Text' box on the left-hand side.5. Click 'OK' to close the 'Format Cells' pop-up window. The highlighted cells should now wrap when you resize your cell ...
Subscribe to:
Posts (Atom)