1. Select a column of numbers that you want to align by clicking on the letter of the column. For example, column C.2. Click the Format menu and select Cells.3. Select the Number tab in the window.4. Select Number from the Category list.5. Select the number of decimal places you want by clicking the up or down arrow next to the box. If you select four decimal places, for example, Excel will round off any number that has more. For example, 5.89237 will become 5.8924. Any number with fewer decimal places will be padded with zeroes. For example, 4.8 will become 4.8000.6. Click 'OK.' Excel...
Browse » Home » Archives for October 2013
Monday, October 28, 2013
How to Convert Lotus123
The Steps1. Open the Media-Convert page. Media-Convert is a free-to-use online converter that can read Lotus 1-2-3 file extensions and convert those files into several other spreadsheet file types.2. Add the Lotus 1-2-3 file to Media-Convert. To add, click on the 'Browse' button beside 'File.' In some browsers, the button may say 'Open File' instead of 'Browse.' When the 'Open' window pops up, find the Lotus 1-2-3 file on the hard drive and click the 'Open' button to upload the file.3. Double-check the input format. 'Lotus 1-2-3' is one of the available file types in the 'Input format' list....
How to Create Microsoft Excel PivotTables
1. Open the Excel 2010 document that contains the information you want to use in a PivotTable.2. Click the Insert tab on the Excel ribbon. Click the PivotTable button at the left end of the ribbon. This opens the Create PivotTable window.3. Look for the dotted lines on your Excel worksheet. These lines determine what data the PivotTable uses. The PivotTable defaults to include all the data on the sheet, but if you need to choose a different area, select the top-left cell of the area you want to use. Then navigate to the bottom-right cell, hold shift, and select that cell.4. Choose between...
Sunday, October 27, 2013
How to Make a Bubble Graph on Excel
1. Open a new Excel 2010 spreadsheet.2. Click on cell 'A1' and type in the title for your first set of data. This data will be shown along the 'X' axis on your bubble graph. Once the title is in place, enter the data into the cell in column 'A.'3. Select cell 'A2' and enter the title for the second set of data. This data will make up the 'Y' axis on your graph. Once the title is in place, enter your data into column 'B,' underneath the title.4. Click on cell 'C1.' Enter the title for your third set of data. This set will be represented by the size of the bubbles on your graph. Once the...
How to Change an ActiveSheet Name
Excel1. Click a sheet tab (near the bottom of your screen) to activate the sheet.2. Right-click the sheet tab.3. In Excel 2003 or Excel 2007, select 'Rename.' In Excel 2010, select 'Rename Sheet.'4. Type the new name over the old name.Visual Basic for Applications (VBA)5. Click on a sheet tab to make it the active sheet.6. Open the Visual Basic Editor. In Excel 2003, select Tools > Macro > Visual Basic Editor from the menu. In Excel 2007 and 2010, click 'Visual Basic' in the 'Code' area of the 'Developer' tab.7. Insert a new module. Select Insert > Module from the menu.8....
How to Make Excel Not Simplify
1. Highlight the group of cells that you plan to enter fractions in. To highlight an entire row or column, click the letter or number on the top or left side of the spreadsheet. Do this only in a spreadsheet that you intend to enter fractions in; if you change the formatting of cells already containing fractions, Excel will change the fractions to decimals.2. Right-click the highlighted cells, and select 'Format Cells' on the context menu. A new pop-up window titled 'Format Cells' appears.3. Select the tab labeled 'Number' at the top of the Format Cells window.4. Click to select 'Text'...
How to Make an Excel 2007 Spreadsheet
1. Open Microsoft Office Excel 2007.2. Create an Excel spreadsheet from scratch by selecting the Microsoft Office Button. Click on 'New' and press the 'Enter' key. A blank worksheet will be placed on your screen. The first cell is column A, row 1.3. Add a heading to the first cell, such as 'Department' and press the 'Tab' key. You can use the 'Enter' key to go down one line or the 'Tab' key to move across your cells.4. Add another heading to the right of 'Department' (in column B, row 1) called 'Sales' and press the 'Tab' key. Continue adding more information to your heading (in column...
How to Export Excel Graphs as Pictures in Words
Import the Excel File into a Word Document1. Open the Word 2010 document.2. Click the “Insert” tab on the command ribbon.3. Click “Object” in the “Text” group. The “Object” dialog window opens.4. Click the “Create from File” tab.5. Type the Excel file name or click “Browse” to locate the Excel chart file.6. Click “Insert.”7. Click “OK.” The Excel file opens on the Word document.8. Click in the chart area. If the chart appears huge, click and drag the sizing handles to re-size. You can also position the chart over the worksheet to minimize the worksheet from view.9. Click outside...
How to Merge Data in Duplicate Rows in Excel
1. Click the Windows 'Start' button and select 'All Programs.' Click 'Microsoft Office,' then click the 'Microsoft Excel' shortcut to open the software.2. Click the 'File' ribbon and then click 'Open.' Click the Excel file you want to edit and click 'Open.' Click the cell where you want to display the merged results.3. Type the following function in the cell:=concatenate(a1, b1)4. Press 'Enter' to save the changes. The cells 'a1' and 'b1' are merged and displayed in the selected ce...
How to Draw Data Trees in Excel
1. Launch Excel 2010 and begin working on a new spreadsheet. Click the cell where you want the top item of the data tree to appear. Begin around cell J1 for a vertical tree or cell A10 for a horizontal tree to allow sufficient room for branches.2. Click the 'Home' tab at the top of the window. Click the arrow next to the Border button in the 'Font' section of the toolbar and select 'Thick Box Border' to draw a border around the tree item.3. Click a cell a short diagonal distance from the first cell. For example, if you put the first tree item in cell J1, click cell 'H4.' Type the first item...
Saturday, October 26, 2013
How to Copy Paste Conditional Formatting
1. Open the worksheet that contains the conditional formatting you want to copy and paste.2. Select the range you want to copy. Make sure the cell that contains the conditional formatting is included in the range.3. Go to the Format menu and select Conditional Format. The conditional formatting from the highlighted range will be already defined in the dialog box.4. Click 'OK.' This will copy the formatting to the rest of the cells in the highlighted ran...
How to Disable the Office 2007 Clipboard
1. Start Microsoft Word 2007 from the 'Start' menu or shortcut. If you do not have this application installed, you can load Excel 2007, Access 2007, Outlook 2007 or PowerPoint 2007 and follow the same steps.2. Click on the 'Home' tab from the top toolbar so you can see the large 'Paste' icon. Below the 'Paste' icon is a caption labeled 'Clipboard.' Click on the small icon at the right of the 'Clipboard' text to bring up the clipboard task pane.3. Click the 'Options' button on the bottom left and click on any items that are checked. Doing this will uncheck the item and disable the corresponding...
How to Calculate Ranges in Excel 2007
1. Open Excel. Click the 'Office' button. Select 'Open' from the menu.2. Highlight the file you want to open. Click the 'Open' button.3. Highlight the cells that you want to put in the range. Click in the 'Name Box' to the left of the 'Formula Bar.' Type a name for the range. Repeat this step until you have created all the needed ranges.4. Click in the cell where you want to perform the calculations. Hold the 'Shift' key and tap the 'F3' key on the keyboard. Select the type of calculation from the 'Select a function' pane in the 'Insert Function' window.5. Type the name of the range...
Thursday, October 24, 2013
How to Create User Forms With Excel 2003
1. In the 'Tools' menu, point to 'Macro' and then click 'Visual Basic Editor' or press 'ALT' 'F11' to open the Visual Basic Editor. Open the 'Main' menu, select 'Insert' and click 'User Form' to create a new UserForm object.2. Place a TextBox control and a Label control for each column in your worksheet onto the form by double-clicking the control or by dragging them from the Toolbox onto the form. Replace any TextBox and Label combination with a ComboBox control if you wish to present the user with a list of options to select from for the field rather than a text box.3. Assign the correct...
How to Open XML in Excel 2007
1. Enable the 'Developer' tab in MS Excel 2007. Click on the Windows icon on the top left hand side of the screen and click on the 'Excel Options' button. Click on the 'Popular' category to bring up popular Excel 2007 choices. Then click on the box next to 'Show Developer Tab in Ribbon.' Click on 'OK' once this box is checked.2. Click on the 'Developer' tab on the top of the screen to show the Developer commands. Click on the 'Import' button in the 'XML' box.3. Browse through your files until you find the file you want. Click on the file to select it and then click 'Open.'4. Select...
How to Add Labels in Excel 2007
1. Open Microsoft Excel 2007 and the worksheet that contains the data you want to chart.2. Select the data that will be charted and create a chart for it by clicking on the 'Insert' tab. Choose the type of chart you want to create from the 'Charts' group---column, line, pie, bar, area, scatter or other. Your chart will be placed onto the worksheet.3. Make sure graph is selected, then click on the 'Layout' tab in the Ribbon, so you can add your data labels. Go to the 'Labels' group and click on the arrow by 'Data Labels.' Choose 'More Data Label Options' from the list of choices.4. Select...
How to Create a Formula in Excel 2003
1. Open Excel by double-clicking the Excel icon on your desktop. If you already have a spreadsheet made, you can create a formula using your existing data. If you do not have any data, just plug some numbers into the cells so you can try out these formulas.2. Decide what your formula needs to calculate. Do you need to add up a column or row of figures? Do you need to divide one cell's value by another cell's value?3. Start with an '=' (equal sign). Every formula will start with an equal sign. If you don't begin with this symbol, your formula will not work.4. Put the first cell's name...
Wednesday, October 23, 2013
How to Use Excel's VLOOKUP Function
1. Learn the syntax for VLOOKUP. It is VLOOKUP(search_value,table_array,column_index_number,range_lookup).2. Specify search_value as the value to search for in table_array. Search_value may be a reference or a value. VLOOKUP will return the #N/A error value if search_value is smaller than any value in the first column of table_array.3. Use table_array to provide the data to search. It must represent at least two columns and a reference to a range or range name may be used. The values in the first column may be logical values, numbers or text. The search is not case sensitive.4. Provide...
How to Select Visible Cells Only in Excel 2007
Using the 'Select Visible Cells Only' Button1. Launch Excel and open the file that you'd like to work on.2. Right-click on the menu bar and then click on 'Customize Quick Access Toolbar.'3. Click the drop-down menu under 'Choose commands from' and then choose 'Commands Not in the Ribbon.'4. Choose 'Select Visible Cells' from the list and then click the 'Add' button. Click 'OK.' The 'Select Visible Cells Only' button should now be visible on your Quick Access Toolbar.5. Select a range of cells that contains hidden rows or columns. Click the 'Select Visible Cells Only' button. This removes...
Tuesday, October 22, 2013
How to Use Random Function in Microsoft Excel
1. Open Microsoft Excel.2. Create two values between which you want a random number generated. For this example, enter '1' in cell A1 and '10' in cell A2, omitting the quotation marks in both cases.3. Type the implementation of the random number function show below into cell A3:=RAND()*(A2-A1) A1The random function is designed to return a random value greater than or equal to 0 and less than 1. By taking the difference between the upper limit of the range (in cell A2) and the lower limit of the range (in cell A1) and then adding the lower range value, you generate a random number between...
How to Convert Word Files to Excel Files
Copy and Paste1. Open the Word file in Microsoft Word.2. Click and drag to highlight the information you wish to bring into Excel, press 'Ctrl-C' to copy.3. Open Microsoft Excel and click into a blank cell.4. Press 'Ctrl-V' to paste' the Word content into Excel. Table data from Word transfers the best. Paragraph text is pasted into the first cell on each row, with one paragraph per row.Save the Word file as HTML First5. Open the Word file in Microsoft Word.6. Select Click the 'File' menu and select 'Save As.' Choose 'HTML' or 'Web page' in the Save As Type drop-down menu.7. Click...
Monday, October 21, 2013
How to Recover a Lost Document in Microsoft Excel
Closed Without Saving1. Click 'File' and then click 'Recent.'2. Click 'Recover Unsaved Workbooks.' A folder of drafts will open in another window.3. Double-click the file to open it.4. Click 'File' and 'Save As' to save the file so you don't lose it again.Previously Saved5. Open the file on which you were working before you lost your changes.6. Click 'File' and 'Info.'7. Click the version that says '(when I closed without saving)' under Versions.8. Click 'Restore' at the top of the window to save the version you lo...
How to Create Microsoft Excel Forms
Add Data Forms Command to Quick Access Toolbar1. Open Excel to a default, blank worksheet. Click the 'Microsoft Office' button at the top left of the screen to open the 'File' menu and then select the “Excel Options” to open a new “Options” window.2. Select “Customization” from the list on the left side of the window to view commands you can add to the Quick Access toolbar. To make locating the 'Data' Forms command easier, click the drop-down list next to “Choose Commands From” and select “Commands Not on the Ribbon.”3. Select the “Forms” command from the drop-down list and press the “Add”...
How to Find and Replace Text in Microsoft Excel 2003
1. Access the 'Find and Replace' menu. Scroll to the “Edit” tab on the command bar and select “Find.” A “Find and Replace” properties menu will open.2. Type in the text you want to find. Under the “Find” tab, you can type in the text that you wish to find.3. Type in the text that you wish to replace. Under the “Replace” tab, you can type in the text that you wish to replace.4. Find and replace desired text. You can do this in two different ways. One way is by pressing the “Find All” button, which will find all occurences of the text you have typed, and another method is by using the “Find...
How to Override an Excel Password
1. Make a new spreadsheet. Leave it entirely blank. If it is a protected workbook, instead of just one sheet, make a new workbook.2. Click on the top left corner of the protected spreadsheet's header bars (above the 1, left of the A) to highlight the whole sheet.3. Copy the spreadsheet, either by pushing 'Ctrl' 'C' or by selecting 'Edit' from the menu bar and clicking on 'Copy.'4. Click on your new blank spreadsheet. Click the top left corner to highlight the whole sheet, as in Step 2.5. Paste the copied spreadsheet by pushing 'Ctrl' 'V' or by selecting 'Edit' from the menu bar and...
Sunday, October 20, 2013
How to Make Pie Graphs in Excel
1. Enter the data that you want your pie graph to represent into a spreadsheet in Microsoft Excel. Make sure to include column headings that explain what the data signifies. Try to be as descriptive with your data entry as possible because these elements will automatically feed into the pie graph. To help explain, we will construct an example in which we create a pie graph that breaks down a favorite color list by percentage.2. Click on the cell that contains your first column heading. Then, from the “Insert” menu, click on the arrow underneath the word “Pie” and the picture of a sample pie...
How to Make Address Labels From Excel 2007
1. Open Excel by clicking 'Start,' then 'All Programs,' then 'Microsoft Office,' and finally 'Microsoft Office Excel 2007.'2. Click the 'Microsoft Office Button,' then select and click 'New,' and under the Template > Microsoft Office Online section click 'Labels.'3. Click 'Mail and shipping,' then select and click 'Business.'4. Select and double click the icon 'Avery 8160 Template' and the label template will begin downloading onto your computer system. Once it has completely downloaded, 30 labels will appear on a letter-size, 8.5-inch by 11-inch, Excel worksheet window.5. Type the...
How to Compare Two Excel Spreadsheets for Duplicate Rows
1. Open your spreadsheet and make sure you know what columns the data you want compared are in. This example will assume the data is in column A, and that the two lists to be compared are in two spreadsheet tabs, labeled Sheet1 and Sheet2 of the same workbook.2. Enter the following formula in cell B1 of Sheet1. =COUNTIF(Sheet1A:A,Sheet2A:A). Hit Enter. If the record is unique (it doesn't appear on both lists), this will evaluate to 0.3. Copy the formula from cell B1 through as many rows as you need on Sheet1.4. Select columns A and B, and click on the Home tab (in Excel 2007) and select...
How to Draw in Excel 2007
1. Open Microsoft Excel 2007.2. Click on the 'Insert' tab. This is located near the top right-hand corner of the screen.3. Click on the 'Line' drawing tool. The 'Line' tool is a good place to start, because you can use basic line shapes to draw a plethora of other custom-drawn shapes.4. Click 'Lock Drawing Mode,' located underneath the main 'Line' heading. This option lets you connect several lines to predetermined nodes.5. Click on the document where you want the line to start.6. Drag your cursor across the spreadsheet to form a line and double-click when the line is long enough....
How to Make a Checkable Survey in Excel
1. Open a new Microsoft Excel 2010 worksheet.2. Enter your desired text into the cells on the spreadsheet. You can click and drag the sides of the letters at the top of each column or the numbers at the left side of each row to resize the cells as you need to. This text is what the survey taker will see when they are using the survey. Leave spaces next to the text so that you can add your checkboxes.3. Click the 'File' tab at the top of the screen and choose 'Options' from the list that appears on the left side of the window. Select 'Customize Ribbon' from the list on the Excel Options window....
How to Turn an Excel Spreadsheet Into a Standalone Application
1. Download and install the XCell Compiler using the link in the Resources section.2. Launch Microsoft Excel and open the spreadsheet that you would like to convert to a standalone EXE file.3. Click the Office jewel in the upper-left corner of the window. Click 'Excel Options.'4. Click the 'Trust Center' link on the left side of the window, then click the 'Trust Center Settings' button.5. Click the 'Macro Settings' link on the left side of the window, then place a check in the box labeled 'Trust access to the VBA project object model.' Click 'OK.'6. Click the 'Add-Ins' tab at the top...
Saturday, October 19, 2013
How to Copy and Paste Tables From Excel into Microsoft Word 2003
1. Highlight and copy the table from Excel. Left-click and hold as you highlight the entire table in Excel. Release the mouse button and the table will remain highlighted. Right-click on the highlighted table, and then click on “Copy.”2. Select the area in Word that you wish to paste the table into. Click on the portion of the document that you wish to paste the table into.3. Paste the table into Word. Scroll to the Edit tab and then select “Paste.”4. Choose your table paste attributes. On the lower-right corner of the table you just pasted, there will be a clipboard icon. Click on this...
How to Check for Duplicates in Excel
1. Click the Windows 'Start' button and select 'All Programs.' Click the 'Microsoft Office 2010' folder to expand the contents of the folder. Click the 'Microsoft Excel 2010' option to launch the Excel application.2. Click the Microsoft Office button, and click 'Open.' Navigate to the spreadsheet file to search for duplicates.3. Click the top leftmost cell to select the entire worksheet. To select a range of cells, click the top leftmost cell and drag the cursor to select the desired columns and rows.4. Click 'Data' from the top navigation ribbon. Click 'Filter' and then click 'Advanced...
How to Recover a VBA Excel Password
1. Navigate to the A Pass Cracker Atomic Visual Basic for Applications (AVBA) link (see Resources). AVBA recovers passwords for VBA passwords associated with Microsoft Excel and Word. The software promises to recover passwords instantly regardless of length. Although there is a trial version of the software available, it will only show the first two symbols of the cracked password: you must purchase the full version to see the rest of the password.2. Click on Last Bit's VBA Password link (see Resources) and download the software. VBA Password uses a combination of six different techniques...
How to Get Solver for Excel 2007
1. Open a spreadsheet in Excel.2. Click 'Add-ins' on the Tools menu. Select 'Solver Add-in' check box.3. Click 'OK,' and the Solver installation will begin automatically.4. Click on 'Solver' on the Tools menu to run the progr...
Friday, October 18, 2013
How to Protect a Pivot Table
1. Open the worksheet with the pivot table. Select the pivot table information in your Excel worksheet that you would like to protect.2. Click 'Review' from the ribbon menu. Under the Changes group, click 'Protect Sheet.'3. Click the 'Use PivotTable Report' check box. Type a password in the 'Password to Unprotect Sheet' box.4. Click 'OK' and re-enter the password. Your pivot table is now protect...
How to Calculate Mode Using Excel
1. Add the numbers in the first column of your Excel 2007 document. For example, add the numbers 9,6,5,9,4,9,2 and 1 in A2, A3, A4, A5, A6, A7, A8 and A9.2. For this example, click on the 'A11' cell. This is the cell where you will calculate the mode. When you calculate another mode, choose any cell at the bottom of the list of numbers you are using.3. Click 'Insert Function' on the top, left-hand side of the Excel spreadsheet. The 'Insert Function' window will pop open. With Microsoft Excel 2007, click on the 'Formulas' tab and then 'Insert Function.'4. Click on the drop-down menu of...
Thursday, October 17, 2013
How to Add a Calendar Date Picker to an Excel Spreadsheet
1. Download the free 'Calendar' tool available at isamrad.com/ExcelCal/default.htm. This plugin is a standard Excel add-in program. It is offered as a compressed ZIP file which must be unzipped after download. Once the XLA file is placed into the Excel 'XLSTART' directory in the 'Program Files' folder of Windows, Excel will show a date picker icon next to cells that are already formatted as dates. Additionally, the date picker can be launched by right-clicking on any cell and choosing the 'Pick from Calendar' option. The applet also installs a toolbar button for the feature.2. Activate a free...
How to Enter Formulas in Excel Divide the Sum of Several Numbers by a Number
1. Click on an empty cell in your spreadsheet.2. Type an '=' sign.3. Type the following formula into the cell: UM(A1:A10).4. Replace 'A1:A10' with the cell locations of the numbers you want to add. In this example, the series of numbers is in cells A1 through A10.5. Type a division sign '/' followed by the number you want to divide by. For example, if you wanted to divide the total of cells A1 to A10 by 3, type '/3.'6. Press the 'Enter' key; Excel will perform the calculati...
How to Create a Flow Chart in MS Word
1. Open Microsoft Word, which automatically defaults to a blank portrait-oriented page on the screen. To change your flow chart to landscape orientation, click the 'Page Layout' tab at the top of the screen and click the 'Orientation' button directly below it. The page changes to landscape.2. Type the name of the flow chart at the top of the page, such as 'Weather Closing Phone Tree.' Highlight the words, click the 'Home' tab at the top of the screen and change their appearance using the options in the 'Font' section of the ribbon/toolbar, such as font style and text color.3. Click the 'Insert'...
Wednesday, October 16, 2013
How to Exit Out of Header Footer Option in Excel 2007
1. Add a header or footer. Click 'Header Footer' in the 'Text' area of the 'Insert' tab. Click on the document in the area marked 'Click to add header' or 'Click to add footer.'2. Design the header or footer. Select preformatted options from the menu, type in your own text, or use a combination of menu items and typed text. When you finish the header or footer, click anywhere on the body of the document.3. Change to Normal View. Click 'Normal' in the 'Workbook Views' area of the 'View' tab. You will leave header/footer mode and return to your workshe...
How to Print Address Labels in Excel
1. Open a blank worksheet in Excel. Go to the 'File' menu, click on 'Page Setup' and go to the 'Margins' tab in Excel 2003. In Excel 2007, go to the 'Page Layout' tab and click 'Margins.'2. Enter '0' in the Top and Bottom boxes. Change the margins in the left and right boxes to '.19.' Under Center on Page, select 'Horizontally' and 'Vertically.' Apply these changes by clicking 'OK.'3. Select cells A1 through A10 with the mouse. Go to the 'Format' menu in Excel 2003, point to 'Row' and select 'Height.' In Excel 2007, click 'Format' on the Home tab and click 'Row Height.' Enter '72' and click...
How to Use the Transpose Function in Excel
1. Highlight the range of cells where you want the transposed data to appear. For example, if you want to transpose cells A1:A10 into a row in cells B1:K1, you would highlight B1:K1.2. Go to the 'Formulas' tab and click on 'Insert Function.' Type 'Transpose' in the 'Search for a function' field and click on the 'Go' button. Select 'Transpose' from the 'Select a function' section and click 'OK.'3. Highlight the range of cells you would like to transpose. In our example, we would highlight cells A1 through A10. The range will appear in the 'Array' field of the Function Arguments window.4....
Tuesday, October 15, 2013
How to Delete Shading From Alternate Rows in Excel 2003
1. Open the spreadsheet which contains the unwanted shading.2. Click on the row number of one of the shaded rows. This will highlight the entire row. Ctrl-click on each row number where there is shading you want to delete.3. Click on 'Format' on the menu then 'Format Cells.' Click on the 'Patterns' tab. Click the bar above the color palette that says, 'No Color.' This will delete the shading from alternate rows in Excel 20...
How to Draw a Histogram in Windows Excel
Load the Analysis ToolPak1. Open a new Excel spreadsheet. Click on the 'File' tab at the top of the screen, and then click 'Options' on the menu that appears.2. Click 'Add-Ins' from the list on the left side of the Excel Options menu. Click the drop-down arrow next to the 'Manage' box at the bottom of the window. Choose 'Excel Add-Ins' from this drop-down menu, and click 'Go.'3. Click the small box next to 'Analysis ToolPak' to place a check in the box. Click 'OK' to close this window.Create the Histogram4. Click on cell 'A1' and enter the title for the data that you want to use with the...
Monday, October 14, 2013
How to Remove Multiple Duplicate Rows in Excel 2003
1. Open the spreadsheet and select the cells that may include duplicate rows. The values in the rows can be text or numbers.2. Click the 'Data' menu, hover over the 'Filter' option and choose 'Advanced Filter' from the submenu.3. Choose 'Copy to another location,' which leaves the original range of data intact, just in case.4. Check the prepopulated 'List range' to confirm it's the range of data you want to filter of any duplicate values.5. Choose, in the 'Copy to' field, the first cell to which you want to copy the filtered cells.6. Place a tick mark in the box labeled 'Unique records...
How to Make a 2nd Line on MS Office Excel
1. Click 'Start,' then 'All Programs.'2. Click the 'Microsoft Office' folder, then click 'Microsoft Office Excel.' This will open a new workbook. To open an existing workbook, click the 'File' tab, then click 'Open' and browse to your file.3. Click the cell into which you wish to add a second line.4. Add the data for the first line, then press 'Alt Enter' to create a second line within the cell. You can continue to use 'Alt Enter' to add additional lines to your cell as we...
How to Add Data Labels to an Excel Chart
1. Start Microsoft Excel 2007 and open a workbook from your files that contains a chart to which you would like to add data labels.2. Select the chart you want to add the data labels to by clicking it. The chart will be surrounded by a light blur border indicating it is selected.3. Choose the 'Layout' tab at the top of the Excel 2007 screen to display the options in the 'Layout' ribbon. Locate the 'Labels' group in the 'Layout' ribbon.4. Click the 'Data Labels' button in the 'Labels' group of the 'Layout' ribbon to display a drop-down list of options.5. Opt for 'Center' from the 'Data...
Sunday, October 13, 2013
How to Add a Custom Menu to an Excel Toolbar in Excel 2003
1. Log on to your computer and open your Excel worksheet. 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. Go to 'Tools' in the toolbar. Hold the mouse over the arrow to expand the menu and select 'Customize'.3. Add the functions that appeal to you by checking desired toolbars under the 'Toolbars' heading.4. Click on the 'Commands' tab. Choose a category from the displayed list, then choose a command and drag it off the dialog box to the toolbar. Repeat as desired.5. Delete a command by dragging...
Saturday, October 12, 2013
How to Multiply in Excel
Single Cell Multiplication1. Select the cell where the answer will be. You can put a self-contained multiplication problem in one cell anywhere in a workbook and use it just like a calculator.2. Start with the equals sign in the cell where the answer goes. This is the first step to tell Excel that the cell contains a math function.3. Use the asterisk sign as the multiplication symbol. Like standard math, insert the asterisk between numbers in the equation with no spaces and hit 'Enter.' The cell should contain the solution to the multiplication problem.Multiply an Entire Range of Numbers...
How to Restore the Default Settings in Excel 2007
Tools Menu1. Log on to your computer and open Microsoft Excel 2007. Open a blank spreadsheet.2. Click on the 'Tools' menu. Choose 'Customize' from the list of options.3. Right-click on the menu you want to restore to its default settings. Choose 'Reset' to restore the menu to its original default settings.Help Menu4. Open Excel 2007. Click on the 'Help' menu.5. Choose the 'Detect and Repair' option. Check the 'Restore my shortcuts while repairing' check box.6. Click 'Start' to begin the repair process. Repairing Excel 2007 will bring it back to its original configurati...
How to Use Visual Basic to Add a Worksheet in Excel 2007
1. Click the Windows 'Start' button and select 'All Programs.' Click 'Microsoft Office,' then click 'Microsoft Excel.' The programming software opens.2. Click the 'Office' button and click 'Open.' Click your Excel file name to open it in your software. Click the 'Development' tab and 'View Code' to open the VBA coding file for the spreadsheet.3. Type the following code in your VBA code file:Set newSheet = Worksheet.AddnewSheet.Name = 'New Sheet'newSheet.ActivateThis code creates a new sheet and names it 'New Sheet.' The code then makes it the active sheet.4. Click the 'Save' button and...
Friday, October 11, 2013
How to Update Link Workbooks in Excel 2007
1. Close out all of the workbooks in the Microsoft Excel 2007 application. Click on the “Microsoft Office” button and then click on the “Open” option.2. Select the destination workbook that contains all of the links and then click on the “Open” button.3. Click on the “Update” button from the pop-up dialog box that appears on the screen to automatically update all of the links for the source workbooks.4. Click on the “Don’t Update” option if you want to only select links to other workbooks, and then click on the “Edit” option from the top toolbar menu.5. Click on the “Links” option and...
How to Detect Repair Excel 2007
Microsoft Excel 20071. Open Microsoft Excel 2007.2. Select the 'Microsoft Office' button. Click the 'Excel Options' button.3. Select 'Resources' located on the left side. Click the 'Diagnose' button and then click 'Continue.'4. Click the 'Start Diagnostics' button. Office tries to identify your software problem and attempts to repair any problems. Click 'Close' when the diagnostics are complete. If Microsoft Diagnostics cannot fix the problem, repair the software through the Control Panel.Control Panel5. Open the 'Start' menu. Choose 'Control Panel' from the menu. Click the link to 'Uninstall...
How to Calculate a Date in Excel
1. Populate today's date with the Today function. Type '=TODAY()' in a blank cell to return today's date. The Now function returns the date and the time stamp: '=NOW()'.2. Calculate a future date by entering a date in a cell. Click on an empty cell and type '=cell reference number of days' where cell reference refers to the date that was entered and the number of days should be substituted for the actual number of days you want to calculate. For example, if we enter 5/22/2009 in cell A1 and want to know what the date will be in 21 days, the formula would be '=A1 21', which returns 6/12/2009.3....
How to Learn Basic Microsoft Excel
1. Learn Excel online through the Microsoft Office website, which includes Excel tutorials for all levels. Click the 'support' tab at the top of your page and select 'Excel' from the drop-down list. Select the Excel version you want to learn from the right and click 'Getting started.' Pick a topic -- such as 'Basic tasks in Excel 2010' -- that interests you. (see References)2. Learn how to complete basic tasks in Excel through video tutorials at Microsoft Office. Click the video that interests you, such as 'Video: Getting Started with Excel 2010,' 'Video: Create a workbook,' or 'Video: Print...
How to Embed a PDF File in Excel
1. Select the cell in your Excel spreadsheet where you wish to embed a PDF. The PDF file will take up more than just one cell; select the cell you want the top left-hand corner of the file to appear. Click on the 'Insert Object' button in the Text group under the Insert tab. Highlight 'Adobe Acrobat Document' under Object type in the Object pop-up window .2. Decide how you want your PDF to appear in your Excel document. If you want the PDF to appear as the first page of the PDF, simply click the OK button. If you want the PDF to appear as an icon, click the check mark labeled 'Display as...
Subscribe to:
Posts (Atom)