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...
Browse » Home » All posts
Sunday, April 15, 2012
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...
Wednesday, March 28, 2012
How to Create a Drop Down List in Microsoft Excel
1. Type the list items into cells in a column of the current worksheet or another worksheet. Name the list if you enter it into a different worksheet. Select the list and click inside the 'Name' box at the top left corner of the worksheet next to the 'Formula Bar.' Type a name for the list and press 'Enter.'2. Click on the cell in which you want to create a drop-down list. To enter the list into several cells, press and hold the 'Ctrl' key and click on each cell in which you want to use the list.3. Go to the 'Data' menu in Excel 2003. Click 'Validation' and go to the 'Settings' tab of the...
Tuesday, March 27, 2012
How to Count All Rows With a Blank Cell in Excel 2007
1. Type '=COUNTBLANK(' in an empty cell.2. Highlight the column of data you want to calculate the number of empty cells.3. Press 'Ente...
Subscribe to:
Posts (Atom)