How to Use Freeze Frames in Excel

1. Open an Excel spreadsheet with some data.
2. Choose which rows and/or columns to freeze. To freeze rows only, select the row immediately beneath the row or rows you want to remain visible. To freeze columns only, select the column immediately to the right of the column or columns you want to remain visible. To select both rows and columns, select the cell immediately below and to the right of the row and column you want to remain visible.
3. Click the 'Window' menu in Excel 2003. Click the 'View' tab in Excel 2007/2010.
4. Click 'Freeze Panes' in Excel 2003 to complete the process. Click the 'Freeze Panes' option with the down arrow and continue to the next step in Excel 2007/2010.
5. Select 'Freeze Panes' from the drop-down menu in Excel 2007/2010 to complete the process.

Read more ►

How to Dock Windows in Excel Visual Basic Editor

1. Open Excel and then open VBA. The shortcut to opening VBA is 'ALT F11.'
2. Select the 'Tools' menu then select 'Options.'
3. In the dialog box, click on the 'Docking' tab. Make sure all the boxes are check on this tab, then click 'OK.'
4. The toolbar windows can be docked simply by moving them towards a side of the window pane. The code windows can be docked by double clicking on the header or clicking on the 'Maximize' button in the upper right corner. The code windows are undocked by selecting the greyed 'Restore Window' button in the upper right corner. Code windows can be alternated between by using 'CTRL Tab.'

Read more ►

How to Set the Number of Decimal Places to Appear in a Microsoft Access Table Field

1. Open your table in Design view.
2. Create a Number or Currency field, or click in a Number or Currency field that already exists.
3. Click on the General tab in the Field Properties box at the bottom of the screen.
4. Click in Decimal Places. A small arrow appears on the right side of the text box.
5. Click on the arrow to produce a menu of choices.
6. Select the number of digits to appear to the right of the decimal place.
7. Save your table.

Read more ►

How to Set Up a Spread Sheet for Profit Loss in a Small Business

1. Open Microsoft Excel and locate the template gallery.To find the template gallery in Excel 2003, select 'File' and 'New.' Using the right task pane, locate the templates search box. Type 'profit loss statement.' You will see all of the available templates. Download the profit loss statement.To find the template gallery in Excel 2007, select the 'Office' button and select 'New.' Using your search box, type 'profit loss statement.' You will see a list of matching templates. Download the profit loss statement.
2. Customize the Excel template to your business needs. Since this statement is a comparison of your business performance during different time periods, decide how often you want to generate this report.Open the template and enter the company name, time frame and date of the report.Adjust the sale revenue and cost of sales section by adding products or services that your company sells. This may require you to add or delete rows.To add products and services, type over the generic products and services included in the template. If you need additional rows for more products and services, right click on an existing product row number and select “Insert.” To delete a products and services row, right click on the existing product row and select “Delete.”
3. Adjust your operating expenses section. Add or remove any expenses that do not apply to your business. Clarify the taxes section to reflect the taxes you are responsible for.To adjust add additional expenses, type over the generic expenses. If you need additional expense rows, right click on the row number and select “Insert.” To remove an expense row, right click on the row number and select “Delete.”
4. Save your changes in Excel 2003 by selecting “File” and “Save As.” Type in a name for your template and change your Save As Type to “Template.”Save your changes in Excel 2007 by selecting the “Office” button. Select “Save As” and then select “Other Formats.” Type in a name for your template and change the Save As Type to “Template.'

Read more ►

How to Solve Probability Equations With Excel

1. Click the 'Fx' button just under the ribbon.
2. Select the down arrow to the right of 'Or select a category.'
3. Select the type of probability equation you want to solve from the 'Select a function' list. There are dozens of functions to choose from, including NORMSINV, which returns the inverse of the standard normal cumulative distribution and PERMUT, which returns the number of permutations possible from a given number of objects.
4. Follow the directions in the pop-up window to input the data necessary to solve the probability equations. Some functions, like the COMBIN function, ask you to type the data directly into the window. Other statistical functions may require you to input the data into the spreadsheet.

Read more ►

How to Make a Data Table in WordPad

1. Click the “Start” button or press the “Windows” button. The Start menu appears.
2. Type “WordPad” in the Search text box. Search results appear.
3. Click “WordPad.” A blank WordPad document screen appears.
4. Click the “Home” tab on the Ribbon.
5. Click on the document screen where you wish to set the table.
6. Click the “Insert Object” button in the Insert group. The Insert Object dialog box opens.
7. Click the “Create New” radio button.
8. Select the “Microsoft Excel Worksheet” program in the Object Type text box.
9. Click “OK.” The Insert Object dialog window closes. A Microsoft Excel worksheet appears.
10. Type the values in the Excel worksheet. Another option includes inserting an Excel table in the Excel worksheet. Click the “Insert” tab on the Excel Ribbon. Click and drag the cursor on the Excel worksheet to select and highlight the rows and columns for the data table. Click the “Table” button in the Tables group. A table appears in the Excel worksheet. Type the values in the table on the Excel worksheet.
11. Click the “X” or “Close” button of the Excel screen. Close the Excel worksheet to copy the data values to the WordPad document.
12. Save this WordPad document.

Read more ►

How to Add Two Cells in Excel 2003

1. Open Excel. You should be able to locate the program by using your 'Start' button. When you cannot find it there, use your 'Search' or 'Find' function.
2. Determine which cells you would like to add. Click on the cell where you want your total to appear.
3. Enter an equal sign, followed by the word SUM, begin parenthesis, the column and row of your first cell, comma, then the column and row of your second cell and end parenthesis. For example =SUM(A2,B6).
4. Appearing in the cell will be the sum of the two cells. Your equation will appear in the formula bar.
5. Delete the answer if you do not want it to show by highlighting the cell and pressing the 'Delete' button on your keyboard.

Read more ►

How to Convert Labels to Avery 5160

1. Open Word 2010 and select the 'Mailing' tab. Click the 'Start Mail Merge' wizard. Click 'Labels.' The label dialog box appears. Select 'Avery' in the vendor list and locate the 5160 labels. Click 'OK.'
2. Click the 'Select Recipients' button. Select 'Use Existing List.' Browse the computer and locate the Excel workbook containing the label information. Select the workbook and click the 'Open' button. The table dialog box appears. Select the worksheet that contains the label data. Click 'OK.'
3. Click the 'Insert Mail Merge' button. A drop-down list appears. Select a field from the list. Click the 'Preview Results' button to preview the label changes. Click 'Update Labels' to apply the new changes to all of the labels.
4. Click 'Finish Merge' to finalize the mail merge process. Select 'Edit Individual Documents.' Click 'All.'

