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 ►