Excel

Browse » Home » All posts

Saturday, April 21, 2012

How to Make Vertical Words in Excel

1. Open your spreadsheet in Microsoft Excel.
2. Click the cell containing the text you wish to make vertical.
3. Click the 'ab' symbol in the Alignment group of the Home tab and select 'Vertical Text' to align letters on top of one another. Alternatively, select 'Formal Cell Alignment,' enter '-90' or '90' in the 'Degrees' field, and click 'OK' to rotate normal text 90 degrees. Selecting '-90' will align the bottom of the characters to the left, while selecting '90' will align them to the right.

How to Use Excel 2007 to Make a Climate Graph With Negative Temperatures

1. Open the Worksheet.
2. Enter a date or time in each cell along one column or one row. For example, the dates April 1, April 2 and April 3 can fill cells B4, B5 and B6, respectively.
3. Enter the temperature values, one value per cell, in this temperature column. The values can be positive or negative. Enter these values in cells adjacent to the categories in Step 2. For example, enter '7' '-2'and '4' in cells C4, C5 and C6, respectively.
4. Click the cells that contain the dates and temperature values.
5. Click on the 'Insert' tab on the Ribbon. The 'Charts' group includes the 'Line' chart button.
6. Click on the 'Line' button to display the different line charts available. The '2-D' line chart displays values over time and different categories, such as dates.
7. Click on the 2-D chart button to convert the data. The chart displays both positive and negative temperature values. Try the other line chart styles to see the effect.
8. Edit the chart for a custom look. For example, the 'Design' tab includes 'Chart Layouts' and 'Chart Styles' groups. The 'Format' tab includes the 'Shape Styles' group that changes the color of the outline and background.
9. Save this worksheet.

How to Remove Password Protection in Excel

1. Open Excel and open the workbook for which you wish to remove the password protection. At this point, if you are using Excel 2003 or an earlier version, proceed to Step 2. If you are using Excel 2007, skip straight to Step 5.
2. Click on the 'File' menu, and then select 'Save As.' Click on the 'Tools' menu and select 'General Options.'
3. Double-click on the asterisk that is in the 'Password to open' box, and then press 'DELETE' on your keyboard. DO the same for the box labeled 'Password to modify.'
4. Click on 'OK,' then 'Save,' and finally 'Yes' to complete the password protection removal if your are using Excel 2003 or earlier.
5. Click on the 'Review' tab at the top of the Excel 2007 window, and locate the group of icons within the 'Changes' group. Click on 'Unprotect Sheet.' Type in the appropriate password when and if you are prompted, and you are finished.

How to Get Data From Excel Into Word

1. Click Excel's Office button, then click the 'Open' command. Navigate to and double-click a file you'd like to open to Word. Click the 'Save as' command after the file loads, then click the 'Excel 97-2003' format from the 'type' dropdown list. This format lets Word read the Excel data. Click the Office button's 'Close' command to close the workbook.
2. Click Word's Office button, then click the 'Open' command. Click the 'Excel' type from the 'Type' dropdown list, then navigate to the folder in which you saved the Excel workbook in the previous step.
3. Double-click the workbook to begin loading it. Word will display a warning message indicating the possible presence of malicious content. Click 'Yes' to continue opening the workbook.
4. Click the 'Entire' option from the dropdown control labeled 'Open document,' if you want to load the entire Excel workbook into Word. Otherwise, click one of the sheets listed in the dropdown to select just that sheet for importing to Word. For example, if your Excel data is only on 'Sheet1,' click that sheet in the 'Open document' dropdown.
5. Click the 'Name range' dropdown list if you chose to import only a particular spreadsheet in the previous step. Skip this step if you're importing the entire workbook. Otherwise, click a named range of cells in the workbook to import just that named range. For example, if the workbook contains a blocked of cells named 'ArtPatrons,' you can click that name in the 'Name range' dropdown to import just that block of cells.
6. Click 'OK' to import the Excel data into Word. Word will format the imported data as a table in a new Word document.

How to Change the Toolbar in Excel 2007

1. Locate the Quick Access Toolbar in Excel 2007. It will be either next to the Office button or under the ribbon.
2. Right-click on the Quick Access Toolbar and select 'Customize Quick Access Toolbar.' Check or uncheck the 'Show Quick Access Toolbar Below the Ribbon' box to place the toolbar where you want it.
3. In the ribbon, navigate to the feature you want to add to the Quick Access Toolbar.
4. Right-click on the feature you wish to add, and a menu will appear.
5. Select the 'Add to Quick Access Toolbar' option. The feature should now be on the toolbar.

