1. Click on the 'Alt' and 'F11' keys from within any Excel worksheet or workbook to open the Visual Basic Editor (VBE). You can also access the VBE by clicking on the 'Developer' tab and then clicking on 'Visual Basic.'2. Click on the 'Insert' tab, and then click on 'Module' to open a blank window for your program.3. Type the word 'Sub' (for subroutine) or 'Function' into the window, followed by the name of your program. For example, 'Sub italics()' is the first line of a subroutine called 'Italics.' If the VBA returns a result such as a number, it's a function. If it performs a task without...
Browse » Home » All posts
Tuesday, July 26, 2011
Monday, July 25, 2011
How to Merge Cells on an Excel Spreadsheet
1. Click the 'Home' tab on the command ribbon.2. Click and drag to select two or more adjacent cells. A black border surrounds the range of cells. The highlighted cells display one white cell in the upper-left corner and one or more blue cells. Only this white cell retains its data.3. Click the down-arrow in the 'Merge Center' command in the 'Alignment' group. The three merge options include 'Merge Center,' 'Merge Across' and 'Merge Cells.'4. Click the preferred merge option. The cells become one larger ce...
How to Create a Table in Excel 2003
1. Open Excel on your computer, and start a new spreadsheet.2. Enter your data into the spreadsheet. If the table is to be row-oriented, enter the desired calculation formulas to the left and just below the data. If the table is column-oriented, enter the calculation formulas above the first value and in the column immediately to the right of the data. Assistance for understanding formulas is available in the Excel 'Help' section.3. Go to the 'Data' tab, and select 'Table.'4. Enter the cell number where the calculated data should appear in the 'Column input cell' field or 'Row input cell'...
How to Remove Mass Links in Excel 2007
1. Open the Microsoft Excel 2007 file on your computer that contains the links you want to remove.2. Enter '1' into a blank cell within your worksheet. Right-click on the cell with your mouse and then click on the 'Copy' option.3. Hold down the 'CTRL' key on your keyboard and select each link in your worksheet that you want to remove.4. Click the 'Home' tab. Click the arrow below the 'Paste' field in the 'Clipboard' group. Click the 'Paste Special' option.5. Click the 'Multiply' option and then click the 'OK' button. Click the 'Home' tab again and then click the 'Cell Styles' option...
Sunday, July 24, 2011
How do I Add the Microsoft Excel 11.0 Object Library?
1. Insert your Office 2003 disc. The Office 2003 Setup window will open.2. Select 'Add or Remove Features.' Click 'Next.'3. Check the 'Choose advanced customization of applications' box. Click 'Next.'4. Click the plus sign next to 'Microsoft Office Excel.' This expands that section of the applications and tools list.5. Click the down arrow beside '.NET Programmability Support.' Click 'Run from My Computer.' Click the 'Update' butt...
How to Remove Grid Lines
For Excel 20031. Select the cells in the spreadsheet from which you want to remove the grid lines. Do this by left-clicking on the mouse and holding it down as you move the cursor over the cells you want to select.2. Click on the 'Format' menu at top of page.3. Click 'Cells.'4. Click on the 'Patterns' tab.5. Click on the background color of the spreadsheet. In most cases, the color is white.6. Click on the 'Border' tab.7. Click on the arrow in the 'Colors' box. Click on the color of the gridlines. In most cases, the color is 25% gray.8. Click 'Outline.'9. Click on 'OK.' The...
How to Determine if a File Exists in Excel VBA
1. Copy the following code:Option ExplicitFunction FileOrDirExists(PathName As String) As Boolean'Macro Purpose: Function returns TRUE if the specified file' or folder exists, false if not.'PathName : Supports Windows mapped drives or UNC' : Supports Macintosh paths'File usage : Provide full file path and extension'Folder usage : Provide full folder path' Accepts with/without trailing '\' (Windows)' Accepts with/without trailing ':' (Macintosh)Dim iTemp As Integer'Ignore errors to allow for error evaluationOn Error Resume NextiTemp...
How to Share Excel Macros
1. Write the macro to be shared in an empty spreadsheet. Click the 'View' tab on the ribbon menu. If you are going to record the macro, click the small arrow at the bottom of the 'Macros' button and then select 'Record Macro...' from the drop-down menu. If you elect to write the macro using Visual Basic for Applications, select 'View Macros...' from the drop-down menu. Provide a macro name and click 'Create' on the 'Macro' dialog.2. Save the spreadsheet as an 'Excel Macro-Enabled Workbook' file. If the macros are saved in other types of Excel files, they may not be visible due to internal...
How to Link a File to MS Excel
1. Open the saved Excel file.2. Click on the cell or object to insert the file link.3. Click on the 'Insert' tab on the command Ribbon.4. Click on the 'Hyperlink' button on the 'Links' group. A window will show 'Insert Hyperlink.'5. Click on the file name from the list of files in the box.6. Click 'OK.' The colored hyperlink will show on the Excel worksheet.7. Save this Excel fi...
How to Summarize Data in Excel
1. Use the Subtotals method. Choose one customer name by selecting a cell in column A. Click the 'AZ' sort button--you can find this on the standard toolbar. Next, select 'Data' and then 'Subtotals.' The Subtotals dialog box should appear. Make sure you've checked off 'OldSales,' 'NewSales' and 'Total.' Click 'OK' to see the summary data in bold on your spreadsheet. Press the '2' in the top left corner of your spreadsheet to see only the summary data.2. Try the Consolidate method. Select a blank cell to the right of your data. Click 'Data' and 'Consolidate.' In the 'Reference' section in the...
How to Make a Pie Chart Using Microsoft Office 2003
1. Click 'Start,' 'All Programs' and then click 'Microsoft Office Word 2003.'2. Click 'File' from the top menu and then click 'Open.' Click the file to which you want to add a pie chart and click 'Open.'3. Click 'Insert' from the top menu and click 'Object' from the drop-down menu.4. Click 'Create New.'5. Click 'Microsoft Graph Chart' from the 'Object Type' box and click 'OK.'6. Click inside a cell on the datasheet window and enter the text or numbers that you want to display in the pie chart. The default chart type is a bar graph.7. Double-click the chart. A box appears around the...
How to Display a Count of Cells on the Bottom of the Window in Excel
1. Open Microsoft Excel and load the spreadsheet you want to edit. This can be an existing file, or you can just use the default new page to test the functions.2. Enter data in the first column. Use the following data to populate the 'A' column on the spreadsheet:Price2.003.004.003. Use the Count or CountA function in the bottom field. The following code is an example of how to use the Count function:=count(a1:a4)To use the CountA function, enter the following code instead:=countA(a1:a4)The equal sign is used to denote a formula. This is prefixed in all cells that contain formulas. The two...
How to Turn Off Filter Arrows in Microsoft Excel 2007
1. Open the Excel sheet that has the filtering option turned on.2. Click the 'Data' tab on the Microsoft Ribbon.3. Click the highlighted 'Filter' button in the 'Sort Filter' section to turn off all filter arrows in the spreadshe...
Saturday, July 23, 2011
How to Sum the Span of Cells of Microsoft Excel 2003
1. Create the numbers in the cells that you wish to sum the span of. To sum the span of cells, you will first need to create a series of numbers that you wish to be summed. You can create lists vertically or horizontally depending on your preference.2. Select the cells that you wish to sum by highlighting them. To highlight the cells that you wish to sum the span of, simply left-click on the first cell and hold the mouse button in as you drag the cursor over the other cells that you wish to sum. Release the mouse button once you have highlighted the desired cells, and they will stay highlighted.3....
How to Enter a Comment in Excel 2007
1. Open an Excel 2007 spreadsheet.2. Use one of the following methods to bring up a comment box: Right-click the cell and select 'Insert Comment' from the list; right-click the cell and press 'Shift' 'M'; use the keyboard shortcut 'Shift' 'F2'; or select the cell, click the 'Review' tab on the ribbon and select 'New Comment' from the 'Comments' group.3. Enter your text into the comment box. Highlight the text and add any formatting options including bold, italics, color, font type and size. Click outside the 'Comments' box to close ...
Subscribe to:
Posts (Atom)