1. Run the program that the infecting macro was originally opened with, such as Microsoft Word or Excel, by double-clicking on its appropriate desktop icon.2. Click on the 'View' tab at the top of the screen. Scroll all the way over to the far right side of the screen and click on the button labeled 'Macros.' Click on 'View Macros' on the drop-down menu that will pop up underneath the Macro button.3. Wait for the new window to pop up and then scroll through the list of macros installed until you find the one that infected your computer. Click on the name of the macro and then click on the...
Browse » Home » All posts
Wednesday, November 28, 2012
How to Format Rows and Columns in Excel 2003
1. Open your Excel worksheet and select the rows or columns you want to format. To select, hold down the left mouse button and drag.2. Click 'Format' on the top menu bar to summon a list of options for formatting your worksheet.3. Click either 'Row' or 'Column.' The rows are horizontal, the columns are vertical.4. If you click 'Row,' a box will appear. Enter the row height. If you pick 'Column,' enter the column's width in the designated box.5. When you've finished formatting, click 'OK' and save your wo...
Tuesday, November 27, 2012
How to Restore Microsoft Excel to Its Default Spreadsheet
Excel 2003 or Earlier1. Go to \'C:\\Documents and Settings\\\\Application Data\\Microsoft\\Templates.\' Open \'My Computer\' and open the \'Documents and Settings\' folder. Open your username, then \'Application Data,\' \'Microsoft\' and finally find the \'Templates\' folder.2. Rename the Book.xlt and Sheet.xlt files to something that you will remember. This step is optional, but allows you to save the settings for later use. Either move these files, or delete them if you don't want to use the template again. If there are no XLT files in this folder, continue below.3. Go to \'C:\\Program...
How to Flip Column Headings As Row Headings on an Excel Spreadsheet
1. Select and copy the entire data range you want to transpose. For example, if you have 10 columns and 10 headers, highlight them as well as all the data within. Excel will accurately transpose not only the column and header titles but also the data.2. Click on a new location in your worksheet for the transposed information to go. The simplest thing to do is go down a few columns and click. This way you can compare the new information with the old before deciding which information to keep. You can delete the other data or decide to use the information in both formats.3. Click on the “Edit”...
How to Perform the Command to Center a Worksheet Both Horizontally Vertically
Excel 20031. Log on to your computer and open Excel 2003. Click the 'File' menu and choose 'Page Setup.'2. Click the 'Margins' tab. Go to the 'Center on Page' section.3. Check both the horizontal and vertical check boxes. Click 'OK' to print your centered worksheet.Excel 20074. Open Microsoft Excel 2007 and open the spreadsheet you want to center. Click the Office button on the upper-left corner of the screen. Go to the 'Print' menu and select 'Print Preview.'5. Choose the 'Page Setup' option and click the 'Margins' tab. Check the 'Horizontally' and 'Vertically' boxes in the 'Center...
Monday, November 26, 2012
How to Compare Two Columns in VLookup
1. Open Excel 2010 and select a workbook. Click the 'File' tab and select 'Open.' Browse the files and locate the workbook. Click the workbook and select the 'Open' button. The workbook opens.2. Sort the values that will be included in the vlookup. The first column needs to sort in ascending order. Click in the first cell of the third column. Click the 'Formulas' tab and select the 'Lookup Reference' button. Select 'Vlookup' from the list of functions. The function arguments window opens.3. Click the 'Lookup value' field. Click the red arrow. Select the first cell in the third...
How to Align Text in Excel Cells
1. Start Microsoft Excel and open the file you want to change.2. Select the cells in which you want to align the text.3. Open the Format menu and select Cells.4. In the Format Cells dialog box, select the Alignment tab.5. In the Text Alignment pane, click the horizontal text box.6. Select the horizontal alignment type such as left, right, center.7. Click the vertical text box.8. Select the vertical alignment type, such as top or bottom.9. Select OK to accept the chang...
Sunday, November 25, 2012
How to Make a Selection in Microsoft Excel
1. Click a single cell with the mouse to select it. This cell will be surrounded by a black border and the row and column it belongs to will be highlighted in the frame around the spreadsheet. If you're only looking to select one cell, you're done!2. Click the initial cell, keep the mouse button pressed down, and drag the mouse horizontally, vertically or diagonally to select multiple adjacent cells. Now the entire group of cells (called a range) will be shaded gray and surrounded by a black border.3. Click the name of a column or row in the frame around your Excel spreadsheet to select...
How to Make an Ogive in Excel
1. Open a new Excel spreadsheet. Type 'Data' into cell A1, then type 'Bins' into cell B1. Enter the data set that you want to use to create the Ogive chart into column A, starting with cell A2.2. Enter the bins for your histogram into column B, starting with cell B2. The bins are the numbers that represent the top value in the data ranges for your histogram. For example, if you want to determine the frequency of ranges from '0 to 5,' '6 to 10' and '11 to 15,' your bins would be '5,' '10' and '15.' The bins will appear on your Ogive chart as values plotted on the horizontal axis.3. Click...
Saturday, November 24, 2012
How to Import OFX Files Into Microsoft Excel
1. Click 'Start,' type 'notepad' (without quotes) and press 'Enter.' Press 'Ctrl O.' Click the 'File type' drop-down menu and select 'All Files and Folders *.*.' Locate your OFX file, select it and click 'Open.'2. Browse through your OFX file. You will notice that there is a pattern among all entries. Each OFX file will be different, but in general you will notice fields of data such as times, amounts or comments. There will also be a selection of letters or characters separating each line of data (e.g., hrt]). This 'separator' will be the same throughout. Determine what the separator is.3....
How to Make Graphing Paper in Excel
1. Open a new Microsoft Excel 2010 spreadsheet. Click on the small square above the '1' and to the left of the 'A' in the spreadsheet's top-left corner. This will select the entire spreadsheet.2. Move your mouse between the 'A' and 'B' at the top of the spreadsheet. Once the pointer changes to appear as a line with two opposite arrows coming off of it, click and hold the mouse button. Drag the mouse to the left to shorten the columns until you get the horizontal spacing that you desire for your graph paper. Make note of the number of pixels that appear in the small popup box above your mouse...
Friday, November 23, 2012
How to Remove a Lost Excel Password
1. Open Excel and then the workbook file for which you wish to remove the password. If you are using Excel 2007 skip straight to Step 5; for all previous versions continue on to Step 2 below.2. Click on the 'Tools' menu at the top of the Excel window. Select 'General Options' from the drop down list of choices that appear.3. Locate the box labeled 'In the Password to open' and double-click on the asterisk in it. Click 'Delete', and click 'OK.' Repeat the process for the box labeled 'Password to modify.'4. Click 'Save', and then 'Yes' to complete the removal of the password in versions...
Thursday, November 22, 2012
How to Insert Animated GIF Files in Excel
1. Navigate to the folder that contains your animated GIF file. Write down the full path name of the folder and the name of the file. For example, if the file is contained in a subfolder of your C: drive called Pictures and the file name is bear.gif, then the full path name would be c:\pictures\bear.gif.2. Open the Microsoft Excel document to which you would like to add your animated GIF.3. Click on the 'View' menu and choose 'Toolbars' => 'Control Toolbox.'4. Click on the top button in the 'Control Toolbox,' which activates 'Design Mode.' 'Design Mode' allows you to draw an item in...
How to Highlight Duplicates in Excel
1. Highlight the cells you want to check for duplicates. You can highlight a row, a column, any array or non-contiguous group of cells, or the entire worksheet.2. Click 'Home,' then 'Styles,' and then 'Conditional Formatting' in Excel 2010, or the 'Conditional Formatting' drop-down in the Home tab in Excel 2007.3. Choose 'Highlight Cell Rules,' then click 'Duplicate Values....'4. Leave 'Duplicate' selected in the drop-down list of the resulting window, and choose a preset or custom format. Click 'OK' to close the window and view the highlighted resul...
How to Transfer an Adobe InDesign Table Into Microsoft Excel
1. Count the exact number of rows and columns in the InDesign table you wish to transfer. Knowing the exact number will be important when you are working in Microsoft Excel.2. Click on the Type tool in the Tool Palette. The Type tool looks like a capital letter T.3. Select all columns and rows of the table. To do this, hold your mouse over the left most line on the top row of the table. The cursor will turn into a solid back arrow. Hold the mouse button down to highlight the first row and drag the mouse down to the bottom of the table to highlight all of the rows. The table will be selected...
Subscribe to:
Posts (Atom)