How to Put a Password in My File in Excel

1. Launch Excel.
2. Click the 'File' menu option, then click 'Info.'
3. Click the 'Protect Document' icon and select 'Encrypt With Password.' A window pops up and prompts you to enter a password.
4. Type a password into the box. Mix upper- and lowercase letters with numerals and special characters -- such as question marks and dollar signs -- to improve the strength of the password. Excel allows up to 255 characters in a password.
5. Click 'OK' to input the new password. Save the file normally to lock in the encryption.

Read more ►

How to Create a Macro in Excel 2007

1. Open Excel 2007 and click the 'Developer' tab at the top-right end of the window. Click the 'Record Macro' button at the top of the 'Code' heading.
2. Type a name for the new macro in the 'Name' text box, such as 'Adding Columns' or 'My New Macro.' Type a key in the 'Shortcut Key' text box if you want to map a shortcut to the new macro. Pressing the 'Ctrl' key and the key you specify will automatically run the new macro.
3. Type a brief description of what the macro is intended to accomplish in the 'Description' box if you think other users may potentially need your macro. Click 'OK' to begin recording the new macro.
4. Perform the specific operations you want recorded in the macro, such as adding together the values in columns, creating new rows or calculating the average of two cells.
5. Click 'Stop Recording' when you are done performing operations. Click the 'Macros' button when you need to run the macro. Click the macro's name and then choose 'Run.'

Read more ►

How to Delete Multiple Rows in Excel 2007

1. Open 'Microsoft Office Excel 2007.'
2. Click the 'Office' button, and select 'Open.' Locate the file you want to edit, and click the 'Open' button.
3. Click the row heading on the left side of the sheet for the first row you want to select.
4. Press and hold the 'Ctrl' key, and click the row headings for the remaining multiple rows you want to select.
5. Click the arrow beside the 'Delete' icon in the 'Cells' group under the 'Home' tab in the Office ribbon menu at the top of the program.
6. Click 'Delete Sheet Rows.'
7. Click the 'Save' icon located next to the Office button to save the changes you've made to the file.

Read more ►

How to Get a List of the Unique Values in an Excel Spreadsheet

Filtering
1. Highlight the cells you wish to filter for unique values.
2. Click the 'Data' tab and select 'Sort Filter,' then 'Advanced.' Inside the box that pops up, choose 'Filter the list, in place' if you wish to filter the data within the spreadsheet. You can also copy the filtered list into a new table by clicking 'Copy to another location,' then selecting the cell range you wish to paste by entering the range in the 'Copy to' field.
3. Choose the check box for 'Unique records only,' then click 'OK' to generate the list of values.
Removing Duplicate Values
4. Highlight the cells from which you wish to remove duplicate values.
5. Navigate to the 'Data' tab and select 'Remove Duplicates,' which is located in the data tools group.
6. Select one or more columns under the 'Columns' section in the pop up box, based upon those columns from which you wish to remove duplicates. Click 'OK.'
7. A message will display showing how many values were removed from the data table and how many unique values are left. Document the information you need, then click 'OK' to view the table.
Applying Conditional Formatting
8. Highlight the cells to which you wish to apply conditional formatting for unique values.
9. Select 'Conditional Formatting' under the 'Home' tab and within the 'Style' group,
10. Choose 'Manage Rules,' then select 'New Formatting Rule.'
11. Ensure the cell range and worksheet displayed in the 'Show formatting rules for' box are appropriate. Then select 'Edit rule.'
12. Select 'Format only unique or duplicate values.' in the Edit Formatting Rule box that pops up. In the 'edit the rule description' field, choose 'Format all' as the list and then choose 'unique' or 'duplicate,' depending upon which items you want to highlight. Choose the type of formatting you want (i.e., color, font, fill) then click 'OK.'

Read more ►

How to Export Excel 2007 to a Works Database

