Sunday, August 28, 2011

How to Plot a Time vs. Growth Graph in Excel 2007


1. Open Microsoft Excel 2007.
2. Place all the 'Time' values in one column, for example, column A. Place all the 'Growth' values in an adjacent column, column B. The 'Time' values become the x-axis values while the 'Growth' values are the y-axis values.
3. Click the first cell included then drag your mouse towards the last included cell to select the range of values to be included.
4. Click the 'Insert' tab from the menu bar. Go to the 'Charts' menu and click 'Scatter.'
5. Click 'Chart Area' to display the 'Chart Tools,' 'Design,' 'Layout' and 'Format' tabs.
6. Go to the 'Design' tab and select the style you want to use.
7. Type the main title for your chart under 'Chart Title.' For example, you can use 'Time vs. Growth' as the main title.
8. Click the 'Layout' tab and then click 'Axis Titles.' Select the 'Primary Horizontal Axis Title' and put 'Time' as the title for the x-axis. Click the 'Primary Vertical Axis Title' and put 'Growth' as the title for the y-axis.
9. Press 'Enter' to create the chart.
Read more ►

Saturday, August 27, 2011

How to Put Bullets in an Excel Spreadsheet


1. Open the Excel 2010 spreadsheet in which you want to add bullets.
2. Click on the cell where you want to add bullets. If there is already text in the cell, you will need to click on the formula bar above the spreadsheet. Place your cursor where you want the first bullet to go.
3. Hold down the 'Alt' button and press '7' on the numeric keypad. This will not work with the numbers above the keypad, so if you have a laptop without a dedicated numeric keypad, you will need to hold down the 'Function' button as well and type the letter that has 7 as an alternate. The bullet point appears.
4. Add the bullet point to adjacent cells by clicking and holding the mouse button over the bottom right corner of the cell. Drag the mouse to the right or down, and when you release the mouse button, all of the cells between where you started and where you released the button will be identical to the original cell.
5. Create a second bullet point in the original cell by clicking on the cell and then placing the cursor at the end of the first line of text, or right after the first bullet if there is no text. Hold down the 'Alt' button and press 'Enter.' Your text and bullet point will look like they disappeared, but they just moved up a line as you created a new text line in that cell. Press 'Alt' and '7' again to add another bullet point, and continue until you have all of the bullets that you need. You can move up and down between lines in a cell by using the arrows at the right end of the formula bar. You can also press the drop-down arrow at the end of the bar to expand the bar so that you can see three lines at once.
Read more ►

How to Hide Column Letters Numbers in Excel


1. Open your document in Microsoft Excel.
2. Click the 'View' tab on the Office ribbon.
3. Uncheck the 'Headings' check box to hide the column and row headings.
Read more ►

How to Create a Time Chart


1. Double-click on the Excel 2010 icon to open up the program. The program will start with a new spreadsheet.
2. Click on cell A1 and enter the column header for the time column. This will generally be 'Year,' 'Month,' 'Day' or simply 'Time,' although you can make the header anything you want. Then click on cell B1 and enter the header for your data column.
3. Enter your time information into column A, starting at cell A2. Then enter the data you are tracking into column B, starting at cell B2.
4. Click on cell A1 and hold the mouse button as you drag the mouse to the last entery in column B. Release the mouse button and the entire data set will be selected.
5. Click on the 'Insert' tab at the top of the screen. Then click the 'Scatter' button in the 'Charts' area. Select any of the five scatter charts, although it is usually easier to view the data if you choose one of the two options that include both lines and markers. Excel 2010 will now create the chart for you.
6. Click on the 'Quick Layout' button on the ribbon at the top of the screen and choose 'Layout 1' to include your column headers on the graph.
7. Right-click on the time data located just below the chart and choose 'Format Axis' from the drop-down menu. Then change the 'Minimum' and 'Maximum' levels to remove empty space at the beginning and end of your chart. Select 'Close' when you are done.
Read more ►

Thursday, August 25, 2011

How to Create a Macro in Excel 2010


1. Identify a complex series of commands you frequently give Microsoft Excel. For example, you could create a macro for formatting a group of cells with 8-point, blue Times New Roman font.
2. Choose the 'File' tab. Click 'Options' and 'Customize Ribbon.' Select the 'Developer' check box in the 'Main Tabs' list to easily access the macro creation tool.
3. Click 'Macro Security' on the 'Developer' tab. Enable macros under the 'Macro Settings' area.
4. Click 'Record Macro' to open a window and create a new macro in Excel.
5. Enter a unique name for your macro. Choose a name that begins with a letter, contains no spaces and accurately describes the macro's function.
6. Select an area to store the macro by changing the 'Store Macro In' field. Create a brief description of the macro so that you can remember its purpose later. Click OK to close the window and begin recording.
7. Perform the series of functions you want to record. Perform each mouse click, keystroke or other function in the proper order to ensure that the macro will work properly.
8. Click 'Stop Recording' when you have finished your series of commands. Microsoft Excel automatically saves the macro when you click this button.
9. Test the macro by selecting an area upon which you want the macro to operate. Select the macro and press 'Run.' Ensure that the macro performs its function correctly.
Read more ►

How to Create a Budget in Excel


1. Go online to the official download website for Microsoft Office.
2. Scroll down the page to the 'Browse Templates' section. Click 'Budgets.'
3. On the left column of the site, navigate to the 'Filter by Product' section. Select 'Excel' from the drop-down menu.
4. Browse the available budget templates. Choose a template with a layout and design that suits your budgeting needs.
5. Click the link for your selected budget template and click the 'Download' button. Once you accept the Microsoft Service Agreement, your template will begin downloading.
6. Open your downloaded template in Microsoft Excel. Customize the colors, fonts, margins and content to your budgeting and financial requirements.
Read more ►

How to Create a Spreadsheet on Microsoft Excel


Using Microsoft Excel 2003 or earlier
1. Open Microsoft Excel.
2. Click 'File' in the top menu bar and select 'New.'
3. Select the 'General' tab and double-click the 'Workbook' item to create a blank spreadsheet. Alternately, select the 'Spreadsheet Solutions' tab to view the program's default templates. Create a new spreadsheet based on a template by double-clicking its icon.
4. Click on a cell within the spreadsheet and begin typing to insert a data point. Press the 'Enter' or 'Tab' key after entering your data to confirm the value. Repeat the process until all data points have been entered.
5. Click 'File' and select 'Save.' Give the file a name, select a save location, and click 'Save' to complete the process.
Using Microsoft Excel 2007
6. Open Microsoft Excel.
7. Click the round 'Office' button at the top-left corner of the window and select 'New.'
8. Select the 'Blank and recent' tab and double-click the 'Blank Workbook' item to create a blank spreadsheet. Alternately, select any tab below the 'Microsoft Office Online' heading to view templates by category (e.g., 'Calendars,' 'Expense Reports,' 'Inventories'). Create a new spreadsheet based on a template by double-clicking its icon.
9. Click on a cell within the spreadsheet and begin typing to insert a data point. Press the 'Enter' or 'Tab' key after entering your data to confirm the value. Repeat the process until all data points have been entered.
10. Click the 'Office' button and select 'Save.' Give the file a name, select a save location and click 'Save' to complete the process.
Read more ►

