1. Open the Excel workbook where you want to enter your VBA code. Press 'Alt' and 'F11' to open up the VBA console.2. Double-click on the module where you want to enter your code. If there is no module you can right-click on a worksheet, move your mouse over 'Insert' and choose 'Module.' Then double-click on the module to bring it up.3. Copy the following formula into the module:Sub AReplace()Dim sb As WorksheetFor Each sb In Worksheetssb.Cells.Replace What:='XXX', Replacement:='YYY', LookAt:=xlPart, _SearchOrder:=xlByRows, MatchCase:=FalseNextEnd SubChange 'XXX' to the value you are searching...
Browse » Home » Archives for April 2012
Saturday, April 28, 2012
How to Filter Duplicates in Excel
1. Click 'Start' then 'All Programs.' Open Excel 2010 by clicking 'Microsoft Office Excel 2010.'2. Click 'File' then 'Open.' Select the Excel spreadsheet that contains the duplicate data you wish to filter.3. Click the 'Data' tab then click the 'Remove Duplicate' button. A dialog box opens which lets you select the columns and rows that you want Excel to scan for duplicate data.4. Click 'Select All' then click 'OK.'5. Click 'OK' once more to confirm the success of the operation. The spreadsheet is now filtered of duplicate da...
How to Add (or Subtract) in a Spreadsheet like Excel
1. Open the Excel worksheet.2. Enter the values in a row or column.3. Click a cell to the right of the row of values or click a cell below the column of values. The selected cell displays a black outline.4. Click the 'Home' tab.5. Click the 'AutoSum' button in the 'Editing' group. This summation button displays the uppercase Sigma. A formula appears with the range of cells.6. Press the 'Enter' key. The total appears in the selected ce...
Friday, April 27, 2012
How to Convert the Date to Text in Excel
1. Open in Excel the workbook that has the dates you want converted to text. If that file isn't available, populate date data into a single column (A2) in a new Excel workbook.2. Label your date column (presumed to be column A for purposes of this instruction) as 'Date' in cell A1. Label the column where you want the converted date to populate as 'Date-Text.'3. Enter the following formula in the second row of the 'Date-Text' column to convert the date to dd-mmm-yyyy format:=TEXT(A2,'dd-mmm-yyyy')Example:Date: 1/10/2010Date-Text: 10-Jan-2010Copy this formula down the column as necessary to...
How to Calculate Empty Cells Using Excel
1. Add the following numbers and blank cells in the first column of your Excel 2007 document. For example, add the numbers 2,3,leave blank,5,6,7,leave blank,9,0,2,3,4,leave blank,6,7, and 8 in A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14 and A15. Here 'leave blank' means don't enter any value in A3, A7 and A13.2. Click on the 'A17' cell for this example. This is the cell where you will calculate how many total blank cells are in this column. You can choose any cell to calculate total blank cells.3. Click 'Insert Function' on the top left-hand side of the Excel spreadsheet. The...
Thursday, April 26, 2012
How to Build a Savings Interest Calculator in Excel
1. Open a new spreadsheet in Excel.2. Label row 1 as follows: A1 is 'Date,' B1 is 'Balance,' C1 is 'Additional deposits' and D1 is 'Interest.' Format columns B, C and D as currency by selecting the columns and clicking on the dollar sign button in the 'Home' tab. (Users of Excel 2003, click the dollar symbol on the Formatting toolbar.)3. Call your bank or look at your account online to find out when the bank adds interest payments to your account.4. Fill in column A with interest payment dates, starting with the most recent date your account received an interest payment. If your bank adds...
How to Make a Relative Frequency Histogram on Excel 2007
1. Create a column for your independent variables (your x-values). For example, if you are comparing the performance of salespersons, write 'Jim' in cell A2, 'John' in cell A3, 'Sue' in cell A4, 'Pat' in cell A5 and Joe in cell 'A6.'2. Create a column with your dependent variables (your y-values). For the example given in Step 1, write 12 in cell B2,11 in cell B3,10 in cell B4, 9 in cell B5 and 4 in cell B6.3. Sum the dependent variable column by clicking an empty cell at the bottom of the data and entering the summation formula. For the Step 1 example, you have information in cells B2 to...
How to Calculate the Time Difference Between Two Times in Excel 2003
1. Open Excel 2003, and select a workbook that contains columns with time information. Click 'File' on the menu bar, and select 'Open.' Browse your files, and select the workbook. Click the 'Open' button. The workbook opens.2. Highlight the first column that contains time data. Right-click the highlighted data, and select 'Format Cells.' The Format Cells dialog box appears. Click the 'Number' tab. Select 'Time' from the 'Category' list. Select the first time format displayed. Click 'OK.'3. Highlight the second column that will appear in the timed calculation. Press 'F4.' This repeats...
Wednesday, April 25, 2012
How to Use MegaStat in Excel 2007
1. Create a new spreadsheet in Excel 2007.2. Open MegaStat.3. Click the 'Add-Ins' menu option at the top-right of the screen, and you will see a new available option for 'MegaStat.' Click it to gain access to all MegaStat's functio...
Tuesday, April 24, 2012
How Do I Create a Color Drop Down Box in Excel?
Create Lookup List With Background Color1. Go to a section of unused cells in the spreadsheet.2. Type the choices that will appear in the drop-down list. Type one choice per cell and compose a list of choices with each selection under the previous one.3. Highlight all cells in the list and then right-click on the highlighted block of cells.4. Click 'Format Cells' from the context menu.5. Click the 'Fill' tab and then click on the desired color for the background of the lookup list (the selected cells).6. Click 'OK.' The background color of the cells is set.Add the Lookup Cells As a...
How to Create Conditional Formats in Excel 2007
1. Open an existing Microsoft Excel document in which to create these conditional formats. Double click on the 'My computer' option on the main operating system desktop. Choose the location of the Excel file and double click on the file icon to open the document.2. Ascertain which cells or worksheet the conditional formatting will apply to. Prior to opening the conditional formatting manager, choose particular cells, the entire worksheet or workbook to apply the conditional format.3. Choose the 'Conditional Formatting' button from the home menu ribbon. Then select the 'Manage Rules' option...
How to Make Mailing Labels in Excel 2007
1. Open the Excel 2007 worksheet containing the list you want to use to make mailing labels. If you do not yet have a list, open a blank worksheet. Enter a name for each column in the first row of the worksheet. Choose names that will be easy to understand in the merge, such as 'First Name,' 'Last Name' and 'Street Address.' Save and close the worksheet.2. Start Word 2007. Go to the 'Mailings' tab and click 'Start Mail Merge.' Select 'Labels' from the drop-down list. The 'Label Options' dialog box opens.3. Select the label settings for the label pages you are using. Pick the label brand...
How to Put Excel Data Into a Pie Chart
1. Open a new worksheet in Microsoft Excel. Add headings in the first column down the left side of the page. For instance, if you are making a pie chart of my favorite things, you would write, 'Football,' in cell A1, 'Chocolate,' in cell A2, and 'Television,' in cell A3. Then, put the numbers in the 'B' column. So, using the above example, this would mean you'd put 50% in cell B1 next to 'Football,' a 30% in cell B2, next to 'Chocolate,' and a 20% in cell B3 next to 'Television.'2. Highlight all of the cells in both columns, from A1 to B3. In Microsoft Excel 2007, simply click the 'Pie'...
Monday, April 23, 2012
How to Merge Excel Worksheets Into a Workbook
1. Open Microsoft Excel. Press and hold the 'Ctrl' key on your computer's keyboard and press the 'O' key to start the 'Open' window. Click on the first workbook you would like to open. Press and hold the 'Ctrl' key and click on the second workbook. Press the 'Open' button at the bottom right of the 'Open' window to open both workbooks.2. Click the workbook on the bottom Windows toolbar that contains the sheet that you would like to merge. Right-click the sheet tab that you would like to move or copy. For example, right-click 'Sheet 1' tab at the bottom left of the Excel workspace to select...
How to Delete Cells in MS Office 2003
1. Open an existing worksheet in Microsoft Excel.2. Select the cell (or cells) you want to delete from your worksheet. To select an individual cell, simply click the cell. For a range of cells, click the first cell and drag your cursor down to the last cell. If it's a large range, click the first cell in the range, and press 'Shift' while you click the last cell. Press 'CTRL' while clicking individual cells that aren't adjacent.3. Open the 'Edit' menu.4. Click 'Delete.' As a shortcut, right-click the selection and click 'Delete.'5. Make a selection in the 'Delete' dialog box. Select...
How to Divide Cells in Excel
Divide the Numbers in a Cell1. Click on a cell to enter your data.2. Type an equal sign (=).3. Type your first number. For this example, we will divide 15 by 5.4. Press the forward slash key on your keyboard (/). This is the division sign in Excel.5. Type in your next number, 5.6. Press the 'Enter' key on your keyboard or click on the check mark on the tool bar. This displays the result of the calculation.Divide Numbers in a Range of Cells7. Type the number 15 into cell A1.8. Type the number 5 into cell A2.9. Click cell A3 and type an equal sign (=).10. Click on cell A1. 'A1'...
How to Calculate a Percentile Using Excel
1. Enter your dataset in a continuous column in Excel. For this example, assume that the data is entered in cells A1 to A100.2. Determine what percentile you want to calculate, and convert it to a number between zero and one. For example, the 20th percentile is 0.2, the 55th percentile is 0.55, the 100th percentile is 1, and so on. This example will use the 40th percentile (0.4).3. Enter the following formula in the cell where you want the percentile result to show:=PERCENTILE(A1:A100,0.4).This tells Excel to calculate the 40th percentile of the data in cells A1 to A1...
How to Add a Shadow to a Chart in Excel
1. Start Microsoft Excel and open an existing workbook from your files that contains a chart to which you would like to add a shadow.2. Select the chart you would like to add a shadow to by clicking on it with your mouse. The chart will be surrounded by a light blue outline when it is selected.3. Choose the 'Format' tab at the top of the Excel screen to show the formatting options that you can apply to your selected chart. Locate the 'Shape Styles' section of the 'Format' ribbon.4. Click the small half box and arrow button that lies on the 'Shape Styles' title bar on the lower right corner....
Sunday, April 22, 2012
How to Make a Pictograph on Excel
1. Launch Excel 2010 and open a spreadsheet containing data that can be expressed in a graph. Highlight the cells that you want Excel to include in the graph.2. Select the 'Insert' tab at the top of the window. Click 'Column' or 'Bar' in the 'Charts' section of the toolbar to generate a graph from the selected data.3. Double-click one of the graph's bars. This opens a Format Data Point window.4. Select the 'Fill' heading on the left side of the Format Data Point window.5. Click to select the 'Picture or Texture Fill' radio button.6. Click the 'File' button under 'Insert from' and double-click...
How to Set Printing Options in Excel
1. Start Microsoft Excel and open a spreadsheet that you would like to print.2. Choose the 'File' button and click 'Print' to bring up the 'Print' dialog box.3. Change the printer you are using by clicking the 'Name' list under the 'Printer' section of the 'Print' dialog box. You can view the printers you have installed and click on which printer you would like to use to print your spreadsheet.4. Check the 'Print to file' check box in the 'Printer' section of the 'Print' dialog box to print the spreadsheet to another computer file instead of from a printer.5. Set the print range of your...
How to Use Excel 2003 Formulas Functions for Budgets
1. Decide which formula you want to use. For example, you may want to add a column of data or multiply certain budgetary numbers by 12 to convert from a monthly to yearly budget.2. Locate the formula you need in the 'Microsoft: Excel Commonly Used Formulas' (see Resources). For example, click on 'Add Numbers' in the Math subsection. One of the functions you can use is the 'Sum' function, which adds numbers in a single cell or multiple cells.3. Enter the formula into the cell where you would like the answer to appear. For example, you may want to add a list of budget items in cells B2 to...
How to Scroll With a Mouse Wheel in Excel 2007
1. Open Microsoft Excel 2007 and launch the document you need to view.2. Click inside the document somewhere (or on the scrollbar at the side of the page). This tells the mouse you are working inside the loaded Excel document.3. Drag your finger from top to bottom over the scroll wheel on the mouse. This moves the page down and you can see the scrollbar on the side of the screen move with your movements.4. Drag your finger from the bottom of the scroll wheel to the top. Doing so scrolls the page back up toward the top of the docume...
Saturday, April 21, 2012
How to Make Vertical Words in Excel
1. Open your spreadsheet in Microsoft Excel.2. Click the cell containing the text you wish to make vertical.3. Click the 'ab' symbol in the Alignment group of the Home tab and select 'Vertical Text' to align letters on top of one another. Alternatively, select 'Formal Cell Alignment,' enter '-90' or '90' in the 'Degrees' field, and click 'OK' to rotate normal text 90 degrees. Selecting '-90' will align the bottom of the characters to the left, while selecting '90' will align them to the rig...
How to Use Excel 2007 to Make a Climate Graph With Negative Temperatures
1. Open the Worksheet.2. Enter a date or time in each cell along one column or one row. For example, the dates April 1, April 2 and April 3 can fill cells B4, B5 and B6, respectively.3. Enter the temperature values, one value per cell, in this temperature column. The values can be positive or negative. Enter these values in cells adjacent to the categories in Step 2. For example, enter '7' '-2'and '4' in cells C4, C5 and C6, respectively.4. Click the cells that contain the dates and temperature values.5. Click on the 'Insert' tab on the Ribbon. The 'Charts' group includes the 'Line'...
How to Remove Password Protection in Excel
1. Open Excel and open the workbook for which you wish to remove the password protection. At this point, if you are using Excel 2003 or an earlier version, proceed to Step 2. If you are using Excel 2007, skip straight to Step 5.2. Click on the 'File' menu, and then select 'Save As.' Click on the 'Tools' menu and select 'General Options.'3. Double-click on the asterisk that is in the 'Password to open' box, and then press 'DELETE' on your keyboard. DO the same for the box labeled 'Password to modify.'4. Click on 'OK,' then 'Save,' and finally 'Yes' to complete the password protection removal...
How to Get Data From Excel Into Word
1. Click Excel's Office button, then click the 'Open' command. Navigate to and double-click a file you'd like to open to Word. Click the 'Save as' command after the file loads, then click the 'Excel 97-2003' format from the 'type' dropdown list. This format lets Word read the Excel data. Click the Office button's 'Close' command to close the workbook.2. Click Word's Office button, then click the 'Open' command. Click the 'Excel' type from the 'Type' dropdown list, then navigate to the folder in which you saved the Excel workbook in the previous step.3. Double-click the workbook to begin...
How to Change the Toolbar in Excel 2007
1. Locate the Quick Access Toolbar in Excel 2007. It will be either next to the Office button or under the ribbon.2. Right-click on the Quick Access Toolbar and select 'Customize Quick Access Toolbar.' Check or uncheck the 'Show Quick Access Toolbar Below the Ribbon' box to place the toolbar where you want it.3. In the ribbon, navigate to the feature you want to add to the Quick Access Toolbar.4. Right-click on the feature you wish to add, and a menu will appear.5. Select the 'Add to Quick Access Toolbar' option. The feature should now be on the toolb...
How to Make a Time Line in Microsoft Excel
1. Gather all the information you need for the time line.2. Open Microsoft Excel. Click on the Excel desktop icon or find Excel in the Start Menu under 'All Programs.'3. Click the 'File' tab and pick 'New' to start a new spreadsheet.4. Add a title to your time line. Click 'Insert' and then choose 'Header and Footer.' Type the title in the header section. Format the title to suit your needs and click 'OK.'5. Move a few rows down the spreadsheet and input the first date. You can format the cells all at once or individually. If you are including times in your chart you may want to format...
Friday, April 20, 2012
How to Manipulate Data in an Excel 2007 Pivot Table
1. Open Excel 2007 and select a workbook containing data. Click the 'Office' button and select 'Open.' Browse your files and select the workbook. Click the 'Open' button to open the workbook.2. Highlight the data you want included in the PivotTable. Select 'Insert' on the menu bar, and then select 'PivotTable.' A drop-down menu appears. Select 'PivotTable' again. Click 'OK.'3. Add fields to the PivotTable by checking fields from the right 'PivotTable Field List.' By default, the fields appear in the column section. Manually drag the fields to any of these sections (row, totals or filter)...
How to Convert Excel Time Difference to Decimal Number
1. Click a cell where you want the decimal representation of the time difference to appear.2. Type '= A1 * 24' and then press 'Enter.'3. Change the cell location 'A1' to the actual location where your time difference appears. For example, if the time difference is 1:15 and appears in cell C3, type 'C3' into the formula instead of 'A1.' Pressing 'Enter' for this result will give you the decimal result '1.2...
How Do I Graph on a Secondary Axis in Excel Office Professional 2003?
1. Click on the data series on the chart that you want to plot on a secondary axis. For example, if you have a chart that shows price and volume and you want to display volume on a secondary axis, then click on 'volume.'2. Click on 'Selected Data Series' on the Format menu.3. Click on the 'Axis' tab, then click on 'Secondary axis.' Excel inserts a secondary axis into your workshe...
How to Create a Pivot Table from Multiple Worksheets
1. Open the workbook in which you want to create the PivotTable.2. Click 'PivotTable and PivotChart Report' on the 'Data' menu.3. Follow the instructions in the wizard. For the first step, you will be asked to identify the source for your data. Click the black box on the right-hand side of the source data box. This will disconnect the source box from the wizard.4. Select the data ranges in the worksheets you need data from. Start with the first range and then move on to the next. The wizard will automatically put a comma between each range of data you select.5. Click the black box on...
Wednesday, April 18, 2012
How to Calculate Days by Subtracting Two Dates in Excel
1. Launch Microsoft Excel and open a new worksheet. Type the date in one cell. For example, type '1/1/2010' in cell A1.2. Type your first date in cell A1. For example, input the date '1/1/2010.'3. Type your second date in cell B1. For example, input the date '3/14/2011.'4. Select the cell C1, type '=' and click the date in cell B1. Then type '-', click the first date and press 'Enter.' Cell C1 now shows 438, the number of days between the two dates you inp...
How to Create an Application in Word or Excel
Create an Application in Word1. Start Microsoft Word. In Word 2003, go to the 'File' menu and click 'New.' In Word 2007, click the 'Office Button' and click 'New.'2. Type 'Employment Application' in the 'Templates on Office Online' box and click the 'Search' button. Select 'Employment Application 2-pp Online Form' in the 'Search Results' list. Click the 'Download' button, and an application will open as a new Word document.3. Enter your company logo by selecting 'Your Logo Here.' Go to the 'Insert' menu in Word 2003, point to 'Picture' and click 'From File.' In Word 2007, go to the 'Insert'...
How to Change Macro Security Settings on Windows Vista
Changing Macro Security in Word or Excel 20071. Click the circular Office logo in the upper-left corner of the Word or Excel window, then click the 'Word Options' or 'Excel Options' button at the bottom of the menu.2. Click the 'Trust Center' link on the left side of the screen, then click the 'Trust Center Settings' button.3. Click the 'Macro Settings' link on the left side of the window to access the macro settings for the Office 2007 program you are using. The menus for Word 2007 and Excel 2007 are the same. The default selection is 'Disable all macros with notification.' To run your...
How to Keep Track of Changes in an Excel Document
Tracking Changes1. Start Microsoft Excel and open the file you want to change.2. Open the Tools menu and select Track Changes, then Highlight Changes.3. In the Highlight Changes dialog box, select 'Track changes while editing.'4. Select 'Highlight changes on screen.'5. Open the When menu and select All.6. Open the Who menu and select Everyone.7. Click OK.8. Click OK. This will save your changes and your file/workbook.9. Enter your new changes.Accepting or Rejecting Changes10. Open the Tools menu and Track Changes menu and select Accept and Reject Changes option.11. In the...
Tuesday, April 17, 2012
How to Unfreeze a Window Pane in Excel 2007
1. Select the 'View' tab from the top menu in Microsoft Excel 2007.2. Go to the 'Window' menu ribbon. Select 'Freeze Panes.'3. Choose 'Unfreeze Panes' from the pop-up menu to unfreeze your Excel spreadshe...
Monday, April 16, 2012
How to Install Office 2000 on Excel 2007
Installing Office 2000 without Excel 20001. Insert your Office 2000 installation CD. A dialog box should open.2. Provide details about your name and organization as well as the 25-digit CD key to continue the installation process, then select the 'Next' button. You will be redirected to another dialog box containing the Office 2000 End-User License Agreement; read it. If you agree, select the 'I accept' option, then click 'Next' to continue with the installation process.3. Select 'Customize' as your installation type, then select all Office 2000 component programs except Excel 2000.4. ...
How to Make a Cell Required in Excel 2007
Making Cells Required to Print Spreadsheet1. Open Excel 2007. Check for the 'Developer' tab in the ribbon across the top of the screen. If you do not have the 'Developer' tab activated, click the round blue 'Microsoft Office' button in the top left corner. Click 'Excel Options' followed by 'Popular.' Check the box for 'Show Developer Tab in the Ribbon,' and then click 'OK.'2. Click the 'Developer' tab, and then click the 'View Code' button under the 'Developer' menu. This will open Microsoft Visual Basic.3. Copy and paste the following code into the blank window:[vba]Private Sub Workbook_BeforePrint(Cancel...
How to Build Pivot Tables in Excel 2007
1. Open Excel and open a spreadsheet on your computer that has data in at least 5 columns and 10 rows. Make sure this data has column headers.2. Press 'Control' and 'A' to select all of the data in your spreadsheet. Click on the 'Insert' tab on the ribbon and select 'PivotTable.' Select 'PivotTable' again. Excel will open the Create PivotTable dialog box. In the section titled 'Choose the data that you want to analyze,' choose 'Select a Table or Range.' In the section titled 'Choose were you want the PivotTable report to be placed,' choose 'New Worksheet.' Click 'OK.' A new worksheet...
Sunday, April 15, 2012
How to Use Page Orientation on Excel 2007
Selecting Page Orientation1. Open Microsoft Excel 2007.2. Click the 'Page layout tab.'3. Click 'Page setup.'4. Click 'Orientation' and click either 'Landscape' or 'Portrai...
How to Merge Cells in a Shared Workbook
1. Navigate to the location of the shared workbook on your computer.2. Double-click on the workbook to open it.3. Click the top left cell that is going to be part of your cell merge, then drag the mouse pointer until all of the desired cells have been selected.4. Right-click anywhere in the highlighted area of cells, then select the 'Format Cells' option.5. Click the 'Alignment' tab, then check the box next to 'Merge cells.'6. Click the gray 'OK' button to close the wind...
How to Write Macros in Excel 2007
1. Make the 'Developer' tab of the ribbon visible. Click the 'Office Button' and select 'Excel Options.' Select 'Show Developer Tab in the Ribbon' in the 'Popular' category. Click 'OK.'2. Enable macros. Go to the 'Developer' tab. Click 'Macro Security' in the 'Code' group. Select 'Enable All Macros' and click 'OK.'3. Click 'Visual Basic' in the 'Code' group. The 'Microsoft Visual Basic for Applications' window opens. Go to the 'Insert' menu and select 'Module' to open a new module.4. Type or paste the macro that you want to use in Excel 2007. Press the 'F5' key to run the macro and ensure...
How to Unlock an Excel Password
1. Download an Excel macro designed to unlock passwords.2. Double-click 'allinternalpasswords.xls' to open the macro. The workbook itself is hidden and the macro displays a toolbar.3. Click the 'File' menu and click 'Open ...' to open the workbook that you wish to unlock.4. Click the button on the toolbar to unlock the password. The macro provides you with a password that will work in the locked workbook.5. Enter the provided password in order to unlock the workbo...
Saturday, April 14, 2012
How to Calculate Correlations Between Three Sets of Data Using Excel
1. Open your Excel file, click the 'File' tab, then click 'Options.'2. Click 'Add-Ins' at the left side of the window.3. Click the drop-down menu to the right of 'Manage,' click 'Excel Add-Ins,' then click 'Go.'4. Check the box to the left of 'Analysis Toolpak,' then click 'OK.'5. Click the 'Data' tab at the top of the window, then click 'Data Analysis' in the Data Analysis section of the ribbon at the top of the window.6. Click 'Correlation' and 'OK.' This opens a new Correlation window.7. Check the 'Columns' option if your data is sorted by columns, or check the 'Rows' option if...
Friday, April 13, 2012
How to Remove Dashes From Social Security Numbers in Excel
1. Open the Excel worksheet containing the Social Security numbers or other data from which you want to remove the dashes. Select the cells containing the numbers. If you want to remove the dashes from the entire worksheet, click the 'Select All' button, which is the rectangle between 'A' and '1' in the upper left of the worksheet. To select an entire row or column, click on the number or letter pertaining to that row or column. To select several cells in the worksheet, press and hold the 'Ctrl' key while you click on each cell.2. Click the 'Format' drop-down in the 'Cells' group of the 'Home'...
How to Create a Text Box in Excel
1. Open Microsoft Excel 2007 and or start a new blank workbook or open an existing workbook that you want to create a text box in.2. Select the 'Insert' tab from the top of the Excel 2007 screen to display the Insert ribbon. This ribbon includes all of the objects you can insert into an Excel workbook.3. Locate the 'Text' section of the Insert ribbon. It is the section at the end or the right of the Insert ribbon.4. Choose the 'Text Box' button from the Text section of the Insert ribbon. The button will be highlighted once it's clicked.5. Click in the area in the worksheet where you...
Thursday, April 12, 2012
Access Denied When Saving From the Excel 2007 Format to Excel 2003
1. Click the Windows 'Start' button and enter the folder location of the Excel file in the search text box. For instance, if the file is located in 'C:\myfolder,' enter this value into the text box and press 'Enter.' This opens an Explorer window that displays the folder contents.2. Right-click the folder that contains your Excel spreadsheet and select 'Properties.' A window opens that displays several options for your folder.3. Remove the check mark in the box labeled 'Read-Only.' This allows you to save your converted files to the folder and stops errors such as 'Access Denie...
How to Change X Axis Values in Excel 2007
1. Click on the x-axis to select it. Click somewhere beneath the bottom horizontal line of the chart to ensure that you select the axis rather than the chart area.2. Right-click within the selected area and choose 'Format Axis' from the drop-down menu that appears.3. Click the circle for 'Fixed' next to 'Minimum:' under 'Axis Options' and type the smallest number you want displayed on the x-axis in the box to the right. Do the same for 'Maximum:' but type the largest number you want displayed on the x-axis.4. Select the 'Fixed' circle next to 'Major unit:' and enter a number in the box...
How to Make a Graph With a Z
1. Open Microsoft Excel and enter your data into the vertical columns. Highlight your data. Click the 'Insert' tab, then click the 'Chart' button under it.2. Choose the graph you prefer, making sure that it is in 3-D. Click 'Press and Hold to View Sample' in order to preview the chart you selected before applying it. Click 'Next' once you have found the chart that works best for your purposes.3. Enter your data range by highlighting the appropriate columns of data and then clicking the button beside the field your selected information appears in. Click the 'Series' tab to edit or modify...
How to Use Excel 2010
1. Open a new Excel 2010 spreadsheet by double-clicking on the Excel icon on your desktop. Look at the spreadsheet and its layout. New files have three worksheets. Move between the three spreadsheets by clicking 'Sheet 1,' 'Sheet 2' or 'Sheet 3' in the lower left part of your screen.2. Examine the tabs along the top -- 'File', 'Home,' 'Insert,' 'Page Layout,' 'Formulas,' 'Data,' 'Review' and 'View.' Click on each one to see its options. Most basic Excel 2010 commands are found on the 'Home' tab.3. Click the cell in the upper left part of the spreadsheet marked A1, found in column A, row...
How to Remove Hyperlinks From Excel 2007
1. Double-click your Excel file to open the file in Microsoft Excel 2007.2. Select a blank cell in your spreadsheet, then type the number '1' into the cell.3. Right-click on the cell and select 'Copy.'4. Hold down the 'Ctrl' key on your keyboard as you select each cell containing a hyperlink that you want to remove.5. Click the 'Home' tab at the top of the Excel 2007 window.6. Click the arrow below 'Paste' in the 'Clipboard' section, then click 'Paste Special.'7. Click 'Multiply' in the 'Operation' section, then click 'OK.' This removes the actual hyperlink from the cell, but it...
How to Construct a Histogram Using Excel 2007
1. Capture the stock data. Go to Yahoo Finance and type 'SBUX' in the symbol box. Click on the link that says 'historical prices'. Go to the bottom of the page and click 'download to spreadsheet'. The info will download automatically and then open in an Excel spreadsheet.2. Get the Max and Min values of the 'Adj Close' column. Go to the editing option of the Home menu. In the drop-down box of mathematical functions select 'Max.' Type 'G2:G501' and press 'Enter.' Repeat the same with 'Min.' The Max value should be 28.29 and the Min value should be 7.17.3. Create the bin values. Round 28.29...
How to Make Sums in Excel 2010
1. Open the Microsoft Excel 2010 spreadsheet that contains the numbers you want to add together.2. Click on an empty cell in the spreadsheet, where you want the summation to appear. Type the equals sign into the cell to start a formula.3. Enter 'SUM(' if you want to add together a number of cells. Type in the column letter and row number of the first cell that you want to include. Place a colon after this cell reference if you are adding together a continuous range of cells, then type in the last cell in the range. Place a comma after the first reference if the selected cells are not continuous...
Wednesday, April 11, 2012
How to Link Data in Other Excel 2007 Workbooks
1. Open the Excel 2007 workbook that contains the data for which you want to link to other workbooks.2. Double-click in the cell on the Excel workbook the contents of which you want to link to other workbooks. This will select all the contents in that cell.3. Right-click in the selected cell and then click 'Copy.'4. Open the other Excel 2007 workbook to which you want to link the data you selected from the workbook that you opened in Step 1.5. Right-click in an empty cell on the workbook, click the 'Home' tab, click the downward pointing arrow below 'Paste' and then click 'Paste Special.'6....
How to Use the Cursor to Highlight Rows in Excel 2003
1. Move the cursor to the row number on the left side of your spreadsheet and click the number to highlight the row.2. Move the cursor to another row number, hold down the 'Shift' key, and click the row number to highlight all the rows between the first highlighted row and the new row. For example, highlight row 12, move the cursor to row 20 and shift-click the row number to highlight all rows between 12 and 20.3. Move the cursor to another row, hold down the 'Ctrl' key and click the row number to highlight only individual rows. For example. highlight row 12, move the cursor to row 20 and...
Subscribe to:
Posts (Atom)