Install the Microsoft Office Compatibility Pack
1. Go to the Microsoft Office Compatibility Pack for Word, Excel and PowerPoint File Formats page (see Resources).
2. Scroll down to the 'Quick Details' section and choose the language for the file you would like to download by clicking the down arrow next to the 'Change Language:' label and making your selection. Click the blue 'Download' button and save the 'FileFormatConverters.exe' file to your computer.
3. Click the down arrow next to the 'Estimated Download Time' label to choose the speed of the Internet connection you are using.
4. Read through and (if necessary) follow the instructions in the 'Overview' and 'System Requirements' sections to be sure your program will function properly once installed.
5. Click 'Start,' type 'Windows Update' and press 'Enter.' Click 'Check for updates' in the Windows Update window that opens and install all recommended software to bring your system up to date. If Windows Update does not recommend software, it is because your computer is already up to date.
6. Open the 'FileFormatConverters.exe' file you saved and follow the instructions given to install the program on your computer.Use the following instructions to save the file in CSV format if you have Excel on your computer and you do not want to install the Microsoft Office Compatibility Pack.
7. Open the file in Excel that you want to transform and click the 'Office' button, select 'Save As' and then 'Other Formats.'
8. Select the downward arrow next to the 'Save as type' label in the 'Save As' dialog box and scroll to find 'CSV (Comma delimited) (*.csv)' and select it. Click the 'Save' button. Save one sheet at a time if saving data from multiple sheets in a workbook. If you are using this method, use the CSV file instead of the Excel file for the conversion.
Convert the Excel Spreadsheet to a Works Spreadsheet
9. Click 'Start' and navigate to the file you want to convert. Right-click on the file, select 'Open with,' then select 'Choose Program' to open the 'Open With' window.
10. Scroll through the list to find 'Microsoft Works.' If it is there, select it and click the 'OK' button to close the 'Open With' dialog box and open the file in the selected program.If you did not find Microsoft Works listed in the 'Open With' dialog box, find the Microsoft Works program and click the 'wksss.exe' file, then click 'OK' to close the dialog box and open the file in the selected program.
11. Click on 'File' on the top menu in Works and select 'Save As.' Be sure the 'Save as type' option is set to Works format. The extension will be '.wps.'
12. Name the document and click the 'Save' button.
Create the Works Database
13. Click cell A1 (the top-left cell in the spreadsheet) and hold down the 'Ctrl' and 'Shift' keys and press the 'End' key to select the active cell range in the workbook.
14. Click 'Edit' on the top menu and select 'Copy' to copy the cells you want to include in your database.
15. Click 'File' on the top menu and select 'New' and then click 'Add to a Field' to create a new database.
16. Click 'Edit' on the top menu and click 'Paste' and click 'Yes' to let Works add extra fields.

Read more ►

How to Convert Columns to Percent Using VBA

1. Open the Excel 2010 spreadsheet where you want to format a column as a percentage. Once the spreadsheet is open, press 'Alt' and 'F11' to open up the VBA console.
2. Right-click on the first worksheet listed on the left side of the VBA console. Choose 'Module' from the popup menu under 'Insert.' Click on the new module that appears a few lines underneath the worksheet.
3. Place your cursor in the white space on the right side of the VBA console. Type 'Sub ColConv' and press 'Enter.' VBA will automatically add the 'End Sub' command to the code.
4. Place your cursor on the line between the 'Sub' and 'End Sub' commands. Enter the following code into the console:Columns('A:A').SelectSelection.NumberFormat = '0.000%'Change both 'As' to whatever column you want to convert. Change the number of '0s' after the decimal to determine how many decimal places the percentage will show. For example, '0.00%' will display a percentage as '15.55%,' while '0%' will display a percentage as '16%.'
5. Click the 'X' at the top of the VBA console to close it. You can run your macro by clicking the 'Macro' button in the 'Developer' tab. Just choose 'ColConv' from the list and click 'Run' to convert your specified column to a percentage.

Read more ►

How to Use Macro in Excel With Examples

