Monday, March 11, 2013

How to Copy Excel Row Numbers Into Word

Copying a Picture of Excel1. 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'...
Read more ►

How Do I Hyperlink to a Hidden Worksheet?

Insert the Hyperlink1. 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...
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'...
Read more ►

Thursday, February 28, 2013

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...
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)...
Read more ►

Wednesday, February 27, 2013

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...
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'...
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,...
Read more ►

Tuesday, February 26, 2013

How to Split Text in Excel 2007

Procedure1. 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 'Finis...
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...
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 wind...
Read more ►

Monday, February 25, 2013

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...
Read more ►

Sunday, February 24, 2013

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...
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...
Read more ►

How to Graph Linear Equations Using Excel

Excel 20071. 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 20034. 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...
Read more ►

Blogger news