1. Launch Excel 2007. Click the 'Microsoft Office' menu button in the upper left corner of the window and select 'Open.' Locate the file with the properties you wish to remove and then click 'Open.'2. Click the 'Microsoft Office' button again, click 'Prepare' and then select 'Properties.' Excel then displays your document's properties in its 'Document Information Panel.' Use your mouse to highlight any field that has text, such as the 'Author,' 'Title,' 'Subject' and 'Category' fields. Press your keyboard's 'Backspace' key to delete the information for that specific property.3. Click the...
Browse » Home » All posts
Monday, January 28, 2013
How to Format a Chart Fill in Excel
1. Start Microsoft Excel 2007 and open a workbook from your files that contains a chart to which you would like to format one of the fills. You can alternatively create a new chart from data in an existing workbook.2. Select the item in the chart you would like to apply a fill to by clicking on it. When the item is selected, it will be surrounded by white round sizing handles.3. Right-click on the selected item, and click on 'Format (Item Selected).' The name in parenthesis will be of the item you selected to fill.4. Choose 'Fill' from the list of format categories on the left side of...
How to Copy From One Worksheet Paste to Another Using VBA
1. Click the 'Developer' tab and then click 'Visual Basic' to open the Visual Basic Editor (VBE) with which you can create VBA.2. Click 'Insert' and then click 'Module' to open a blank module window.3. Cut and paste the following code into the module window:Sub Copy_Data()Application.ScreenUpdating = FalseWorksheets('Sheet1').Range('A1:A10').Value = Worksheets('Sheet2').Range('B1:B10').ValueApplication.ScreenUpdating = TrueEnd Sub4. Tailor the code to your specific needs; as written, the code copies the data in cells A1 to A10 in worksheet 1 to cells B1 to B10 in worksheet 2. For example,...
Sunday, January 27, 2013
How to Copy an Excel Chart to Word
1. Start Microsoft Excel 2007 and open a workbook from your files that contains a chart you want to copy into Word 2007.2. Click to select the chart. The chart should now be surrounded by a light blue border. Right-click on the chart and choose 'Copy' from the shortcut menu.3. Start Microsoft Word 2007 and open an existing document that you would like to copy the Excel chart into or create a new, blank document for the chart.4. Point and click to place the insertion point in the place in the document where you want to insert the Excel chart.5. Choose the 'Home' tab, if necessary, and...
How to Set Auto Correct Options in Microsoft Excel 2003
1. Open the auto correct options properties box. To open the auto correct options properties box you will need to scroll to the “Tools” tab on the command bar and select “AutoCorrect Options.”2. Set the “Auto Correct” tab options. Under this tab you can check the boxes for the features that you would like Auto Correct to perform. You can check or uncheck the following features: correct to initial capitols, capitalize the first letter of sentences, capitalize names of days, correct accidental usage of CAPS keys, and replace text as you type. You can also add commonly mistyped words into the...
How to View VBA Code in Excel 2007
1. Open the workbook in Excel that you would like to view VBA code for. VBA code is workbook specific, meaning it is only attached to one workbook. In order to view the code for a specific workbook, you must have that workbook open.2. Click on the 'Developer' tab, then click on 'View Code.'3. Click on a module in the left sidebar. This will open the module and display the VBA in a box on the right side of your scre...
Saturday, January 26, 2013
How to Learn Microsoft Excel Online
1. Visit the official Microsoft Excel training site for Excel 2007 and Excel 2010 (see Reference section). The site offers a wide array of topics from creating your first workbook to creating macros to automate some of the features in the program. If you're new to Excel, there are a variety of basic topics plus step-by-step video tutorials. The best way to find what you are looking for help on is to use the search box on the website to type in a help topic, like 'Creating charts in Excel 2007.'2. Click on the 'Free Training Tutorial' link in the Reference section. This free website walks you...
How to Use an Excel Rand
1. Open Microsoft Excel and create a blank spreadsheet, if one doesn't open automatically.2. Double-click in the cell that you want to create a random number in.3. Type '=Rand()*(b-a) a' (without quotes) to create a random number between and including the smallest number 'a,' and the largest number 'b.' For instance, if you want to create a cell that displays a random number between 0 and 100 every time you recalculate the spreadsheet, you'd type '=Rand()*(100-0) 0.' This number can then be used in other calculations throughout the sheet, in order to test how certain functions respond to...
Friday, January 25, 2013
How to Make a Word Search With 2007 Microsoft Excel
1. Change the page orientation to landscape. Click on 'Page Layout,' then 'Orientation,' then 'Landscape.'2. Add a header and footer. The header is for the title and the footer is for the word list. Click on 'Insert' and then click on 'Header and Footer.'3. Add a title for your word search. For example, 'States.'4. Highlight cells A1 to N15 by left clicking on cell A1, then dragging the mouse to cell N15.5. Click on the 'Home' tab, then click on 'Format,' then 'Column Width.' Type '0.25' into the text box and then press 'OK.'6. Add a border by right clicking on the cell, then clicking...
How to: Find and Replace in Excel 2007
1. Open Excel 2007. Open the spreadsheet you want to edit.2. Press the 'Ctrl' and 'H' keys simultaneously to open the 'Find and Replace' dialog box. Click the 'Find' tab.3. Type the string of characters you want Excel to find into the 'Find What' input box.4. Click 'Find Next' to find the next instance of the character string, or click 'Find All' to find all instances of the string.5. Click the 'Replace' tab. Type the characters you want to find into the 'Find What' input box.6. Type the replacement text into the 'Replace With' input box.7. Click either 'Replace Next' or 'Replace...
How to Use Microsoft Excel 2003 With Vb.Net
1. Open VB.Net. Click 'File,' 'Open' and browse to your VB.Net project. Double-click the project file to open it.2. Click the 'Project' link from the 'Tools' menu. Click 'References.' Check the box next to 'Microsoft Excel Object Library.' Click 'OK.'3. Click 'Caption.' In the 'General Declaration' window type the following code:Option ExplicitPrivate appExcel As Excel.ApplicationPrivate wBook As WorkbookPrivate mySheet As WorksheetReplace mySheet with the name of your own Excel spreadsheet.4. Click 'File,' 'Save' to confirm the changes you have made to Exc...
Thursday, January 24, 2013
How to Reduce the Size of Excel Files
1. Remove unnecessary graphics and fonts from the Excel file. Simple report data doesn't need a lot of excess formatting to make it attractive. If you need to keep different fonts in your file, reduce some of the font sizes you originally used.2. Reduce the number of pivot tables you allow in your data analysis. Run your pivot table wizard when dealing with involved calculations. When given options to format the file, choose those that allow the data to refresh instead of adding a new table.3. Input your data, close the file and save as an Excel (XLS format) file and as an HTML (XML format)...
How to Display Fractions in Excel 2003
1. Open Excel by going to the 'Start' menu, pointing to 'Programs' or 'All Programs', and clicking on 'Microsoft Excel' in the 'Programs' list. Or you can open Excel by double-clicking a shortcut icon on your desktop or task bar.2. Open a blank or existing worksheet. Select the cells you will want to use to enter fractions by clicking on one of the outer cells in that range, holding down the left mouse button and dragging your mouse across the range of cells that you want to select. If you only want to format a single cell, simply click on that cell.3. Click on 'Format' in the toolbar. Click...
How to Capitalize the First Letter of Names in Excel 2007
1. Right-click on the column header that sits atop the column of names you want to capitalize. Choose 'Insert' from the menu that appears. This creates a new blank column to the left of the names.2. Select the cell in the new column that is directly to the left of the first name you want to capitalize.3. Enter this formula into the cell: '=Proper(XX)' without the quote marks, where the 'XX' is the column letter, followed by the row number of the cell directly to the right of the one you are entering the formula into. Press 'Enter' to place the formula into the cell. The capitalized name...
How to Convert From Excel 2007
1. Open the Excel file you'd like to convert. Do this by clicking it twice. This will open up the contents of the file in Microsoft Excel 2007.2. Click the 'Office' logo button in Excel's top left corner.3. Click 'Save As.'4. Select the format you'd like to convert your file into. Each option that you have will be laid out on screen. The different file formats will be accompanied by a brief description as well as what programs they can be used with, so choose a format based on your own needs.Formats available include the Excel 97-2003 workbook, which can be opened with earlier versions...
Subscribe to:
Posts (Atom)