1. Start Excel. A new workbook is automatically opened for you.
2. Open the macro recording window. In Excel 2003, click on 'Tools > Macro > Record New Macro' and in Excel 2007 click 'View > Macros > Record Macro.'
3. Type in a meaningful name in the macro box according to what you want to record: for example 'OpenTaxFile,' or 'MakeExpenseSheet.'
4. Enter a shortcut key for your macro in the 'Shortcut key' box. For example, enter a 'O' to assign the keys 'Ctrl' and 'O' to your macro.
5. Click on 'OK.' The macro recorder is now running.
6. Perform the task that you want the macro to automate. For example, open a particular file by click on 'File > Open' in Excel 2003, or 'Office > Open' in Excel 2007 and then locate the file. You can also format a spreadsheet: for example, make an expense sheet by typing in any information that you want contained on the sheet, like mileage and business expenses.
7. Stop macro recording by clicking on 'Macro > Stop Recording.' Your macro is now ready for testing and use.

Read more ►

How to Calculate R Squared for Measurements in Excel

1. Open a new Excel 2010 spreadsheet. Click on cell 'A1' and type in a header for your measurements. This text will appear at the top of the chart where your R-squared value is located.
2. Click on cell 'A2' and enter your first measurement. Then enter the rest of your measurements down column 'A.'
3. Select cell 'A1' and click the 'Insert' tab at the top of the Excel window. Click the 'Line' button, located in the 'Charts' area of the ribbon. Select the 'Line' option, which will be the icon in the upper-left corner, from the menu that appears. A line chart will appear on your spreadsheet.
4. Click anywhere on the chart to select it, and then click the 'Layout' tab at the top of the screen. Click the 'Trendline' button in the Analysis area of the ribbon, and choose 'More Trendline Options' from the pop-up menu.
5. Click the radio button next to 'Linear' in the Format Trendline window. Then place a check mark next to 'Display R-squared value on chart,' near the bottom of the window. Click 'Close' to close the window. Your R-squared value will appear just above the trendline on the chart.

Read more ►

How to Use Squared in Excel

1. Launch Microsoft Excel, then enter the number to be squared into cell A1. Press 'Enter' to move the focus to cell A2.
2. Press the Equal sign '=' and type the word 'Power' followed by a left parenthesis '(' and then click once on cell A1 to select it as the source. Type a comma ',' and then the number '2' and a right parenthesis ')' and press 'Enter.' The cell A2 now shows the squared value of whatever is entered into cell A1, or in other words the contents of cell A1 raised to the second power. The final formula will look like this: =POWER(A1,2)
3. Change the number in cell A1 to any other number and the formula in cell A2 will automatically update to reflect the value of cell A1 raised to the second power.

Read more ►

How to Print Microsoft Excel Spreadsheets With Gridlines

1. Open the Microsoft Excel spreadsheet that you would like to print with gridlines. Make sure that all of the information on the spreadsheet is correct and ready to print.
2. Click 'File' and 'Page Setup.' This will bring up a box where you will be able to change different features of your spreadsheet.
3. Click the tab at the top of this box that says 'Sheet.' From this box you will be able to change different ways that you can print your spreadsheet. Find the box that says 'Print.' You will see a box inside this area that says 'Gridlines.' Click this so that there is a check in the box. Click 'OK.' When you print your spreadsheet, you will be able to see the gridlines behind your content.

Read more ►

How to Convert Decimal Time Into Seconds in Microsoft Excel

1. Open a new Excel 2010 spreadsheet.
2. Click on cell 'A1,' and type in the time in decimal form. Enter the minutes before the decimal point if you want the result to display like it would on a clock.
3. Click on cell 'A2.' Type the following formula into the cell: '=((A1-INT(A1))*60)' (without quotes). Press 'Enter' to complete the formula, and you will see the number of seconds appear in the box. This formula will remove the minutes from the equation entirely, so if you entered '4.5' into cell A1, your result here would be '30,' as '.5' is exactly half of a minute.
4. Click on cell 'A3.' Type the following formula into the cell: '=(A1/60)/24' (without quotes). Press 'Enter' to complete the formula. This will give you the numerical version of the time, which Excel can then convert into hours, minutes and seconds.
5. Right-click on cell 'A3,' and choose 'Format Cells' from the pop-up menu. Select 'Time' from the list of options on the left side of the window. Choose one of the time options that includes hours, minutes and seconds, but does not include a.m. or p.m.
6. Click 'OK' to close the window. You will see cell A3 change to show you your entered time in hours, minutes and seconds.

