1. Start a new document and add data or open the document containing the data you wish to convert into a graph. Arrange the data with the item headers at the top of the column and data in the same column or the headers at the beginning of the row and the data to the right.2. Select the data you want to include in the graph.3. Click on the 'Insert' tab in the ribbon.4. Click on the down arrow under the 'Bar' graph icon.5. Choose the graph design you like the best. Your data will convert into a bar graph on the spreadsheet.6. Click on the 'Design' tab to change colors, layout, add a...
Browse » Home » Archives for December 2011
Wednesday, December 28, 2011
How to Lock Charts in Excel
1. Open the worksheet with the graph in Excel.2. Click the 'Review' tab and then click 'Protect Sheet.'3. Click 'Allow All Users of This Worksheet To' and then select the elements you want people to be able to change. For example, even though the chart is protected, you may want users to be able to format cells, insert rows or perform sort functions on the worksheet.4. Type a password into the 'Password to Unprotect Sheet' box and then click 'OK.' You need to type the password again to confirm ...
How to Calculate Age in Excel Using a Date of Birth
1. Open a new Microsoft Excel 2010 worksheet.2. Click on cell A1. Enter the birth date of the person whose age you want to know. You can enter a date with dashes between the numbers, such as '3-30-1983.'3. Click on cell B1 and enter this formula:=datedif(A1,today(),'y')In this example, 'A1' refers to the cell where you typed in the person's birth date. 'Today()' calls the current date on the machine. 'Y' indicates that Excel should give the result in years. Press 'Enter' on your keyboard to complete the formula entry, and the person's age will appear in cell ...
Tuesday, December 27, 2011
How to Delete an Embedded Chart in Excel
Delete an Excel Chart Object1. Launch Microsoft Excel. Click the “File” tab followed by “Open” and open the workbook document that contains the embedded chart.2. Click the chart object to select and highlight the item. After it is highlighted, Excel displays a box around the chart with “handle” dots around the edge of the box.3. Press the “Delete” or “Del” key on your computer keyboard to delete the embedded chart.Delete an Excel Chart Sheet4. Highlight the chart sheet in the Excel workbook document.5. Click the “Home” tab on the main menu ribbon across the top of the document.6. Click...
How to Import Excel 97 Macros to Excel 2003
1. Click 'Start' > 'All Programs' > 'Microsoft Office' > 'Microsoft Excel' to open Excel 2003.2. Click 'File' > 'Open,' browse through your computer files to find the Excel 97 worksheet you want to import, select the file and then click 'Open' to open the Excel 97 worksheet in Excel 2003.3. Click 'Tools' > 'Macro' > 'Security' to access the macro security options in Excel 2003.4. Select the 'Medium' security setting to ensure that you are able to access most of the safe macros on any file but avoid accessing potentially harmful macros.5. Click 'OK' to save the new security...
A Tutorial to Sort in Microsoft Excel
Excel 20031. Open the file in Excel 2003 with data that you would like to sort.2. Highlight the data that you would like to sort. If you want to sort the entire worksheet, click the small rectangle located in the top-left corner between the 'A' column and the '1' row.3. Click 'Data' from the drop-down menu located above the toolbar.4. Click 'Sort.'5. The 'Sort' dialog box is displayed. Specify which column you would like the data sorted by first, second and third.6. Specify if you want the data sort in ascending (alphabetical or number sequence low to high) or descending (reverse...
How to Move a Picture, Text Box or Other Object in PowerPoint, Excel or Word Exactly Where You Want it
Removing Word Restrictions1. Launch the Word 2010 document that contains the object that you want to move.2. Click the object, and then click the 'Format' tab on the far-right end of the Word ribbon.3. Click the 'Arrange' button in the ribbon. Select 'Wrap Text' from the menu that appears. Then choose 'Through,'Behind Text' or 'In Front of Text.' Any of these three options release the object so that you can click on the object's border and move it where you want.Removing PowerPoint Restrictions4. Open the PowerPoint 2010 presentation that contains the object you want to move.5. Click...
How to Create Axis Bar Graphs in Excel
1. Open Microsoft Excel. Start with a new document or load an existing spreadsheet with data you wish to analyze.2. Organize the data in a row structure. If you are creating a new spreadsheet, type different items of the same data set over many rows within the same column. For example, if you wish to graph daily temperature changes, create a column heading called 'Temperature' in cell A1. Then, type each day's weather below it in cells A2, A3 and on down through column A. Do not skip any rows.3. Click on any cell within the data column so Excel recognizes the active set of data. It is not...
Monday, December 26, 2011
How to Copy a Worksheet As a Picture in Excel 2007
1. Highlight the area that you want to copy as a picture. Click in the uppermost left cell and drag to the lowermost right cell while holding down the mouse button.2. Click the 'Copy' drop-down menu on the 'Home' tab. Select the 'Copy as Picture' option. This action will launch a separate dialog window.3. Select 'As shown on screen' to copy the selection as a screen shot, or select 'As shown when printed' to copy the selection as it would appear printed on a page. Select the 'Picture' option to copy the worksheet as a scalable image, or select 'Bitmap.' The 'Bitmap' copy will result in more...
How to Prevent Excel From Dropping Off Leading Zeros
1. Open your Microsoft Excel document or a new Excel document.2. Select the cells you would like to modify. If you wish to modify the entire spreadsheet to show leading zeros, click the diamond icon in the upper left of the workbook window, or click the 'Edit' drop-down menu and choose 'Select All.' If you want to select only a portion of the cells, click the leading cell and drag to highlight additional cells. Also, you can click the letter at the top of a column to highlight an individual column. You can do the same for rows by clicking the number at the beginning of a row.3. Select the...
Sunday, December 25, 2011
How to Create a Pivot Table From Multiple Pivot Tables
1. Open the PivotTable you would like to work with. Also open a worksheet you would like to consolidate all other pivot table information onto from one PivotTable.2. Click on a cell with the new worksheet where you want to start the consolidated data.3. Click 'Consolidate' on the Data menu.4. Click on 'Sum' (or another function) in the Summary function in the Function box. This is the function you want Microsoft Excel to use to consolidate the data.5. Input the sheet tab of the first range to consolidate in the Reference box and repeat for each PivotTable you want to grab information...
How to Remove Encryption in Excel 2007
1. Open the encrypted spreadsheet in Excel, which will require your password.2. Click the circle in the upper-left side of the Excel window. This will appear just before 'Home' on the menu and will have a Windows logo inside. In the drop-down menu, select 'Prepare' and then 'Encrypt Document.'3. Delete the password in the window entitled 'Encrypt Document.' Press 'OK' to remove the password from your spreadshe...
How to Add a Note to an Excel Formula
1. Open an Excel file with existing formulas or create your worksheet with at least one formula.2. Click in the cell at the end of the formula. For example, click within cell A5. Then type the formula '=A2 A3' (without quotes).3. Go to the 'Ribbon' at the top of Excel and click on 'Review.' Click on 'New Comment.' A colored text box will appear to the right of cell A5.4. Start typing your comment after the username that appears. When finished typing, click another cell. The cell with a comment will contain a red triangle. Move your mouse over the cell to reveal the comment.5. Alternatively,...
How to Remove a Drop Down Box in Excel 2003
1. Click inside the cell from which you want to remove the drop-down list box. Do not double-click, as this will take you into the cell editing mode; just use a single left click.2. Select the 'Data' menu from the top menu bar, and then click the 'Validation' option in the menu that opens.3. Click the 'Settings' tab in the data validation dialog box.4. Click 'Clear all' and then select 'OK'. Your drop-down list will be delet...
How to Open a Xlsx File
Microsoft Excel1. Launch Microsoft Excel. Click “Start,” “All Programs” and “Microsoft Office.”2. Choose “Microsoft Excel” so that the program will start. A new spreadsheet will open.3. Go to the ribbon and click the “File” tab. Select “Open” from the menu so that a dialog window appears. Select “My Computer” on the left, browse to find your XLSX file, then click “Open” so that it will load inside the programOpenOffice Calc4. Launch the OpenOffice spreadsheet. Click “Start,” “All Programs” and “OpenOffice.org”5. Choose “OpenOffice.org Calc” so that the program will start. A new spreadsheet...
How to Combine Columns in Access
1. Open the database you want to update in Access.2. Go to the Database window and choose 'Query' from 'Objects.' Then select 'Create query in using wizard.'3. Click the 'Tables/Queries' drop-down in the wizard and select the first table containing the columns you need.4. Select the fields (columns) you want to add. To add a single field, click the '>' button. To add all the fields, click the '>>' button.5. Click the 'Tables/Queries' drop-down and choose the next table containing the columns you want to combine. Then follow step four to add the fields. To add additional columns...
Saturday, December 24, 2011
How to Show a Comment Box in a Cell With a Drop Down List in Excel
1. Open the Microsoft Excel application on your computer, then open a file. Create a list of entries for the drop-down list in a single column.2. Select the cell where you want the drop-down list to appear. Click on the 'Data' option from the top toolbar menu.3. Click on the 'Validation' option then click on the 'Settings' tab. Click on the 'List' option from the 'Allow' box.4. Enter a reference to your list in the 'Source' box. Click on the box next to the 'In-cell drop-down' field so it's selected.5. Click on the 'Input Message' tab. Click on the box next to the 'Show input message...
How to Find Probability in Excel 2007
1. Open Excel 2007 and select the 'Formulas' tab.2. Click on the icon for 'Other Formulas.' A pop-out menu will show up. Select 'Statistical Formulas' from the pop-out menu.3. Select BINOMDIST. A dialog box will appear with four fields.4. Enter the number of successful tests in for the first field.5. Enter the number of trials in the second field.6. Enter the probability of success for a given success in the third field.7. Enter TRUE or FALSE in the fourth field. Use TRUE if the probability distribution is cumulative, and FALSE if it's not.8. Read the result from the bottom of...
How to Combine Bar Graphs in Excel
1. Open the document with the data that you would like to combine into one bar graph. If you have created any graphs or charts at this point, delete them by right-clicking and selecting 'Delete.'2. Highlight only the data for the first graph. For example, if you wanted to combine the 'Expenses' and 'Profit' graphs together, only highlight one of those pieces of information.3. Click 'Insert' and choose 'Bar' from the 'Charts' group. Choose the specific type of bar graph that you would like. It should appear to the right of the information you highlighted.4. Highlight the second set of data,...
How to Attach Macros to All in Excel
1. Click 'View' and then click 'Macros.'2. Click 'Record' macro to open the Record Macro window.3. Click the arrow underneath 'Store macro in:' to open the drop down menu.4. Click 'Personal macro workbook' to store the macro in the Personal.xls workbook. The macro will be available for use in any workbo...
How to Create an Invoice in MS Excel
1. Navigate to the Microsoft Office templates website. This will display a list of invoice templates (blank, preformatted documents with categories that that you can fill in).2. Click on the name of the template you would like to use.3. Click on the 'Download' button on the next page. You will need to accept the Microsoft Service Agreement by clicking on the 'Accept' button. The document will download to your computer.4. Open Microsoft Excel. Click on 'File' and then 'Open' in Excel 2003; in Excel 2007, click on the 'Office' button and then click 'Open.'5. Find the downloaded template...
How to Replace Text in Excel 2007
1. Open the Microsoft Excel 2007 spreadsheet that you want to replace text for. Click on any cell in the spreadsheet.2. Click on the 'Home' tab and then click on the 'Find and Select' option from the 'Editing' group.3. Click on the 'Replace' button. Enter the text that you want to find in the 'Find what' text box and then enter the text you want to replace that with into the 'Replace with' text box.4. Click on the 'Options' button to define your search by selecting specific rows or columns, to search for case-sensitive data, or to match the entire cell contents.5. Click on the 'Replace'...
Friday, December 23, 2011
How to Open Word or Excel in a Specific Program
Open an Excel Document in Another Specific Program1. Start Microsoft Excel.2. Click the 'File' tab and then click 'Options' under 'Help.'3. Click 'Save,' then click 'Save files in this format.' Under 'Save Workbooks,' select a default format from the list and then click 'Save.'4. Start the specific program and then open your file with the new default format.Save and Then Open a Word Document in Another Specific Program5. Start Microsoft Word, click the 'File' tab and then click 'Open.'6. Click 'OpenDocument Text' from the 'File of type' list.7. Select the Word file you want to open...
How to Add a Pointer to Table in Excel 2007
1. Open the Excel file that contains the table to which you want to add the pointer.2. Click the 'Insert' tab on the Excel Ribbon.3. Click the 'Shapes' button. Click one of the arrow icons in the 'Lines' section to select it.4. Click and drag your mouse from a space on your Excel worksheet to the cell in the table to which you want the arrow to point.5. Click and drag the pointer's circular resize handles to resize the arrow to an appropriate length. Hover over the arrow you inserted with your mouse until a four-way arrow appears. Click and drag the arrow if you want to move or reposition...
How to Create a Check Register in Excel
1. Label columns A through G in the first row, as follows: cleared, date, check #, item description, debit, credit and balance. Highlight columns E, F and G (debit, credit and balance) and right-click to 'Format cells...' and adjust these columns to represent currency. Column B can be adjusted for date format in the same manner.2. Extend the width of these columns as far as you need by clicking on the right edge of the column and dragging toward the right. For example, the 'item description' column will need to be much longer than the 'cleared' column.3. Key in your first entry as 'starting...
How to Count Duplicate Value in Excel 2003
1. Double-click the Excel 2003 XLS file on your hard drive. The file loads in the Excel 2003 software for you to edit its content.2. Click an empty cell in the column directly after your document information. Type the following function in the empty cell:=IF(COUNTIF(A2:A7,A2)>1,1,'')Replace the cell ranges with the cells you want to check for duplicates.3. Click another empty cell and type '='. This triggers the 'function' feature in Excel. Select 'Sum' from the 'Function Name' drop-down and highlight the column used previously to detect duplicates. Press 'Enter.' The result is the sum...
How to Remove All Macros in Excel 2007
1. Open up your spreadsheet workbook in Microsoft Excel.2. Press (ALT) (F11). This will open up the VBA editor.3. Right-click on the module associated with the macro. You'll find all of the modules that are active in your current spreadsheet in the upper left-hand corner.4. Select 'Remove Module X,' where 'Module X' will be the name of the module you want to remove. Excel will ask if you would like to export Module X. Click 'No.'5. Repeat steps three and four until you've removed all of the modules associated with your workbo...
Thursday, December 22, 2011
How do I Delete Control From Excel Spreadsheet at Runtime?
1. Click the Office Button, then click 'Excel Options'.2. Select the 'Popular' category and check the 'Show Developer Tab In The Ribbon' box. Click 'OK'.3. Open the Developer tab and click 'Design Mode'.4. Find the control you want to delete. It will be surrounded by a border, either simple and thin, or thick and dotted, depending on whether or not it is an ActiveX control. Click on this border to select the control.5. Press the 'DELETE' key on your keyboa...
How to Rotate a Worksheet in MS Excel 2003
1. Select the entire table you want to rotate by left clicking at the top, left cell, dragging the mouse down to the bottom, right corner, and releasing.2. Press 'Ctrl' and 'C' at the same time to copy your table.3. Select a cell somewhere outside of the table you're rotating. You can even select a cell on a different worksheet entirely.4. Click the black, down arrow under 'Paste' in the Clipboard section of the Home tab. Select 'Paste Special.'5. Click the 'Transpose' check box, then click 'OK' to paste the transposed da...
How to Create an Email Distribution Mailing List in Excel
1. Open Microsoft Excel. Start with a new blank document.2. Type column headers across row one. Your emails created from the distribution list can include any type of personalized information you desire. The most important column that must be included is the actual email address, so be sure one column header says 'Email' or 'Email address' to make this clear. Alternately, you may include first and last names or other information that will be unique for each email.3. Enter the data for each recipient on a separate row. The first recipient in the email distribution list will be listed on row...
Wednesday, December 21, 2011
How to Calculate Subtotal
Calculating a Subtotal in a Few Easy Steps1. Obtain a data set. This means that you need to have a set of numerical values listed. Using the example of a checking account deposit, this would be the checks and/or cash amounts that you need to deposit. Deposit slips have blank boxes for you to fill in these values.2. Write your values down. For instance, you may have a check for $50.27, a check for $85 and $75 in cash that you wish to deposit. In the section for checks on your deposit slip, you would write 50.27 and 85.00. In the blank section for cash, you would record 75.00.3. Add your data...
How to Set the Defaults for an Excel Comments Box
Set Excel Comment Defaults in Windows XP1. Right-click the desktop, avoiding any icons. Select 'Properties' to open the 'Display Properties' dialog box.2. Go to the 'Appearances' tab. Click the 'Advanced' button to open the 'Advanced Appearance' dialog box.3. Select 'Tooltip' from the 'Item' list near the bottom of the dialog box.4. Select the new default color for Excel comments in the 'Color1' box. Choose a default font in the 'Font' box, a font size in the 'Size' box and a font color in the 'Color' box.5. Click 'OK' to apply the changes. Close any open dialog boxes.Set Excel Comment...
How to Find Cells With Strikethrough in Excel
1. Open Microsoft Excel. Hold the 'Control' key and press the 'F' key on the keyboard. The combination opens the'Find' function.2. Click on the 'Format' button in the 'Find and Replace' window. Click on the 'Fonts' tab.3. Check the 'Strikethrough' checkbox in the 'Effects' section and click the 'OK' button.4. Click the 'Find all' button in the 'Find and Replace' window.5. Look at the bottom of the 'Find and Replace' window. All the cells with 'Strikethrough' are listed at the bottom of the wind...
Tuesday, December 20, 2011
How to Convert Hours to Seconds in Excel
1. Open a new workbook in Microsoft Excel.2. Enter the time in a blank cell such as 6:20:35 in A1.3. Click on a blank cell and enter the following formula: =(HOUR(cell)*60*60) (MINUTE(cell)*60) SECOND(cell), where cell refers to the cell reference that contains the time. The formula extracts the hour, minutes, and seconds from the time. It multiplies the hours by 60 to convert into minutes, then multiplies by 60 again to get seconds. The minutes are multiplied by 60 to get the seconds, and the seconds are added to the calculation to get the total seconds.For example, the formula =(HOUR(A1)*60*60)...
How to Change the Password in Excel
1. Open the Excel spreadsheet you want to edit. If the file already has a password configured, enter the password and click 'OK.'2. Click 'File' in the main menu toolbar and select 'Save As.' In the window that opens, click the 'Tools' button to open a dialog box for advanced settings.3. Click 'General Options.' In the text box labeled 'Password to modify,' enter a new password for your Excel file. Press 'OK.'4. Click 'Save' to save your new password settings. The Excel file saves to the hard drive and the password is modifi...
How to Convert Phone Numbers in MS Excel
1. Open Microsoft Excel. Open the file you’d like to work on by going to “File”, then “Open,” or begin a new workbook using the blank workbook that opens by default.2. Select the cell that has the numbers typed to be converted to a phone number format. If you have multiple cells that need to be converted, select them all by holding the left mouse button and dragging the mouse.3. Locate the “Format” option on the toolbar and click once. This will bring up a drop-down menu. Click on “Cells” to bring up a formatting box. You can also pres “Ctrl” “1” to bring up the box.4. Click “Special”...
Monday, December 19, 2011
How to Remove a Title Chart in Excel 2003
1. Open the Excel 2003 chart that contains the title you wish to delete.2. Click the chart title once.3. Hit the 'Delete' key to delete the chart title in Excel 20...
Excel Macro Online Tutorial
1. Navigate to the Brown University Excel macros tutorial listed in References. The guide walks you through running macros, creating macros, and running macros using toolbar buttons and shortcut keys. The guide offers plenty of examples and an advanced section on how to edit macro code. The instructions for creating and running the macros are applicable to Excel 2003, but the concepts are the same for Excel 2007.2. Go to the Help With PCs website listed in the References section. This website includes an Excel macros tutorial, complete with screen shots to help you see what actions you are...
How to Remove a Sort in Excel 2007
1. Click the 'Office' button at the top left of the Excel interface, then click 'Excel Options,' 'Popular' and 'Edit Custom Lists.' In versions of Excel earlier than 2007, click 'Tools,' 'Options,' then 'Custom Lists.'2. Click the list you want to delete to select it.3. Click 'Delete,' then click 'O...
How to Sort by Time in Excel 2007
1. Place titles in the top boxes of every column that you wish to fill. For example, if you are listing phone calls, you might want to list the time, date, name and length of the call.2. Format each column by clicking on the first box under the title box and then holding the 'Shift' key while you press the 'down' arrow. When the number of boxes you will be use are selected, choose the 'Home' tab to see the 'Numbers' group. Click 'Time' for the time column. The rest of the columns can be formatted in the same way but use the option of 'Date' or 'Number.'3. Highlight the column again to choose...
Sunday, December 18, 2011
How to Enable Macros in Microsoft Excel 2007
1. Click the Microsoft Office button located in the upper left corner of the computer screen.2. Select 'Excel Options' from the menu.3. Click 'Trust Center' to open the 'Excel Trust Center.'4. Select 'Trust Center Settings.'5. Click 'Macro Settings' to modify the settings for macros within Microsoft Excel 2007.6. Select 'Enable all macros' to allow all macros in your spreadsheets to r...
How to Make a Line Graph That Compares Two Things in Excel
1. Open a new Microsoft Excel 2010 spreadsheet.2. Click on cell 'B1.' Enter the name of the first set of data you want to include in your graph. This name will appear as a label next to the line on the graph. Click on cell 'C1' and do the same for the second set of data.3. Click on cell 'A2.' Enter the X-axis labels into the cells in this column. While the 'Y-axis' in a line graph is always numerical, the X-axis can display numbers, dates, times or even text.4. Enter your data into the cells just under the headers in columns 'B' and 'C.'5. Click any cell in your data table. Select the...
Saturday, December 17, 2011
How to Divide Excel Pivot Table Data Into Separate Spreadsheets Within the Same Workbook
1. Click on the worksheet in the Excel file that contains the Pivot Table. You can do this by clicking the appropriate worksheet tab at the bottom of the spreadsheet window.2. View the Pivot Table and identify the summary calculations along its right side. Pivot Tables can create many different types of calculations, but all are based on the groups indicated in the Pivot Table, and the results of these calculations appear to the right of each group's row.3. Double-click a result calculation in a single row of the Pivot Table. All the records from the original spreadsheet that comprise that...
How to Convert Numbers to Words in Excel
1. Open Microsoft Excel.2. Press the 'Alt' and 'F11' keys simultaneously to start the Visual Basic Editor.3. On the Insert menu, click 'Module' and type the following code into the module sheet (Note: Omit the '*').Option Explicit'Main FunctionFunction SpellNumber(ByVal MyNumber)Dim Dollars, Cents, TempDim DecimalPlace, CountReDim Place(9) As StringPlace(2) = ' Thousand 'Place(3) = ' Million 'Place(4) = ' Billion 'Place(5) = ' Trillion '' String representation of amount.MyNumber = Trim(Str(MyNumber))' Position of decimal place 0 if none.DecimalPlace = InStr(MyNumber, '.')' Convert cents...
How to Create a Pie Chart in Excel That Illustrates a Portion That Contributes to a Total
1. Open Microsoft Excel. Click into the first cell on the spreadsheet, A1. Type the first sector of items to calculate for the pie chart, such as 'Cats.' Press the 'Enter' key to drop to the next cell, A2. Type the next item, such as 'Dogs.' Continue entering items until all are listed.2. Click into cell B1. Type the number to use for the pie chart calculations, such as '100.' Press the 'Enter' key to drop into cell B2 and type the number corresponding with the entry in column A. Repeat until all of column A's cells have numbers in column B.3. Highlight all of the cells you just entered....
How to Change Color of Selected Cells in Excel 2007
Manual Color Change1. Highlight the selected cells you wish to change color. Hold the left mouse button down while running your mouse pointer over the selected cells, provided the cells are continuous. If the cells do not touch each other and are more selective, you can hold the Ctrl (Control) button as you click each cell you wish to highlight.2. Select the 'Home' tab on the top tool bar. Underneath 'Home' should be seven sections, with labels on the bottom of each section. The section names should be: 'Clipboard,' 'Font,' 'Alignment,' 'Number,' 'Styles,' 'Cells' and 'Editing.'3. Click...
How to Link Excel Charts to Powerpoint
1. Click the 'Start' button on the lower left corner of your screen, and point your cursor to 'All Programs.' Scroll down, and click 'Microsoft Office' in the alphabetical list of your programs, then 'Microsoft PowerPoint.'2. Click the 'Insert' tab on the ribbon on Microsoft PowerPoint 2007. If you're using PowerPoint 2003, click the fourth menu item, labeled 'Insert,' on the upper left side.3. Click 'Object' on the right side of the ribbon if you're using PowerPoint 2007 and 'Object' in the 'Insert' menu if you're using 2003.4. Click the second radio button on the left, labeled 'Create...
How to Create a BOM Using MS Excel
1. Start Excel by double-clicking the Excel icon on your taskbar or desktop, or click 'Start,' point to 'Programs' or 'All Programs' and select 'Microsoft Excel.'2. Go to the 'File' menu in Excel 2003 and select 'New' or click the 'Office Button' in Excel 2007 and select 'New.'3. Type 'bill of materials' into the 'Search Office Online' under 'Templates.' Click 'Go' or press 'Enter.'4. Select the BOM template you want to use. Click 'Download.' The template opens as a new Excel worksheet. Go to the 'File' menu in Excel 2003 or the 'Office Button' in Excel 2007 and click 'Save As.' Enter...
How to Remove Cells with Zeros from Excel 2007
1. Click 'Alt' and 'F11' to open the Visual Basic Editor (VBE).2. Click 'Insert' and then click 'Module.'3. Cut and paste the following code into the blank window:Sub CleanZeros()Dim c As RangeFor Each c In ActiveSheet.UsedRangeIf c = 0 And Len(c) > 0 Then c.DeleteNext cEnd Sub4. Press 'F5' to run the mac...
Friday, December 16, 2011
How to Share an Excel 2003 Spreadsheet With Multiple Users
1. Open Excel 2003 by clicking the program's icon on your computer's desktop or by selecting the program's name on the “All Programs” menu.2. Click “File” followed by “Open.” Navigate to the directory containing the spreadsheet you want to share with other users. Double-click the spreadsheet's file name to open the file.3. Click “Tools” and select “Share Workbook.” The “Share Workbook” dialog box will open.4. Click the check box next “Allow changes by more than one user at the same time.”5. Click the “Advanced” tab, if you want to change the default settings related to sharing a spreadsheet.6....
How to Add Minutes Seconds
1. Add the minutes and the seconds separately.Add up all the minutes and separately add up all the seconds. For three values as follows, two minutes and 33 seconds, 12 minutes and 10 seconds and 17 minutes and 23 seconds, the total minutes is 31 and the total seconds is 66.2. Divide the total number of seconds by 60 to convert the seconds into minutes. In the example, 66 divided by 60 is one minute, six seconds.3. Add the minutes and the seconds. The total is 32 minutes, six secon...
How to Use the Microsoft Excel Program
1. Create a chart or graph from information on a spreadsheet. Select the cells to be included in the chart. In Excel 2003, click the 'Chart Wizard' button on the toolbar. In Excel 2007, go to the 'Insert' tab of the ribbon and select a type of chart. Or press the 'F11' key to create an instant, basic chart.2. Format the chart by right clicking it and selecting 'Chart Type' to change the type or subtype of the graph. Right click and select 'Format Plot Area' to alter the chart background.3. Make a header or footer for the spreadsheet. In Excel 2003, go to the 'View' menu and click 'Header...
How to Make a Graph on Excel With Intervals of 0.5
1. Open the Excel 2010 spreadsheet file that contains the data you want to make into a graph.2. Click on any cell within the data field that you want to use in your graph, then click the 'Insert' tab at the top of the window. Click on your desired chart type from the Charts area of the ribbon, then click on the specific chart that you wish to create. Excel will place the chart in the middle of your spreadsheet.3. Click on any of the white space in the chart to select the entire chart, then click the 'Layout' tab at the top of the screen. Click the drop-down box on the left end of the ribbon...
How to Make a List with Colors Using Microsoft Excel 2007
1. Open Excel 2007 and enter data into your spreadsheet. Make sure that you include a few rows and columns as you add your data.2. Highlight a few rows of data and click the 'Home' tab. Click the 'Fill Color' icon in the 'Font' group. Select a color for these cells.3. Highlight the remaining rows of data. Click the 'Home' tab and select the 'Fill Color' icon. Select a different color for this set of cel...
Thursday, December 15, 2011
How to Use Excel Dashboard
1. Open Excel.2. Download or create your data as an Excel spreadsheet, with the first row containing the column names. Select 'Save As' in the 'File' menu, name your file, and click 'Save.' Select 'Exit' on the file menu to close the Excel program.3. Open the Excel Dashboard program. Select the 'Excel' button. The driver field will auto-fill. Select the 'Access/Excel File' button. Select the file name, and the 'Connect Name' will auto-fill.4. Select 'New Blank Dashboard' in the 'Choose Action' box. Name the dashboard. Select 'OK.' Expand the menu in the 'Table Browser' window. Double-click...
Wednesday, December 14, 2011
How to Sort Data in Excel 2003
1. Open the Excel 2003 file that contains the information you need to sort.2. Click and hold on the top left cell in the data that you want to sort. Drag the mouse to the bottom right cell and release the button. Your selected data will now be highlighted in a different color.3. Click 'Data' on the right side of the toolbar on the top of the window. Choose 'Sort' from the drop-down menu to open the 'Sort' window.4. Click the drop-down arrow next to 'Sort By' and select the column that you want to sort by. You can also choose to sort the data further by selecting additional columns in the...
How to Open a 2003 Excel Workfile From 2007 Excel
1. Launch Excel 2007.2. Click the Microsoft Office button in the top left corner of Excel.3. Click 'Open.' This brings up a list of files in your default directory. Find the directory where your Excel 2003 file resides if it is not displayed in the default list.4. Double-click the Excel 2003 file to open it. If you do not see your Excel 2003 document in the list, click the down arrow on the button that says 'All Excel Files,' and select 'All Files' or 'Excel Files' instead. The Excel 2003 file opens in Excel 20...
How to Sort Numbers Dashes in Excel
1. Launch Microsoft Excel 2010.2. Right-click on the letter 'A' above the first column and click 'Format Cells' from the context menu. Click the 'Number' tab and click 'Text' in the 'Category' box. Click 'OK' to save the setting and change the way Excel treats column 'A' to text. This allows you to enter and sort numbers that contain dashes.3. Click the first cell in the first column, or Cell 'A1.' Type '100' and press 'Enter' to save the contents of the cell and move to the next cell down.4. Type '1200' in the second cell and press 'Enter.' Continue to enter the following series in the...
Tuesday, December 13, 2011
How to Remove Duplicates from Excel Macro
Build a Macro to Remove First Column Duplicates1. Browse to Tools on the toolbar and down to Macro. To the right, find the Visual Basic Editor and left-click on it. Once in the Visual Basic Editor, find the drop-down that allows you to create a User Form, Module or Class Module. Choose 'Module.'2. Copy and paste the following into the editing box that opens:Sub DelDups_OneList()Dim iListCount As IntegerDim iCtr As Integer' Turn off screen updating to speed up macro.Application.ScreenUpdating = False' Get count of records to search through.iListCount = Sheets('Sheet1').Range('A1:A100').Rows.CountSheets('Sheet1').Range('A1').Select'...
How to Create Bar Codes in Excel
Determine Requirements and Install Bar Code Font1. Determine font requirements. Bar code type determines font requirements. Add-ins covering a number of font types is available but can be costly so a better idea is to purchase either a general-purpose font, or a font specific to the bar code you need. Common bar code fonts include:Code 39 -- General-purpose bar codeCode 128 -- Used as the basis for Health Industry and Blood Bank bar codesUCCEAN -- International bar code typically used for shipping/receivingITIF14 -- Used to mark external containers of products with an EAN (European Article Numbering)...
How to Use Subtotals in Excel 2003
1. Open your Excel worksheet with your data arranged in columns.2. Select the column you want subtotaled. Hold down the left mouse button and drag down the column.3. Under 'Data' on the top menu, select 'Subtotal' from the dropdown menu.4. In the 'Subtotal' pop-up window that appears, check the features you want in your subtotal, and then click 'OK.'5. A subtotal of your numbers will appear on the worksheet. Save your wo...
How to Fix a Corrupt XLS File
1. Locate the file that requires repair. For best results, copy the corrupt file to a stable hard drive, if it is located on removable media or on a networked device.2. Click 'File->Open...,' (Excel 2003), or the 'Office Button,' then 'Open.' (Excel 2007).3. In the 'Open' window, select the corrupt file.4. Click the drop-down arrow next to the 'Open' button, and select 'Open and Repair' from the menu. Excel will open the file in 'File Recovery' mode and attempt to repair the corrupti...
How to Create Labels From Excel
1. Open a blank Excel worksheet. Go to the 'Page Layout' tab of Excel 2007 and select 'Margins.' In Excel 2003 or earlier, go to the 'File' menu, select 'Page Setup' and go to the 'Margins' tab.2. Change the 'Top' box to '0' and leave the header at '0.5.' Change both the left and right margins to '0.19.' Change the bottom margin to '0' and leave the footer at '0.5.' Select 'Horizontally' and 'Vertically' under 'Center on Page.' Click 'OK' to apply these changes.3. Select cells A1 through A10. If you are using Excel 2007, click the 'Format' dropdown of the Home tab and select 'Row Height.'...
Monday, December 12, 2011
How to Validate Data in Excel
1. Know the types of data that you can validate in an Excel spreadsheet. Numbers, dates and times and length can be limited to whole numbers, or ones including decimals, be a minimum or maximum amount or within a range.2. Use a list of values for the cell. This is helpful when categorizing items with a specific list of data or when the cell always contains one choice such as small, medium or large.3. Decide if you want the user to view a message when the cell is selected prior to them entering data (input message) or when incorrect data is entered (error message.) Error messages can simply...
Sunday, December 11, 2011
How to Reset the Excel Document Password
1. Open the worksheet that you wish to change or remove the password for. Enter the password when prompted.2. Select the 'File' menu to open a left-hand menu pane.3. Click 'Info.'4. Click 'Encrypt Workbook' next to 'Permissions.' Another menu will show up.5. Choose 'Encrypt with password.' A password encryption window will appear and the other menus will close.6. Remove the password by clearing the 'Password' field and selecting 'OK.' Modify the password by typing in a new one in the 'Password' field, then selecting 'O...
How to Make a Pie Chart in Excel 2003
1. Enter the data labels into the cells in one column or row of the Excel worksheet. Enter the data into corresponding cells in the next column or row.2. Select the data by depressing the left mouse button and dragging the mouse pointer over the cells.3. Go to the 'Insert' menu and select 'Chart' or click the 'Chart Wizard' button on the standard toolbar to start the 'Chart Wizard.'4. Select 'Pie Chart' as the chart type. Choose a subtype, such as 'Exploded Pie' or '3-D Pie.'5. Click 'Next.' Make any other changes or additions in the wizard as desired. Click 'Finish' to complete the...
How to Remove Page Breaks From Excel 2007
1. Open the Excel file in which you'd like to remove a page break. Click the 'View' tab at the top of the screen.2. Click 'Page Break Preview' in the 'Workbook Views' group. This allows you to see your manual page breaks.3. Click the row or column label after the page break you wish to delete. As an example, to delete the page break between columns E and F, you would click the top 'F' column label, which selects the entire F column. Likewise, click the '20' row label to select the page break between rows 19 and 20.4. Click the top 'Page Layout' tab.5. Click 'Breaks' in the 'Page Setup'...
Subscribe to:
Posts (Atom)