1. Open the Word document that contains the chart you want to modify.2. Click the chart axis you want to change. The axis will be outlined in black; right click over the axis to view options for editing the chart.3. Select 'Format Axis' from the menu that pops up. The 'Format Axis' dialog window will open.4. Select 'Axis Options' from the list of formatting options.5. Select the axis scale minimum or maximum by checking 'Fixed' next to 'Minimum' or 'Maximum.' Type the minimum or maximum number you want to use for the scale.6. Change the spacing in the tick marks on the axis by checking...
Browse » Home » Archives for April 2011
Thursday, April 28, 2011
How to Find Links in Microsoft Excel
Links in Hyperlink1. Open the Excel workbook containing the links you want to find.2. Place your cursor in an empty cell and create a dummy hyperlink (so you can use its format to find other hyperlinks). To create the hyperlink, select the 'Insert' tab and click 'Hyperlink' in the 'Links' group. Select 'Existing File or Web Page' under 'Link to' in the 'Insert Hyperlink' dialog box. Type a website address (ex., 'http://some-address-123.com') into the 'Address' text field and click 'OK.'3. Select the 'Home' tab and go to the 'Editing' group. Click 'Find Select' and 'Find.' The 'Find and...
Wednesday, April 27, 2011
How to Make the Top Line Stay Visible in Excel
1. Open your spreadsheet in Microsoft Excel.2. Click the 'View' tab in the ribbon.3. Click 'Freeze Panes' in the 'Windows' group and click 'Freeze Top Row' to make the top line stay visib...
How to Convert Excel 2003 to the 2007 Format
1. Open the file to be converted using Excel 2007. Click 'File' in the menu bar and select 'Open.' Navigate to the file you wish to open and convert. This will open the file in Compatibility Mode.2. Click the 'Microsoft Office Button' located in the menu bar then click 'Convert' in the pop up window. When asked if you are sure you wish to convert this workbook to the new file format, click 'OK' to confirm. If you do not want this warning message to appear again, select the option for 'Do not ask me again about converting workbooks.'3. Click 'Yes' in the window that appears asking if you...
Tuesday, April 26, 2011
How to View Excel Spreadsheets Without Microsoft Office
1. Download and install the free Excel Viewer on your computer. You can find a link to the download in the resources section of this article.2. Open the Excel Viewer. Click 'File' from the Excel Viewer window toolbar and then select 'Open.'3. Select the Excel file you want to view and then click 'Open.' The Excel Viewer will automatically display the Excel spreadsheet you have select...
How to Cross Out on Excel
1. Launch Microsoft Excel 2010 to begin working in a new workbook, or double-click an existing Excel spreadsheet to edit.2. Click on the cell containing the text that you want to cross out. If you want to select multiple cells, hold down the 'Ctrl' key on your keyboard, and then click each desired cell with your mouse.3. Click the 'Home' tab at the top of the window.4. Click the 'Format Cells: Fonts' button at the bottom right-corner of the 'Font' section of the ribbon. The button is a small square with an arrow in it.5. Check the box to the left of 'Strikethrough' in the 'Effects' section...
How to Make a Flowchart in Excel
1. Make the 'Drawing' toolbar available in Excel 2003 by going to the 'View' menu and pointing to 'Toolbars.' Click on 'Drawing'; the 'Drawing' toolbar will appear at the bottom of the window. In Excel 2007, go to the 'Insert' tab of the ribbon and find the 'Illustrations' section.2. Click on 'AutoShapes' in Excel 2003 and point to 'Flowchart.' Click on the first shape you want to use and click onto the worksheet to place it in the appropriate area. In Excel 2007, click the 'Shapes' button and choose the shape you want to use first from the 'Flowchart' gallery. Click onto the worksheet and...
Monday, April 25, 2011
How to Paste Special in Microsoft Excel 2003
1. Select the cells, rows, or columns that you want to manipulate and go to the Edit menu and select 'Copy' (or press Ctrl-C) to copy the data.2. Click the cursor on the cell or cells where you want the manipulated data to be placed.3. Go back to the Edit menu and select 'Paste Special.' This will open up a window where you will choose how to manipulate the selected data.4. The first section, labeled 'Paste,' is where you tell Microsoft Excel what parts of the data you want to paste. 'All' will paste all of the copied data, 'Formulas' will paste just the formulas connected to the copied...
How to Find a Confidence Interval for the True Mean Using Excel 2007
1. Enter the alpha value in cell A1. The alpha value represents '1,' minus the probability the true mean lies within the confidence interval. For example, if you want a 95 percent probability that the true mean lies within the confidence interval, your alpha value equals 0.05.2. Enter the standard deviation of the data in cell A2. The wider the distribution of data, the greater the standard deviation.3. Enter the sample size in cell A3. The larger the sample size, the smaller the confidence interval will be.4. Enter '=CONFIDENCE(A1,A2,A3)' into cell A4. Excel will display the confidence...
How to Balance a Checkbook With Excel 2003
Manual Method1. Open a blank Excel 2003 spreadsheet.2. Type the following headings in the first row: 'Check #,' 'Date,' 'Description,' 'Debit,' 'Credit' and 'Balance.' These mimic your checkbook register. Format the headings however you like. Recommended formatting is to bold, center and underline headings.3. Type 'Initial Balance' or 'Initial Deposit' in the first empty cell under 'Description.' Type your current or starting balance in the first empty cell under 'Balance.'4. Type the following formula in the next empty cell under 'Balance': '=F2-D3 E3. This assumes Debit is in column...
Sunday, April 24, 2011
How to Edit Cells With Multiple Users in Excel 2007
1. Format the document prior to sharing it across a network. Once an Excel 2007 file is shared, many common formatting procedures are no longer available until the sharing is deactivated. These include conditional formatting, charts, pictures, links, outlines and PivotTables. It is best to prepare the file for mass data entry with the features everyone will need during editing.2. Click on the 'Share Workbook' button. This will open up the features dialog for network sharing of the Excel 2007 document with multiple users. The button is found on the Review tab of the Excel 2007 toolbar, in the...
How to Change the Order of the Legend in an Excel Graph
1. Locate the chart data in the Excel spreadsheet. To locate the applicable data, click on the graph: the data will be surrounded on the worksheet by a blue box.2. Copy the data, then paste it to a clear area on your workbook. Alternatively, paste it into a new worksheet.3. Change the data into the order you want it to appear on the graph then copy and paste the columns.4. Copy and paste the new data order back into the original spot on the workbo...
How to Remove Leading Zeroes in Excel
1. Open the spreadsheet that you want to edit in the Microsoft Excel program.2. Highlight the cells that contain decimal information for which you'd like to remove the leading zero.3. Right-click the highlighted cells and choose 'Format Cells.' This will open a cell-formatting options window.4. Click the 'Number' tab and select 'Custom' from the category list.5. Click the text box underneath the 'Type' heading and press the 'Backspace' key multiple times to clear the contents of the field.6. Type a decimal point and then type the number of zeroes that correspond to the number of decimal...
How to Create an Alphanumeric Custom List in Excel 2007
Create the List1. Open Excel and click on the Office button, which is located in the top left-hand corner of the window.2. Click the 'Excel Options' item from the menu that drops down.3. Click on the category labeled 'Popular.' Locate the section called 'Top options for working with Excel.' Click the 'Edit Custom Lists' item in this section.4. Click the 'New List' option located in the 'Custom Lists' box.5. Type the first item of the custom list. Choose any combination of alphanumeric text characters. Enter the item into the 'List entries' box. Press the Enter key on the keyboard.6....
Saturday, April 23, 2011
How to Insert the Time Date in an Excel Spreadsheet
1. Navigate to the cell to which you want to add the date and time. Click on the cell to highlight.2. Move your mouse up to the 'Fx' bar above the spreadsheet. This is the bar where you enter formulas for specific cells.3. Type '=Now()' without the quotation marks. This enters the current date and time into the Excel spreadsheet in the selected ce...
Friday, April 22, 2011
How to Merge 2 Excel Workbooks in Excel 2007
Share the Workbook1. Launch Microsoft Excel on your computer. Click 'File' and then 'Open' on the ribbon bar. Navigate to the file to share, highlight it and click the 'Open' button.2. Click 'Tools' and then 'Share Workbook.' Click the 'Editing' tab and then enable the 'Allow Changes by more than one user at the same time' option.3. Click the 'Advanced' tab and then click 'Track changes.' Click the 'Keep change history for:' option. In the 'Days' text box, enter a number of days for the estimated time needed for others in the group to edit the file and review changes. Click the 'OK' button.4....
How to Save Margins in Excel
1. Open Excel and click the 'Page Layout' tab and then click 'Margins.'2. Click 'Custom Margins' in the menu that appears. Click the 'Margins' tab in the 'Page Setup' window that appears.3. Click the number in the 'Top' box and type the margin size you wish to use in the 'Top' box. Repeat this step for the 'Left,' 'Right,' and 'Bottom' boxes.4. Click the 'OK' button to save the settings for the workshe...
How to Use a Microsoft Excel 2003 Dashboard
1. Produce an annual report or magazine quality visuals reports using Excel. Use templates downloaded from the Microsoft website. Create a chart by arranging the data (that you want to plot in your chart) in columns and rows. Select the cells you want to include and from the Insert menu, click the Chart option. Select the type of chart you want to represent your data. For example, select a pie chart, and decide where you want to place the chart.2. Replace charts that do not reflect the data you want used. Because Excel is so flexible, you can lay out the flow of business processes and drill...
How to Use Excel Cell Data to Reference a Sheet Name
1. Create a workbook in Excel. It will start with three worksheets, shown by tabs along the bottom of the screen. By default, these are named 'Sheet1,' 'Sheet2' and 'Sheet3.' Sheet1 will be active.2. Enter ''Sheet2' in cell A2. Enter ''Sheet3' in cell A3. Note that both of these prepend the word 'Sheet' with a single quote ('), to indicate that it's a text value.3. Click on the tab for Sheet2 and enter 'Orange' in cell A1.4. Click on the tab for Sheet3 and enter 'Screwdriver' in cell A1.5. Click on the tab for Sheet1, and in cell B2, enter the following formula: '=INDIRECT('''A2''!A1')'...
How to Convert Excel 2007 Files to dBase
1. Find out what formats the database you're importing into can accept. Nearly all of them can take comma-separated values (CSV), and many can accept legacy Excel formats, such as XLS.2. Click the 'Office' button (the round button at the upper left with the Microsoft Office logo on it). On the menu that pops up, select 'Save As.'3. Select the appropriate file type (either CSV or XLS) from the drop-down menu at the bottom of the dialog box that opens up. Click on the 'Save' button.4. Import the file in dBase or FoxPro to make sure that everything worked appropriately and the data is in...
Thursday, April 21, 2011
How to Make a Word Search With Microsoft Excel
1. Make a list of the words that you want to appear in your word search. The number of words should correlate to the size of the word search: larger grids can contain more words than smaller grids. Relate the words to a common theme such as animals, colors or family members.2. Open Microsoft Excel. Select the rows and columns that you want to appear in your word search by clicking in box A1, holding down the mouse button, and dragging the cursor to highlight other boxes. For example, select boxes A1 through Y25 to make a square 25-by-25 word search.3. Click the 'Home' tab and select 'format'...
How to Set a Password on Excel 2007
1. Open the Excel spreadsheet to which you want to add a password. Click the Microsoft Office Button, select 'Save' and select a location to save the spreadsheet.2. Click the Microsoft Office Button, select 'Prepare' and choose 'Encrypt Document' from the list. An 'Encrypt Document' dialog box appears.3. Enter a password into the text box and click 'OK.' Confirm the password on the next menu by entering it again into the text box and click 'OK.' If you entered the password correctly, the dialog box will disappear. Save the spreadsheet aga...
Wednesday, April 20, 2011
How to Recover a Protected Password in Excel 2007
Excel 2007 Password (Software)1. Download Excel 2007 Password from the Last Bit website (see Resources). Double-click the downloaded installer to set up the application. Click quot;Startquot; then quot;All Programsquot; and quot;Excel 2007 Passwordquot; to open it.2. Click quot;Startquot; then click the folder icon to locate the Excel document you want to recover. Click quot;Open.quot;3. Wait for Excel 2007 Password to crack the password. If it is successful it will prompt you for payment to release your password to you; if it is not successful it costs nothing.Excel Key (Shareware)4. ...
How to Remove Excess Area in an Excel 2007 Graph
1. Move your cursor over the white space behind the graph until you see a cursor with four arrows in a cross.2. Click the mouse to select the 'Resize' function.3. Click on one of the circles located on the corners or sides of the graph and drag until the graph fills the chart area as desired. This will remove any excess white space in the cha...
How to Make a Guest List on an Excel Template
1. Open Excel. It doesn't matter if you are in a blank workbook or an existing spreadsheet. If you are using Excel 2003 or earlier, click 'File' and then 'New.' If you are in Excel 2007, click the Office button and then click 'New.'2. Type 'Guest List' into the 'Search Online' box in the 'Templates' section if you are using Excel 2003. In 2007, click 'Microsoft Office Online' under templates, and then type 'Guest List' into the 'Search Microsoft Office Online for a Template' box. Click 'Go.'3. Click on a template in the 'Search Results' box to preview it. When you have found the basic template...
Tuesday, April 19, 2011
How to Add a Bullet in Excel
1. Start Microsoft Excel and open a spreadsheet.2. Point to the cell that you want to add the bullet to with the mouse and double-click the left button to edit the cell.3. Hold down the 'ALT' key and press the '7' key on the number pad. When you release these keys, a bullet will appear in the cell. When using a laptop keyboard, an additional key may be necessary if it does not have a number pad. The key sequence for a bullet on a laptop is 'ALT' 'Fn' '7.'4. Hit 'ALT' then 'Enter' to go to the next line in a cell. Once your cursor moves to the next line, enter the bullet keystrokes...
How to Install Microsoft Excel Features
Microsoft Vista1. Click on the 'Start' button, then click 'Control Panel.'2. Click on 'Programs,' then click on 'Installed Programs.'3. Click on 'Excel,' then click 'Change.'4. Click 'Add or Remove Features' and 'Next.'5. Click on the Microsoft Excel features you want, then click on 'Upgrade' or 'Install Now.'Windows XP6. Click on 'Start,' then click on 'Control Panel.'7. Click on 'Add or Remove Programs,' then click 'Change or Remove Programs.'8. Click on 'Excel,' then click on 'Change.'9. Click 'Add or Remove Features,' then click 'Next.'10. Click on the Microsoft Excel features...
How to Use the Excel OnTime Method
Specific Time1. Click on the 'Developer' tab. If you do not see it, then click on the 'Microsoft Office' button. Click the 'Excel Options' button. Click on the 'Popular' tab. Check the 'Show Developer tab in the ribbon' check box. Click the 'OK' button.2. Click the 'View Code' icon in the Controls section.3. Type the following code:Private Sub Workbook_Open()Application.OnTime TimeValue ('13:00:00'), 'YourProcedure'End SubThis tells excel to run the procedure, or macro, named YourProcedure to run at 1 p.m.Lapsed Time4. Click on the 'Developer' tab.5. Click the 'View Code' icon in the...
Monday, April 18, 2011
How to Insert Footnotes in Excel 2003
1. Right-click on the cell that will link to the footnote. Select 'Hyperlink.'2. Click 'Place in This Document' when the 'Insert Hyperlink' menu opens.3. Enter the name of the cell that will include the footnote in the 'Type the cell reference' box. For example, if you were going to include the footnote in A27, you would type 'A27' here.4. Click 'OK.'5. Click on the cell (e.g., A27) that will include the footnote, and type the footnote information. The cell that you clicked on in Step 1 will now link to this cell when you click ...
How to Insert a Row in Excel 2007
1. Click on any cell in the row below the location where you would like to insert a new row. For example, if you'd like to add a row above row 11, click on a cell in row 11.2. Locate the 'Cells' group on the Microsoft Excel 'Home' tab. It is located at the upper-right-hand corner of the screen.3. Click on the 'Insert' drop-down button located in the Cells group (the first button displayed).4. Select the 'Insert Sheet Rows' opti...
How to Use Column Headings in Excel
How to Freeze Column Headings1. Start Microsoft Excel. Open the worksheet in which you want to freeze the column headings.2. Click inside of the first cell in the row just beneath the one containing the column headings.3. Go to the 'Window' menu in Excel 2003 and select 'Freeze Panes.' Go to the 'View' tab in Excel 2007 or 2010 and click 'Freeze Panes' in the 'Window' group. Select 'Freeze Panes' from the drop-down list. Excel freezes the rows above and the columns to the left of the cell you select, so if your heading is in 'Row 1' and you click inside cell 'A2,' only the first row will...
How to Calculate a Z
1. Open Excel 2007 and a blank spreadsheet.2. Enter all of your data in one column. Each separate piece of data should be in its own cell.3. Click on an empty cell within the spreadsheet and then calculate the mean of your data by entering an average function in the formula bar and hitting 'Enter.' The mean will be displayed in the empty cell. If your data was listed in cells B3 to B52, your function would look like this: 'Average (B3:B52).'4. Click on another empty cell within your spreadsheet and then calculate the standard deviation of your data by entering a standard deviation function...
Sunday, April 17, 2011
How to Set a Date Range in Excel
Set Start and End Dates1. Click any cell in an Excel spreadsheet, then click the 'Home' tab. Click the 'Short date' item from the dropdown list in the 'Numbers' panel. This tells Excel to display the number you entered in the cell as a date.2. Type any date in the cell you just formatted, in this format 'm/d/yyyy.' For example, type '1/1/2001.'3. Use the instructions from step 1 to format the cell two columns to the right of the first cell you formatted. Type the ending date of your range in this cell.4. Click in the cell that's in between the two cells containing your dates, then click...
How to Return to Normal View in Excel 2007
1. Right-click anywhere on the Excel 2007 screen. A menu will pop up.2. Use the cursor to highlight the 'Close Full Screen' option.3. Click on the 'Close Full Screen' option. Excel 2007 will immediately return to normal vi...
How to Disable Scientific Notation in Excel 2003
1. Highlight the column into which your list will go.2. Right-click anywhere in the highlighted column.3. Choose 'Format Cells...: from the drop-down menu.4. In the 'Number' tab, choose 'Text' from the 'Category' list. Import your da...
How to Create a Pivot Table From Multiple Sheets
1. Open the Excel workbook that has the worksheets you want to use to create a Pivot Table. Click a blank cell that you aren't using in the Pivot Table report.2. Start the Pivot Table and Pivot Chart Wizard by pressing the following keys 'ALT' 'D' 'P.' The Pivot Table and Pivot Chart Wizard box will open.3. Check the box next to 'Multiple consolidation ranges' under the question that asks 'What is the data that you want to analyze?'4. Check the box next to 'Pivot Table' when asked what type of report you want to create; click 'Next.'5. Check the box next to 'I will create the page...
How to Hide the Standard Toolbars in Office
1. Click 'Start' > 'All Programs' > 'Microsoft Office,' and then click on the MS Office program you want to use.2. Right-click on the blue question mark icon in the upper right-hand corner of the program window. The icon is on the same line as the 'Home' and 'Insert' tabs.3. Choose 'Minimize the Ribbon.' The ribbon disappears.4. Show the ribbon again by right-clicking the question mark icon and choosing 'Minimize the Ribbon.' (See the check mark next to 'Minimize the Ribbon' when minimize is activ...
Saturday, April 16, 2011
How to Recover an Excel File from Autosave
1. Open Microsoft Excel to enable the recovery features available in the Office 2010 suite.2. Recover a file you haven't yet saved. Select 'File,' and then 'Recent.' Choose 'Recover Unsaved Workbooks.' From the saved drafts folder that displays, choose your file and click 'Open.' Select the 'Save' icon and name your file to save it properly.3. Recover a previous version of a file to which you forgot to save changes. Open the file upon which you were working. From the File tab, select 'Info.' From the versions listed, select the one labeled '(when I closed without saving).' Click 'Restore'...
How to Move Excel Macros to Another PC
Copying the Workbook1. Determine where your macros are saved. You can save the macros you create in the workbook you are currently using or in your personal workbook. If you want to use your macros across different workbooks, you are most likely saving them to the personal.xls workbook.2. Copy the workbook where the macros are saved to your chosen storage medium.3. Copy the workbook to the new computer and start using your macros.Using the VBA Editor4. Copy the actual macros themselves from the Visual Basic editor.5. Go to Tools–Macro–Visual Basic Editor.6. Go to the Modules folder...
Friday, April 15, 2011
How Can I Get Rid of Page Breaks in Excel?
1. Select the worksheet that you would like to print. Select 'Page Break Preview,' in the View tab.2. Click the page break that you would like to delete. Click breaks within the page setup menu. 'Click 'Remove page break.'3. Click 'Select All' at the top left-hand corner of the worksheet. Scroll to the Insert menu Select 'Reset All Page Breaks.'4. Remove page breaks in the Excel for Mac version by rolling the mouse over the page break -- which is a dotted line. Click on it then go to the Insert Drop-down menu.5. Scroll down to and select 'Remove Page Break.' This removes the page break...
How to Change Text Case in Microsoft Excel
How to Change Text Case in Excel 20071. Open the Excel spreadsheet.2. Click on the cell that is next to the first data cell in the row of cells to be changed.3. Type in =Lower (cell#) to change the text to lower case. Type in =Upper(cell#) to change the text to upper case. Type in =Proper(cell#) to change the text to proper case.Example: In cell B6 type in: =Proper(A6) to change the text in the A column to proper case.4. Click 'Home' and then 'Fill>Down,' or click and drag down the row of adjacent cells to fill them with the text-case formula. The row should now contain the new text...
How to Include a Signature When Sending Excel Email As an Attachment Button
Create the Signature Line1. Open the Excel worksheet.2. Click on the worksheet where you wish to insert a signature line.3. Click the 'Insert' tab on the command ribbon.4. Click the down-arrow on the 'Signature Line' button in the 'Text' group. A drop-down list appears.5. Click 'Microsoft Office Signature Line.' A 'Signature Setup' dialog box opens.6. Type the information to appear under the signature line: suggested signer, suggested signer's title, suggested signer's email address and instructions.7. Select the check box for 'Allow the signer to add comments in the Sign dialog.'8....
How to Reduce the Size of an Excel Spreadsheet
1. Make a backup copy of the file you want to reduce.2. Open the Excel document and hit 'Ctrl' ' End' in each tab of the spreadsheet. You're looking for the last cell with data in it, in effect the lowest, right-most cell in the worksheet. For many sheets, this cell will be well outside of what you might have thought the spreadsheet contained.3. Select unused columns by clicking on a column header, then holding down the 'Ctrl' 'Shift' 'Right Arrow' keys. This will select all columns to the right of the one you selected, including the one you selected. Press the 'Delete' key.4....
How to Ungroup Worksheets in Excel
1. Start Microsoft Excel 2007 and open a workbook from your files that contains worksheets that are grouped together.2. Locate the worksheet tabs at the bottom left of the opened workbook. The sheet tabs that are white are the ones that are grouped together.3. Hold down the CTRL key on your keyboard and click on the sheet tab of the worksheet that you want to ungroup from the rest of the worksheet group. Once you do this, the worksheet will be turn back to its set color and become separated from the existing group.4. Release the CTRL key on your keyboard after you have ungrouped the worksheet.5....
How to Unprotect a Microsoft Excel Document
Microsoft Excel 20101. Click the 'File' tab and click 'Open.' Navigate to the file you want to unprotect, select the file and click 'Open.'2. Select the “Review” tab on the ribbon at the top of the screen, and click “Unprotect Sheet” from the Review menu.3. Enter the file’s password if prompted to do so.Microsoft Excel 20034. Click “File” on the toolbar and then select “Open.” Navigate to folder that contains the protected spreadsheet. Select the file and click “Open.”5. Select the “Tools” drop-down menu, select “Protection” and choose “Unprotect Worksheet.'6. Enter the file’s password...
Thursday, April 14, 2011
How Do I View Two Excel Spreadsheets on Two Screens?
1. Open the first document you wish to view through Excel. This will open your document on one screen.2. Click on the Start Menu at the bottom left of your computer screen, then open Microsoft Excel again. This will open Excel in a separate window.3. Click 'File' then 'Open' from the toolbar at the top of the Excel window, then find and open the second file you wish to view. You now have two files open, in two separate Excel windows. This makes it easy to click back and forth between files, plus copy and delete information as need...
How to Make a Flowchart in Microsoft Office
1. Open Microsoft Word from the 'Microsoft Office' folder under 'All Programs' in the Start menu. Select a new document in Microsoft Word.2. Click on 'Shapes' under the Insert tab to see a list of available shapes. The flowchart category has several shapes useful for creating flowcharts.3. Select a shape you like, and then click on the document to add the shape in that position. You can move the shape by clicking on it and then dragging across the document while holding down the mouse button. Edit your shape using the options available in the menu at the top, and add a text box if you want...
How to Make an Inventory Spreadsheet
1. Open your software. If you need automatic updates with SharePoint, use Excel 2010. If you are creating a simple list for insurance purposes, use a word processing program with tables or a spreadsheet program.2. Determine the data labels to include in your inventory spreadsheet. If you are doing a home inventory, for example, include 'Value' as a column heading, in addition to labels such as 'Item' and 'Serial Number.' For a retail inventory, create headings such as 'Wholesale Cost' and 'Retail Price.'3. Enter your column headings across the first row of your table. Set the first column...
Tuesday, April 12, 2011
How to Resize a Chart in Excel
1. Start Microsoft Excel 2007 and open an existing workbook that contains a chart or create a chart from existing Excel data.2. Click on the chart you want to resize so it is selected. A light blue outline will surround the chart when it is selected.3. Point to one of the corners or edges of the selected chart where you see three small dots. Your mouse will turn into a double-headed arrow when you hover over the areas that you can resize.4. Click with your mouse on the edge of the chart where you see the three areas and drag the mouse either outward (to make the chart larger) or inward...
How to Delete a Drop Down Box in Excel
Remove the Drop-Down Only1. Select the cells that have drop-down boxes.2. Click the 'Data' tab and choose 'Data Validation.'3. Remove the check in the box labeled 'In-cell dropdown.' Click 'OK.'Remove Data Validation4. Select the cells that have drop-down boxes.5. Click the 'Data' tab and choose 'Data Validation.'6. Select 'Any value' under 'Allow.' Click 'O...
How to Create a Floating Bar Chart in Microsoft Excel 2003
1. Set up your spreadsheet data with at least two rows of data. One of the rows of data will be what you actually want to show in the graph, and the other data set needs to have values that are less than the data set you want to show.2. Highlight the data set. Click on the 'Insert' menu at the top of the screen, and then click on 'Chart' to bring up the chart options.3. Click on the 'Bar' option from the list of chart type options on the left-hand side to bring up all of the bar chart options. Click on the 'Stacked Bar Chart' option, click 'Next' twice, and then click 'Finish' to build...
How to Solve Linear Programming in Excel
1. Set up the linear program in the form:Maximize c(transpose)xSubject to: Ax ≤ b, x ≥ 0where c, x, A, and b are matrices. The objective function can also be minimized or equal to some number z. The constraints are in linear form. X does not have to have a non negative constraint. These differences in the linear program depend on the specific problem. However, it is imperative that the linear program be set up correctly. Be sure to make all calculations for the cTx, Ax, and b matrices in Excel before you solve the linear program. You can begin by either setting all values of x to 1 or...
How to Sort by Cell Color
1. Click the first cell in the range of cells you want to sort. Drag down and across to highlight each of the cells that needed to be sorted by their color.2. Navigate to the tab labeled 'Data.' Click the 'Sort' button at the left side of the 'Sort and Filter' grouping.3. Click the 'Column' drop-down box underneath the 'Sort By' heading. Select the column in the range you want to sort.4. Select the 'Sort On' drop-down menu and choose 'Cell Color.' Click the 'Order' drop-down menu and select the color you want to sort by, such as 'Green' or 'No Cell Color.'5. Click the final drop-down...
Monday, April 11, 2011
How to Create a Loan Amortization Table in Excel
1. Download the free Amortization Schedule for Excel 1.6 spreadsheet program available by Vertex42 and CNET. The program is designed for the layman and makes it easy to create a loan amortization table that quickly visualizes the relationships between a loan's principal, its time period and interest rate. Once created, the table may be changed by adjusting any of these variables on-the-fly. The flexibility of this template makes it easy to see how the loan is affected by the occasional extra payment. It also demonstrates the consequences of a missed payment. The table supports all the popular...
How to Create Tabs in an Excel Spreadsheet
1. Open Microsoft Excel. There will be multiple tabs at the bottom with the name 'Sheet' and a number for each tab. Each of these tabs is a separate worksheet. Click on the tab to open that worksheet.2. Right-click on the tab and select 'Rename' to change the name on the tab.3. Add tabs to the file by right-clicking on a tab and selecting 'Insert.'4. Copy an existing worksheet as a new tab by right-clicking on a tab and selecting 'Move or Copy.' Choose where to place the new tab and select the copy check box to leave the original tab in its location.5. Rearrange tabs by dragging them...
How to Paste Special in Microsoft Word
1. Start Microsoft Word and open an existing file or start a new document.2. Copy the text you want to paste from another Word file or other application.3. Place your cursor in your open Word document where you want to paste the copied text.4. Right-click and choose 'Paste' from the shortcut menu. You can also use the keyboard shortcut of CTRL V to paste the text into the new location. After you paste, a clipboard will appear at the end of the pasted text.5. Hover your mouse over the clipboard until an arrow appears to the right of the clipboard.6. Click on the clipboard arrow to show...
Subscribe to:
Posts (Atom)