How to Lock an Excel 2003 Spreadsheet

1. Launch Excel and open the spreadsheet which you want to protect.
2. Click the 'Tools' menu, expand the 'Protection' submenu and select 'Unprotect sheet.' This step will allow Excel to reinitialize the protection of the spreadsheet. If the spreadsheet is password protected, you may have to type in the current password.
3. Click the 'Tools' menu again, expand the 'Protection' submenu and select 'Protect sheet.' The 'Protection' dialog box will open.
4. Click the actions which you wish to allow users to perform on the sheet in the 'Allow all users of this worksheet to' list. For example, you can allow users to create a new column but prevent them from deleting any existing columns.
5. Type the password you wish to use to protect the spreadsheet in the 'Password to unprotect sheet' field. Confirm your changes by clicking 'OK.'

Read more ►

How to Remove Locked Cells in Excel 2003

1. Open Excel 2003 and click the 'File' drop down menu. Select 'Open.' Browse the files and locate the workbook. Click the workbook and the 'Open' button. The workbook opens.
2. Click the worksheet that contains the locked cells. Click the 'Tools' drop down menu and select 'Protection.'
3. Select 'Unprotect Sheet.' If a password was applied to the protection, you will be prompted to enter the password. Click 'Ok.'
4. Click the 'Format' drop down list and select 'Cells.' Click the 'Protection' tab and de-select the 'Locked' option. Click 'Ok.' The lock is removed from the cells.

Read more ►

How to Use Excel to Calculate Total Time

1. Enter the starting date and time in cell A1 using the format 'month/day/year hour:minutes AM/PM.' For example, if your starting time is 7:15 a.m. on July 15, 2010, you would enter '7/15/2010 7:15 AM' in cell A1.
2. Enter the ending date and time in cell A2 using the format 'month/day/year hour:minutes AM/PM.' For example, if your ending time is 7:15 a.m. on July 17, 2010, you would enter '7/17/2010 7:15 AM' in cell A2.
3. Enter '=A2-A1' in cell A3 to find the number of days between the two times. Excel will automatically display the total time. In this example, Excel would automatically display '2.' If you want to convert to hours elapsed, multiply by 24. If you want to convert to minutes, multiply by 1,440.

Read more ►

How to Make All of the Columns the Same Size in Microsoft Excel

Using a Mouse
1. Open the Excel worksheet with data in columns.
2. Hover your cursor over the letter of the first column you wish to select. When the black down arrow appears, click and drag across to the last column you want to select.
3. Hover on the line between any two selected column letters--it doesn't matter which two--until you see a black symbol with two arrows pointing in opposite directions. Click and drag left to make the columns narrower or drag right to make them wider. All the selected columns should now be of equal width.
Using the Menu
4. Open the Excel worksheet with data in columns.
5. Hover your cursor over the letter of the first column you wish to select. When the black down arrow appears, click and drag across to the last column you want to select.
6. Click the 'Home' tab, then click 'Format' in the Cells section.
7. Select 'Column Width' from the menu.
8. Enter a number in the box provided and click 'OK.' You can specify any number between 0 and 255; this represents the number of characters the column will display.

Read more ►

How to Use the Date Function in Excel to Show Next Month

1. Open Excel 2007 and type '2010' in cell A1. Enter '10' in cell A2 and '11' in cell A3. This information will be used as reference data in the Date function. Enter the Date function '=Date(A1,A2,A3)' in cell B1. This function will display a numerical representation of the date 10/11/2010.
2. Format how the date displays by right-clicking cell B1 and selecting 'Format Cells.' Click the Number tab and pick the 'Date' category. Select a date format. Click 'OK.'
3. Change the formula in cell B1 to add 30 days to the current day to display the next month. Enter the following formula: '=DATE(A1,A2,A3 30).' The cell will reflect the date of 11/10/2010.

Read more ►

How to Create a Linear Chart Using Excel 2007

1. Open Microsoft Excel from the 'Start' menu and wait for the application to load.
2. Enter the data you want to convert into a chart into cells on a spreadsheet. Include labels for each column in row 1. Ensure that the X and Y values are in their own columns and each row contains the X and Y value that should be graphed together on the chart.
3. Click and drag from the top-left cell to the bottom-right cell to highlight all the data you want to include in the chart.
4. Click the 'Insert' tab on the top of the screen.
5. Click 'Scatter,' and then choose the chart type you wish to use. As soon as you click a chart type, it will automatically be inserted into the spreadsheet.
6. Select the 'Layout' tab under Chart Tools. Click 'Trendline,' and then choose linear trendline from the drop-down menu.