Read more ►

How to Use Goal Seek in Visual Basic

1. Open the Excel document in which you'd like to run your Goal Seek macro.
2. Find the two cells you would like to use for Goal Seek. The first should be the cell for which you have a fixed goal. The second should be a cell you allow Excel to change in order to fulfill that goal. The first cell's value must be a formula that is based on the second cell--otherwise, no matter what changes Excel makes to the second cell, no changes will appear in the first.
3. Open the Macro window. In Excel 2007 or later, do this by clicking on the 'View' tab of the ribbon, then clicking 'Macros.' In earlier versions of Excel, click the 'Tools' menu, choose 'Macro,' then choose 'Macros.'
4. Type a name for your Goal Seek macro in Macro window, and click 'Create.' This will launch the Visual Basic for Applications editor and show you the text of the new Macro, which will start out as an empty subroutine like this:Sub MyMacroName()
End Sub
5. Create a Range object representing the cell for which you have a known goal (the first cell from Step 2). For example, if you'd like to Goal Seek cell A1, write:Dim goalCell As Range
goalCell = ThisWorkbook.Worksheet(1).Range('A1')
6. Create a Range object representing the cell you'd like Excel to change to cause the first cell to reach the known goal. For example, if you'd like Excel to manipulate cell A2, write:Dim variableCell As Range
variableCell = ThisWorkbook.Worksheet(1).Range('A2')
7. Call the GoalSeek method on the goal cell's Range. As the first argument, provide the value you'd like it to Goal Seek to; as the second argument, provide the variable cell's Range. For example, if you'd like to Goal Seek to 0, write:goalCell.GoalSeek(0, variableCell)

Read more ►

How to Make a Chart With Standard Errors in Microsoft Graph

1. Type your data into Excel using a column format. For example, if you are creating a chart for children's test scores, type the names of the children in the first column, then type the test scores in the second column.
2. Highlight the data in the document. Click at the top left, then drag the cursor to the bottom right.
3. Click 'Insert,' then click 'Chart.' Follow the instructions on the Chart Wizard to create a graph of your choice.
4. Double click a series on the chart, then press 'Ctrl' and '1' to open the Format Series dialog box.
5. Click either the 'X Error Bars,' or the 'Y Error Bars' tab, depending on what type of error bar you want to add.
6. Click an icon that represents the specific error bar you want to add. The choices are 'Both,' 'Plus,' 'Minus,' or 'None.'
7. Click a radio button for the error amount, and type an amount into the error text box. For example, click the radio button for 'Fixed value,' then type '2' into the text box.
8. Click 'Ok.'

Read more ►

How to Delete a Custom Toolbar in Excel 2003

1. Open Excel 2003 and locate your customize toolbar. Click 'Tools' on the menu bar and select 'Customize.' The Customize dialog box appears.
2. Click the 'Toolbars' tab in the Customize dialog box. Search the menu for your custom toolbar's name. Use the scroll bar to drag up and down to find your custom toolbar's name. Remove the check from custom toolbar's name.
3. Click the toolbar name. The toolbar name is highlighted in blue. Click the 'Delete' button. The custom toolbar is deleted.

Read more ►

How to Import an MS Outlook Calendar Into MS Excel

1. Launch Microsoft Outlook.
2. Click the 'File' tab at the top of the window.
3. Click 'Open,' and then click 'Import.'
4. Click 'Export to a file,' and then click 'Next.'
5. Click 'Microsoft Excel 97-2003,' and then click 'Next.' This is the .XLS file type, which is compatible with all versions of Microsoft Excel from 97 to 2010.
6. Click 'Calendar,' and then click 'Next.'
7. Click 'Browse,' and then select a location on your computer for your Excel calendar file. Click 'Next' to continue.
8. Click 'Finish.'
9. Browse to the file location you selected earlier, and then double-click the file to open it in Excel.

Read more ►