Read more ►

How to Align Text in Cells in Excel 2003

1. Open your Excel worksheet.
2. Select the cells containing the text you wish to align. To select, click on each cell individually while holding down the 'Ctrl' key or drag your mouse across the cells.
3. Click 'Format' on the top menu to see the dropdown list of formatting options.
4. Select 'Cells.' A new window will appear with cell formatting options.
5. Click the 'Alignment' tab to study options for aligning the text in your cells.
6. Select the appropriate text alignment features.
7. Click 'OK' to implement your changes. Then save your work.

Read more ►

How to Unhide Columns in Microsoft Excel 2003

1. Highlight the columns that house the hidden columns. To unhide a column, left-click and hold with the mouse on the column letter to the left of the hidden column. Then drag the mouse cursor over that column letter and the one directly to the right of it, highlighting both the columns that sit adjacent to the hidden column.
2. Access the column's Properties menu to unhide. Once you have highlighted the columns, right-click on them to access the submenu.
3. Unhide the column. To unhide the column, scroll to “Unhide” and left-click.
4. Save any changes. To quickly save any modifications to your spreadsheet simply press the hotkeys “CTRL-S.” This will save your file.

Read more ►

How to Make a Budget on Excel 2007

1. Open Microsoft Excel 2007. Select the 'Office' button and click 'New.' In the 'New Workbook' dialog box, click on the 'Installed Templates' or 'Budget' group to find budget templates that are inbuilt into Excel.
2. Pick a template that works for you. Hit the 'Create' button to use the template.
3. Check out the data and structure of your template. Type in your monthly expenses by selecting the applicable cell and entering the correct data into the cell. Remove any data you don't need by selecting the applicable cell and hitting the delete key or deleting the entire row.
4. Change the monthly income to match your income. The budget will automatically deduct your expenses from the income column.
5. Save your newly created budget by clicking the 'Office' button and choosing 'Save.' Name your file in the 'Save As' dialog box and hit 'Save.' You may reuse the budget for upcoming months and re-save your file by clicking the 'Office' button and choosing the 'Save As' option.
Make a Budget on Excel 2007 from Scratch
6. Open Microsoft Excel 2007.
7. Create columns for your expenses, their projected cost and actual cost in your blank worksheet. Then place your expenses under each header.
Example:
Expense: Electricity
Projected Cost: 75
Actual Cost: 70
8. Enter all the expenses for each bill. Then place your cursor in the blank row just after the last entry of your 'Actual Cost' column. Use Excel's inbuilt formula to calculate the total for your monthly cost by clicking the 'AutoSum' button. Excel will highlight the cells that are being calculated in the 'Actual Cost' column. Hit 'Enter' to accept the calculations.
9. Create columns for your income and balance. Then enter your information under each header.
Example:
Income: 3480
Balance: (calculated automatically)
10. Calculate your balance for the month by selecting the blank cell below or beside the 'Balance' column and typing an '=' sign (no quotes) in the formula bar. Then click on the cell that includes your income and type a '-' sign (no quotes) in the formula bar. Click on the cell that includes your 'Actual Cost' total and hit 'Enter.' Your balance will now appear in the empty cell beside/under 'Balance.'
11. Double-check that your figures are correct and save your file (by selecting the 'Office' button and hitting 'Save.' Your Excel 2007 budget is now complete.

Read more ►

How to Sort Columns by Date in Excel

1. Click on the columns you would like to sort. For example, if you want to sort column A, click on the 'A' column header to highlight the entire column.
2. Click on the 'Data' tab, then click on 'Sort.' This will open the sort dialog box.
3. Click on the 'Continue With the Current Selection' radio button, then click on 'Sort.'
4. Click on the arrow underneath 'Order' and select either 'Newest to Oldest' or 'Oldest to Newest' depending on which way you want to sort the dates.
5. Make sure the 'Sort on' selection box reads 'Values,' then click on 'OK.' Excel will sort the column according to date.

Read more ►

How to Create Input Forms in Excel 2003

1. Open the file you want to modify in Excel 2003. If you have multiple worksheets, go to the worksheet you want to edit.
2. Add column headings to the first row of the spreadsheet. To insert a row, click on the row header for the first row. Right-click and select 'Insert.'
3. Go to cell 'A1' and type a heading for that column. Press the 'Tab' key to advance to the next column.
4. Add column headings to the remaining columns on the worksheet.
5. Highlight the content you want to include in the input form, such as the column headings and any existing content in the spreadsheet.
6. Select 'Data' and 'Form' from the toolbar. If Excel displays a message box, click 'OK' to use the first row for labels. A dialog box for the input form you've created opens.

Read more ►

How to Extract the Last Word in a Cell

1. Open Excel and click 'File' and 'Open,' browsing to the file of raw data. Highlight the file and click 'Open.'
2. Create a blank column next to the first column of raw data you would like to parse. For example, if column 'A' is the first column of raw data, then right-click on the 'B' and select 'Insert.' This will provide you with a new, blank column.
3. Type '=RIGHT(A1,LEN(A1)-FIND('*',SUBSTITUTE(A1,' ','*',LEN(A1)-LEN(SUBSTITUTE(A1,' ','')))))' into cell B2 and click 'Enter.' This formula breaks down the line of text in cell A1 in the following manner:'LEN(A1)-LEN(SUBSTITUTE(A1,' ',''))' makes a count of the spaces.'SUBSTITUTE(A1,' ','|', ... )' replaces the last space with a '|.''FIND('|', ... )' finds the position of the '|.''Right(A1,LEN(A1) - ... ))' returns all characters after the '|.'
4. Click and hold the bottom-right corner of cell B1 and drag it down in order to pass the formula down to the remaining cells.

Read more ►

How to Create a Stock Chart in Excel 2007 With Multiple Stocks

1. Open Excel. Create a new document or open a spreadsheet that already contains stock data.
2. Enter or arrange the stock price data into columns. Each column should represent the changes in a stock's price. For example, if you are creating a chart of daily activity in the stock market for four specific stocks, use the first four columns, A through D. Label the stock name or ticker symbol at the top of each column in row 1, then place the daily price data in the subsequent rows. Do not skip rows or leave any cells blank.
3. Select the entire data set by dragging the mouse from cell A1 to the right through all the stocks' columns and then down through all the rows to the last day of information. When done, the entire data set should be highlighted within the Excel window.
4. Click the 'Insert' tab on the ribbon toolbar at the top of the Excel 2007 window. Locate the 'Charts' group within this tab.
5. Click on the 'Line' chart option and then choose any line chart format that appeals to you. A chart is automatically inserted into the spreadsheet containing all the data you selected. Each column is drawn as a separate line on the chart. The overlapping lines show the different stocks' price moves together in one chart.

Read more ►

How to Add an XML Map to an Excel Spreadsheet

1. Launch Microsoft Excel and open the spreadsheet to which you want to add the XML map.
2. In Excel 2003, click the 'Data' tab and put the cursor over 'XML.' On the drop-down, select 'XML Source.' In Excel 2007, click 'Data,' then click 'From Other Sources' in the drop-down, then click 'From XML Data Import.'
3. Click on the 'XML Maps' button and then click 'Add.'
4. Locate the XML schema you want to map to the spreadsheet and then click 'Open.'
5. Click 'OK' to map the XML schema to the spreadsheet.

Read more ►

How to Learn MS Excel Macros

Learn How to Record a Macro
1. Access the 'Macro' menu from the 'Tools' menu and click on 'Record New Macro.' This will open a dialog box in which you will type a name for the macro. When you click the 'OK' button, the macro will automatically begin to record and a small window with a 'Stop' button will appear.
2. Perform the set of functions that you would like to have in your Macro. If you would like to average a set of numbers, add a dollar sign and put a black border around the cell, carry out all of those tasks. The functions and commands you perform will record in the order in which you complete them.
3. Press the stop button to cease recording. You now have a macro that can average numbers, add a dollar sign and put a black border around the call with just one click.
Learn How to Run a Macro
4. Get to the 'Macro' option through the 'Tools' menu. When you click on 'Macro,' it will bring up a list of all available macros saved in your Excel.
5. Make a button for the macro to add to your toolbar. To create the macro button, go to the 'Tools' menu and select 'Customize' from the list. Go to the 'Commands' tab and click 'Macros' under the 'Categories' section. Drag the custom button of your choice to the toolbar. Go to 'Modify Selection' in the 'Customize' window and click on 'Assign Macro'. Choose the name of your macro from the list of macros that comes up and press the 'OK' button. The button will now stay on your toolbar and with one-click will perform all of the recorded functions.
6. Create your own keyboard shortcut. This will allow you to run the macro by pressing a combination of keys on the keyboard. To make a shortcut, click on 'Macro' under the 'Tools' menu. Choose your macro from the list and go to 'Options'. A window will come up with a place for a 'Shortcut key'. Pick a key to use as the shortcut for your macro, keeping in mind that some keys are already shortcut keys in Excel, such as Ctrl P for paste and Ctrl X for cut. After you have entered your key, click 'OK.' Your macro will now run automatically when you press the Ctrl key and the key that you assigned for your macro.

Read more ►

How to Insert a Comment Box in Microsoft Excel

Microsoft Excel 2007
1. Open your spreadsheet in Microsoft Excel.
2. Click on the cell where you want the comment to appear. Click on the 'Review' menu, and then 'New Comment' in the 'Comments' section. You can also right-click on the cell and click 'Insert Comment.' A text box will appear with your user name in it.
3. Type your comment. When you are finished, click anywhere in the spreadsheet outside of the text box. The comment box will disappear, but will reappear when you roll the mouse pointer over the cell.
4. Click on the cell, and then the 'Edit Comment' button to edit the comment or 'Delete Comment' to delete it. Use the 'Previous' and 'Next' buttons to jump from comment to comment, the 'Show/Hide Comment' button to display that cell’s comment without having to keep your mouse on it and the 'Show All Comments' button to show all of the comments on the sheet. Click it again to hide them.
Microsoft Excel 1997-2003
5. Open your spreadsheet in Microsoft Excel.
6. Click on the cell where you want the comment to appear. Click on the 'Insert' menu, and then 'Comment.' You can also right-click on the cell and click 'Insert Comment.' A text box will appear with your user name in it.
7. Type your comment. When you are finished, click anywhere in the spreadsheet outside of the text box. The comment box will disappear, but will reappear when you roll the mouse pointer over the cell.
8. Click on the cell and then the 'Insert' menu and 'Edit Comment' to edit the comment. You can also right-click on the cell and click 'Edit Comment' to edit it, or 'Delete Comment' to delete it or 'Show/Hide Comment' to display the comment without rolling your mouse over it. Click it again to hide the comment.

Read more ►

How to Embed Flash Game in Excel Spreadsheet

1. Download free flash game online or use one you already have
2. Open Excel and go to the top left option button. Choose excel options in the bottom right hand corner.
3. Click show developer tab in the ribbon.
4. Go to the developers tab and click insert. Choose insert shockwave object.
5. Create an area on the spreadsheet as large as the window you are working on.
6. Right click the area you just created and choose properties.
1. Make the embed movies option 'True'
2. Find the file you want on your computer and paste the path into the movie option. (exit properties)
7. Click design mode and you now have an active game.
8. Right click the game area on the screen and choose play.
9. Save normally and send it to yourself at work. Have fun.
10. Tell me if it works, I have a game or two at http://best-roulette-strategy.org/free-casino-games.html

Read more ►

How to Use the Freeze Pane Command to Create Static Headings in Excel 2003

1. Open your Excel worksheet once you have logged on to your computer. You should be able to locate the program by using your 'Start' button. When you cannot find it there, use your 'Search' or 'Find' function.
2. Highlight the column to the right of the column to be frozen. Go to 'Window'. Select 'Freeze Panes'. A bold line will appear to the right of the frozen column indicating that those panes are frozen.
3. Freeze rows by highlighting the row below the row to be frozen. Repeat Step 3 as needed.
4. Freeze both by highlighting the cell to the right of the column and below the row and repeating Step 3.
5. Enjoy scrolling through your worksheet while your titles stay in place.

Read more ►

How to Use ActiveCell in Excel Using a VBA

1. Launch Microsoft Office Excel, click the 'Developer' tab, and click 'Visual Basic.'
2. Click the 'Insert' menu and click 'Module' to insert a new code module. Type the following code to start a new sub procedure:Private Sub usingActiveCell()
3. Copy and paste the following to activate 'Sheet1:'Worksheets('Sheet1').Activate
4. Copy and paste the following to add a value to 'A1,' 'A2,' and 'A3:'Range('A1').SelectActiveCell.Value = 3.5Range('A2').SelectActiveCell.Value = 10Range('A3').SelectActiveCell.Value = 20
5. Copy and paste the following to highlight the cells with data:With ActiveCellRange(Cells(.Row, .CurrentRegion.Column), Cells(.Row, .CurrentRegion.Columns.Count .CurrentRegion.Column - 1)).Interior.ColorIndex = 8Range(Cells(.CurrentRegion.Row, .Column), Cells(.CurrentRegion.Rows.Count .CurrentRegion.Row - 1, .Column)).Interior.ColorIndex = 8End WithApplication.ScreenUpdating = True
6. Copy and paste the following to display the values added through the 'Immediate Window:'Range('A1').SelectDebug.Print ActiveCell.ValueRange('A2').SelectDebug.Print ActiveCell.ValueRange('A3').SelectDebug.Print ActiveCell.Value
7. Copy and paste the following to end the sub procedure:End Sub
8. Press 'Ctrl' and 'G' to display the 'Immediate Window' and press 'F5' to run the procedure.

Read more ►

How to Create a Two X Axis Chart in Excel

1. Create a chart that measures two data series against a set of variables using the Chart Wizard. Click 'Finish' and the chart will appear in your worksheet.
2. Click anywhere on the chart. In the top navigational menu, click the 'Format' tab. Click the arrow in the 'Chart Elements' box, and then select the data series you wish to be the secondary plot.
3. Click on 'Format Selection' in the 'Current Selection' section of the 'Format' tab.
4. Click on the 'Series Options' tab in the pop-up window, and then select 'Secondary Axis.' Click 'Close'. You will see a secondary vertical axis appear in the chart.
5. Click anywhere in the chart, then click the 'Layout' tab in the top navigational menu. Click on 'Axes'.
6. Click 'Secondary Horizontal Axis' and then choose your desired layout from the display options. Your secondary plot will change to a horizontal one.

Read more ►

How to Insert an Excel Drop Down Menu Box Into a Word Document

1. Select the Excel cell with the drop-down box by left-clicking it with your mouse.
2. Click 'Ctrl' and 'C' to copy the contents of the box to the clipboard.
3. In Microsoft Word, click on the 'Home' tab.
4. Click the down arrow beneath 'Paste' at the far left of the ribbon (the toolbar). Select 'Paste Special' from the options list.
5. Choose 'Microsoft Office Excel Worksheet Object.' This inserts the object into Word.

Read more ►

How to Insert a Calendar Into an Excel Spreadsheet

1. Download a calendar template from Microsoft Office Online. Search through the available templates and, after you find one you like, click the calendar link and select 'Download.'
2. Click 'Accept' to agree to the service agreement and click 'Save' to save the template to your computer.
3. Open the Excel workbook that you want to insert a calendar into. Click the 'Insert' button at the top of the page and select 'Object' from the menu that drops down.
4. Select 'Create from file' in the Object box that opens and click 'Browse' to search for the calendar template. When you find it, select the template and click 'Insert.' The calendar will then appear in your spreadsheet.

Read more ►

How to Convert XLXS to XLS in Microsoft

Convert With Excel
1. Launch Microsoft Excel 2007 or Excel 2010. Open the '.xlxs' file that you want to convert to '.xls'.
2. Click 'File' from the main program menu. Select 'Save As' from the drop-down menu.
3. Select 'Excel 97-2003 Workbook' from the 'Save As' context menu. This converts and saves the '.xlxs' file to an '.xls' file.
Convert With Office Compatibility Pack
4. Launch your Web browser. Navigate to the Microsoft Office Compatibility Pack download page.
5. Click the 'Download' link toward the top of the page. Select 'Save' from the on-screen download prompt to save the 'FileFormatConverters' installation file to your computer's hard drive. Wait for the download to finish.
6. Locate the file in your computer's 'Downloads' or 'My Downloads' folder. Double-click the file to install the Microsoft Office Compatibility Pack. If prompted, restart your computer during the installation process.
7. Open Microsoft Excel. Click 'File' followed by 'Open' to open the '.xlxs' Excel file that you want to edit or view. Excel now converts the workbook document into a format that is compatible with the older version of Excel.

Read more ►

How to Add Hours in Microsoft Excel

1. Create or open an Excel workbook that has hours that need to be totaled. The hours are formatted as h:mm.
2.
In the example at the left, the sum of the column results in an inaccurate number since Excel ignores hours that exceed 24. By reformatting the cell that holds the sum formula, we can correct this situation.
3. Right click in the cell that holds the sum formula, and then click on Format Cells.
4. On the Format Cells dialog box, click on the Number tab if it's not already displaying.
5.
Edit the custom setting, placing brackets around the 'h' as: [h]:mm .
6.
Click OK and you will see that the revised formatting has corrected the display value.

Read more ►

How to Hide Password Protect a Sheet Within Excel

1. Open the Excel worksheet you want to password protect and hide.
2. Place your cursor on the worksheet tab at the bottom of your spreadsheet.
3. Right click over the tab and choose 'Protect Sheet' from the pop-up menu. The “Protect Sheet” dialog box will open.
4. Add a check mark to 'Protect worksheet and contents of locked cells.' Insert the password you want to use into the 'Password to unprotect sheet' text box.
5. Choose the options you want to allow and press 'OK.' Re-enter your password in the “Confirm Password” dialog box and press “OK.”
6. Right click on the worksheet tab again and select 'Hide' from the options. The worksheet will be hidden from view.

Read more ►

How to Use Excel to Find Duplicates in a Long List

1. Open Microsoft Excel and the file that contains your list with duplicates.
2. Highlight the entire column (or columns) that contain the list(s) you want to examine for duplicates by clicking on the column letter(s) ('A,' 'B,' etc.) at the top of your data.
3. Click the 'Conditional Formatting' command in the 'Styles' group under the 'Home' tab, choose 'Highlight Cells Rules' and then choose 'Duplicate Values.'
4. Choose the color scheme you want the duplicate values to be highlighted with using the drop-down menu on the right of the 'Duplicate Values' dialog box that opens, or just click 'OK' to accept the default color scheme and highlight all duplicates.

Read more ►

How to Copy Excel Row Numbers Into Word

Copying a Picture of Excel
1. Click on the 'Page Layout' tab at the top of the screen. Look for the 'Sheet Options' area and place a check mark next to 'Print' under 'Headings.' This will make the row numbers and column letters show up in a printed document.
2. Select the top, left cell from the area that you want to copy. Navigate to the bottom, right cell. Hold 'Shift' and select this cell, highlighting the entire range of cells.
3. Click on the 'Home' tab at the top of the screen. Locate the 'Clipboard' area and select the drop-down arrow next to the 'Copy' button. Select 'Copy as Picture' from the menu, which will open up a small window.
4. Select 'As shown when printed' from the window. This will copy the cells as they would look if you were to print the selected area, including the row numbers and column letters.
5. Open the Word document to which you want to paste the Excel information. Place your cursor where you want to add the cells and press 'Ctrl' 'V' to paste the information.

Read more ►

How Do I Hyperlink to a Hidden Worksheet?

Insert the Hyperlink
1. Open the Microsoft Office document.
2. Click and drag the cursor over the text or image where you wish to insert the embedded hyperlink.
3. Right-click the selected text or image to show a list of commands, including 'Hyperlink.'
4. Click 'Hyperlink.' The 'Insert Hyperlink' dialog window opens. You can also click the 'Insert' tab on the command ribbon and click the 'Hyperlink' button in the 'Links' group.
5. Click the 'Existing File or Web Page' button in the 'Link to' list.
6. Click the 'Recent Files' button to the left of the text box.
7. Click the Excel file from the list.
8. Click 'OK.' The hyperlink appears on the document.
Unhide the Excel Worksheet
9. Point the cursor over the hyperlink. The ScreenTip will display instructions for following the link.
10. Press the 'Ctrl' key and click the hyperlink. The Excel workbook opens.
11. Right-click any sheet tab near the bottom of the screen. For example, 'Sheet 1' or a named worksheet tab. A list of commands appears.
12. Click 'Unhide.' A small dialog box opens with a list of hidden worksheets.
13. Click to select the worksheet in the 'Unhide sheet' text box.
14. Click 'OK' to unhide the worksheet. The dialog window closes. The Excel worksheet appears on the screen.

Read more ►

How to Learn the Basics of Microsoft Excel Free Without a Class

1. Open a new Excel 2010 spreadsheet window. Then open a Web browser window. Click and hold on the top of the Excel window and drag it to the left side of your Windows 7 desktop. The window will automatically adjust its size to fill exactly half the screen. Do the same thing with your browser on the right side of your desktop.
2. Direct your browser to the 'Get to know Excel 2010: Create Your First Spreadsheet' course at the Microsoft Office website (http://office.Microsoft.com/en-us/excel-help/get-to-know-excel-2010-create-your-first-spreadsheet-RZ101773335.aspx). Click the 'Start this course' button.
3. Watch the video that plays in your browser. During the video, click the 'Pause' button in the lower-left corner of the video player to stop the video and test out what you have learned in your spreadsheet window. After the six-minute introductory video is done, select another video from the list on the left side of the browser window. Each of the next six videos will give you information about one basic aspect of Excel 2010.
4. Select 'Practice' from the left side to bring up a practice spreadsheet that will walk you through a few practice routines. Once you feel comfortable, click 'Test yourself' on the left side to bring up a multiple-choice test regarding basic Excel commands. Finally, select 'Quick Reference Card' to open up a printable page that contains a number of basic Excel tasks and instructions to complete them.
5. Visit the Microsoft Excel 2010 Help and How-to page at the Microsoft Office website (http://office.Microsoft.com/en-us/excel-help/CL010253675.aspx?CTT=97). This page gives you a long list of selectable Excel commands and concepts. Select your desired entry to go to a help page surrounding that topic. You can also use the search box at the top of the screen to search the Microsoft Office website for a specific item. Be sure to include 'Excel 2010' in your search query, as the Office website holds articles for all Office products dating back to Office 2000.
6. Use the built-in help system in Microsoft Excel 2010 to address specific areas where you need assistance. Click the blue question mark at the top-right corner of the screen to open up the help window. Select the item from the list on the left, or enter in a search query into the box at the top of the window and press 'Enter,' then select the article you want to look at.

Read more ►

How to Remove All Hyperlinks Except One in Excel 2003

1. Open on your computer the Microsoft Excel 2003 file that contains the hyperlinks you want to remove.
2. Click any blank cell in your worksheet and type '1' into the cell. Click your mouse outside the cell.
3. Right-click the cell with the '1' in it, and then select the 'Copy' option from the shortcut menu.
4. Hold down the 'CTRL' key on your keyboard while selecting each hyperlink you want to remove. Make sure to not click the one link you want to keep.
5. Select the 'Edit' menu option from the top toolbar, and then click the 'Paste Special' option. Select the 'Multiply' option and then click the 'OK' button. All the hyperlinks you selected will be removed.

Read more ►

How to Change the Chart Axis Using the Graph Standard Toolbar in MS Word

1. Double-click the chart you want to modify in MS Word to make the 'Chart' toolbar visible.
2. Click the 'Category Axis Gridlines' button in the Standard toolbar to make gridlines on the X axis visible.
3. Click the 'Value Axis Gridlines' button in the standard toolbar to make gridlines on the Y axis visible.
4. Select 'Chart' and 'Chart Options' from the menu. The 'Chart Options' dialog box appears.
5. Select the 'Titles' tab to add or modify the titles for the axes on your chart.
6. Go to the text field for the axis' title you want to modify, such as 'Category (X) axis,' 'Series (Y) axis,' and 'Value (Z) axis' and type a title.
7. Select the 'Axes' tab to modify the axis on your chart.
8. Go to the axis you want to modify, such as 'Category (X) axis.' Deselect any axes you want to hide. Select 'Automatic,' 'Category' or 'Time-scale' option for how you want the axis displayed. Click 'OK.'

Read more ►

How to Make a Crossword Puzzle Using Excel

1. Open a blank work sheet in Excel.
2. Enter 'Ctrl A' to select all cells. While all cells are selected, place the cursor on the border between two columns of cells and drag them until the cells show a width of 3.75 (35 pixels). Place the cursor between two rows of cells and drag until the row height is 24.75 (35 pixels). This will give you a printable grid with squares that are about 0.3' by 0.3', large enough to write in comfortably.
3. Define the grid area you want to print out. For a 20 cell by 20 cell crossword, select 20 columns by 20 rows. Select all of the cells you want to assign grid lines to. Click on the 'Cell Borders' drop-down (located on the Font area of the tab, with a stylized picture of a grid on it).
4. Enter your first clue in a clear area and give it a number. Type in the answer to the clue on the grid you made earlier. Repeat until you've entered all of your clues and answers in the crossword puzzle.
5. Select all of the cells that don't have letters in them and change their fill color to black. The drop-down for selecting the fill color for a cell is on the Home tab, in the area labeled 'Font.' It is immediately to the right of the drop-down used to select 'Cell Borders' in Step 3. Clicking on it will allow you to select the color.
6. Save the file and print a copy as your answer key, typically as Crossword_Subject_Key.xls. For example, a crossword about Frog Anatomy might be named Crossword_FrogAnatomy_Key.
7. Select all of the cells in the grid (but not your questions) and hit the 'Delete' key. This will delete all of the letters in the cells.
8. Set the font size to 3 points and set the vertical justification to 'top.' (Vertical justifications are the icons next to the font size drop-down in Excel 2007.) Enter the numbers corresponding with each clue in the boxes where each word starts.
9. Save the file (under a different file name, such as Crossword_Subject_Blank) and print out copies. Continuing the example naming convention above, the crossword would be called Crossword_FrogAnatomy_Blank.

Read more ►

How to Locate a Path to MS Excel 2003

1. Click the circular Windows 'Start' button in the bottom-left corner of the desktop. Type 'Excel.exe' in the search box at the bottom of the Start menu. Right-click on the Excel file after it appears at the top of the menu under Programs. Select 'Properties' from the pop-up menu, which opens another dialog box.
2. Select the 'General' tab.
3. Find the 'Location' section in the middle of the tab. The path to the location of Excel 2003 displays similar to the following string of text: 'C:\Program Files\Microsoft Office\Office11.' The Excel 2003 file is within the Office11 folder on the 'C' drive.

Read more ►

How to Extract the Last Word in a String of Text in Microsoft Excel

1. Open the Microsoft Excel worksheet that has the column of text from which you want to extract the last word. As an example, you want to extract the last name from a list of names in column A and insert it into column C.
2. Click in cell “C2.” Enter the following formula and press the “Enter” key:=MID(SUBSTITUTE(A2,' ','^',LEN(A2)-LEN(SUBSTITUTE(A2,' ',''))),FIND('^',SUBSTITUTE(A2,' ','^',LEN(A2)-LEN(SUBSTITUTE(A2,' ','')))) 1,256)You can copy and paste this formula, adjusting the C2 cell reference as necessary. The entire formula goes into one cell.
3. Once you have entered the formula, you can quickly fill the formula down through subsequent cells. To do that, hover your mouse over the black square in the lower right corner of the cell. When the mouse pointer changes to a “ ” symbol, click your mouse and drag down.

Read more ►

How to Split Text in Excel 2007

Procedure
1. Highlight the data you want to separate.
2. Click the 'Data' tab at the top of the page, then 'Text to Columns.'
3. Select 'Delimited.' Click 'Next.'
4. Choose your delimiter, such as a space or comma. This is where Excel separates the data. Click 'Next.'
5. Select the 'Column data format' that is appropriate for your data. Click 'Next.'
6. Select where you want the split data to go to and click 'Finish.'

Read more ►

How to Remove Capital Letters in Excel 2007

1. Confirm that you have a block of adjacent empty cells, preferably to the right of your data, that you can use for the reformatted cells. If you don't have room on your spreadsheet, highlight the column of cells directly to the right of your original cells, click 'Insert' on the Ribbon -- not the 'Insert' tab -- and select 'Insert Cells' to add a column of empty cells.
2. Click the cell directly to the right of the cell you want to change. For example, if the text you want to change is in cell A1, click cell B1. Enter '=PROPER(A1)' in cell B1 and hit the 'Enter' key. This will change the text from all caps to initial caps, meaning the text 'CHANGE THE CASE' in cell A1 will appear as 'Change The Case' in cell B1. To convert the text to all lowercase, enter '=LOWER(A1)' in cell B1 and hit 'Enter.' This will convert 'CHANGE THE CASE' to 'change the case.'
3.
Microsoft identifies the version of the software by the year it was released.
Copy the formula. Highlight the cell where you input the formula and click 'Copy' in the 'Clipboard' group on the 'Home' tab. Click the cell to which you want to copy the formula and click 'Paste,' also in the 'Clipboard' group. If you're converting a large number of cells, such as an entire column of text, highlight the formula and any cells to which you want to copy it, and click 'Fill' from the 'Editing' group on the 'Home' tab. Click the corresponding direction to which you want to copy the formula.
4. Highlight the converted cell (or cells) and click 'Copy.' Then highlight the cells where you want to paste the newly formatted data and select 'Paste.' Click 'Paste Special' and then click 'Formulas.' Your correctly formatted text will now be in place.
5. Click the 'Office' button and 'Save' to save your work.

Read more ►

How to Encrypt an Excel 2007 File

1. Open the Excel workbook you want to encrypt.
2. Click the 'Microsoft Office' button in the top-left corner of the screen.
3. Place your mouse cursor over the 'Prepare' entry on the left side of the menu to bring up its options. Click 'Encrypt Document' on the right side of the menu. A password pop-up window will open.
4. Enter a password for the document. Make sure you can remember it since you will not be able to recover the spreadsheet if you forget it.
5. Click 'OK,' re-enter the password and click 'OK' to close the window.

Read more ►

How to Merge Cell Contents in Excel 2007

1. Open the Excel worksheet.
2. Click the 'Home' tab on the command Ribbon.
3. Click and drag on the two or more cells to merge. A heavy black outline will form around the selected cells. The column headers above the outlined cells will turn a different color.
4. Click the down-arrow for the 'Merge Center' command in the 'Alignment' group. The drop-down menu offers three merge formats: Merge Center, Merge Across, Merge Cells. 'Merge Center' centers the text within the larger cell. 'Merge Across' retains the left-aligned text in the row. 'Merge Cells' unites the cells and keeps the data from the upper-left cell.
5. Click on one merge format. The cells will merge to appear as one larger cell. The heavy black outline will disappear.
6. Save this worksheet.

Read more ►

How to Convert a Workbook in Excel 2007 to a PowerPoint Slide

1. Open the Excel workbook you want to copy to PowerPoint. On the first worksheet press 'Ctrl A' then 'Ctrl C' on the keyboard.
2. Open a PowerPoint presentation. Click on the slide where you want to insert the worksheet. Don't click in a text box, but just a blank area on the slide. Press 'Ctrl V' to paste the table into PowerPoint. Press 'Ctrl M' to create a new slide.
3. Switch back to Excel then click the tab for the next worksheet in the workbook.
4. Select and copy the contents of that sheet and paste them into the new slide in PowerPoint. Repeat this process for each worksheet in the workbook to convert the entire workbook into a PowerPoint presentation.
5. Paste a chart or graph into PowerPoint from Excel by clicking the chart in Excel and pressing 'Ctrl C' to copy it.
6. Switch back to PowerPoint and create a new slide.
7. Press 'Ctrl V' to paste in the chart.
8. Click the 'Paste Options' link next to the chart and choose to link the data or to link to the entire Excel workbook.

Read more ►

How to Convert Excel Macro to Open Office

1. Find a suitable utility program to convert macros in the Excel Visual Basic language to the CalcBasic code necessary for Open Office. A free option is the online conversion program offered by Business Spreadsheets (see link in 'References'). This convenient web page allows the user to paste existing Visual Basic code into a text box and automatically convert it into CalcBasic. While no automatic conversion between the two programming languages will be thorough, this process is a good primer for the tweaking that is inevitably necessary to ensure full functionality in Open Office. This utility is good for programmers looking to quickly jump start the conversion process so all Open Office users will have access to their macro programs.
2. Install a Visual Basic compatibility package into Open Office. This option is particularly convenient as it allows Open Office to run a Visual Basic program without any conversion. However, this is not ideal for any spreadsheet designed for a mass audience as each user would need to make the update to their Open Office software. There are two options for making this change. The Go-oo program extends Open Office software to a variety of file types allowing users to easily integrate many applications.An additional solution along these lines is a full reconfiguration of the Open Office installation package running on a network. Novell has created a new design of Open Office that supports Visual Basic code, but the installation is complicated. This process also relies on the OOo updates offered by Go-oo but integrates them from the ground up. This is better suited to network environments where many individuals will need this functionality.
3. Acquire a version of Open Office that already has Visual Basic compatibility built in. As of 2006 there are at least 10 versions of Open Office supporting Visual Basic. This obviates the process for more robust Excel macro conversion, but is not suitable for programmers looking to reach a wide audience. Open Office in its native format does not recognize Visual Basic code, so this option is only suitable for programmers making the switch for themselves or a controlled user base.

Read more ►

How to Graph Linear Equations Using Excel

Excel 2007
1. Highlight the data you want to graph by clicking at the top left of the data and dragging the mouse to the bottom right.
2. Click on the 'Insert' tab.
3. Select 'Line graph' and choose '2-D Line.' Excel will draw the graph for the linear equation based on the table of values you input.
Excel 2003
4. Highlight the data you want to graph by clicking at the top left of the data and dragging the mouse to the bottom right.
5. Click on the 'Chart Wizard' in the toolbar.
6. Choose 'Line.'
7. Check the 'Chart subtype' box and click 'Next' three times to move through the rest of the chart wizard.
8. Click on 'Finish.' Excel will graph your linear equation using the values from your table.

Read more ►

How to Unlock a Cell in Excel If Information Is Entered into Another Cell

1. Open the Excel spreadsheet that you want to work with.
2. Select the cell that you want to allow someone to enter information into. Right-click the selected cell, and choose 'Format Cells.' Click the 'Protection' tab at the top of the window, and clear the 'Locked' check box. Click 'OK.'
3. Click the 'Review' tab at the top of the Excel window, and then click the 'Protect Sheet' button. Type in a password, if you need one, and click 'OK.' If you entered a password, you will have to type it in again. Be sure to write the password down so that you won't forget it. All of the cells except for the one you selected are now locked.
4. Press 'Alt' 'F11' to open the Visual Basic console. Select the sheet that you are working on from the list of worksheets.
5. Copy the following code into the open space on the right side of the Visual Basic window:Private Sub Worksheet_Change(ByVal Target As Range)Dim KeyCells As RangeSet KeyCells = Range('A1')If Not Application.Intersect(KeyCells, Range(Target.Address)) _Is Nothing ThenWith Worksheets('Sheet1').Unprotect Password:='qqq'.Range('B1').Locked = False.Protect Password:='qqq'End WithEnd IfEnd Sub
6. Edit the code for your specific worksheet. Change 'A1' to the cell that you want users to be able to alter. Change 'B1' to the cell you that want to automatically unlock when users input data into the first cell. Change 'Sheet1' to the name of your worksheet. Change 'qqq' to whatever password you are using to lock the cells. If you are not using a password, delete both instances of 'Password:='qqq'.
7. Press 'Alt' 'F11' to close the Visual Basic window. Your worksheet will now unlock the specified cell when a user enters information into the original cell. Save your work now, because when you test the worksheet out, the target cell will be unlocked.

Read more ►

How to Troubleshoot Microsoft Excel

1.
Start Excel from the main program. Sometimes a shortcut to a program can become corrupt and cause the application to have problems opening. Go to the 'Start' menu, click on 'All Programs' and find Microsoft Excel in the program list. If it opens properly, delete the problematic shortcut by right clicking it and selecting 'Delete.' You can make a new shortcut by right clicking the main application and choosing 'Send to Desktop.'
2.
Disable add-ins. Sometimes these optional programs are problematic. In Excel 2007, click the 'Office' button. Click on 'Excel Options' and select 'Add-Ins.' In Excel 2000-2003, go to the 'Tools' menu and select 'Add-Ins.' If you disable them and the problem is solved, enable them one at a time to determine which is corrupted.
3.
Let Excel find and fix the problem. If you are using Excel 2000-2003, go to the 'Help' menu, click on 'Detect and Repair' and then click 'Start.' In Excel 2007, click the 'Office' button, click 'Excel Options' and then click 'Resources.' Click 'Diagnose' and then click 'Continue.' Click the 'Start Diagnostics' button. Excel will look for potential problems and repair them, if possible.
4.
Perform a 'System Restore' on your computer. This will restore your computer to an earlier date and time when Excel was working properly. Click 'Start' and then 'All Programs.' Point to 'Accessories,' and then 'System Tools.' Click 'System Restore,' and follow the wizard's instructions.
5.
Uninstall Microsoft Office and then reinstall it . Go to the 'Start' menu and then to the 'Control Panel.' Select 'Microsoft Office' and uninstall it. Use the Office disk you used to install it originally and reinstall the software.

Read more ►

How to Make a Graph on Excel That Shows Names for the the Y

1. Open a new Microsoft Excel 2010 spreadsheet. Click on cell 'B1' and type in the name of your first data series. This name will appear in your graph's legend. Then click on cell 'C1' and enter the name for your second data series.
2. Click on cell 'A2' and enter the names that will appear down your 'Y' axis into column 'A.' Continue to enter names until you have added them all.
3. Select cell 'B2' and type in the first data point that falls under the column and row names. Then select cell 'C2' and repeat the process. Continue until you have entered all of your data into columns 'B' and 'C.'
4. Click on cell 'B2.' Select the 'Insert' tab at the top of the screen. Click the 'Bar' button in the Charts area of the ribbon, then click one of the available bar graphs that appears in the pop-up menu. All of the available bar graphs will let you have names on the 'Y' axis and a certain number of data points on the 'X' axis. Once you click the graph type your bar graph will appear in the spreadsheet.
5. Click anywhere on the graph to select it, then select the 'Layout' tab at the top of the window. Click the drop-down arrow next to 'Chart Area' and select 'Horizontal (Value) Axis' from the list of choices. Click the 'Format Selection' button located just under the drop-down box and the Format Axis window will appear.
6. Click the radio button next to 'Fixed' in the 'Maximum' category on the right half of the window. Type the maximum value you want for your data points into the box next to the button. Then click on the 'Fixed' radio button in the 'Major Unit' category. Type in the value exactly one-half as large as your maximum value into this box.
7. Click 'Close' to close the Format Axis window. Your graph will now have the only two data points on the horizontal axis.

Read more ►

How Do I Change Data in Vertical Columns to Horizontal Columns in Excel or Access?

Transposing Data in Excel
1. Highlight the columns you want to transpose into rows. Press “Control C” to copy the data.
2. Open a new worksheet for the transposed data. Select an empty worksheet tab from the bottom of the Excel window, or press “Shift F11” to create a new worksheet. Rename the worksheet “Transposed Data.”
3. Right-click on cell “A1” to open the context menu. Select “Paste Special” from the menu to open the “Paste Special” dialog.
4. Check the “Transpose” box at the bottom of the “Paste Special” dialog to transpose the data. Click “OK.” Your data will be pasted into the spreadsheet as rows. Save your workbook.
Transposing Data in Access
5. Open the table you want to transpose. Select “Save As/Export” from the “File” menu. Select “To an External File or Database” in the 'Save As' window and click “OK.”
6. Give your table a name and select the version of Excel installed on your computer from the dialog box. Click “Export.”
7. Open your exported file in Microsoft Excel. Follow Steps 1-4 of “Transposing Data in Excel.” Close Microsoft Excel.
8. Import the transposed data into Microsoft Access. Select “Import” from the “File” menu. Use the “Files of Type” drop-down list and select “Microsoft Excel.”
9. Locate and select the file that contains the transposed data and click “Import.” Click “Show Worksheets” on the first screen of the Import Wizard and select the “Transposed Data” worksheet. Click “Next.”
10. Do not select the “First Row Contains Column Headings” option in the second screen of the Import Wizard; click “Next.” Check the “No Primary Key” option on the third screen of the Import Wizard and click “Finish” to import your data into a new table.

Read more ►

How to Make a Schedule in Excel

1. Open Microsoft Excel. click the 'File' menu and choose 'New.'
2. Go to the 'Available Templates' section and the Office.com Templates area.
3. Preview a schedule template by clicking on it. Once you have found the one that fits your requirements, click the 'Download' button. The schedule will open as a new Excel worksheet.
4. Change existing text in the schedule template by double-clicking on the cell that contains the text you want to alter. Select the existing text using your mouse or the keyboard shortcut 'Ctrl-A.' Type over the existing sample text with the information you need on the schedule.
5. Modify the color of a cell by clicking the cell to select it. Right-click and choose 'Format Cells.' Go to the 'Patterns' tab and choose the hue you want in the Cell Shading Color section. Click the color and click 'OK' to apply it to the cell.
6. Adjust the font in any cell by clicking the cell to activate it, and right-clicking and choosing 'Format Cells.' Go to the 'Fonts' tab and choose a font type, style, size and color, and apply any effects you choose. Click 'OK' to apply the changes.
7. Press 'Ctrl-S' to save your schedule. Provide a name for the worksheet and navigate to the location where you want it saved.

Read more ►

How to Activate the Excel Help Button

1. Open Microsoft Excel.
2. Click the 'Help' button, which is the blue circle with a question mark in the middle of it in the upper-right corner of the worksheet just below the 'Maximize'and 'Minimize' buttons. The 'Excel Help' window is activated and pops up on the screen.
3. Click one of the links in the 'Getting started with Excel 2010' area or type a search term into the help text box at the top of the window. Close the help box by clicking the 'X' in its top-right corner.

Read more ►

How to Stop Auto Recalculation Upon Data Entry in Excel

1. Open Microsoft Excel, and then open a new or previously saved workbook.
2. Click 'File' at the top of the screen. Click on 'Options' in the drop-down menu that appears. The 'Excel Options' window opens.
3. Click 'Formulas' on the left side of the window. Under 'Workbook Calculation,' click 'Manual.'
4. Click the 'Recalculate workbook before saving' check box if you want to turn this option off as well. Click 'OK' to close the window.

Read more ►