How to Make a 3x5 Note Card on Excel


1. Click 'Start,' and then click 'Programs.' Click 'Microsoft Excel 2010.'
2. Click 'Page Layout,' and then click 'Page Setup.'
3. Click Size,' and then click 'Custom.'
4. Specify the width to be '3' inches and the height to be '5' inches. Click 'OK.'
Read more ►

How to Delete Multiple cells in Microsoft Excel 2003


1. Decide on the cells that you wish to delete. Make sure that you know what cells you want to delete and where they are located in the spreadsheet.
2. Highlight the multiple cells. To highlight the cells that you wish to delete, left-click and hold on the first cell and then drag the mouse cursor over the additional cells to highlight them.
3. Access the cell sub-menu. Once you have highlighted the multiple cells that you wish to delete, right-click to access the cell sub-menu.
4. Delete the highlighted cells. Scroll to “Delete” and left-click in the cell sub-menu, which will bring up a cell deletion properties box. You can select “Shift Cells Up”, which will shift the remaining cells up when you delete the existing cells, or “Shift Cells Left”, which will shift the remaining cells left when you delete the existing cells. Select the desired option and then click “Okay” to implement.
Read more ►

Wednesday, August 24, 2011

How to Password


1. Open Excel 2010 and click the 'File' tab. Click 'Open.' Browse the files and locate a workbook. Click the workbook and the 'Open' button. The workbook opens.
2. Select the worksheet where the password protection will be applied. Click the 'Review' tab and select 'Protect Sheet.' The Protect Sheet dialog box appears.
3. Type the password in the provided 'Password' field. Click 'Ok.' When prompted to confirm the password, retype the password. Click 'Ok.' Notice the ribbon has grayed out areas. These areas will not be accessible unless the user knows the password.
Read more ►

How to Check If a Cell Is Empty in Excel Program?


