How to Merge Cells in Excel With the Keyboard

1. Navigate to the first cell in an open spreadsheet you want to merge by using the arrow keys on your keyboard.
2. Select the adjoining cell or cells by holding down the 'Shift' key and pressing one or more of the arrow keys on the keyboard. You should see an outline of the cells that you will merge.
3. Press the 'Alt' key to display number and letter key tips in Excel.
4. Press 'H' to display the key tips for all commands in the 'Home' tab.
5. Press 'M' to open the merge menu. Select one of the merging options: press 'C' to 'Merge and Center,' press 'A' to 'Merge Across' or press 'M' to 'Merge Cells.' You can also use the down arrow key to select an option.

Read more ►

How to Calculate Time in Excel 2007

1. Open the Excel 2007 document in which you want to include time calculations.
2. Enter headings for your calculation columns. For example, in a new Excel 2007 spreadsheet, you might type “Start” in cell A1, “End” in cell B1, and “Total” in cell C1.
3. Enter start and end times in the cells under the first two headings you added. For example, type 11:30 AM in cell A2 and 12:15 PM in cell B2. Always enter AM and PM after the time, unless you are using 24-hour clock time.
4. Insert formulas in the third column to calculate difference in times: If you have start and end times in cells A2 and B2, respectively, in cell C2 you would type “=B2-A2” (without the quotes) to subtract the later time in cell B2 from the earlier time in cell A2.
5. Change the cell formatting of the columns involving time calculations. Unless you do this, you may see incorrect or no results in the cells of the time totals column, though a formula is still visible in the Formula bar when you click a cell in that column. To do a time-sheet-style display of time, you will need two different time formats. Select the cells containing the start and end times and click the box at the lower-right corner of the “Number” group on the “Home” tab. The “Format Cells” dialog box appears. On the “Numbers” tab, select “Time” from the “Category” list, and select “1:30 PM” from the “Type” list. Click OK to return to your worksheet.
6. Select the cells containing the calculated time totals and again click the box in the lower-right corner of the “Number” group. Select the “Time” category, but now click the second item in the “Type” list, “13:30.” Click OK. The cells to the right of the start and end times should now show the difference in times displayed in hours and minutes. For example, for a time of 11:30 AM in cell A2 and 12:15 PM in cell B2, cell C2 will display '0:45.'

Read more ►

How to Use Excel's Intercept Function

1. Find the function field at the top of the page, with the = sign to the left. This is where you can program a cell value. If the function field is not immediately available, you can go to 'Insert' and select 'Function.'
2. In your function field, add the operator INTERCEPT.
3. Start a parenthetical statement after INTERCEPT. Your values and parameters will all be inside a set of parentheses.
4. Add a cell range for your 'y axis.' The most common arrangement might be a range of values for a y axis in the A column of the spreadsheet, and a range of values for an x axis in the B column. In this case, your cell range, joined by a colon, would look something like this: A2:A7.
5. Add a comma, then add the range of cell values for the x axis, such as: B2:B7.
6. Close your parentheses. Your statement should look like this: INTERCEPT (A2:A7, B2:B7). Adding this to a function field for a cell will make that cell's value the point at which your x and y axis converge.

Read more ►

How to Create a Sales Invoice

Excel 2010
1. Open Excel 2010. Click the 'File' tab and select 'New.' Click the 'Invoices' category in the left task pane. Review the available sales invoices. Download the sales invoice by clicking the invoice image and the 'Download' image. The invoice opens in Excel 2010.
2. Right click the default logo image and select 'Change Picture.' Browse your files and select your logo. Click the 'Open' button. Your image replaces the sales invoice template logo.
3. Highlight the default customer information on the template and type your custom information. Save the changes by clicking the 'Save' icon on the Quick Access Toolbar.
Google Documents
4. Access the Google Documents website. Type 'Invoice' in the search box. Click 'Search Templates.' Review the available sales invoices. Download the sales invoice by clicking the 'Use This Template' button. The invoice opens in Google Documents.
5. Delete the default logo image by clicking the image and pressing the 'Delete' button on the keyboard. Select 'Insert' and 'Image.' Browse your files and select your logo. Click the 'Open' button. Your image comes up in place of the template.
6. Highlight the default customer information on the template and type your custom information. Save the changes by clicking the 'Save' icon on the menu.
OpenOffice
7. Access the OpenOffice website. Type 'Invoice' in the search box. Review the available sales invoices. Download the sales invoice by clicking the 'Use This' button. The invoice opens in OpenOffice Calc.
8. Delete the default logo image by clicking the image and pressing the 'Delete' button on the keyboard. Select 'Insert' and 'Image.' SelectGH 'From File.' Browse your files and select your logo. Click the 'Open' button. Your image takes the place of the sales invoice template.
9. Highlight the default customer information on the template and type your custom information. Save the changes by clicking the 'Save' icon on the menu.