Read more ►

How to Change the Case in Excel 2007

1. Open Excel 2007 and select a workbook that contains data that needs the case changed. Click the 'Office' button and select 'Open.' Browse your computer and locate the workbook. Click the workbook and select 'Open.'
2. Insert a column near the data. Click on the first cell in the column. Click on the 'Formulas' tab in the ribbon. Select the 'Text' option. Click 'Proper.' The Function Arguments window opens. Click on the red box in this window. Highlight the first cell that needs the case changed. The cell reference appears in the Function Arguments window. Click 'OK.'
3. Review the results of the Proper function. The case of the data has been changed to proper case. The first letter of each word is now capitalized.

Read more ►

How to Copy a Pivot Table to Another Worksheet

Copy the Worksheet
1. Click on the worksheet that contains the Pivot Table. You can do this easily by clicking the appropriate worksheet tab that appears at the bottom of the Excel window.
2. Right-click the worksheet tab again. A pop-up menu will appear. Choose the 'Move or Copy' option. Another pop-up menu appears.
3. Click the 'Create a copy' check box. Then click once on the existing worksheet in the menu list before which you wish to place the copy of the Pivot Table.
4. Press the 'OK' button. Excel copies the Pivot Table to another worksheet and places the copy in the specified worksheet location.
Copy the Pivot Table
5. Click on the worksheet that contains the Pivot Table you wish to copy.
6. Click once on an empty cell in the upper left of the Pivot Table, just above the Pivot Table data.
7. Drag the mouse down and to the right until you reach an empty cell on the lower right of the Pivot Table.
8. Right-click on the selected Pivot Table cells and choose the 'Copy' option. Alternately, press the 'Ctrl' and 'C' keys on your keyboard to copy the information.
9. Click in the worksheet where you wish to place the copied Pivot Table. Press the 'Ctrl' and 'V' keys, or right-click and choose the 'Paste' command.

Read more ►

How to Print Selected Areas of an Excel Worksheet

1. Start Microsoft Excel and open the file you want to change.
2. Drag to highlight the cells you want to print.
3. Open the File menu and select Print.
4. In the 'Print what' box, click Selection.
5. Select OK to print your selection.

Read more ►

Excel Tutorial on Statistics

1. Decide what statistical function or test you need to perform. For example, you might be trying to find an average, or mean, of several numbers, or you may want to find the slope for a graph that you've already plotted in Excel.
2. Click on the cell where you want to insert the statistical function.
3. Find the function name in Excel. Click on the 'Formulas' tab in Excel 2007 or Excel 2010, then click on 'More Functions.' Mouse over 'Statistical,' then click on the function you need. Most functions are named so that you can easily find what you are looking for. For example, AVERAGE finds the average of a range of numbers and MAX finds the maximum value in a range of numbers. If you are unsure about a particular function, mouse over the function name to find out more about the function or press the 'F1' key to bring up the help window for formulas and functions.
4. Fill out the information requested in the pop up window. The information will depend on which of the dozens of functions you have chosen. In general, you can expect to at least have to choose a range of cells to perform the function on. For example, if you want to find the average of a set of numbers in cells A1 to A10, then you'll need to enter 'A1:A10' as the range in the pop up window.
5. Press the 'OK' button. Excel will perform the requested function and return the result in the requested cell.

Read more ►

How to Create an Excel XLA Add

1. Launch the Microsoft Excel software. Click 'File' in the top navigational bar and select 'New' from the drop-down menu. A Workbook Options window will be displayed. Press 'Blank Workbook.' Excel will create a new workbook.
2. Select 'File' in the top menu again. Select 'Properties' from the drop-down menu. Look in the Document/Name Properties box and press the tab labeled 'Summary.' Name the new workbook. This name will be what is shown in the add-ins window after you are finished.
3. Click 'Tools' in the top menu bar and select 'Macro'; then click 'Visual Basic Editor.' The editor will appear on the screen.
4. Click 'Insert' in the top menu bar and click 'Module' from the drop-down menu. A code module box will be displayed. Enter in the function code with which you want the Excel add-in to work. For example, you may type 'Function' followed by a space, then 'Age(DoB As Date).' This add-in, if activated in an Excel worksheet, will convert any references to DoB to the numbers listed in the Date column. If you are unsure of how to structure a function code, browse the Microsoft Excel help site (see Resources).
5. Save the file. You may now add it to a current worksheet by selecting 'Tools' in the worksheet and choosing 'Add-Ins.' Navigate to the hard drive folder in which you saved the XLA file and click it; then press 'Open.'

Read more ►