ISBLANK Function
1. Open the Excel worksheet with the data you want to check.
2. Enter an appropriate header in the first empty column.
3. Input '=isblank(B2)' on the row corresponding to the first data you want to check and press 'Enter.' This formula says, 'Cell B2 is empty.' If that statement is true, it returns a value of 'TRUE.' Otherwise, it returns a value of 'FALSE.'
4. Copy the cell containing the formula. Select all the cells corresponding to the data you want to check. Paste the formula.
5. Select the 'Data' tab on the menu and select the 'Filter' button.
6. Click the filter arrow at the top of the column containing the formula. Select 'TRUE' to see the rows or columns with empty cells.
LEN Function
7. Open the Excel worksheet you want to check.
8. Enter an appropriate header in the first empty column.
9. Input---on the row corresponding to the first data you want to check---the following:=if(LEN(B2)
10. Copy the cell containing the formula. Select all the cells corresponding to the data you want to check. Paste the formula.
11. Select the 'Data' tab on the menu and select the 'Filter' button.
12. Click the filter arrow at the top of the column containing the formula. Select 'TRUE' to see the rows or columns with empty cells.
IF Function
13. Open the Excel worksheet you want to check.
14. Enter an appropriate header in the first empty column.
15. Input---on the row corresponding to the first data you want to check---the following:=if(B2='', 'EMPTY', 'NOT EMPTY')Press 'Enter.'
16. Copy the cell containing the formula. Select all the cells corresponding to the data you want to check. Paste the formula.
17. Select the 'Data' tab on the menu and select the 'Filter' button.
18. Click the filter arrow at the top of the column containing the formula. Select 'TRUE' to see the rows or columns with empty cells.
Read more ►

How to Protect Cells in Excel 2003


1. Open Excel on your computer and select the spreadsheet that you want to protect.
2. Click the 'Select All' icon in the upper-left corner of the spreadsheet. The icon is a gray rectangle located adjacent to the A1 cell.
3. Select 'Cells' from the format menu and choose the 'Protection' tab. Uncheck the box next to 'Locked.'
4. Choose the cells that you want to protect. To select multiple cells, hold down the 'Control' key while you click on each cell. To select a large block of cells, hold down the 'Shift' key while you click on the first and last cells in the block to be protected.
5. Go to the Tool menu and select 'Protection.' Click on 'Protect Sheet' and then 'OK.' If you choose to password-protect the spreadsheet, select a password in the 'Protect Sheet' dialogue box before clicking 'OK.'
Read more ►

Excel 2003 Macros Won't Run


1. Click on 'Tools,' then click on 'Macros,' then click on 'Security.' Check to see if the 'High' radio button is selected. If it is, this is likely preventing your macros from running. Click on the 'Medium' button for the security level and then click on 'OK.'
2. Save your worksheet if Step 1 didn't work, then close Excel completely. Restart Excel and reopen the worksheet.
3. Repeat Step 1 and Step 2. This should resolve the quirk preventing the macros from running.
Read more ►

Tuesday, August 23, 2011

How to Graph Complex Functions With Excel


1. Open a blank workbook in Microsoft Excel.
2. Enter 'x' in cell A1. Press 'Tab' to go to the next column over. Enter 'y' in cell B1.
3. Select cell A2. Enter the first value of x you want to use for the horizontal axis. For instance, to span the negative and positive axes, enter '-5,' and in each cell below, enter the next value in the series, up to 5. Enter '-4' in cell A3 and onward...-3, -2, -1, 0, 1, 2, 3, 4, 5.
4. Select all the x values in column A by highlighting A2 and dragging your cursor down to the last cell. You need to define the name of the values, so Excel knows that each value in column A equals a value of x. This will be used when you create a formula in the y column. Click the 'Formulas' tab. In the 'Defined Names' group, click 'Define Name.' Enter 'x' in the 'Name' box. Click 'OK.'
5. Select cell B2. Enter a complex function that you want to graph. If you are graphing a linear equation with the format y=mx b, enter '=m*x B' in cell B2. Tab over, and Excel will calculate the formula with the corresponding value of x.
6. Copy the formula from cell B2 to the other cells. Select cell B2. Click the 'Home' tab. Click 'Copy' in the 'Clipboard' group. Click and drag over the cells below B2 to select them. Click the arrow underneath the 'Paste' icon in the 'Clipboard'group. Choose 'Formulas.' The formula is added to each cell in the B column and contains each y-value in terms of x.
7. Highlight all the cells. Click the 'Insert' tab to create a graph for the function.
8. Click 'Scatter' in the 'Charts' group. Choose a subtype for the scatter chart. The chart immediately is displayed on your worksheet.
9. Click the chart to select it. The 'Chart Tools' appear on the Ribbon, which include the 'Design, Layout and Format' tabs. Browse through these tabs to make changes to the chart style, chart layout and the layout of individual chart elements, such as chart title, axes, legend and data labels.
10. Click a chart element directly on the worksheet to edit any titles you want to change.
11. Click the 'Microsoft Office Button,' and select 'Save as' to save the graph and data.
Read more ►

How to Edit a UDF File


1. Right-click on the UDF file.
2. Click on 'Open with.'
3. Select the 'Choose Default Program' option.
4. Select Microsoft Excel.
5. Click on 'Browse' only if Microsoft Excel is not on the list. Then, search for it and click on 'Open.'
6. Click on 'OK.' Your UDF file will open.
7. Click on 'File.'
8. Click on 'Save as.'
9. Select the file extension you wish to convert the UDF file to.
10. Click on 'Save.' Your UDF has been edited.
Read more ►

Monday, August 22, 2011

How to Use the IF Function in Excel 2007 With Absolute References


1. Enter the 'IF' formula into a cell of your choosing, following the format '=IF(comparison,true_value,false_value)'. As an example, to test if cell A1 is zero, you might enter '=IF(A1=0,'zero','not zero')'. This solely uses relative references.
2. Add a dollar sign in front of the cell column letter to prevent the column reference from changing, but allow the row number to change. In the example, it would look like '=IF($A1=0,'zero','not zero')'. This uses an absolute reference for the column, but a relative reference for the row.
3. Add a dollar sign in front of the cell row number to prevent the row reference from changing, but allow the column letter to change. In the example, it would look like '=IF(A$1=0,'zero','not zero')'. This uses an absolute reference for the row, but a relative reference for the column.
4. Add a dollar sign in from of both the cell reference's column letter and row number to prevent either from changing. In the example, it would look like '=IF($A$1=0,'zero','not zero')'. This solely uses absolute references. No matter where you copy and paste the formula, it will check whether cell A1's value is zero.
Read more ►

How to Publish an Excel Workbook


Excel 2010
1. Click the green 'File' tab at the upper left part of your screen while you have the workbook open. This will bring you to the Microsoft Office Backstage view.
2. Click the 'Save and Send' tab in the menu column on the left side of the page. This will bring up the Save and Send options.
3. Choose 'Save to Web' to publish to your SkyDrive account, or click 'Save to SharePoint' to save the workbook to a SharePoint account.
4. Click 'Publish Options' to choose specific parts of the workbook to publish. You can also just click 'Save As' to publish the whole workbook.
Excel 2007
5. Click on the Microsoft Office button. This will bring up a menu of options for the open workbook.
6. Click on the 'Publish' tab toward the bottom of the column to open a menu called 'Distribute the document to other people.'
7. Click 'Excel Services' in the pane that opens up. This will bring up a 'Save As' pop-up window.
8. Click the 'Excel Services Options' to choose what sections of the workbook you want to publish, and click 'Save' to publish to the desired document library.
Read more ►

How to Crack/Hack Password Protected Excel Spreadsheets


1. You can do anything with the right tool, only if the right tool existed. In this case the right tool does exist. Brute Force Attack Program will help you easily gain access to the password protected Excel Spreadsheet. It tries every possible password until it gets the one that works. It can take minutes to months depending on how hard you make the password.
2. First go to the link below in 'Resources' and download the Brute Force Attack program. It comes with a trial so you can try before you buy. The good news is the program can help you brute force attack/hack/crack Word Documents and Excel Spreadsheets.
3. Now use the program to open and start the brute force attack, hack, crack on the Excel Spreadsheet.It will get it sooner or later and then your done.
Read more ►

How to Change Excel 2007 Column Headings


1. Navigate to the folder that contains the Microsoft Excel workbook that you want to edit. Double-click the file to open the workbook in the Microsoft Excel 2007 application.
2. Highlight row 1 in the worksheet to which you wish to add column headers. Right-click the row and choose 'Insert' to add a column header row. Skip this step if there are already column headers typed in row 1 of the worksheet.
3. Type the heading for each column.
4. Click on cell A2 if your worksheet contains only column headings. Click on cell B2 if your worksheet contains both column and row headings.
5. Click the 'Window' tab and choose 'Freeze Panes.' The column and/or row headings that you have typed in will always be displayed at the margins of the worksheet. If you later need to eliminate column headings simply click 'Window' and choose 'Unfreeze Panes.'
Read more ►

How to Change the Default Page Margins in Excel


1. Open Microsoft Excel and click 'File' on the top of the window. Select 'New' from the File menu. This will open a new Excel workbook.
2. Click 'File,' 'Page Setup' and 'Margins.' Enter a size, in inches, for each margin including the sides, header and footer. Click 'Save' on the bottom of the page.
3. Click 'File' on the top of the window and select 'Save As.' Type 'Book.xlt' into the box beside 'File Name' and select 'Template' from the drop-down menu for the file type.
4. Choose the location to which you are saving this template by navigating to the 'XLStart' folder in the window above the file name box. The exact location of this file on your hard drive can vary, so you will need to search your hard drive beforehand to know where it is located. Click 'Save.'
Read more ►

How to Use Excel's TRUE Function


1. Learn the syntax for TRUE: it is TRUE(). This function does not require any arguments. Similarly FALSE() always evaluates to FALSE.
2. Use TRUE with the IF function. TRUE might be used for testing purposes to force a certain value to be returned. For example, consider the IF statement: IF (logic_test;true_value;false_value). If logic_test evaluates to TRUE, true_value is returned, otherwise false_value is returned.
3. Look at the following IF statement:IF (TRUE();'is true';'is false')This IF statement will always return the first value. This might be useful during testing if we were not sure what value was being returned.
4. Examine the use of TRUE() with the following AND function:AND (condition1;condition2)AND returns TRUE only if all of its arguments evaluate to TRUE. If during testing we were not sure what condition1 evaluated to, we might substitute TRUE() for condition2 thus:AND (condition1;TRUE())If this AND statement returned TRUE, we would know that condition1 was true.
5. Test an OR function with TRUE(). The statement
OR(condition1:condition2;...) returns TRUE if any condition is TRUE and returns FALSE if all conditions are FALSE. Assume this OR is returning FALSE, and we need it to return TRUE for testing purposes. We could temporarily change one of the conditions to TRUE().
Read more ►

How to Format a Web Address Hyperlink in Excel 2010


1. Right click the cell that you want to format and click 'Hyperlink.' The 'Insert Hyperlink' dialog box appears on your screen.
2. Click 'Existing File or Web Page' under 'Link to.' Enter the web address in the 'Address' field.
3. Enter the text you want Excel to display in the cell in the 'Text to display' box.
4. Click the 'OK' button.
5. Click the 'Home' tab and click 'Cell Styles' in the 'Styles' group.
6. Right click 'Hyperlink' from the 'Data and Model' heading.
7. Click 'Modify' and then 'Format' (in the 'Style' dialog box). Change the hyperlink's font, style, size and color on the 'Font' tab. To change the cell alignment of the hyperlink, click the 'Alignment' tab. Click the 'Fill' tab to add a background color to the cell.
8. Click the 'OK' button to apply the changes.
Read more ►

Sunday, August 21, 2011

How to Create an XLSX File


Create XLSX files in Excel 2007
1. Open Microsoft Excel 2007.
2. Click the round 'Office' button at the top-left corner of the Excel window and select 'New.' Choose your preferred document or template type and then click 'Create.'
3. Click the 'Office' button and select 'Save' when you are ready to save your spreadsheet data. Select the 'Save as type' drop-down menu, choose the top-most option labeled 'Excel Workbook' and then click 'Save.' Your document is saved in XLSX format.
Create XLSX files in Excel 2000, Excel XP or Excel 2003
4. Open a Web browser window and navigate to http://update.microsoft.com/. Install all high-priority updates before downloading the Microsoft Office Compatibility Pack.
5. Download the Microsoft Office Compatibility Pack from the Microsoft website. Double-click the installer file after it downloads to your computer and then follow the on-screen prompts to install the software.
6. Open Microsoft Excel 2000, Excel XP or Excel 2003.
7. Click 'File' in the top menu bar and select 'New.' Choose your preferred document or template type and then click 'OK.'
8. Click 'File' and select 'Save' when you are ready to save your spreadsheet data. Select the 'Save as type' drop-down menu, choose the option labeled 'Excel 2007 Workbook' and then click 'Save.' Your document is saved in XLSX format.
Read more ►

How to Remove Adobe in Excel


1. Open Microsoft Excel.
2. Click on the program's 'Office' logo button (where the 'File' menu typically is in other Windows programs) at the top of the screen.
3. Click 'Excel Options.'
4. Select the 'Add-in' category from the 'Options' menu. Clear the check box next to the listing for your Adobe add-in and click on the 'OK' button. This will remove the Adobe add-in from your copy of Microsoft Excel.
Read more ►

How to Use the Exponential Function in Excel


Direct Calculations
1. Launch Microsoft Excel and open a blank workbook if one does not automatically open.
2. Click a cell to select it. Press the '=' to begin to create a formula for the cell.
3. Type 'Power(2,3)' and press 'Enter' or 'Tab' to save the contents of the cell and move to the next cell down or to the right, respectively. Notice that the cell now displays the answer to the first number in parentheses raised to the second number in parenthesis, or 'Two raised to the third power,' which is equal to '8' in this case.
Referenced Cells
4. Launch Microsoft Excel. Open a blank workbook if one does not automatically open.
5. Click a blank cell and type the number '5' into the cell. Press 'Enter' to save the cell contents and move to the next cell down.
6. Type the number '2' into the cell. Press 'Enter' to save the contents and move to the next cell down.
7. Press the 'Equal' key ('=') to begin to create a formula for the cell.
8. Type the word 'Power' followed by the 'Open Parenthesis' symbol. Hold down the 'Shift' key and press the '(' symbol, located on the same key as the number 9, and then click once on the cell with the number '5' in it. Press the ',' on the keyboard, and then click once on the cell with the number '2' in it. Press the close parenthesis key. Hold down 'Shift' key and press the ')' symbol, located on the same key as the number '0.' Press 'Enter.' Notice that the result is the number in the first cell, a '5,' raised to the power in the second cell, a '2,' or '25' in this case. Note that if the first cell is 'A1' and the second cell is 'A2,' then the formula for the third cell will look like '=POWER(A1,A2)' to work correctly.
Read more ►

Saturday, August 20, 2011

How to Sort by Cell Color in Excel 2003


1. Press 'Alt and 'F11' together from the Excel worksheet you want to sort. This opens the Visual Basic Editor (VBE).
2. Click 'Insert' and then click 'Module.'
3. Cut and paste the following code into the blank window:Sub SortByColor()On Error GoTo SortByColor_ErrDim sRangeAddress As StringDim sStartCell As StringDim sEndCell As StringDim rngSort As RangeDim rng As RangeApplication.ScreenUpdating = FalsesStartCell = InputBox('Enter the cell address of the ' _'top cell in the range to be sorted by color' _Chr(13) 'i.e. 'A1'', 'Enter Cell Address')If sStartCell > '' ThensEndCell = Range(sStartCell).End(xlDown).AddressRange(sStartCell).EntireColumn.InsertSet rngSort = Range(sStartCell, sEndCell)For Each rng In rngSortrng.Value = rng.Offset(0, 1).Interior.ColorIndexNextRange(sStartCell).Sort Key1:=Range(sStartCell), _Order1:=xlAscending, Header:=xlNo, _Orientation:=xlTopToBottomRange(sStartCell).EntireColumn.DeleteEnd IfSortByColor_Exit:Application.ScreenUpdating = TrueSet rngSort = NothingExit SubSortByColor_Err:MsgBox Err.Number ': ' Err.Description, _vbOKOnly, 'SortByColor'Resume SortByColor_ExitEnd Sub
4. Press 'F5' to run the macro. The macro will ask you the beginning of the range you want to sort by color: enter the top-left cell in the range.
Read more ►

How to Insert Hyperlinks into Excel 2007 Without Changing Text Format


1. Open the saved spreadsheet.
2. Click to highlight the text where you wish to insert the hyperlink.
3. Click the Insert tab on the ribbon.
4. Click on the 'Hyperlink' button in the Links group. A dialog box entitled Insert Hyperlink will appear.
5. Click a file from the Look In list. If the hyperlink leads to a website, click the Address box and enter the URL.
6. Click the 'OK' button. The colored hyperlink appears on the selected text.
7. Change the text that contains the hyperlink, if you wish. For example, to change the hyperlink color to match the original font color of the text, click the Home tab's font commands.
Read more ►

How to Find Row Number of Active Cell For VBA


1. Press 'Alt' and 'F11' together from inside the worksheet where you want to find the active cell's row number. This action opens the Visual Basic Editor (VBE).
2. Click 'Insert' and then click 'Module' to open a blank module window.
3. Cut and paste the following code into your worksheet:Sub RowNum()MsgBox 'The active cell row is ' ActiveCell.RowEnd Sub
4. Press 'F5' to run the routine. The macro will return the active cell's row in a message box.
Read more ►

How to Make a Graph in MS Excel


Instructions
1. Input the graph data. For the purposes of this example, type 'Month' in cell A1, and type the months January through December in cells A2 through A13. In cell B1, type 'Applications.' For each month, increase the 'Applications' number by 200. In cell B2, type '200,' in cell B3 type '400' and so on. The last figure in the 'Applications' column -- '2,400' -- is in cell B13.
2. Place the cursor on a cell within the data table. If the cursor is not on an item in the table, the chart will not know where to access the data. Go to the 'Insert' tab. Click on the down arrow under the 'Column' option in the 'Charts' panel.
3. Select the first chart option under the '3-D Column' heading. A graph titled 'Applications' will appear in your work area, showing 12 columns that represent the 12 numbers you entered in Step 1.
4. Click on the border of the chart to drag it to the desired location. Change the size of the graph by grabbing one of its corners and dragging it.
Read more ►

Friday, August 19, 2011

How to Create Quality Control Charts in Excel


1. Distribute your data to revolve around a mean (average). Ensure your measurements are independent of each other. Create a subgroup for each data point and measurement number.
2. Add all your measurements in the subgroup and divide by your number of measurements. Calculate the mean of all the means; this will determine your over all mean. Determine the standard deviation of your data points by using this command: 'Standard deviation: =STDEV(data points).'
3. Tally the upper and lower control limits (UCL, LCL). Enter this formula: 'UCL = CL 3*S', 'LCL = CL -- 3*S.' This conveys 3 standard deviations above and below your mean. This will process your 1, 2 and 3 sigma lines. Draw a line at each deviation you've calculated. Diagram the subgroup means 'x-axis' counter to the 'y-axis.' Confirm that your points do not fall off any of your sigma lines. This can help you determine whether you data is 'in-control' or 'out-of-control.'
Read more ►

How to Convert XML to an Excel 2003 Spreadsheet


Converting the XML File Directly Using Excel 2003
1. Click on the Microsoft Excel 2003 icon on your computer's desktop to open the application. Or click 'Start,' 'All Programs,' 'Microsoft Excel 2003,' if you are using Windows. On a Mac, click on the Excel icon in the Applications folder of your Mac's hard drive.
2. Click 'File,' then 'Open.'
3. Click on the down arrow next to the box labeled 'Files of Type.' Select 'XML files (*.xml).'
4. Click on the down arrow next to the box labeled 'Look In.' Navigate to the directory containing the XML file you would like to convert to a spreadsheet.
5. Double-click on the XML file's name to open it. The 'Open XML' dialog box will open.
6. Click on 'As an XML list' to open the XML file to view the raw data in a structured list format. Click 'OK.' This option lets you edit the XML data.
7. Click on 'As a read-only workbook' to open the XML file to view the data in an uneditable file. Click 'OK.' The XML data will be displayed in a grid instead of a list.
Converting XML File Via The Excel 'Data' Menu
8. Open Microsoft Excel 2003.
9. Click 'Data' and select 'XML.'
10. Click on 'XML Source.' The 'XML Source' task pane will open.
11. Click on 'XML Maps.' Click on 'Add.' Use the 'Look in list' function to navigate to the XML file you want to open.
12. Double-click on the XML file to open it. Click 'OK' to close the open dialog box confirming that you want to open the XML file.
13. Click 'OK' to display the XML file in the XML Source task pane.
14. Click and drag the items you want to view from the Source task pane to the blank cells of the open Excel 2003 worksheet.
15. Click on the 'A1' cell of the spreadsheet to highlight it.
16. Click on 'Data,' 'XML,' 'Import.' The 'Import XML' dialog box will open.
17. Click on 'Look in list' to locate the XML file you used in Step 5.
18. Click on the file's name. Click 'Import.' The XML file will open in Excel 2003.
Read more ►

How to Make a Large Organizational Chart on Microsoft


1. Open the Excel, Outlook, PowerPoint or Word program to display a new document.
2. Click the “Insert” tab on the command ribbon.
3. Click the “SmartArt” button in the “Illustrations” group. A gallery of thumbnail images appears.
4. Click the “Hierarchy” option in the left pane to display “Hierarchy” charts in the middle pane.
5. Click a thumbnail image to preview an enlarged view and chart description.
6. Click “OK.” The chart template copies to the new document. The “SmartArt Tools” ribbon displays two tabs: “Design” and “Format.”
7. Click the “Design” tab on the “SmartArt Tools” ribbon.
8. Click the “Text Pane” button in the “Create Graphic” group. The “Type your text here” pane appears.
9. Type the text such as a name and title, in the the text pane. The text copies to the organization chart.
10. Insert more chart shapes by clicking the “Add Shape” button in the “Create Graphic” group on the “Design” tab.
11. Update the layout by clicking the “More” arrow beside the “Layouts” group. A gallery of layout thumbnails appears. Click the preferred layout. For example, the “Picture Organization Chart” can insert image files.
12. Apply formatting options by clicking the “Format” tab in the “SmartArt Tools” ribbon. Experiment with the “Shape Styles” or “WordArt Styles” to customize the shapes in your chart. For example, select a color border for colleagues working on a specific project.
13. Save this document. Select a file location you can easily access.
Read more ►

How to Create a Family Budget Using Microsoft Excel


1. Open Microsoft Excel.
2. Click cell 'A1,' then type 'Item.'
3. Click cell 'A2,' then type the first item in your budget. For example, 'Grocery.'
4. Click cell 'A3,' then type the second item in your budget. For example, 'Rent.' Continue entering your budget items in column A, moving down the column.
5. Click cell 'B1' and then type 'Amount.'
6. Click cell 'B2,' then type the amount that corresponds with the item in cell A2. In this example, cell A2 contained the item 'Grocery.' If you spend $600 per month on groceries, type 600.
7. Click cell 'B3,' then enter the amount that corresponds with the item in A2. Continue entering amounts for items, moving down column B, until you have entered an amount for each item in column A.
8. Highlight column B; click the 'B' at the top of the column.
9. Click the 'Home' tab and then click the '$' symbol in the Number group. This tells Excel that all the numbers you entered are in dollars.
10. Click on the first blank cell in column B, then click the 'Σ' button on the Home tab. This sums up the items in your budget column and gives you a total.
Read more ►

Thursday, August 18, 2011

How to Add Dates in Microsoft Excel


1. Right-click on the cell you want to format.
2. Choose 'Format Cells' from the list.
3. Click on the 'Number' tab.
4. Choose 'Date.'
5. Click on the date option from the list box. For example, click on '5-Jul' to format all dates in that particular cell that way.
6. Press 'OK.'
Read more ►

How to Make a Rubric in Excel


1. List the achievement levels across the first row, one level per cell. Reserve column A for the category titles and begin the achievement headings in column B. The achievement levels may be academic grades, place rankings or any other scoring system.
2. Click on the row header to highlight the entire row. Then select the 'Home' tab from the ribbon and click the 'Bold' button in the 'Font' group. Making the text bold allows the user to more easily distinguish the headings from the criteria.
3. Type the category headings down the first column, one category per cell. For instance, a rubric for a research paper may include categories for punctuality, research quality, mechanics and formatting. Double click on the boundary between column A and B to adapt the column width to the length of the longest word.
4. Click inside the cell at the intersection of the first category row and the first achievement level column. Type a short description of the criteria necessary to achieve this level in this category.
5. Repeat this process until there is a description for every category at every achievement level.
6. Click inside the first criteria cell and drag the handle on the black selection box that appears to enlarge it until it encompasses all the cells.
7. Click on the 'Home' tab in the ribbon, then click the 'Wrap Text' button in the 'Alignment' group. This causes your text to automatically wrap to fit the width of the column.
8. Click and drag the boundary between two column or row headers to widen the cells.
9. Apply a border to each column and row, if desired. This helps clearly separate the criteria. To do this, click the 'Home' tab in the ribbon, then click the 'Borders' button in the 'Font' group and select a border type.
Read more ►

Wednesday, August 17, 2011

How to Turn Off Auto Save


Instructions
1. Turn off AutoSave in Visio. Go to the 'Tools' menu and select 'Options.' When the new window comes up, click on the 'Save/Open' tab. Uncheck the box next to 'Save AutoRecover information.' Click 'OK' at the bottom of the window.
2. Turn off AutoSave in Word, Excel or PowerPoint. Click on the button at the top left of the program's window that looks like the Windows logo. Look for a button that says 'Word Options,' 'Excel Options' or 'PowerPoint Options' at the bottom right of the window that appears. Click on 'Save' in the list at the left. Uncheck the box next to 'Save AutoRecover information.' Click 'OK' at the bottom of the window.
3. Turn off AutoSave in Publisher. Go to the 'Tools' menu and select 'Options.' When the new window comes up, click on the tab that says 'Save.' Uncheck the box next to 'Save AutoRecover information.' Click 'OK' at the bottom of the window.
Read more ►

How to Create a Scatter Plot With a Microsoft Word Spreadsheet


1. Open the Word document.
2. Click on the 'Insert' tab on the command Ribbon.
3. Click on the 'Chart' button in the 'Illustrations' group. A dialog box will display the different charts.
4. Click on an 'XY (Scatter)' chart button. Click on the 'OK' button. An Excel worksheet and a chart template will appear.
5. Enter the values on the worksheet. Click the 'Enter' key. The data will convert on the scatter chart.
6. Format the scatter chart for a custom look. For example, the 'Design' tab includes chart styles. The 'Format' tab includes colored outlines.
7. Save this document.
Read more ►

How to Create a Form Using Microsoft Excel


1. Insert form. Open a new workbook in Microsoft Excel. Press the 'Alt' and 'F11' keys on your keyboard to open Microsoft Visual Basic. Double click on 'Sheet 1' (Sheet 1) under Microsoft Excel Objects in the left window pane under VBAProject. Go to the Insert menu and select 'UserForm' to insert a form.
2. Name form. Go to the Properties window in the left window pane and click on 'UserForm1' next to (Name). Type a new name for your form. Hit 'Enter.'
3. Add text box. Click on the 'Textbox' button in the Toolbox toolbar. Click on a place in the form where you would like to add a standard-sized text box. You can adjust the size of the box using the handles. Go to the Properties window in the left window pane and click on 'TextBox1' next to (Name). Type a new name for your text box. Hit 'Enter.' Repeat this step for additional text boxes you would like to add.
4. Add label. Click on the 'Label' button in the Toolbox toolbar. Click on a place in the form where you would like to add a standard-sized text label. Adjust the size of the box using the handles. Go to the Properties window in the left window pane and click on 'Label1' next to (Name). Type a new name for your label. Hit 'Enter.' Repeat this step for additional labels.
5. Add buttons. Click on the 'Command' button in the Toolbox toolbar. Click on a place in the form where you would like to add a standard-sized button. Go to the Properties window in the left window pane and click on 'CommandButton1' next to (Name). Type a new name for your button. Hit 'Enter.' Change the caption to the text you would like to appear on the button such as 'Login.' Repeat this step for additional buttons you would like to add.
6. Add code. Select the button, go to the View menu and select 'Code.' Enter code functionality for the button. Go to the View menu and select 'Object' to go back to the user form. See the link in Resources below for examples of button codes.
7. Test form. Go to the Run menu and select 'Run Sub/UserForm' to run the form.
Read more ►

Tuesday, August 16, 2011

How to Create a Pivot Table From External Data in an Excel File


1. Save your external data into a file. The most common type of file is an external database.
2. Pull up a blank spreadsheet within Excel 2003. Click 'Data' in the drop-down menu and scroll down to 'PivotTable.'
3. Click 'External Data Source' and select 'PivotChart Report with PivotTable Report.' Once you make these selections, another pop-up menu will appear.
4. Select 'Get Data,' which will bring up another window. Select the file or database you will be choosing from. These include Access, Excel, dBase, and ODBC.
5. Click OK and close. Use default value for all other prompts and click Finish. The pivot table will automatically appear.
Read more ►

How to Copy Formulas Down in Excel Lightning Fast


1. Open the Excel 2010 spreadsheet where you want to add your formula.
2. Select the first cell where you want the formula to appear and type in your formula. Press 'Enter' when you are done.
3. Move the mouse to the cell where you just entered your formula. Move the pointer over the bottom-right corner of that cell and it will change into a ' ' sign.
4. Click and hold the mouse button. Drag the mouse down the spreadsheet until you reach the last cell where you want the formula to appear. Release the mouse button, and the formula will instantly copy itself down into every cell.
Read more ►

Monday, August 15, 2011

How to Use a Financial Calculator to Get Compound Interest


1. Use the compound interest financial calculator on Moneychimp (moneyChimp.com). Fill out the boxes on screen with information about your current loan including the principle, the interest rate, the annual addition and the years to grow. Input the number of times your interest is compounded. Click 'Calculate' to view the total amount of your loan or investment with compound interest added in.
2. Use the financial calculator on 1728.com. Fill out the boxes at the bottom of the financial calculator page with information about your current loan, savings account or investment (whichever applicable). Select the appropriate terms from the boxes on screen and click 'Calculate' to view the future value of your loan, account or investment with compound interest added in.
3. Use a regular financial calculator with the appropriate formula. The formula for compound interest is 'Principal x ( 1 Rate )years.' Replace each term with the dollar amount related to your loan, account or investment information. The total amount of money that you solve for is the value of your account, loan or investment with compound interest added into the principle.
Read more ►

How to Create CSV Files in Excel 2007


1. Open your spreadsheet. Click on the 'Office' button in the upper left-hand corner.
2. Select the 'Save As' option from the pull-down menu. Click on the 'Other Formats' button.
3. Choose the 'CSV (Comma delimited)' option.
4. Type a name for the CSV file.
5. Check the location of the file, making sure you remember where the file will be saved.
6. Click on 'Save.' You can now close the Excel file.
7. Open the CSV file to make sure there weren't any problems with the export.
Read more ►

Sunday, August 14, 2011

How to Make a Graph in Excel Edit the Legend


Create a Chart
1. Open the Excel worksheet that contains the data for the chart.
2. Click and drag to select the data for the chart.
3. Click the “Insert” tab on the command ribbon.
4. Click the arrow for the preferred chart type in the “Charts” group. Examples of chart types include 'Column,' 'Line' and 'Pie.' A gallery of chart thumbnails appears.
5. Click to select the chart type. A chart displays over the Excel worksheet. The “Chart Tools” ribbon shows three tabs: “Design,” “Layout” and “Format.”
6. Format and style your chart with the commands on the “Design,” “Layout” and “Format” tabs. For example, the “Design” tab contains options for “Chart Layouts” and “Chart Styles.”
Edit the Chart's Legend
7. Click the Excel chart. The 'Chart Tools' ribbon appears.
8. Click the “Design” tab in the “Chart Tools” ribbon.
9. Click the “Select Data” button in the “Data” group. The “Select Data Source” dialog window opens.
10. Click the “Add,” “Edit” or “Remove” options in the “Legend Entries (Series)” section. Update the legend. Click “OK.”
11. Right-click the legend box. A dialog box displays options for “Legend Options,” “Fill,” Border Color,” “Border Styles,” “Shadow” and “Glow and Soft Edges.”
12. Click to select the preferred options to format your chart’s legend.
13. Click “Close.”
Read more ►

How to Automatically Shade Every Other Row in Excel 2007


1. Open the spreadsheet you want to shade the rows of in Excel.
2. Hold the 'Ctrl' key on your keyboard and press 'A,' releasing both keys.
3. Click 'Home' on the top menu in Excel 2007.
4. Click 'Format as Table' under 'Styles' and click 'OK.' This shades the rows for you automatically.
Read more ►

How to Make Excel Reports


1. Open the Excel program to display a new worksheet.
2. Click the “File” tab on the command ribbon to display a list of commands.
3. Click “New,” then a gallery of “Office.com Templates” appears.
4. Click the “Reports” link, then a list of folder icons appears.
5. Click the preferred folder such as “Financial Records,” “Logs” or “Human Resource Records.” A gallery of thumbnail images appears.
6. Click the preferred report image to display a larger image in the preview pane to the right.
7. Click “Download” in the right pane. The template copies to the new worksheet.
8. Click in a cell and type your data. Use the Excel editor commands to customize the look of this report. For example, select a 'Font' and 'Fill Color' command on the 'Home' tab.
9. Save this Excel Workbook. On the “Save As” dialog box, click a file location in the left pane. For example, “Desktop” or a named folder. Type a file name in the “File name” text box. Click “Save.”
Read more ►

How to Set Margins in Excel


1. Start Microsoft Excel and open an existing spreadsheet on which you would like to set the margins.
2. Choose the 'File' menu and click 'Page Setup' to open the 'Page Setup' dialog box. The 'Page Setup' dialog box can be used to set up your page just how you would like it to appear.
3. Click on the 'Margins' tab at the top of the 'Page Setup' dialog box to show the margins for the spreadsheet that you currently have option.
4. Set the 'Left,' 'Top,' 'Right,' 'Bottom,' 'Header' and 'Footer' margins by clicking within the text box underneath each option to highlight the current margin setting.
5. Type a new measurement for whichever margins you would like to change or use the arrows to move up and down throughout the measurements you can select for each option.
6. Notice as you update each margin the preview in the center of the screen will change to reflect your new margin settings.
7. Use your mouse to click the 'OK' button to close the 'Page Setup' dialog box and set the margins you have chosen for your current Excel spreadsheet.
Read more ►

Saturday, August 13, 2011

How to Create a Currency Converter With Microsoft Excel


1. Select the currency you want to convert to.
2. Find the current conversion rate. Sites such as Yahoo's currency converter will list the latest currency conversion rate for the various international currencies. Several sites offer this service, so perform an Internet search for the site you feel most comfortable with.
3. Open Microsoft Excel. Label the first three columns in the Excel spreadsheet as 'Current Currency,' 'Currency Conversion Factor' and 'Converted Currency.' You don't have to label the columns as indicated here, but for instructional purposes, it makes it easier to identify the column's contents. You can label them A, B and C if you'd like.
4. Insert the amount of the currency you wish to convert in the first column (Current Currency). If you're converting $453 US dollars into another currency, insert that amount in the first column.
5. Place the currency conversion factor in the second column.
6. Create a formula in the third column. Insert this formula in the third column ' column1/cell1 * colum2/cell1.' In this example, assuming you did not skip a row after your title, your dollar amount will be in A2 and your conversion amount will be in B2; therefore, your formula will read ' A2* B2.' Be sure to hit the 'Enter' key once you've put in the formula. It will automatically convert the currency.
7. Add formatting. If you want your converter to look nice, format the column by bolding, underlining or adding color.
Read more ►

How to Import More Than 65,536 Rows in Excel 2003


1. Click 'Tools,' select 'Macro' and choose 'Macros.'
2. Type a name for your macro in the 'Name' field, such as 'LargeFileImport,' and click 'Create.' The Visual Basic Editor will open automatically.
3. Double-click '(Name) Module' in the 'Properties' window and type 'LargeFileModule.'
4. Click the ' ' icon next to 'Microsoft Office Excel Objects.'
5. Double-click 'LargeFileModule' to open the 'Code' window.
6. Copy and paste the following into the 'Code' window:Sub LargeFileImport()'Dimension VariablesDim ResultStr As StringDim FileName As StringDim FileNum As IntegerDim Counter As Double'Ask User for File's NameFileName = InputBox('Please enter the Text File's name, e.g. test.txt')'Check for no entryIf FileName = '' Then End'Get Next Available File Handle NumberFileNum = FreeFile()'Open Text File For InputOpen FileName For Input As #FileNum'Turn Screen Updating OffApplication.ScreenUpdating = False'Create A New WorkBook With One Worksheet In ItWorkbooks.Add template:=xlWorksheet'Set The Counter to 1Counter = 1'Loop Until the End Of File Is ReachedDo While Seek(FileNum)
7. Click 'File' and select 'Close' to close the Visual Basic Editor.
8. Click 'Tools,' select 'Macro' and choose 'Macros.'
9. Select the 'LargeFileImport' macro from the 'Macros' dialog box and click 'Run.'
10. Enter the name of your file (myhugedocument.txt, for example) in the dialog box that appears. Excel will import the data, splitting it into multiple worksheets in order to circumvent Excel's line limit.
Read more ►

