Sunday, August 11, 2013

How to Make All Excel Rows the Same Height

1. Open Microsoft Excel.2. Hold the 'Ctrl' key and press 'A' to select all cells.3. Right-click any row number and select 'Row Height...' from the pop-up menu.4. Enter a point size for the cell in the 'Row Height' window and click 'OK' to set all rows to that size. Alternatively, you can click and drag the line between row numbers to change them visually. When you release your mouse button, all rows will appear at the selected heig...
Read more ►

How to Calculate the Percent Change in Excel

1. Open Microsoft Excel.2. Click the cell where you want the calculation to be performed.3. Type '=(B-A)/A' and press 'Enter' to calculate the decimal change from 'A' to 'B.' Replace 'A' with the original number, and 'B' with the new number. As an example, to calculate the decimal change on a sale which reduced the original price of $120 to the sale price of $80, you would enter '=(80-120)/120' and press 'Enter.' This produces 0.3333. You can also use cell references, such as '=(A2-A1)/A1' where 'A1' references the first row of the 'A' column.4. Right-click the cell, and select 'Format...
Read more ►

How to Create Check Boxes

Set Up Word or Excel1. Click 'Start' > 'All Programs' > 'Microsoft Office' and then either 'Microsoft Word 2010' or 'Microsoft Excel 2010.'2. Select 'Options' from the 'File' tab in Microsoft Office or Microsoft Excel's ribbon. Select 'Customize Ribbon.'3. Select the 'Developer' check box under 'Main Tabs.' Click 'OK.'Check Boxes in Word4. Select 'Design Mode' from the 'Developer' tab of the ribbon.5. Click the place on the document where you want to insert the check box.6. Click the 'Check Box Content Control' icon in the 'Controls' group of the Developer tab.7. Select 'Properties'...
Read more ►

Sunday, July 28, 2013

How to Change Row Colors in Pivot Table

1. Open Microsoft Excel 2003, then open the workbook containing the pivot table you want to change the row colors.2. Click the tab in the Excel workbook for the sheet that contains the pivot table. If workbook tabs are hidden, click the 'Tools' link in the menu bar, then click the 'Options' link in the drop-down menu to open the 'Options' dialog box. Click the 'View' tab in the dialog box, check the box next to 'Sheet tabs,' then click the 'OK' button.3. Select one of the rows in the pivot table you want to change the color. Click the first cell in the row, then drag the pointer to the final...
Read more ►

How to Remove Excel From Shared Mode

1. Click the Windows Start icon and select 'All Programs.' Click 'Microsoft Office,' then click 'Microsoft Excel.' The spreadsheet software opens.2. Press the 'Ctrl' and the 'O' keys to open the 'Open' dialog window. Double-click the file you want to edit.3. Click the 'Review' ribbon tab, then click 'Protect and Share Workbook.' This button opens a sharing configuration window.4. Remove the check mark next to the 'Allow changes by more than one user at the same time.' Click 'OK' to save the chang...
Read more ►

How Do I Change Margins on One Page of a Document in Microsoft Word?

1. Highlight all of the text on the page where you want to change the margins.2. Open the 'Page Setup' dialogue box.3. Enter your desired margin sizes in each corresponding margin field.4. Click the drop-down arrow next to 'Apply to' and choose 'Selected text.'5. Click 'OK' to finish adding margi...
Read more ►

How to Create a Chart in Excel 2007

1. Create data that can be charted. Open Excel 2007, and either open an existing worksheet or use the default. Enter or create some data that supports the creation of a chart, for example the amount of sales by product over a period of time. This data should be in the form of a table, with the element values to be charted populating the left hand column and the data series, or information about the elements, in the cells across from each element. More than one series, for example the quarters in a year, can be included for each element. Title the data series across the top of the table and do...
Read more ►

Saturday, July 27, 2013

How to Calculate IRR

1. Set up a new spreadsheet with each row showing the cash inflows and outflows by year. For example, Row 1 would have the cost of the new equipment at time zero (the date of purchase). Row 2 would have the expected manufacturing cost savings in year 1. Row 3 would have the savings in year 2, etc.2. Choose 'Insert/Function' from the main menu. Select 'All Functions' and choose 'IRR' from the list.3. A box will appear that asks you to define the values, and for a guess. Highlight your cash inflows and outflows in your spreadsheet to be the relevant values. For a guess, choose the default...
Read more ►