How to Use an Access Pivot Table

1. Click 'Start,' 'All Programs,' 'Microsoft Office' and then select 'Microsoft Access 2010.'
2. Click 'File' and then 'Open' and browse to the Microsoft Access database you want to analyze.
3. Click 'View' and then select 'PivotTable View' and this displays the 'PivotTable Field List.'
4. Select a numerical field from the 'PivotTable Field List,' then drag and drop this field in the 'Drop Totals or Detail Fields Here' section of the pivot table view. For example, if you want to know how many orders you have in a store database, the order quantity field is the numerical field you select, since it represents the number of orders. A simple pivot table view is displayed showing the summarized list of the order quantities.
5. Select the field representing the store's product identifier from the 'PivotTable Field List,' then drag and drop it in the pivot table view section labeled 'Drop Row Fields Here.' Now the pivot table view is displayed listing the order quantities for each store product. The grouping of information by store product identifier makes the pivot table summary more meaningful for analysis.
6. Right-click the numerical field column name in the pivot table view and select 'AutoCalc' and then select 'Sum' and now you have a meaningful pivot table that summarizes the order quantity for every store product in your database.

Read more ►

How to Open QBB Files Without QuickBooks

1. Open either Quicken or Excel. Quicken is another financial program similar to QuickBooks while Excel is a spreadsheet program packaged in the Microsoft Office platform.
2. Select 'File,' 'Import,' then choose the QBB file you want to view.
3. Click 'OK' and wait for the software to convert the QuickBook document into its own format standard. Once complete, the financial information appears on your computer screen.

Read more ►

How to Learn Excel Spreadsheet

Free Excel Training from Microsoft
1. Download and install a free trial version of the Microsoft Office suite that includes Excel and several other useful programs in a limited time, fully functional trial version.
2. Click 'Start' at the Windows orb, 'All Programs' and 'Microsoft Office' to open the start menu group. Click 'Microsoft Excel 2010' to launch the software.
3. Click 'File' and 'Help' to launch the interactive training series to learn basic and intermediate Excel functions and to find step-by-step guides to performing the most popular functions.
Basic Excel Functions
4. Click 'Start' at the Windows orb. Click 'All Programs' and 'Microsoft Office' to open the start menu group. Click 'Microsoft Excel 2010' to launch the software.
5. Click once in the top left cell -- A1 -- and type in any number. Press 'Enter' to save the cell and move to the next cell down or press 'Tab' to save the cell and move to the next cell to the right. Alternately, type in any number and click another cell or use the arrow keys on the keyboard to save the cell contents and move to another cell.
6. Enter another number in a second cell. Press 'Enter' or otherwise save the cell contents by moving to another empty cell.
7. Press the '=' sign on the keyboard. Click the first cell with a number in it once with the mouse. Press the ' ' sign on the keyboard. Hold 'Shift' and press ' ' or press the ' ' key on the numeric keypad, if equipped, and then click once on the second cell with a number in it. Press 'Enter.' This creates a formula to add two cells together and display the results in a third cell.
8. Click in the first cell with a number and change the number. Press 'Enter' or otherwise save the cell contents by moving to another empty cell. Notice that the cell that displays the total updates automatically to reflect the new total. Formula cells update as new information is entered.

Read more ►

How to Create Invoices in Microsoft Word From Excel 2007

1. From a new blank workbook in Excel, click the 'Office' button and then the 'New' icon to display the 'New Workbook' dialog box. Under the 'Microsoft Office Online' section, choose 'Invoices' to view the invoice templates that are available for free download. Filter out customer-submitted templates, if desired, by clicking on the 'Hide customer submitted templates' icon at the top of the screen.
2. Preview the available templates by single-clicking on each one to view the template in the preview pane to the right. Click on the 'Download' button once you've selected the desired template. You will briefly see a status window until the file download is complete (downloading times are usually minimal, but will vary depending on the speed of your Internet connection). A new Excel window showing your template will pop up after the download has completed.
3. Select the cells containing data in this new worksheet, then right-click the selected data and choose 'Copy.'
4. With the Excel window still open, launch Microsoft Word. In the 'New Blank Document' screen, click the 'Paste' menu button in the 'Clipboard' group on the 'Home' tab. Choose 'Paste Special' to launch the 'Paste Special' dialog box.
5. Under the 'Paste As' section, choose the 'Microsoft Excel Binary Worksheet Object' option and then click 'OK.' Your invoice template will be pasted into Word as an Excel object. In order to enter your data into the template and temporarily alter the ribbon to show Excel commands, double-click the Excel object.

Read more ►