How to Make a Time Line in Microsoft Excel

1. Gather all the information you need for the time line.
2. Open Microsoft Excel. Click on the Excel desktop icon or find Excel in the Start Menu under 'All Programs.'
3. Click the 'File' tab and pick 'New' to start a new spreadsheet.
4. Add a title to your time line. Click 'Insert' and then choose 'Header and Footer.' Type the title in the header section. Format the title to suit your needs and click 'OK.'
5. Move a few rows down the spreadsheet and input the first date. You can format the cells all at once or individually. If you are including times in your chart you may want to format the cells separately.
6. Format the descriptions so they appear vertically instead of horizontally in your time line. Highlight the cell or groups of cells you want to change. Click the 'Format' tab. Choose 'Cells.' When the format window opens pick 'Alignment.' Change the number in the 'Degrees' box. The diagram on the side displays the look of the angle you chose.
7. Create borders around the cells or the entire time line. Highlight the cells. Select 'Format' from the menu bar. Now pick 'Borders' and choose the type of border to use from the list provided.
8. Add a background color to specific cells. Select the cells you want to add color to. Choose 'Fill Color' or select the paint brush from the draw tool bar at the bottom of the screen. Pick a color and click 'OK.'
9. Insert pictures into the time line. Choose 'Insert' from the menu bar and then click on 'Picture.' Choose a file from your computer or a clip art from Excel's clip art gallery.
10. Save the time line. Select 'File' from the menu bar and then click 'Save' from the drop-down menu.
11. Print your time line. Click 'File' on the menu bar. Pick 'Print' from the drop-down menu and click 'OK.'

Friday, April 20, 2012

How to Manipulate Data in an Excel 2007 Pivot Table

1. Open Excel 2007 and select a workbook containing data. Click the 'Office' button and select 'Open.' Browse your files and select the workbook. Click the 'Open' button to open the workbook.
2. Highlight the data you want included in the PivotTable. Select 'Insert' on the menu bar, and then select 'PivotTable.' A drop-down menu appears. Select 'PivotTable' again. Click 'OK.'
3. Add fields to the PivotTable by checking fields from the right 'PivotTable Field List.' By default, the fields appear in the column section. Manually drag the fields to any of these sections (row, totals or filter) to see how manipulating them changes your pivot table.

How to Convert Excel Time Difference to Decimal Number

1. Click a cell where you want the decimal representation of the time difference to appear.
2. Type '= A1 * 24' and then press 'Enter.'
3. Change the cell location 'A1' to the actual location where your time difference appears. For example, if the time difference is 1:15 and appears in cell C3, type 'C3' into the formula instead of 'A1.' Pressing 'Enter' for this result will give you the decimal result '1.25.'

How Do I Graph on a Secondary Axis in Excel Office Professional 2003?

1. Click on the data series on the chart that you want to plot on a secondary axis. For example, if you have a chart that shows price and volume and you want to display volume on a secondary axis, then click on 'volume.'
2. Click on 'Selected Data Series' on the Format menu.
3. Click on the 'Axis' tab, then click on 'Secondary axis.' Excel inserts a secondary axis into your worksheet.

How to Create a Pivot Table from Multiple Worksheets

1. Open the workbook in which you want to create the PivotTable.
2. Click 'PivotTable and PivotChart Report' on the 'Data' menu.
3. Follow the instructions in the wizard. For the first step, you will be asked to identify the source for your data. Click the black box on the right-hand side of the source data box. This will disconnect the source box from the wizard.
4. Select the data ranges in the worksheets you need data from. Start with the first range and then move on to the next. The wizard will automatically put a comma between each range of data you select.
5. Click the black box on the right-hand side of the source box again to attach the box back to the wizard. Click 'Next' in the wizard until you reach the end and then click 'Finish' to exit the wizard and create the PivotTable.

Wednesday, April 18, 2012

How to Calculate Days by Subtracting Two Dates in Excel

1. Launch Microsoft Excel and open a new worksheet. Type the date in one cell. For example, type '1/1/2010' in cell A1.
2. Type your first date in cell A1. For example, input the date '1/1/2010.'
3. Type your second date in cell B1. For example, input the date '3/14/2011.'
4. Select the cell C1, type '=' and click the date in cell B1. Then type '-', click the first date and press 'Enter.' Cell C1 now shows 438, the number of days between the two dates you input.

