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 ►

How to Show a Comment Box in a Cell With a Drop Down List in Excel

1. Open the Microsoft Excel application on your computer, then open a file. Create a list of entries for the drop-down list in a single column.
2. Select the cell where you want the drop-down list to appear. Click on the 'Data' option from the top toolbar menu.
3. Click on the 'Validation' option then click on the 'Settings' tab. Click on the 'List' option from the 'Allow' box.
4. Enter a reference to your list in the 'Source' box. Click on the box next to the 'In-cell drop-down' field so it's selected.
5. Click on the 'Input Message' tab. Click on the box next to the 'Show input message when cell is selected' field so it's selected. Type the message you want and the comment box will appear in the cell.

Read more ►

How to Find Probability in Excel 2007

1. Open Excel 2007 and select the 'Formulas' tab.
2. Click on the icon for 'Other Formulas.' A pop-out menu will show up. Select 'Statistical Formulas' from the pop-out menu.
3. Select BINOMDIST. A dialog box will appear with four fields.
4. Enter the number of successful tests in for the first field.
5. Enter the number of trials in the second field.
6. Enter the probability of success for a given success in the third field.
7. Enter TRUE or FALSE in the fourth field. Use TRUE if the probability distribution is cumulative, and FALSE if it's not.
8. Read the result from the bottom of the dialog box.

Read more ►

How to Combine Bar Graphs in Excel

1. Open the document with the data that you would like to combine into one bar graph. If you have created any graphs or charts at this point, delete them by right-clicking and selecting 'Delete.'
2. Highlight only the data for the first graph. For example, if you wanted to combine the 'Expenses' and 'Profit' graphs together, only highlight one of those pieces of information.
3. Click 'Insert' and choose 'Bar' from the 'Charts' group. Choose the specific type of bar graph that you would like. It should appear to the right of the information you highlighted.
4. Highlight the second set of data, making sure to unhighlight the first set of data. Press 'Ctrl c' to copy the information. Click on the graph and press 'Ctrl v.' This should insert the second set of information into the graph. Repeat for any other pieces of information.

Read more ►

How to Attach Macros to All in Excel

1. Click 'View' and then click 'Macros.'
2. Click 'Record' macro to open the Record Macro window.
3. Click the arrow underneath 'Store macro in:' to open the drop down menu.
4. Click 'Personal macro workbook' to store the macro in the Personal.xls workbook. The macro will be available for use in any workbook.

Read more ►

How to Create an Invoice in MS Excel

1. Navigate to the Microsoft Office templates website. This will display a list of invoice templates (blank, preformatted documents with categories that that you can fill in).
2. Click on the name of the template you would like to use.
3. Click on the 'Download' button on the next page. You will need to accept the Microsoft Service Agreement by clicking on the 'Accept' button. The document will download to your computer.
4. Open Microsoft Excel. Click on 'File' and then 'Open' in Excel 2003; in Excel 2007, click on the 'Office' button and then click 'Open.'
5. Find the downloaded template file on your computer and open the document. The template will load and open in an Excel spreadsheet, ready to fill in.

Read more ►

How to Replace Text in Excel 2007

1. Open the Microsoft Excel 2007 spreadsheet that you want to replace text for. Click on any cell in the spreadsheet.
2. Click on the 'Home' tab and then click on the 'Find and Select' option from the 'Editing' group.
3. Click on the 'Replace' button. Enter the text that you want to find in the 'Find what' text box and then enter the text you want to replace that with into the 'Replace with' text box.
4. Click on the 'Options' button to define your search by selecting specific rows or columns, to search for case-sensitive data, or to match the entire cell contents.
5. Click on the 'Replace' option to replace text that is found or click on the 'Replace All' option to replace all of the text throughout your spreadsheet.

Read more ►