How to Restore All Hidden Columns in Excel


1. Open the spreadsheet in Excel.
2. Click on the arrow in the top left corner of the Excel spreadsheet. This highlights all data in the workbook.
3. Click 'Format' in the 'Cells' menu along the top of the page. A drop-down menu appears.
4. Click 'Hide Unhide' under the 'Visibility' heading, then click 'Unhide Columns.' Changes are applied instantly and all columns are visible.
Read more ►

Thursday, August 11, 2011

How to Create a Simple Checkbook Register With Microsoft Excel


1. Open Microsoft Excel. Type in 'Check Register' in cell A1. Center this across the columns you will be using, from A through G. Select cell A1, hold down the shift key and select cell G1. After you highlight it, go to 'Format' and 'Merge Cells.' Then select 'Center' which is under 'Format' and 'Cells.'
2. Skip a row and make the headings starting in cell A4. Type in 'Item Number,' move to the next column and type in 'Date,' move to the next column and type in 'Description of Transaction,' continue moving and typing the headings as follows: 'Payment,' 'Done,' and 'Deposit.' Go to cell G3 and type in 'Balance.'
3. Format the cells. In cell G4 select 'Format' and 'Cells' under 'Numbers' select 'Currency' and the way you want the dollar amount shown in the category. Go to cell B6. Hold the shift key down and page down a few times. Then select 'Format,' 'Cells' and 'Date' and then the way you want the date to look. Do the same for the 'Payment,' 'Deposit' and 'Balance' columns but format them for money. Alternatively, you can format them as numbers with two decimals.
4. Select the 'Balance' column again and put in the following formula in cell G6: '=G5 F6-D6'. Copy the formula down by using 'Auto Fill' or 'Copy' and 'Paste.'
5. Start entering your data beginning with your current balance in G4, and then adding each transaction as you make it. Don't forget to put in debit transactions as well as any bills that you pay online. Add in all your deposits too.
6. Play with and test the numbers, as you want to be sure that it's working correctly.
Read more ►

