Monday, October 22, 2012

How to Find Hidden Macros in an Excel Spreadsheet

Finding Macros with the Macro Tools in Excel1. Open Excel normally.2. Click on the 'Developer Tab.'3. Click on the button labeled 'Macros.' A dialog box will pop up. The dialog box will have all the Macros available on all open workbooks. You can select 'Macros' there and delete them.Finding Macros with the Visual Basic Editor4. Open Excel normally.5. Click on the 'Developer Tab.'6. Click on the button labeled 'Visual Basic.' The Visual Basic editor will pop up. On the left hand pane, there will be a list of every single Macro that Excel has loaded; this will include Macros that...
Read more ►

How to Update Microsoft Excel

1. Use the update feature in Excel. Click the 'Office' logo in the top left corner. Click 'Options.' Click the 'Resources' tab. Click 'Check For Updates' under the 'Get Updates' title. The program will automatically search for updates and download them.2. Use Microsoft Windows Updater. Click the 'Start Menu,' and type 'Check For Updates' in the 'Start Search' bar. Hit 'Enter' on the keyboard. Windows updater will open. Click 'Download Updated.' Windows Updater will download updates for Excel, Windows and all other Microsoft programs.3. Upgrade Excel. Excel will only update the version of...
Read more ►

How to Open a Protected Excel 2003 in Excel 2007

1. Click “Start,” select “All Programs,” open the “Microsoft Office” folder and then click “Microsoft Excel” to open Excel 2007.2. Click “File” and then click “Open” to access the files on your computer.3. Browse through the files on your computer for the password protected Excel 2003 worksheet you want to open in Excel 2007.4. Select the file in question and click “Open” to open the worksheet.5. Type in the password for the protected worksheet and then click “OK' to access the file. If you don’t know the password, you’ll have to ask the creator of the file for it or download a password...
Read more ►

How to Create a Legend for a Spreadsheet

Chart Legend1. Create a chart from existing data within a Microsoft Excel spreadsheet. Note that legends aren’t recommended for use with pie charts. Labels should be used instead.2. Go to “Insert” and select “Chart.”3. Select your chart type. Press “Next.”4. Select your data range. Either enter the range of cells manually or press the small button to the right of the range box. Highlight the cells you wish to include in your chart. Choose the “Series” tab to further customize your data range. Press “Next.”5. Enter a title for your chart, X axis and Y axis.6. Select the “Legend” tab....
Read more ►

Sunday, October 21, 2012

How to Change the Vertical Axis on an Excel Bar Chart

1. Click on the vertical axis of the bar graph.2. Click on the 'Layout' tab under 'Chart Tools.'3. Click on 'Format Selection.' The first tab in the pop-up window, 'Axis Options,' allows you to change general options like the interval between tick marks and placement of axis labels. For example, if you want the vertical axis labels to appear in front of the bars (as opposed to sitting in the middle), click on the 'Between tick marks' radio button under 'Position Axis.'4. Select the placement for the vertical axis from the 'Axis Options' tab. For a vertical axis below the bar graph, choose...
Read more ►

Saturday, October 20, 2012

How to Recover Unsaved Word Documents if a Computer Turns Off

Turn on the AutoSave Option1. Open the Word file.2. Click the 'File' tab on the command Ribbon. A list of basic commands opens.3. Click the 'Options' button. A dialog window opens.4. Click 'Save.' This link appears in the left pane. A dialog window opens.5. Click to select the check box for 'Save AutoRecover information every 'X' minutes.' This option appears in the 'Save documents' section.6. Type the number of minutes, such as 10, to specify the timed intervals.7. Click to select the check box for 'Keep the last autosaved version if I close without saving.'8. Click 'OK.'Access...
Read more ►

How to Convert Rows Into Columns

1. Open Excel and input the following data going across in cells 'A3 through L3' the months January through December. In cells 'A4 through L4' enter random figures as shown in the illustration. (NOTE: You can use an existing chart of your own, instead.)2. Highlight the range starting from cells 'A3 through L4'. Do this by placing the mouse pointer in cell A3 and left-clicking the mouse once. While still holding down the mouse pointer, drag it to cover the last cell position in the range of data which is column L and row 4 (L4) and then let go of the mouse.3. Select 'Edit' and then choose...
Read more ►

Friday, October 19, 2012

How to Make My Excel Spreadsheet Interactive