Read more ►

How to Write Percentage Formulas in Excel

1. Calculate the percent of a total. Choose a cell for the percentage formula and enter the '=' symbol to activate the formula in Excel. Highlight the cell with the part, then enter the '/' symbol, and then select the cell with the total. For example, if the total lies in cell A10 and the part lies in A3, the formula is '=A3/A10'.
2. Calculate difference in percent between two numbers. Choose a cell for the percentage formula and enter the '=' symbol to activate the formula in Excel. Enter the opening parenthesis symbol, or '('. Highlight the cell with the first number, then enter the '-' symbol. Select the cell with the second number, and then enter the closing parenthesis symbol, or ')'. Then enter 'ABS' and select the second number to use its absolute value as a divisor. For example, if you are comparing sales data, and July 2011 sales are in A2 and the July 2012 are in B2, the formula is '=(B2-A2)/ABS(A2)'.
3. Select the percent cell and choose your format. From the Home tab, click 'Percent Style' from the Number group.

Read more ►

How to Use Text Wrap in Excel

1. Open a new workbook in Excel by choosing 'File,' and then 'Page Setup.'
2. Select the small square at the top left corner of the screen of the new page. This highlights the entire workbook for formatting. If you want to format only a single cell, select that cell and continue with Step 3.
3. Right-click your mouse and select 'Format Cells,' 'Alignment' and then click the 'Wrap Text' box listed under 'Text Control.'
4. Resize the width of any Excel columns as necessary. Type in the text you need into each column of the spreadsheet. Whenever you get to the right margin of a particular cell, your text will wrap to the next line and continue to do so until you finish typing in that cell. Note that wrapped text automatically adjusts the row height of the cell.

Read more ►

How to Open a Dbf

1. Navigate to the folder containing your DBF file.
2. Right-click the DBF.
3. Drop down to the 'Open With' submenu.
4. Select 'Microsoft Office Excel' from the list of programs.

Read more ►

How to Use Freeze Frame in Excel

1. Click on the cell after the row or column you want to freeze. If you want to freeze column A, then put your cursor in column B. If you want to freeze row 1, then put your cursor in row 2. Combine these if you want to freeze a row and column.
2. Click 'View' then 'Window.'
3. Select 'Freeze Panes.'

Read more ►

How to Protect a Sheet in Microsoft Excel 2003

1. Access the sheet protection menu. To access this menu, scroll to the “Tools” tab on the command bar and select “Protection.” Under the sub-menu that opens, select “Protect Sheet.”
2. Set the sheet protect options. Make sure that you check the box labeled “Protect worksheet and contents of cells” to enable protection. Under the scroll menu in the middle of the sheet protection properties menu, you can check the corresponding boxes for the features you want disabled when unauthorized users are viewing the file.
3. Add a password to your worksheet. To add password to your worksheet, simply type it into the “Password” field.
4. Implement the sheet protection. To implement all of your protection changes, click the “OK” button.

Read more ►

How to Make Text Flash in Excel

1. Open the Microsoft Excel 2010 file in which you want to make the text flash. Press 'Alt' and 'F11' to open up the VBA console.
2. Right-click the 'ThisWorkbook' entry on the left side of the VBA console. Move your mouse over 'Insert' and choose 'Module.'
3. Double-click the 'ThisWorkbook' option. Copy the following code and paste it into the white space on the right side of the screen:Private Sub Workbook_Open()BlinkEnd SubPrivate Sub Workbook_BeforeClose(Cancel As Boolean)NoBlinkEnd SubThis code will start and the blinking text when you open this workbook, and stop the blinking text when you close the workbook, once you insert the code to tell Excel what Blink and NoBlink actually mean.
4. Double-click 'Module 1' from the list on the left side of the screen. Place your cursor on the right side of the screen and enter the following line:Public Timecount As DoubleThis creates a variable called 'Timecount' that you can use in every subroutine.
5. Press enter to move the cursor to the next line and enter the following code:Sub blink()With ThisWorkbook.Worksheets('Sheet1').Range('A1:A10').FontIf .ColorIndex = 3 Then.ColorIndex = 2Else.ColorIndex = 3End IfEnd WithTimecount = Now TimeSerial(0, 0, 1)Application.OnTime Timecount, 'Blink', , TrueEnd SubThis creates a subroutine called 'Blink' that will cause all the text within the defined range to flash. You can change the range from 'A1:A10' to whatever range you desire, including an individual cell.
6. Press 'Enter' to access the next line and enter the following code:Sub noblink()ThisWorkbook.Worksheets('Sheet1').Range('A1:A10').Font.ColorIndex = _xlColorIndexAutomaticApplication.OnTime Timecount, 'Blink', , FalseEnd SubThis will create a subroutine that will run when you close the workbook. It turns all the text back to black, so that someone who opens the workbook without macros enabled will not accidentally see nothing in the text boxes.
7. Close the VBA console by clicking the 'X' in the top-right corner. Click the 'File' tab at the top of the screen and choose 'Save as.' Select 'Excel Macro-enabled Workbook' from the drop-down field and type in a name for the workbook. Click 'Save.'
8. Close the Excel file and then reopen it. Your text, within the range defined in the macro, will start to flash. Depending on your security settings, you may need to click the 'Enable Macros' button at the top of the screen to see the flashing text.

