How to Lock Charts in Excel

1. Open the worksheet with the graph in Excel.
2. Click the 'Review' tab and then click 'Protect Sheet.'
3. Click 'Allow All Users of This Worksheet To' and then select the elements you want people to be able to change. For example, even though the chart is protected, you may want users to be able to format cells, insert rows or perform sort functions on the worksheet.
4. Type a password into the 'Password to Unprotect Sheet' box and then click 'OK.' You need to type the password again to confirm it.

Read more ►

How to Calculate Age in Excel Using a Date of Birth

1. Open a new Microsoft Excel 2010 worksheet.
2. Click on cell A1. Enter the birth date of the person whose age you want to know. You can enter a date with dashes between the numbers, such as '3-30-1983.'
3. Click on cell B1 and enter this formula:=datedif(A1,today(),'y')In this example, 'A1' refers to the cell where you typed in the person's birth date. 'Today()' calls the current date on the machine. 'Y' indicates that Excel should give the result in years. Press 'Enter' on your keyboard to complete the formula entry, and the person's age will appear in cell B1.

Read more ►

How to Delete an Embedded Chart in Excel

Delete an Excel Chart Object
1. Launch Microsoft Excel. Click the “File” tab followed by “Open” and open the workbook document that contains the embedded chart.
2. Click the chart object to select and highlight the item. After it is highlighted, Excel displays a box around the chart with “handle” dots around the edge of the box.
3. Press the “Delete” or “Del” key on your computer keyboard to delete the embedded chart.
Delete an Excel Chart Sheet
4. Highlight the chart sheet in the Excel workbook document.
5. Click the “Home” tab on the main menu ribbon across the top of the document.
6. Click the down-arrow icon in the “Delete” section of the “Cells” group. Select “Delete Sheet” from the pull-down options list.
7. Click “OK” in the confirmation dialog box. Excel deletes the chart sheet and the chart object.

Read more ►

How to Import Excel 97 Macros to Excel 2003

1. Click 'Start' > 'All Programs' > 'Microsoft Office' > 'Microsoft Excel' to open Excel 2003.
2. Click 'File' > 'Open,' browse through your computer files to find the Excel 97 worksheet you want to import, select the file and then click 'Open' to open the Excel 97 worksheet in Excel 2003.
3. Click 'Tools' > 'Macro' > 'Security' to access the macro security options in Excel 2003.
4. Select the 'Medium' security setting to ensure that you are able to access most of the safe macros on any file but avoid accessing potentially harmful macros.
5. Click 'OK' to save the new security settings and then you'll be able to do whatever you need to do on the Excel 97 worksheet you just imported to Excel 2003.
6. Click 'File' > 'Save As,' select 'Excel 97-2002' from the 'File Type' menu and then click 'Save' to save the worksheet. Saving the worksheet in this manner will keep the worksheet accessible to any Excel version starting with Excel 97 and ending with Excel 2003.

Read more ►

A Tutorial to Sort in Microsoft Excel

Excel 2003
1. Open the file in Excel 2003 with data that you would like to sort.
2. Highlight the data that you would like to sort. If you want to sort the entire worksheet, click the small rectangle located in the top-left corner between the 'A' column and the '1' row.
3. Click 'Data' from the drop-down menu located above the toolbar.
4. Click 'Sort.'
5. The 'Sort' dialog box is displayed. Specify which column you would like the data sorted by first, second and third.
6. Specify if you want the data sort in ascending (alphabetical or number sequence low to high) or descending (reverse alphabetical and number sequence high to low).
7. Under the 'My list has' section, choose whether your data has a 'Header Row' or 'No Header Row.' This refers to whether you input a title for the columns that you want to sort. For example, is one of the columns titled 'date' or 'name?' If you do have header titles for your columns, you can click the 'Header Row' radio button and Excel will sort the data starting below your header rows. If you do not have header rows, click the 'No Header Rows' radio button and Excel will sort all the data.
8. Click 'OK' to sort your data.
9. If you only want to sort a single column of data, highlight just the column of data you would like to sort and then follow steps 3 through 8.
Excel 2007 and 2010
10. Open the file in Excel 2007 or 2010 with data that you would like to sort.
11. Highlight the data that you would like to sort. If you want to sort the entire worksheet, click the small rectangle designated with a small triangle located in the top-left corner between the 'A' column and the '1' row.
12. Click on the 'Data' tab located across the top of the screen.
13. Locate the 'Sort Filter' box.
14. This box displays the options of 'Sort A to Z' (ascending order) or 'Sort Z to A' (descending order) or to choose custom sort under 'Sort.'
15. Clicking 'A to Z' or 'Z to A' will quickly sort the data you have highlighted.
16. Click 'Sort' to apply additional parameters for the sort.
17. A 'Sort' dialog box is opened displaying the parameter choices of 'Column,' 'Sort On' and 'Order.'
18. Click the 'Column' drop-down menu.
19. A listing of the highlighted columns is displayed. Choose which column you would like to first sort the data by (i.e., date, name, title).
20. Next click the 'Sort On' drop-down menu.
21. Excel allows you to choose which feature you would like to sort the data on. For example, you can choose to sort the data by the values in the cells, the color of the cell (if you have colored coded your data), the cell font color (if you have colored the text within the cell, such as negative numbers being colored red) or cell icon.
22. Next click the 'Order' drop-down menu.
23. Choose whether to sort the data in ascending (A to Z alphabetical or number sequence low to high) or descending (Z to A reverse alphabetical and number sequence high to low) order.
24. At this point, if you would like to sort the data by data in multiple columns, click the 'Add Level' button located at the top-left of the 'Sort' dialog box. This feature allows you to sort first by the data in one column and then by the data in a second column, third column and so on. For example, if you have an address book in Excel, you could choose to sort the address book first by last name, then by first name. At that point, you could even choose to sort it by a third criterion of city. Your data would then be displayed in alphabetical order by last name and then first name, and then categorized by city.
25. Click 'OK' when you are finished setting the parameters.
26. If you only want to sort a single column of data, click in the column header cell of the column of data you would like to sort and then click either the 'A to Z' or 'Z to A' button.

