1. Open the Microsoft Excel 2007 file on your computer that contains the worksheet or workbook that is password protected.2. Click on the 'Review' tab, and then click on the 'Unprotect Worksheet' option from the 'Changes' group.3. Enter your password if the 'Protect Workbook' dialog box appears.4. Click on the 'OK' button, and then the 'Unprotect Worksheet' option will read as 'Protect Worksheet.'5. Click on the 'Microsoft Office' button, and then click on the 'Save' button to save your changes to unprotect the workshe...
Browse » Home » All posts
Thursday, June 21, 2012
How to Create Organizational Charts With Excel 2007
1. Open Excel to a blank spreadsheet.2. Click the 'Insert' tab, then click the 'SmartArt' button.3. Select the 'Hierarchy' group from the left pane. Choose an organizational chart layout you like. Click on each one to see a preview and a description of it in the right pane. Click 'OK' after you have selected the one you want. You should see a chart with text boxes and lines appear.4. Select a shape in the chart, then click the down arrow next to the 'Add Shape' button in the Design tab to add more boxes to your organizational chart. You can select whether you want to add a shape before,...
How to Calculate a Future Date in Excel
1. Open a new or existing Excel workbook and select a new worksheet.2. Use row 1 for column labels. Type 'Start Date' into cell A1--column A, row 1. Type 'Plus 30 Days' into cell B1, 'Plus 60 Days' into cell C1 and 'Plus 90 Days' into cell D1. To display these column labels correctly, you need to widen columns A, B, C and D. To widen a column, select its right border and then drag it to the right.3. Select--highlight--cells A2 through D3. Under the 'Home' tab, select the 'Cells' grouping, click 'Format' and then click 'Format Cells' to display the 'Format Cells' window. Click 'Date,' select...
How to Use Conditional Statements in Excel
The Three Parameters of IF() Statements1. The first parameter in an IF() statement is an equation or logical operator. For example, A1>A2.2. The second parameter of an IF() statement is separated from the first by a comma, and is what is displayed if the IF statement is true. For example, 'Passing Grade'.3. The third parameter of an IF() statement is separated from the second by a comma, and is what is displayed if the IF statement is false. For example, 'Failing Grade.'4. Finally, here's a completed IF() statement: =IF(A1>A2,'Passing Grade','Failing Grade'). This statement...
Tuesday, June 19, 2012
How to Download Microsoft Excel 2003
Buy an Older Version1. Make sure that your computer is capable of running Excel 2003. The requirements are Windows XP or later, 128 MB of RAM and 400 MB of hard-disk space.2. Log on to an online software store such as Brothersoft.com, Amazon.com or Excellent-software.net.3. Type 'Excel 2003' in the search bar on the website.4. Scroll through the results and select the program you wish to purchase.5. Select the method of payment you wish to use. Most websites accept PayPal or credit card payments. Enter your payment details and then confirm the transaction.6. Follow the on-screen instructions...
How to Prevent a Microsoft Excel 2007 File from Opening
1. Open your spreadsheet in Microsoft Excel 2007.2. Click the top-left 'Office' button, and select 'Save As.'3. Click the 'Tools' drop-down menu, located to the left of the 'Save' button, and select 'General Options.'4. Enter a password in the 'Password to open' field, and click 'OK.'5. Re-type the password in the confirmation window, and click 'OK.'6. Click 'Save' to secure your spreadsheet.7. Click 'Yes' in the 'Confirm Save As' dialog windows, which asks if you want to replace the current file. This overwrites the unprotected file with the password-protected versi...
How to Copy and Paste for Conditional Formatting in Excel
Copy Conditional Formatting1. Select the Excel cell that contains the conditional formatting rules you want to copy. Hold the 'Ctrl' button and press the letter 'C' to copy the cell to the clip board.2. Right click on the cell you want to copy the conditional formatting to. If you are copying it to a range of cells, left-click on the first cell and hold the mouse button down. Then move the mouse to the last cell and release the button. Finally, right-click on the selected cells.3. Move your mouse over 'Paste Special' in the pop-up menu to reveal additional pasting options. Select the icon...
How to Show Grid Lines When Printing in Microsoft Excel
Printing1. Open the worksheet or worksheets in Excel that you wish to print. You can do this by clicking on theworksheet tab at the bottom of the screen. To select more than one worksheet, after you select the first worksheet, press Shift and then select the second or multiple worksheets.2. Go to the 'Page Layout' tab on your menu bar for Microsoft Excel 97-2003 or interface for Microsoft Excel 2007.3. Select the 'Sheet Options' group and click on the 'Print' check box under 'Gridlines.'4. Preview the grid lines to view how they will print by pressing the 'Ctrl F2' keys to open the Print...
How to Create a Form in Excel 2007
1. Open the Microsoft Excel 2007 application. Click the “Microsoft Office” button and select “Open.”2. Locate the Excel 2007 file stored on your computer for which you want to create a form. Select the file and click on the “Open” button.3. Add any column headers to the columns within the spreadsheet. Click on any cell in the data table where you want to add the form.4. Click on the arrow next to the Quick Access Toolbar and click on the “More Commands” option. Click on the “All Commands” option and select the “Form” button from the list.5. Click on the “Form” button from the Quick Access...
Monday, June 18, 2012
How to Find Out How Often a Number in a Set Appears in Excel
1. Highlight your data set. For example, if your set of numbers is in cells A1 to A50, highlight cell A1 with your mouse.2. Choose 'Data' from the ribbon. Click on 'Advanced' to bring up a pop-up box.3. Check the 'Copy to another location' radio button, and check the 'Unique records only' box. Enter the range of your data set. In this example, cells A1 to A50 would be entered as $A$1:$A$50. In the 'copy to' box, enter where you would like the data to be output. For example, enter $B$1:$B$50 (which will return the result in cells B1 to B50). Press 'OK.' This returns a list of numbers in your...
How to Use Hyperlinks in Dropdown Menus in Excel
Adding Links to Drop-down Menus1. Access editing capabilities by double-clicking the cell in the menu that contains the URL that you would like to hyperlink.2. Activate the URL by pressing 'Enter.' This will convert the text URL to an active hyperlink.3. Click that now-active hyperlink one more time to complete the process.4. Repeat Steps 1 through 3 for each menu item.Alternate Method5. Choose a menu cell, for example, cell B6.6. Insert the following function into cell C6 (the cell below the chosen menu cell):=HYPERLINK(B6, 'Goto Link')7. Change 'GoTo Link' to your choice of te...
How to Use Excel to Make a Percentage Bar Graph
1. Open Excel to a blank spreadsheet.2. Enter your numbers in cells in table form and add labels for each column and row. For example, if you want to compare men to women and the percent who smoke vs. the percent who do not smoke, you would create a 2x2 table. You would label one column 'Men' and one column 'Women.' To the left, you would label the first row 'Smoke' and the second row 'Don't smoke.' When entering numbers in each cell, add the percent sign to let Excel know that these are percentages. For example, you should enter '32%' instead of '32.'3. Select the table you created by clicking...
How to Add a Watermark to an Excel Spreadsheet
Insert Your Watermark1. Place your cursor where you would like the watermark to appear. Choose to put this in a header or footer or in the middle of a page.2. Choose 'Picture' under the 'Insert' menu.3. Browse for and select your image. Hit 'OK.' Your image should now be on the spreadsheet.Adjust the Coloring to Make the Image Look Like a Watermark4. Click on the photo. This will make the picture toolbar appear.5. Click 'Format Picture' on the toolbar.6. Under 'Image Control/Color,' select 'Watermark.' This will lighten the colors in your image to look like a waterma...
How Can I Make a Dynamic Drop
1. Launch Excel 2003 and click the Tools menu. Select Macro and then Visual Basic Editor. Insert a new module by clicking the Insert menu and selecting Module. Type the following to create a new procedure:Private Sub createDropDownList()On Error GoTo Err_createDropDownList:2. Type the following to dynamically create a new ComboBox control in the active Excel worksheet:With ActiveSheet.OLEObjects.Add(ClassType:='Forms.ComboBox.1', Link:=False, _DisplayAsIcon:=False, Left:=70, Top:=60, _Width:=100, Height:=25)With .Object.AddItem 'Item List 1'.AddItem 'Item List 2'.AddItem 'Item List 3'End WithEnd...
How to Copy Paste a Range to a VBA Excel Workbook
1. Create two different workbooks in Excel. The first workbook will contain the range that you want to copy while the other one is where you will paste the range into. Keep the workbook that currently has the range open. The other workbook doesn't have to be open to complete the rest of the steps.2. Open the Visual Basic Editor. Click on 'Tools > Macros > Visual Basic Editor' in Excel 2003 or earlier. In Excel 2007, you will need to show the 'Developer' tab first. Click on the 'Office' button and then 'Excel Option.' Click the checkbox next to 'Show Developer tab on the ribbon' under...
Subscribe to:
Posts (Atom)