1. Open Excel 2003 and click in cell A1. Type '1' in cell A1 and '2' in cell A2. Highlight these two cells.2. Notice the fill handle in the lower right hand corner of these highlighted cells. Point to the fill handle. Your mouse will become a thin black ' .' This is your indicator that the fill handle can be dragged to fill in the sequence.3. Drag the fill handle down a few cells. Notice the rest of the sequence is automatically populated in the cel...
Browse » Home » Archives for June 2013
Friday, June 28, 2013
Thursday, June 27, 2013
How to Delete a Named Range in Excel 2007
1. Open your Excel file.2. Click 'Formulas.'3. Select 'Name Manager.'4. Highlight the named range.5. Press 'Delet...
How to Make a Decision Tree in Excel
1. Draw a square in a blank Excel worksheet. In Excel 2007, click 'Insert,' then 'Shapes' and then click on a square. In Excel 2003, click on the 'Rectangle' autoshape button on the drawing toolbar and drag the square to your worksheet.2. Right-click on the square and click 'Add text.' Type the major decision into the box. For example, you might be deciding whether to save or spend a recent windfall, so write 'Save or Spend' in the box.3. Select a 'Line' shape from the toolbar. Click on the right edge of the square and drag the line to a length of an inch or two (you can change the lengths...
How to Upgrade From Excel 2003 to 2010
Office 2010 Installation1. Place the Office 2010 installation disc into your computer or download Office 2010 from the Microsoft website.2. Follow the prompts to initiate the installation of Office 2010. If you have downloaded a version of the software, you may be prompted to unzip the files. For CDs, you will have to enter a product key, which can be found on your CD case.3. Click 'Customize' in the 'Choose the installation you want' dialog box.4. Right click and then click 'Not available' for all programs except for Excel 2010.5. Click 'Install now' to install Excel 2010.Excel 2010...
How to Transfer Excel VB Data From Range to Array
1. Click the “View” tab on the 'Ribbon' menu. Click the “Macros” icon to display the “Macro” dialog.2. Select an existing macro name in the list box if you want to add the ability to copy data from a range of cells to an array. Click “Edit” to open the Visual Basic editor. If you want to write a new macro, type the name into the “Macro name” text box and click “Create.'3. Declare an array variable as a 'Variant' data type. The following example declares the array 'RangeArray':Dim RangeArray As Variant4. Assign the data cell range to the array. Continuing the example, assign the cells A1...
How to Format Drop
1. Open Excel 2010 and select a workbook that will contain the drop-down list. Click the 'File' tab and select 'Open.' Browse your files and select the workbook. Click the 'Open' button. The workbook opens.2. Highlight the range of cells where the drop-down list will be displayed. Select the 'Data' tab, then select 'Data Validation.' The Data Validation dialog box appears.3. Click the 'Settings' tab. Change the 'Allow' drop-down list to 'List.' In the 'Source' drop-down box, type 'Yes,No,Maybe.'4. Click the 'Input Message' tab. The input message will appear as the user uses the drop-down...
Wednesday, June 26, 2013
How to Hide Worksheets in Excel 2007
1. Select the worksheets you want to hide. Click the worksheet tab, such as Sheet1 or Sheet2 to select one sheet. To select at two or more adjacent sheets, click the first tab then hold the 'Shift' key and click the last tab. To select more than one nonadjacent sheets, click the first tab then hold the 'Control' key and click the other tabs you want to hide. To select all sheets, right-click any sheet tab then choose 'Select All Sheets' on the shortcut menu.2. Click 'Format' in the Cells group located on the Home tab above the worksheets.3. Select 'Hide and Unhide' under Visibility and click...
How to Make an Invoice in Excel 2007
1. Click the round 'Office' button in the top left of the Excel worksheet. A drop down will appear with a list of icons on the left and a list of 'Recent Documents' on the right.2. Click 'New,' the first icon at the top of the list on the left of the drop down. A new screen will pop up automatically defaulting to 'Blank and recent' in the box on the left of the screen and 'Blank Workbook' at the top of the middle box.3. Click 'Invoices' in the box on the left of the screen under the header 'Microsoft Office Online.' The middle screen will change to show thumbnails of various invoice designs.4....
How to Calculate the Percentage Change From the Previous Year in Excel
1. Enter previous and current year information in columns side by side. Give the column headings to indicate the first is the current year information and the second is the prior year information.2. Name the next column 'Percent Change,' and click on the first row in that column that has data in the fields for current and previous years.3. Enter the following formula into the cell; '=(cell with current year info)-(cell with prior year info)/(cell with prior year info).' For example, if the first row to have data in it is Row 6, the current year information is in Column C, the prior year...
How to Create Labels in Microsoft Office 2007 From Excel 2007
1. Open a new Excel spreadsheet. Type 'Last Name' into Cell A1. Move right across the first row of cells labeling each new cell with the information you need in order, such as 'First Name,' 'Title,' 'Address,' 'City' and 'Zip Code.'2. Type in the relevant information for each mailing label you need on the column below the row heading. For example, type in the last name for each contact underneath the 'Last Name' column.3. Highlight the entire section of columns and rows with the mailing label information, including the top row headers. Navigate to the 'Formulas' tab and click 'Define Name.'...
Tuesday, June 25, 2013
How Can I Overlay Graphs?
1. Open the Excel worksheet that contains the data series.2. Click and drag the cursor on the range of cells that will convert to a chart.3. Select the “Insert” tab on the command ribbon.4. Click the arrow in the lower-right corner of the “Charts” group to launch the dialog box. The “Insert Chart” dialog box opens with a gallery of sample charts.5. Select a 2-D chart. For example, choose the bar, column or line.6. Click “OK.” The worksheet data converts to an embedded chart. The “Chart Tools” ribbon appears.7. Click one data series in the chart’s plot area.8. Click the “Design”...
How to Fix a Faded MS Office Menu
1. Click 'Save' on your document. Sometimes this is all that is needed to move your cursor from a place (such as editing a cell in Excel) that blocks certain menu commands. If 'Save' is one of the faded items, click anywhere in the document to move your cursor from its current position.2. Examine the title bar at the top of your Office program window. This will tell you the title of the document as well as the program and other information. If the title bar contains the words 'Read Only,' you can save the file under a different name to allow access to the toolbar items. In this case, click...
How to Add Borders to Multiple Cells in Microsoft Excel 2003
1. Select the cells to which you wish to add a border. Left-click on one cell, then hold and drag the cursor across the entire group of cells to highlight them. When you release the mouse button, all the cells will stay highlighted.2. Right-click on the group of highlighted cells to access the Cell Properties menu. Select “Format Cells” to access the border menu. Then scroll to the “Border” tab to change the border.3. Under the “Border” tab, you can select a premade border under “Presets.” Or you can devise a custom shape and size for the border by clicking on the different border shapes...
Monday, June 24, 2013
How to View or Hide the Toolbar in Excel 2007
View or Hide1. Open Excel 2007. You will notice three distinct parts of the Excel 2007 window: The spreadsheet, the formula bar and the toolbar. The toolbar includes seven different tabs: Home, insert, page layout, formulas, data, review and view. The traditional functions such as file, save, save as and print are under the Office button in the upper left corner.2. View the toolbar located near the top of the screen. This will be your default option. On Excel 2007, the toolbar is referred to as the ribbon. Rather than just a list of headings with drop down menus, Excel 2007 toolbar has a visual...
How to Disable the Security Warning in Excel 2007 Macro
1. Open Excel 2007 and click the 'Office' button. Click 'Open.' Browse the files and locate the workbook. Click the workbook and the 'Open' button.2. Notice the security warning across the top of the Excel workbook. Click the right 'Options' button on the security button.3. Select 'Enable Content.' Click 'Ok.' The security warning is disabled and the macros are functional in the workbo...
How to Create Excel Spreadsheet of Folder Subfolder Directories
In Excel 2003 and Older1. Log in to your computer as an administrative user.2. Open a command window by holding down the 'Shift' key on your keyboard while you right-click anywhere on your desktop. A menu will appear. Click 'Open a Command Window Here.' A command window will open on your desktop. You will see a few words followed by a blinking cursor.3. Type “CD\' after the blinking cursor (do not type the quotation marks). Press the “Enter” key on your keyboard. A new command line will appear below. It should read 'C:\>' followed by the blinking cursor.4. Type 'dir /ad /s >c:/directories.txt”...
How to Share a Workbook
Setting Up Workbook Sharing in Excel 2003 or Earlier1. Open Microsoft Excel and then open the workbook that you want multiple people to be able to edit at once.2. Click 'Tools' and then click 'Share Workbook' to load the Share Workbook options window.3. Check the 'Allow Changes by More Than One User at the Same Time. This Allows Workbook Merging' option under the 'Editing' tab. Click 'OK.'4. Click 'File' and then 'Save' to update the interactivity to the workbook.5. Tell other users that they can open the workbook. At any time, click 'Tools' and then 'Share Workbook' to see who has accessed...
How to Calculate Excel Formulas With Multiple Pages
3-D Reference: Contiguous Worksheets1. Create an Excel workbook with four worksheets.2. Enter a numeric value in cell A1 of Sheet2, Sheet3 and Sheet4. Start by making a simple formula to sum up values across these three worksheets.3. In any cell on Sheet1 enter an equals sign followed by your function and an opening parenthesis. For our example, enter “=SUM(”.4. Click on the 'Sheet2' tab at the bottom of your workbook and select the cell in Sheet2 that you want to include in your sum. For our example, use cell A1.5. Hold down the shift key and click on the 'Sheet4' tab. The formula updates...
How to Get a Date Using VLOOKUP in MS Excel 2003
1. Apply cell formatting to any cells that will contain dates. Start a sample project by formatting the entire worksheet. Click the 'Select All' box in the upper left-hand corner. Click 'Format > Cells.' On the 'Number' tab under 'Category,' select 'Date.' Under 'Type,' choose a date format. Click 'OK.'2. Create column headings. In cell A1, type 'Enter Start Date.' In cell B1, type 'End Date.' In cell C1, type 'Start.' In cell D1, type 'End.'3. Build a lookup table. The VLOOKUP function will look for a certain date in the left-hand column and return the corresponding date in the right-hand...
How to Get Percentages in Excel
1. Open a Microsoft Excel spreadsheet.2. Input a number in one cell, which corresponds to an amount. Input another number in another cell corresponding to the total.3. Select a blank cell where to calculate the percentage between the two. The percentage formula is equal to the amount divided by the total. The total is usually greater than the amount.4. Type '=Cell1/Cell2' without the quotation marks in the blank cell, where cell1 corresponds to the location of the first cell and cell2 corresponds to the location of the second cell. Press 'Enter' to get the fractional value. For example,...
Sunday, June 23, 2013
How to Create Excel Templates
1. Open an existing Excel spreadsheet that has all or most of the features you wish to use. Save it as a workbook with a different name, so that you don't accidentally lose any vital information.2. Delete any information that you do not want, such as names and numbers. Leave formulas that you will want to continue to use with the template.3. Create a new worksheet if you do not have an existing spreadsheet that contains the formatting you require. Format the cells, such as adding borders, choosing font options and entering formulas.4. Save the document by going to the 'File' menu and choosing...
How to Make Text Over Images With Microsoft Excel
Clip Art and Pictures1. Add a clip art image or picture to your spreadsheet. Go to 'Insert' and choose 'Picture.' Select 'Clip Art,' 'From File' or 'From Scanner or Camera.' Select your image to insert it into the spreadsheet. Place the image in your desired location.Note that if you want to set transparency options on images from your computer, scanner or camera, they must be bitmap images. These images have a .bmp extension.2. Right-click the image and select 'Show Picture Toolbar.' If the toolbar is already shown, you'll only see an option to 'Hide Picture Toolbar.'3. Click the 'Set Transparent...
Timeline Excel Tutorial
1. Open your Excel worksheet.2. Click the “Insert” tab on the command ribbon.3. Click the “SmartArt” button in the Illustrations group. A dialogue window opens prompting you to choose a SmartArt graphic.4. Click “Process” on the left pane to open the Process gallery, which includes timelines.5. Click a graphic, such as “Basic Timeline.” A larger, detailed view of the graphic and a description appear in the right pane of the dialogue window.6. Click “OK.” The selected graphic appears on the worksheet. The “SmartArt Tools” ribbon displays the “Design” and “Format” tabs.7. Click the...
How to Set Up a Budget on Excel
Set Up Income and Expense Columns1. Open the Excel application to a blank spreadsheet.2. Click cell 'A1' and enter a title for your budget. Type something like 'Monthly Budget' and maybe a 'Last Updated on...' reference to help you quickly see when you last made changes.3. Click into cell 'A3' and enter 'Item.'4. Click into cell 'B3' and enter 'Income.'5. Click into cell 'C3' and enter 'Expenses.'Add Budget Line Items and Dollar Amounts6. Click into cell 'A4.' Start listing your income and expenses, one in each row down the page. Start with your income first. You can double-click the...
Saturday, June 22, 2013
How to Edit an MS Excel Drop Down Menu
1. Launch Excel.2. Select the cell with a drop down menu in it.3. Click on the Data tab of the Ribbon Interface, and select Data Validation. A dialog box will appear. In Excel 2003, you get to this dialog box by clicking on the 'Data' menu item at the top of the application window and selecting Validation.4. Look at the 'Source' field. If it has values separated by commas, the only references this menu uses are those values. Change the value. If it begins with an '=' and refers to a word like this: '=List_Menu1,' it's referring to the named range of List_Menu1 somewhere else in Excel....
How to Create a Drop
1. Click the 'Office' button, and then click 'New.' Click the 'Create' button on the dialog box to accept the default values for a new Excel workbook.2. Click the 'Office' button again, and then click the 'Options' button. Click the 'Show developer tab' check box to display the tab containing the drop-down calendar control.3. Click the 'Developer' tab, and then click the 'Insert' button of the 'Controls' panel. Excel will display a list of controls you can insert in your workbook. None of the displayed controls is a drop-down calendar, but Excel enables access to more controls than those...
How to Get the Ruler to Show Up in MS Excel
1. Open 'Microsoft Excel.'2. Select the 'View' tab.3. Click 'Page Layout,' located in the 'Workbook Views' section.4. Change your measurement options by clicking the 'Microsoft Office' button. Select 'Excel Options' and choose 'Advanced.'5. Click the units to use from the 'Ruler Units' box located under 'Displa...
How to Make a Normal Distribution Curve in Excel 2007
1. Open a new worksheet in Excel.2. Fill in your x-values in column 1, starting at cell A1. For example, if you want your x-values to be from -10 to 10, write '-10' in cell A1, '-9.5' in cell A2, and '-9' in cell A3, all without quotes. Continue down the column until you have entered all of your values through to cell A41.3. Enter '=NORMDIST(A1,0,1,0)' without quotes into cell B2. This formula is for the standard normal distribution, with a mean of 0 and a standard deviation of 1. You can enter any mean or standard deviation into this formula. For example, if you want a mean of 10 and a...
Friday, June 21, 2013
How to Display Fractions in Excel
1. Start the Microsoft Excel program.2. Open the document you wish to add the fractions to by clicking 'Open' on the toolbar. Select 'Open' from the drop-down list. Select the file from the list.3. Select the box, or cell, where you want to display the fraction. If you want to display fractions in multiple cells, highlight all of the cells.4. Right-click on the cell and select the 'Format Cells' option. Another alternative is to click on 'Format' in the toolbar at the top and then select 'Cells' from the drop-down menu.5. Pick the 'Numbers' tab. A list of categories is displayed. Select...
How to Convert Excel to Access
1. Edit the Excel file. Eliminate any rows or columns that you don't want to import. If you only want some of the data in your Access database, create a new named range that contains only the cells you want to include.2. Create the new Access database. Click on File, get external data, import. Change the file type to excel (xls) and then select the spreadsheet to import. You will have to do one table within the spreadsheet at a time. If import errors occur, you may need to make corrections to the spreadsheet, then do the import process again.3. Access will add a primary key by default. Primary...
How to Make Column Titles in Excel 2007 Appear at the Top of Each New Page
1. Open the Excel 2007 file that contains your worksheet. Select the worksheet that you want to print from the list of worksheets at the bottom of the Excel window.2. Click the 'Page Layout' tab at the top of the screen. Locate the 'Page Setup' area of the ribbon and click the 'Print Titles' button.3. Select the 'Sheet' tab in the window that appears. Find the entry that reads 'Rows to repeat at top' and click the small box to the right. The 'Page Setup' window will minimize.4. Select the row that contains the titles you want to repeat. This is normally the first row, but can be any row...
How to AutoFit Column Width in Excel
1. Open Microsoft Excel using the 'Start' menu or a shortcut. Open the document with which you want to work.2. Click the column you want to modify. To select more than one column, press and hold the 'Ctrl' key while clicking on each column.3. Click the 'Format' drop-down menu in the 'Cells' group of the 'Home' tab. Select the 'AutoFit Column Width' option in the 'Cell Size' secti...
Thursday, June 20, 2013
How to Use Excel for a Questionnaire
1. Click the 'Developer' tab, and then click the 'Insert' command on the 'Controls' panel. A gallery of controls for your questionnaire will appear.2. Click the 'Text box' button, whose icon looks like a rectangle with text. Drag on the current spreadsheet to grow the text box.3. Right-click the text box, then click 'Properties.' Excel will display a window showing modifiable attributes of the text box control. Type'J5' in the 'LinkedCell' rows of the 'Properties' window. Excel will use this cell reference to insert questionnaire data entered into the text box control.4. Use the instructions...
How to Convert Excel 2007 to Excel 97
1. Open the workbook in Excel 2007.2. Click the 'Office' button.3. Choose 'Save As'.4. Click on 'Excel 97-2003 Workbook' from the list of 'Save As' options. Excel will save the file in Excel 97 format. The file can now be opened in Excel ...
How to Make a Field Mandatory in an Excel Spreadsheet
1. Launch Microsoft Excel.2. Click the 'Office' button at the top of the screen, then select the 'Excel Options' button at the bottom of the window. Choose the 'Show Developer Tab in the Ribbon' option, then click the 'OK' button.3. Press 'Alt F11,' then double -click the sheet in the left-hand column that will have the mandatory field.4. Type the following VBA code into the window:Sub Button1_Click()If Range('A2').Value = '' ThenMsgBox ('Please insert value in cell A2')Exit SubEnd IfEnd SubYou can replace each instance of 'A2' to correspond to the cell or range of cells you are making...
Wednesday, June 19, 2013
How to Remove Conditional Formating in an Entire Sheet in Microsoft Excel 2003
1. Click 'Start,' then 'All Programs,' then 'Microsoft Excel.'2. Press 'Ctrl' 'O.' Locate and open your workbook that contains conditional formatting.3. Press 'Ctrl' 'A' twice to highlight your entire worksheet.4. Click 'Format,' then 'Conditional Formatting.'5. Click 'Delete,' then check all three of the check boxes. Click 'OK' to remove the formatti...
How to Apply Themes and Styles in Excel 2007
Themes1. Open a spreadsheet in Excel 2007. A spreadsheet allows you to enter data in the format of rows, columns and individual cells.2. Type data into rows and columns. Organize your numerical data or details into an organized spreadsheet.3. Open the 'Page layout' tab. Click on the 'Theme' group. View options to change colors, fonts or effects.4. Apply a template theme by clicking the theme under the Built-In tab.5. Create a custom theme. Click the document theme that you want to use under 'Custom.'6. Look for more by clicking on 'Browse for Themes' to search for more theme ideas.7....
How to Hide X on the UserForm Title Bar in Excel 2003
1. Open your Microsoft Excel 2003 document and scroll to the right until you get to the “X” column.2. Right-click on the column header (“X”) in the user form title bar and select the “Hide” option. The “X” column will now be hidden from view in the spreadsheet.3. Click and drag from the “W” column to the “Y” column to select both columns and then right-click on one of them. Select the “Unhide” option to unhide the “X” column aga...
How to Revert Excel 2007 to A1 Format Instead of R1C1
1. Click on the Windows 'Start' button and select 'All Programs.' Open the 'Microsoft Office' folder, and then click on 'Microsoft Office Excel' to launch the application.2. Click on the 'Office' button in the top-left corner of the screen and then click the 'Excel Options' button at the bottom of the menu.3. Click on the 'Formulas' tab in the 'Excel Options' window. Under the 'Working with Formulas' section, clear the checkbox labeled 'R1C1 Reference Style.'4. Click the 'OK' button to apply the setting. The change to the cell referencing scheme happens instantly, and you will see the...
How to Capitalize the First Letter in Excel
1. Open the Excel 2010 file that contains the text that you want to capitalize.2. Right-click on the column letter directly above the first cell that contains your text. Choose 'Insert' from the pop-up menu and a new column will appear to the left of your selected column.3. Click on the cell directly to the left of the first cell that holds your text.4. Enter the following formula into the cell: =upper(left(XX,1))right(XX,LEN(XX)-1) where 'XX' is the column letter followed by the row number of the cell to the right of the current one. Press 'Enter' when you are finished entering the...
Sunday, June 16, 2013
How to Make Excel 2003 the Default
1. Click 'Start' and type 'regedit' in the Windows search box. Click 'regedit.exe' from the list of files that appears.2. Locate the 'HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options' key and right-click on the 'Options' folder. Click 'New' and 'DWORD Value' and enter 'NoReReg' for the Dword Value. Right-click on the 'NoReReg' value that you created and click 'Modify.' Type '1' in the 'Value Date' box and click 'OK.'3. Open Excel 2003 and select 'Detect and Repair' from the 'Help' menu. Click 'Start' and click 'OK' when the process finish...
How to Delete Cells in Microsoft Excel
1. Select the cell or range of cells you want to delete. To select multiple cells, click in the first cell and drag down or over to the last cell.2. Go to the 'Edit' menu and choose 'Delete.' A dialog box pops up.3. Decide how you want your data moved to fill the space of the deleted cells. Choose 'Shift cells left' to have the data in the rows with the deleted cells slide over. Choose 'Shift cells up' to have the data in the columns with the deleted cells move up. All formulas will adjust accordingly.4. Delete an entire row or column in Excel by choosing 'Entire row' or 'Entire column.'...
How to Combine a Graph
1. Open the Excel Program.2. Click the 'File' tab on the command ribbon. A list of commands appears.3. Click 'Open.' Select the workbook to open.4. Click the 'Insert' tab on the command ribbon.5. Click and drag on the categories and data cells for the chart.6. Click the arrow next to the chart style in the 'Chart' group.7. Click to select the preferred chart type, for example, '2-D Column.' The data converts to an embedded chart. The 'Chart Tools' ribbon appears with three tabs: 'Design,' 'Layout' and 'Format.'8. Click the 'Design' tab on the 'Chart Tools' ribbon.9. Click one...
Saturday, June 15, 2013
How to Create a Multiple Stacked Chart in Excel 2003
1. Open your Microsoft Excel spreadsheet filled with your data sets.2. Click your cursor on the 'A1' cell. Hit the 'Control' ('Ctrl') button and then press the 'A' key without letting go of the 'Control' button. You will see the cells where you have typed your data become highlighted. Keep in mind that you need at least two sets of data to create a stacked column chart.3. Click 'Insert' on your toolbar.4. Click Column. Select one of the 'stacked' column styles. You can choose, for example, a cylindrical stacked column or a conical stacked column. Excel will turn your data into a chart,...
How to Create a Combination Chart in MS Excel
1. Open a blank worksheet in Microsoft Excel.2. Create a data table. For instance, enter time values in column A, such as the months of the year. In column B, enter a column heading for your first data series, such as number of items sold, followed by the data values. Enter a second data series in column C, such as average price, with each data value lining up with a value in column A.3. Highlight all of the data you want to plot in a chart, including both data series.4. Click the 'Insert' tab. In the 'Charts' group, select the chart type you want to use for the first data series. For...
How to Make a Line Graph in Microsoft Excel
1. Arrange the data in either rows or columns. Excel makes the decision as to how to best graph the line based on the data input you provide. You need at least two sets of data to create the axes for your chart. For example, build a line graph using one row or column that provides time periods, such as months or quarters, and the other row or column listing gross sales.2. Select the data in the rows or columns to include in the line chart. Click and drag your mouse across the data in the Excel spreadsheet to include it.3. Click the Insert tab and review the available types of Chart. Select...
How to Delete a Macro in Excel
1. Start Microsoft Excel 2007, and open a spreadsheet from your files that contains at least one macro that you want to delete.2. Select the 'Developer' tab from the top of the Excel screen. The 'Developer' ribbon will be displayed just under the tab.3. Find the 'Code' group in the 'Developer' ribbon and click the 'Macros' button. The 'Macro' dialog box will open onto your Excel screen.4. Choose the name of the macro you want to delete from the list that appears in the 'Macro' dialog box. The macro name will be highlighted in black once it is selected.5. Click the 'Delete' button on...
Friday, June 14, 2013
How Do I Exit From the Header in Office 2007 Windows Vista?
1. Look at the top of your Word program window and locate the text 'Header and Footer Tools.'2. Under 'Header and Footer Tools,' click 'Design.' The 'Design button will be immediately below the words 'Header and Footer Tools.'3. Click the red 'X' on the far right side of the Design menu that says 'Close Header and Footer,' under ...
How to Make a Second Line in One Cell in MS Office Excel on Mac
1. Position your cursor inside the cell at the exact place you want to create a new line, such as at the end of the first line.2. Hold down the 'Option' and 'Command' keys on your keyboard.3. Press 'Enter.' Release the 'Option' and 'Command' keys. You now have a new li...
How to Calculate a Year
1. Click on a blank cell where you want to enter your formula calculation and display the year-to-date average.2. Begin your formula calculation by clicking the 'Average' function. You can find this formula in one of several places in different versions of Excel. In Excel 2010, it is easily accessible on the 'Auto Sum' menu, available on both the 'Home' tab and the 'Formulas' tab. Or you can always manually type in '=AVERAGE().'3. Select the cells you want to use in the average. If they are all in the same row or column, click and drag your cursor across all of the cells you want. If they...
How to Tab Over in Excel 2003
1. Launch Microsoft Excel 2003.2. Click 'Tools' at the top of the window.3. Click 'Options.'4. Click the 'Transitions' tab at the top of the window.5. Click the box to the left of 'Transition Navigation Keys' to remove the check mark, and then click 'O...
How to Change the Display of Axes in Excel
1. Start Microsoft Excel 2007 and open an existing workbook that contains a chart that you would like to change the display of the axes.2. Click the chart that you want to change the display of the axes so it is selected. The chart will have a light blue border surrounding it, indicating that it is selected.3. Choose the 'Axes' button in the 'Axes' section of the 'Layout' ribbon. A drop-down menu will appear.4. Point to 'Primary Horizontal Axis' to view the options for changing the display of the primary horizontal axes. The display options for your primary horizontal axis will be displayed...
How to Import a Web Page to Excel 2007
Import Data from Web Page1. Open both your Internet browser and Microsoft Excel 2007 program. Go to the web page that you want to import into Excel.2. Go the Data tab on the user interface in Excel. In the 'Get External Data' command set, click 'From Web.' A 'New Web Query' box will appear on the screen.3. Type in the web page that you want to import into Excel, if it does not automatically appear in the 'New Web Query' box. Select the 'Import' button. Excel will then give you the option to select the cell in which you want the web page information to be placed.4. Select either Existing...
Thursday, June 13, 2013
How to Create a Visio Network Diagram From Excel Data
1. Start Visio and click on the 'File' tab. Click 'New' in the left pane and select 'Network.' Choose 'Detailed Network Diagram' and click 'Create.'2. Drag a ring network shape or Ethernet shape from the 'Network and Peripherals' group onto the page. Drag the appropriate devices from the 'Computers and Monitors' or 'Network and Peripherals' section onto the page.3. Connect the device shapes to the network shape. Click on the network or Ethernet shape and hover the mouse pointer over the yellow, diamond-shaped control handle. When the pointer changes to a four-way arrow, drag toward the first...
How to Open XLSM, XLSX, XLSB, XLTX, XLTM and XLAM Files in Excel 2003 and 2002
1. Go to the Microsoft Download Center (link in Resources) and select 'Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint File Formats,' located under the 'Popular downloads' heading. Click the 'Download' button on the right side of the ensuing page.2. Click 'Run' if you are using Internet Explorer; click 'Open' if you are using Google Chrome; click 'Save File,' then double-click the downloaded file if you are using Mozilla Firefox.3. Click 'Yes' if you are prompted by the User Account Control window. Read the license terms and select the 'Click Here to Accept the Microsoft...
How to Turn Excel Cells Into Mailing Labels
1. Open Excel 2010 and click the 'File' tab. Click 'Open.' Browse the files and locate a workbook. Click the workbook and the 'Open' button. The workbook will open.2. Review the workbook and make sure the data that will be used in the mailing labels contains column headers. Click the 'Save' icon on the Quick Access Toolbar.3. Open Word 2010 and click the 'Mailings' tab. Click the 'Start Mail Merge' button. A drop down list appears. Select 'Labels.' The Labels Option dialog box appears. Select the 'Label Vendor' drop down list and select the type of labels you are creating. Select the label...
Wednesday, June 12, 2013
How to Move a Chart in Excel to Another Page
1. Launch Microsoft Excel 2010.2. Click the 'File' tab at the top-left corner of the window, and then click 'Open.'3. Browse to the file containing the chart that you want to move, and then double-click the file to open it.4. Click the chart to select it. This will add three tabs to the top of the window in a new 'Chart Tools' section.5. Click the 'Design' tab in the 'Chart Tools' section.6. Click the 'Move Chart' button in the 'Location' section of the ribbon at the top of the window.7. Check the 'New Sheet' option, and then click 'OK.' The chart will be moved to a new tab called...
How to Create an XML Map
1. Click the 'developer' tab in Microsoft Excel or if it is not available click the Microsoft Office button. Next click on Excel options.2. Locate the 'popular' category in Excel. Now you will click the 'show developer tab.'3. Click 'source' on the developer tab in the group labeled XML.4. Locate XML maps and click on it. Now click 'add.'5. Find the 'lookin' list and click on the drive, list and folders that you want to open. Now click 'open' for whatever you want.6. Click 'OK' and the XML map is creat...
How to Make a Histogram in Excel 2010
1. Download the Excel 2010 Analysis ToolPak. Click 'File,' and then 'Options.' From the Add-Ins category, select 'Excel Add-Ins,' which display in the Manage box. Click 'Go.' Check the 'Analysis ToolPak' box from the list of add-ins and click 'OK.'2. Choose an appropriate bin size for your data set. The bin size refers to the range of values that fall into a specific class. For example, if your data set is ages of people in the United States, set your bin size to 10 years. This makes the bins correspond to ages 0-10, 11-20, 21-30 and so on, with a maximum bin of 101-110. Select a bin width...
How to Convert an Excel 2007 File to Excel 2003
1. Open the Microsoft Excel 2007 file you want to convert; you can do this by clicking the Microsoft Office button in the upper left-hand corner (it looks like a circle with the Microsoft Office logo on the inside) and then 'Open.' From the pop-up window, select the location of your Excel 2007 file. You can recognize 2007 files because they have a file extension of XLSX.2. Click on the Microsoft Office button again; this time, select the right-facing arrow next to the 'Save As' option. A list of possible formats will appear; from this list, choose 'Excel 97-2003.'3. Verify that the name...
How Do I Use Dragon SpeakingNaturally 10 With Microsoft Excel?
1. Open Microsoft Excel.2. Click the 'Office' button in Microsoft Excel. It is in the left, top corner of the program.3. Click 'Excel Options' from the drop-down menu.4. Click 'Add-Ins' from the menu along the left navigation pane in 'Excel Options' dialog box.5. Click the drop-down menu next to 'Manage' and select 'Disabled Items.'6. Locate and click on 'dgnexcel.dll' from the list of disabled items.7. Click 'Close' and 'O...
Tuesday, June 11, 2013
How to Search a Cell Range for a Match in Excel VBA
1. Open the Visual Basic Editor (VBE). Click the 'Developer' tab in Excel and then click 'Visual Basic.'2. Click 'Insert' and then click 'Module.'3. Cut and paste the following code into the blank window:Sub Find_First()Dim FindString As StringDim Rng As RangeFindString = InputBox('Enter a Search value')If Trim(FindString) '' ThenWith Sheets('Sheet1').Range('A1:A20')Set Rng = .Find(What:=FindString, _After:=.Cells(.Cells.Count), _LookIn:=xlValues, _LookAt:=xlWhole, _SearchOrder:=xlByRows, _SearchDirection:=xlNext, _MatchCase:=False)If Not Rng Is Nothing ThenApplication.Goto Rng, TrueElseMsgBox...
How to Move Rows in Excel
1. Select the row heading (A, B, C and so forth) that you wish to move and highlight it. You can also select several rows by holding down your left mouse button and sliding it across the rows which you would like to select, if you want to move more than one row at a time.2. Keep your mouse placed on the highlighted row(s) and right click your mouse button. This will bring up a pop up menu with several options to choose from.3. Choose 'Cut' from the menu that pops up. This will make the row you want to move disappear, but your computer will store it in its temporary memory. As long as you...
How to Put a Combo Box in an XLS Cell
1. Open the Excel document to which you want to add a combo box.2. Click on 'File' in the top-left corner of the Excel window. Choose 'Options' from the list that appears.3. Select 'Customize Ribbon' on the left side of the new window. Place a check mark next to 'Developer' on the list located to the far right side of the window. Click 'OK.'4. Click the 'Developer' tab at the top of the screen. Select 'Insert' and choose 'Combo Box (Form Control),' which will be the second option from the left in the top row. Select a cell where you want to enter the combo box.5. Right-click the combo...
Subscribe to:
Posts (Atom)