Read more ►

How to Sort in Excel 2003

1. Open Excel 2003 and select a workbook containing data that needs to be sorted. Click 'File' on the menu bar and select 'Open.' Browse your computer for the workbook. Click the workbook and select 'Open.' The workbook opens.
2. Highlight the range of data that needs to be sorted. Click the first cell in the range you want to sort by. Click the 'Ascending' button on the Standard toolbar. The data is sorted in ascending order by the values in the column.
3. Highlight the range of data you want to sort. Click 'Data' on the menu bar. Select 'Sort.' The 'Sort' dialog box opens. Select a column header in the 'Sort By' field to sort your data by. Select another field in the 'Then By' field to perform a secondary sort. Click 'OK.' Your data is now sorted by multiple criteria.

Read more ►

How to Teach Yourself Microsoft Excel Virtually

1. Browse through Excel tutorials on the official Microsoft Excel website. Choose 'Getting Started With Excel 2010' if you are a total beginning, or 'Excel Skills Builder' to augment the skills you already have.
2. Compare private databases of Excel tutorials. Examples include 'Excel-2010.com,' 'Excel 2010 Tutorials' and 'Lynda.com.' Although the accuracy of non-Microsoft materials isn't guaranteed, private websites often provide other users' personal experiences, which may help you work through difficulties better than straight instruction.
3. Enroll in a formal online Excel 2010 training course via a local community college or university. Enrolling in an online course allows you the freedom to teach yourself Excel but the resource of having a tutor or professor on hand to clear up any ambiguities for you.

Read more ►

How to Control Multiple Users on One Excel Spreadsheet

1. Open the Excel spreadsheet you wish to share among multiple users.
2. Click 'Tools' and select the 'Share Workbook' option. A pop-up window will appear.
3. Place a check mark in the check box at the top of the 'Editing' tab on the Share Workbook pop-up window.
4. Click the 'Advanced' tab at the top of the 'Share Workbook' pop-up window. The window will change to present a variety of customizations for controlling multiple users on the Excel spreadsheet.
5. Choose desired options on the 'Advanced' tab. You may change the history log time frame and control how updates are handled.
6. Click the 'OK' button. Excel will immediately save the workbook and provide a pop-up message to indicate this. The Excel spreadsheet is now set up to handle multiple users.
7. Place the spreadsheet on a shared network drive where multiple computers can access it.
8. Save the spreadsheet on any computer to immediately see updated changes by other users currently working on the same file.

Read more ►

How to Create Mailing Labels in Microsoft Word

1. Open Microsoft Word 2010 and create a new document if one hasn't already been created. You can create a new document by clicking 'File' then 'New.'
2. Click the 'Mailings' tab, then 'Labels.' The 'Envelopes and Labels' window will open.
3. Type the address you wish to use on your labels in the address box. Choose if you want a whole sheet of the same label or just a single label printed in the 'Print' section.
4. Click the 'Options...' button near the middle bottom section of the window to choose the labels to which you want to print. Under 'Label Information' select the brand of labels you are using in the drop-down box. Under 'Product Number' select the product number of the labels you are using and then click 'OK.'
5. Click 'New Document' to create a new page of labels. If you are only printing a single label, the new document option will not be available. To print just a single label, click the 'Print' button in the lower left-hand side of the window.
6. Insert the label sheet in your printer. Print the newly created label document by clicking 'File,' then 'Print.' Choose your printer and click 'Print.'

Read more ►

How to Make the Top Row Scroll in Excel

1. Open up to the worksheet in the Microsoft Excel workbook.
2. Click the 'View' tab.
3. Click the 'Freeze Panes' icon. Select 'Freeze Top Row' from the menu.
4. Click the 'Windows Office' orb logo in the top left corner. Use the save options on the menu, if you want to make the top-row scroll permanent.

Read more ►