How to Number the Rows in Excel 2007


Fill Column
1. Select the first cell in spreadsheet.
2. Type the starting value in that cell.
3. Type another value in the next cell to start sequence.
4. Select cells with values that you've typed inside.
5. Drag 'fill handle' to include number of cells that you want in your sequence.
ROW Function
6. Type '=ROW(A1)' into the first cell of the range you want to sequence. This will give you the number 1 in that cell.
7. Type specific number after '=ROW(A1)' to start numbering at a certain point. For example, typing '=ROW(A1),'2010-000' will create a starting number of 2010-001.
8. Drag 'fill handle' to include number of cells that you want in your sequence.
Read more ►

How to Use MS Excel 2007 to Calculate Sum


1. Enter values into a row or column of cells.
2. Navigate to the cell you want the sum to appear. You may pick any cell, even one nowhere near the cells you want to sum.
3. Click the 'AutoSum' button in the Editing Box at the far right of the Home tab. Excel will enter the Sum Function in the active cell, including a range of cells to add.
4. Make certain the cell range is correct (notice the dashed box for a visual representation of the cell range). Press the Enter key to confirm the Sum function.
5. Drag through another range of cells if the range Excel entered is not the range you need summed. In other words, left click into the first cell you want in the equation and move the mouse through the additional cells. Press the Enter key to confirm the function.
Read more ►