Read more ►

How to Move a Picture, Text Box or Other Object in PowerPoint, Excel or Word Exactly Where You Want it

Removing Word Restrictions
1. Launch the Word 2010 document that contains the object that you want to move.
2. Click the object, and then click the 'Format' tab on the far-right end of the Word ribbon.
3. Click the 'Arrange' button in the ribbon. Select 'Wrap Text' from the menu that appears. Then choose 'Through,'Behind Text' or 'In Front of Text.' Any of these three options release the object so that you can click on the object's border and move it where you want.
Removing PowerPoint Restrictions
4. Open the PowerPoint 2010 presentation that contains the object you want to move.
5. Click the object, and then click the 'Format' tab at the top of the screen.
6. Click the 'Arrange' button in the PowerPoint ribbon, and then click the 'Align' button on the menu that appears. Finally, click 'Grid Settings' to open up a small window.
7. Remove the check mark from the 'Snap objects to grid' option by clicking on the check box. Click the 'OK' button to close the window. Your PowerPoint objects can now be positioned anywhere on the presentation.
Precisely Moving Objects
8. Open the Excel, Word or PowerPoint file that holds the object you want to move.
9. Select the object that you want to move.
10. Press and hold the 'Ctrl' key on your keyboard. If you are moving a text box, click any of the four corners to select the box without placing the cursor inside the box. Tap the arrow keys to move the object one pixel in the direction of the arrow that you press.

Read more ►

How to Create Axis Bar Graphs in Excel

1. Open Microsoft Excel. Start with a new document or load an existing spreadsheet with data you wish to analyze.
2. Organize the data in a row structure. If you are creating a new spreadsheet, type different items of the same data set over many rows within the same column. For example, if you wish to graph daily temperature changes, create a column heading called 'Temperature' in cell A1. Then, type each day's weather below it in cells A2, A3 and on down through column A. Do not skip any rows.
3. Click on any cell within the data column so Excel recognizes the active set of data. It is not necessary to highlight or select the data, as Excel can easily recognize where the list begins and ends.
4. Click the 'Chart' button on the tool bar. Optionally, click on the 'Insert' menu and choose the 'Chart' option. A pop-up window will appear.
5. Select the chart type you wish from the list. To create a conventional bar graph, choose either the 'bar' or 'column' graph types. Both create a bar chart, but change the angle of the bars to either horizontal or vertical.
6. Select a chart sub-type from the selection to the right of the chart type list. This selection changes depending on the chart type you choose. Bar charts can be presented in a three-dimensional view or with various forms of color shading.
7. Press the 'Next' button.
8. Choose the 'Rows' option, since your data exists within a row structure. A preview of the final chart will appear in the window.
9. Press the 'Next' button.
10. Add an additional explanation to either axis. The column heading of column A is automatically selected as the 'X' axis title. You may offer additional wording to describe the axis in the 'Category X Axis' field, if desired, to maintain full control over the axis of the bar graph.
11. Press the 'Finish' button. Your bar graph is now created in Excel.

Read more ►

How to Copy a Worksheet As a Picture in Excel 2007

1. Highlight the area that you want to copy as a picture. Click in the uppermost left cell and drag to the lowermost right cell while holding down the mouse button.
2. Click the 'Copy' drop-down menu on the 'Home' tab. Select the 'Copy as Picture' option. This action will launch a separate dialog window.
3. Select 'As shown on screen' to copy the selection as a screen shot, or select 'As shown when printed' to copy the selection as it would appear printed on a page. Select the 'Picture' option to copy the worksheet as a scalable image, or select 'Bitmap.' The 'Bitmap' copy will result in more distortion if you need to enlarge the worksheet picture after it is pasted into another document. Click the 'OK' button to copy the worksheet. You may now paste the picture into another document using the 'Paste' option.

Read more ►

How to Prevent Excel From Dropping Off Leading Zeros