How to Convert Mac Office 2003 Excel to Windows Excel 2003

1. Connect the flash drive to your Mac computer. In a moment you are going to see a desktop icon appear for the device.2. Open Microsoft Office 2003 and load the file you want to convert over to Windows.3. Click 'File,' 'Save' and select the flash drive as your save location.4. Eject the flash drive by dragging it down to the trash can in the lower right corner of your desktop dock. Once the icon is gone you can safely remove the device from your Mac.5. Connect the flash drive to your Windows computer. Launch Microsoft Office Excel 2003.6. Click 'File,' followed by 'Open.' Select the...
Read more ►

Friday, July 26, 2013

How to Learn Excel for Free on the Computer

1. Click 'Start,' click 'All Programs,' click 'Microsoft Office' and then click 'Microsoft Office Excel 2007' to display its Book1 - Microsoft Excel window.2. Click the blue question mark — Microsoft Office Excel Help — button to display the Excel Help window. Scroll to 'Training' and then click on it to display a list of Training Topics. Click on 'Excel 2007 training courses' to display its window, which is subtitled: A roadmap to Excel 2007 training. Click on the title of any course listed here to display its website, read its title page, click 'Start this course' to display page 2, and...
Read more ►

How to Spell Check Multiple Worksheets in Excel

1. Open Excel by double-clicking on the program's icon. Open the document with multiple worksheets that you want to spell check.2. Click on the first bottom tab while holding down the 'Shift' key. Continue holding down the 'Shift' key and click on the remaining tabs to highlight all worksheets that need checking for spelling or grammatical errors.3. Select the 'Tools' menu option and then choose 'Spelling.' A popup box appears asking, 'Do you want to continue checking at the beginning of the sheet?' Click 'Yes.'4. Review each word that the computer doesn't recognize. The spell check takes...
Read more ►

How to Calculate Compound Interest for Excel 2003

1. Title cell A1 'Principal,' cell A2 'Compounding Periods,' cell A3 'Yearly Rate,' cell A4 'Time Period,' cell A5 'Periodic Rate' and cell A6 'Total Interest.'2. Enter the value for the amount of money you started with in cell B1, the number of times interest compounds each year in cell B2, the yearly interest rate in cell B3 and the number of years you will leave the money in the account in cell B4.3. Enter the formula '=B3/(B2*100)' in cell B5 to calculate the periodic interest rate. You have to divide by 100 to convert from a percentage to a decimal.4. Enter the formula '=B1*(1 B5)^(B2*B4)-B1'...
Read more ►

How to Merge or Split Cells Data in Microsoft Excel

1. Open Excel 2010. Type some random numbers in cells A1, B1 and C1. Highlight cells A1, B1 and C1.2. Click the 'Home' tab and select 'Merge and Center.' The cells will merge as one large cell displaying information from cell A1.3. Split the merged cells by selecting the newly merged cell. Click 'Merge and Center' icon. The cells will split displaying three separate cells aga...
Read more ►

How to Create a Dropdown List in Excel 2007

1. Type a list of entries for the drop-down list in a single column. For example, if you want a drop-down list for the days of the week, type 'Monday' in cell A1, 'Tuesday' in cell A2, 'Wednesday' in cell A3, 'Thursday' in cell A4, 'Friday' in cell A5, 'Saturday' in cell A6, and 'Sunday' in cell A7.2. Click on the cell where the drop-down list will go.3. Click on the 'Data' tab, then click on 'Data Validation,' then click on 'Data Validation' again.4. Click on the 'Settings' tab in the dialog box.5. Click on 'List' from the 'Allow' box.6. Enter the cell references into the 'Source'...
Read more ►

Thursday, July 25, 2013

How to Create a Spreadsheet Template in Excel

1. Create a workbook file with all the basic settings you use: sheets, default text (such as column and row labels and page headers and footers), formulas, macros and anything else you want in new workbooks based on the template. You probably don't want to enter a lot of data into the template, but you might.2. Open the File menu and select Save As.3. In the 'Save as type' box, click Template (*.xlt).4. In the 'Save in' box, select the folder where you want to store the template. To create a normal template, select the Templates folder, which should have automatically opened when you chose...
Read more ►

Blogger news