Use the 'Share Workbook' Command1. Open the Excel file.2. Click the 'Review' tab on the command Ribbon.3. Click 'Share Workbook' in the 'Changes' group. A 'Share Workbook' dialog box appears.4. Click the 'Editing' tab on the 'Share Workbook' dialog box.5. Click to select the check box for 'Allow changes by more than one user at the same time. This also allows workbook merging.'6. Click the 'Advanced' tab in the 'Share Workbook' dialog box.7. Select the radio buttons for options, such as 'Track changes' and 'Conflicting changes between users.'8. Click 'OK.'9. Click 'Save' on the...
Read more ►

How to Delete All Unprotected Cells in Excel Spreadsheet

1. Open the spreadsheet containing the unprotected cells that you want to delete. Go to the 'Edit' menu in Excel 2003 and select 'Find.' Go to the 'Editing' group on the 'Home' tab in Excel 2007 or 2010 and click 'Find and Select.' Choose 'Find' from the drop-down menu. You can also use the keyboard shortcut 'Ctrl F' to open the 'Find' dialog box.2. Click the 'Options' button to expand the 'Find' dialog box. Click the 'Format' button to open the 'Find Format' dialog box.3. Go to the 'Protection' tab of the 'Find Format' dialog box.4. Clear the 'Locked' check box by clicking inside it to...
Read more ►

How to Convert Wb3 Files to Xls

Quattro Pro Users1. Launch Quattro Pro.2. Go to 'File,' 'Open' and double-click the WB3 file you wish to convert.3. Go to 'File,' 'Save As' and choose 'Microsoft Excel 97/2000/2002/2003' from the drop-down list, then click 'Save.'Excel 97 or 2000 Users4. Download and install the Quattro Pro converter from Microsoft for Excel 97 or Excel 2000.5. Launch Excel.6. Go to 'File' 'Open' and select the WB3 file you wish to change into an XLS file.7. Go to 'File,' 'Save As' and choose 'Excel Workbook (*.xls)' from the drop-down menu, then click 'Save.'Excel 2003 Users8. Launch Excel.9....
Read more ►

How to Compare Cells in Excel

1. Open a new Excel worksheet. Enter or import the first set of data into column A.2. Enter or import the second column of data into Column C of the same worksheet. Leave Column B empty.3. Type this formula in cell B1: '=IF(ISERROR(MATCH(A1,$C$1:$C$#,0)),'',A1)', replacing # with the row number of the last value in column C.4. Select cells in column B, starting at B1 and dragging your mouse down to the cell that corresponds to the last row in columns A and/or C.5. Go to the Home tab, click on 'Fill,' then select 'Down' from the drop-down menu to finish comparing the cells. Any duplicate...
Read more ►

Thursday, October 18, 2012

How to Learn Microsoft Office Excel

1. Open up Excel on your computer. You'll be greeted with a fresh spreadsheet. Play around with the software by typing data into blank cells. To get a quick understanding of Excel, some people dive right in to the process. Not every person learns by reading a book, so get an idea of what you can do before moving on to tutorials. Excel shouldn't be seen as on-the-job drudgery. You can balance checkbooks, use it for taxes and even create word puzzles. You can find lots of games to play on websites such as www.willard.k12.mo.us/co/tech/msexcel.htm that will teach you the basics while having fun.2....
Read more ►

How to Remove Everything After a Character in Excel 2007

1. Start Excel 2007. Open the worksheet you want to use by clicking 'Open' in the menu linked to the round 'Office' button.2. Identify the cell you want to trim. The cell's name is a combination of the letters printed across the top row of the worksheet and the numbers printed at the leftmost column. By default, the first cell in your spreadsheet will be 'A1.' The currently selected cell is always listed just above the first row containing the cell labels.3. Choose a blank cell close to the cell you want to remove characters from and click on it to make it the currently active cell.4. ...
Read more ►

How to Change the Decimal Place in Cells in Microsoft Excel 2003

1. Highlight the cell in which you wish to change the decimal place. Simply left-click on that cell with your mouse.2. Access the cell-formatting menu. Scroll to the “Format” tab on the command bar and select “Cells.” A cell-formatting-properties box will open.3. Access the number submenu. Scroll to the “Number” section in the drop-down menu of the cell-formatting-properties box and left-click.4. Change the cell decimal place. A “Decimal Places” subsection will appear to the right. Click on the up and down arrows to modify the decimal places. Then click on 'OK' to implement these chan...
Read more ►

How to Fill an Excel Cell With Two Colors

1. Right-click the Excel cell you wish to format and select 'Format Cells.'2. Click the 'Fill' tab.3. Click 'Fill Effects' under the color picker section.4. Click 'Two colors' at the top-left, and choose the two colors from the right-hand drop-down menus.5. Select the 'Shading styles,' and view the preview to get the effect you want.6. Click 'OK' twice to exit both windo...
Read more ►

Blogger news