1. Open your Microsoft Excel document or a new Excel document.
2. Select the cells you would like to modify. If you wish to modify the entire spreadsheet to show leading zeros, click the diamond icon in the upper left of the workbook window, or click the 'Edit' drop-down menu and choose 'Select All.' If you want to select only a portion of the cells, click the leading cell and drag to highlight additional cells. Also, you can click the letter at the top of a column to highlight an individual column. You can do the same for rows by clicking the number at the beginning of a row.
3. Select the 'Format' drop-down menu. Choose 'Cells...' or 'Format Cells,' depending on the release of Excel you are running. A window will pop up.
4. Choose the 'Number' menu within the 'Format Cells' window. Scroll down through the list of various categories and select 'Text.' This will allow any data put into a cell to be displayed as it was input. Click 'OK.'

Read more ►

How to Create a Pivot Table From Multiple Pivot Tables

1. Open the PivotTable you would like to work with. Also open a worksheet you would like to consolidate all other pivot table information onto from one PivotTable.
2. Click on a cell with the new worksheet where you want to start the consolidated data.
3. Click 'Consolidate' on the Data menu.
4. Click on 'Sum' (or another function) in the Summary function in the Function box. This is the function you want Microsoft Excel to use to consolidate the data.
5. Input the sheet tab of the first range to consolidate in the Reference box and repeat for each PivotTable you want to grab information from. Select 'Create links to source data' check box if you want to update the data and need to know which PivotTables are open to access the data.
6. Create a new PivotTable from the consolidated data. On the Data menu, click 'PivotTable and PivotChart Report.' Use the data from the consolidated worksheet for your data range and click through all other options. Click 'Finished' for consolidated PivotTable.

Read more ►

How to Remove Encryption in Excel 2007

1. Open the encrypted spreadsheet in Excel, which will require your password.
2. Click the circle in the upper-left side of the Excel window. This will appear just before 'Home' on the menu and will have a Windows logo inside. In the drop-down menu, select 'Prepare' and then 'Encrypt Document.'
3. Delete the password in the window entitled 'Encrypt Document.' Press 'OK' to remove the password from your spreadsheet.

Read more ►

How to Add a Note to an Excel Formula

1. Open an Excel file with existing formulas or create your worksheet with at least one formula.
2. Click in the cell at the end of the formula. For example, click within cell A5. Then type the formula '=A2 A3' (without quotes).
3. Go to the 'Ribbon' at the top of Excel and click on 'Review.' Click on 'New Comment.' A colored text box will appear to the right of cell A5.
4. Start typing your comment after the username that appears. When finished typing, click another cell. The cell with a comment will contain a red triangle. Move your mouse over the cell to reveal the comment.
5. Alternatively, add a note directly to the Excel formula by using the 'N' function. To do so, add the following to your existing formula: N(“Write your comment here”). Move your mouse over the cell to reveal the comment.

Read more ►

How to Remove a Drop Down Box in Excel 2003

1. Click inside the cell from which you want to remove the drop-down list box. Do not double-click, as this will take you into the cell editing mode; just use a single left click.
2. Select the 'Data' menu from the top menu bar, and then click the 'Validation' option in the menu that opens.
3. Click the 'Settings' tab in the data validation dialog box.
4. Click 'Clear all' and then select 'OK'. Your drop-down list will be deleted.

Read more ►

How to Open a Xlsx File

Microsoft Excel
1. Launch Microsoft Excel. Click “Start,” “All Programs” and “Microsoft Office.”
2. Choose “Microsoft Excel” so that the program will start. A new spreadsheet will open.
3. Go to the ribbon and click the “File” tab. Select “Open” from the menu so that a dialog window appears. Select “My Computer” on the left, browse to find your XLSX file, then click “Open” so that it will load inside the program
OpenOffice Calc
4. Launch the OpenOffice spreadsheet. Click “Start,” “All Programs” and “OpenOffice.org”
5. Choose “OpenOffice.org Calc” so that the program will start. A new spreadsheet will open.
6. Go to the top menu and click “File” then “Open.” At the window prompt, browse to find your file, then click the “Open” button so that it will load into the software.
SkyDrive
7. Navigate to the Microsoft SkyDrive website, create an account and log in. If you have a Windows LiveID or Hotmail account, you may log in using your username and password instead.
8. Go to the menu and click “Add files.” A 'File Upload' dialog window will open.
9. Browse to find your XLSX file, then click “Open.” Your document will load into the Excel Web application, and will be accessible to you online.

Read more ►

How to Combine Columns in Access

1. Open the database you want to update in Access.
2. Go to the Database window and choose 'Query' from 'Objects.' Then select 'Create query in using wizard.'
3. Click the 'Tables/Queries' drop-down in the wizard and select the first table containing the columns you need.
4. Select the fields (columns) you want to add. To add a single field, click the '>' button. To add all the fields, click the '>>' button.
5. Click the 'Tables/Queries' drop-down and choose the next table containing the columns you want to combine. Then follow step four to add the fields. To add additional columns from other tables, repeat this step and click 'Next.'
6. Type in a title for your query.
7. Choose the 'Open the query to view information' option and click on 'Finish.'

Read more ►