How to Copy Formulas in Excel


1. Determine what formula is to be copied and to what location it is to be copied. Carefully consider the cells that are to be referenced in the formula and that they are indeed the cells that contain the information to be acted upon by this formula.
2. Highlight a cell that has the formula in it and click the right mouse button. Select the 'Copy' option.
3. Move to the new destination cell for this formula, right click the mouse button and select 'Paste.'
4. Check the first cell to make sure the correct calculation has been performed. If not, check the formula that appears in the cell that contains the result of the formula that was just copied. Make sure that the formula references the correct cells. If not, correct the formula and then copy the corrected formula to the rest of the cells that should have this formula applied to them.
Read more ►

How to Write Simple Macros in Excel


1. Go to the worksheet you want to insert a macro on.
2. Click 'Record New Macro' after clicking 'Macro' on the Tools menu.
3. Name the macro with keyboard shortcut or assign it to a toolbar. You can also add a description of the macro for reference later. These are all optional commands that you can do in the dialogue box, the next step in the wizard. If you don't want to do any of these things, you can skip the step all together and click 'OK' to start recording the macro. New macros are saved in the global template named Normal.dot by default and you can always assign a name or toolbar location after you've created the macro.
4. Start recording by clicking 'OK' and create the macro by going through each step as you normally would while doing the task.
5. Click the 'Stop Recording Button' when finished recording the macro. You can also press the 'Pause Recording Button' if you need to pause the recording.
Read more ►

How to Determine Y Axis Values in an Excel 2003 Line Graph


1. Highlight the entire range, including the x-axis and y-axis values.
2. Click 'Insert' from the menu bar. Click 'Chart.' This launches the Chart Wizard. Alternatively, click the icon of a bar graph from the toolbar.
3. Select 'Line' under 'chart type.' Pick a sub-type from the right pane. Click 'next.' The wizard will generate a preview of your chart, guessing which values you want on the y-axis. The window will change to 'Step 2 of 4.' If the wizard correctly determined your values, click 'finish' to insert the chart.
4. Click the 'series' tab. One box will contain the cell numbers of the range Excel identified. It will look something like '=Sheet1!$B$3:$B$8.'
5. Click the icon at the right end of this box. It will contain a small red arrow. The wizard will appear to close, and the spreadsheet will return.
6. Highlight the data you want to select as your y-axis values. The wizard window will return.
7. To select y-axis values for additional data series, repeat Steps 5 and 6 for other boxes in the window.
8. Click 'finish.'
Read more ►

Blogger news