1. Start a new document and add data or open the document containing the data you wish to convert into a graph. Arrange the data with the item headers at the top of the column and data in the same column or the headers at the beginning of the row and the data to the right.2. Select the data you want to include in the graph.3. Click on the 'Insert' tab in the ribbon.4. Click on the down arrow under the 'Bar' graph icon.5. Choose the graph design you like the best. Your data will convert into a bar graph on the spreadsheet.6. Click on the 'Design' tab to change colors, layout, add a...
Browse » Home » All posts
Wednesday, December 28, 2011
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 ...
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 ...
Tuesday, December 27, 2011
How to Delete an Embedded Chart in Excel
Delete an Excel Chart Object1. 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 Sheet4. 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...
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...
A Tutorial to Sort in Microsoft Excel
Excel 20031. 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...
How to Move a Picture, Text Box or Other Object in PowerPoint, Excel or Word Exactly Where You Want it
Removing Word Restrictions1. 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 Restrictions4. Open the PowerPoint 2010 presentation that contains the object you want to move.5. Click...
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...
Monday, December 26, 2011
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...
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...
Sunday, December 25, 2011
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...
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 spreadshe...
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,...
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 delet...
How to Open a Xlsx File
Microsoft Excel1. 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 programOpenOffice Calc4. 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...
Subscribe to:
Posts (Atom)