How to Create an Application in Word or Excel

Create an Application in Word
1.
Start Microsoft Word. In Word 2003, go to the 'File' menu and click 'New.' In Word 2007, click the 'Office Button' and click 'New.'
2.
Type 'Employment Application' in the 'Templates on Office Online' box and click the 'Search' button. Select 'Employment Application 2-pp Online Form' in the 'Search Results' list. Click the 'Download' button, and an application will open as a new Word document.
3.
Enter your company logo by selecting 'Your Logo Here.' Go to the 'Insert' menu in Word 2003, point to 'Picture' and click 'From File.' In Word 2007, go to the 'Insert' tab and click on 'Picture.' Find the logo on your computer and insert it. Type the name of your business over 'Company Name.'
4.
Change any of the template example fields by selecting them and typing over the text. To alter the properties of a form field, double-click the gray field area, and the 'Form Field Options' dialog box will open. Select an option from a drop-down menu, or click the 'Add Help Text' button for more options.
5.
Save the application when finished. Before allowing an applicant to fill in an application in Word, open the document and save it with a new name, such as the applicant's name or the date, so that the original will not be changed.
Create an Application in Excel
6.
Start Microsoft Excel. Open a new, blank workbook. Insert a company logo by going to the 'Insert' menu in Excel 2003. Point to 'Picture' and click 'From File.' In Excel 2007, go to the 'Insert' tab and click on 'Picture.' Find the logo on your computer and insert it on the left side of the page. Enter a text box on the right side and type the name of your business inside it.
7.
Type the desired questions into cells on the spreadsheet. Leave empty the adjoining cells for the applicants to type into.
8.
Create 'Yes' or 'No' drop-down lists from which applicants can select an answer. Go to the 'Data' tab in Excel 2007 or the 'Data' menu in Excel 2003 and select 'Data Validation.' Go to the 'Settings' tab of the Data Validation dialog box.
9.
Select 'List' in the 'Allow' drop-down list. In the 'Source' field, type 'Yes,No' (without quotes). Click 'OK' to apply the drop-down list.
10.
Enter other data into the 'Source' field of the Data Validation box to create custom lists. Type a comma between each list item. When applicants click in the cell, they will be presented with a list of options from which to choose. Save the application when complete.

How to Change Macro Security Settings on Windows Vista

Changing Macro Security in Word or Excel 2007
1. Click the circular Office logo in the upper-left corner of the Word or Excel window, then click the 'Word Options' or 'Excel Options' button at the bottom of the menu.
2. Click the 'Trust Center' link on the left side of the screen, then click the 'Trust Center Settings' button.
3. Click the 'Macro Settings' link on the left side of the window to access the macro settings for the Office 2007 program you are using. The menus for Word 2007 and Excel 2007 are the same. The default selection is 'Disable all macros with notification.' To run your own macros, select 'Enable all macros.'
4. Click 'OK' to save your changes.

How to Keep Track of Changes in an Excel Document

Tracking Changes
1. Start Microsoft Excel and open the file you want to change.
2. Open the Tools menu and select Track Changes, then Highlight Changes.
3. In the Highlight Changes dialog box, select 'Track changes while editing.'
4. Select 'Highlight changes on screen.'
5. Open the When menu and select All.
6. Open the Who menu and select Everyone.
7. Click OK.
8. Click OK. This will save your changes and your file/workbook.
9. Enter your new changes.
Accepting or Rejecting Changes
10. Open the Tools menu and Track Changes menu and select Accept and Reject Changes option.
11. In the Select Changes to Accept or Reject dialog box, select 'Not yet reviewed' to see all changes or 'Since date' to see changes after a certain day.
12. Click OK.
13. In the Accept or Reject Changes dialog box, review the edits to the spreadsheet.
14. Select the Reject or Accept button for each edit.

Tuesday, April 17, 2012

How to Unfreeze a Window Pane in Excel 2007

1. Select the 'View' tab from the top menu in Microsoft Excel 2007.
2. Go to the 'Window' menu ribbon. Select 'Freeze Panes.'
3. Choose 'Unfreeze Panes' from the pop-up menu to unfreeze your Excel spreadsheet.

Subscribe to: Posts (Atom)