How to Set 'Do Not Print Cell' in Excel

Hiding blocks of cells
1. Launch Microsoft Excel by pressing your 'Start' button and selecting the application from your list of available programs, or click on the icon if you have one saved on your desktop. Open an existing file that contains data rather than a blank worksheet. Create a backup file if necessary to protect yourself from inadvertently deleting data on the spreadsheet.
2. Highlight a row, column or specific cells in your spreadsheet. To select an entire row or column, point to the row or column headings (numbers for rows and letters for columns) until the regular mouse pointer turns into a right arrow (for row headings) or a down arrow (for column headings). Click the left mouse button to select the row or column. To select a block of cells, go to the first cell you want to highlight, click the left mouse button and drag the cursor until the desired block is selected. Then release the left mouse button.
3. Right-click your selected row, column or block of cells. Select 'Hide' from the pop-up menu that appears. If the pop-up menu does not appear, try holding the Ctrl key and right-clicking on the selection. Once you select the 'Hide' option, you will see that the selection is no longer visible on screen.
4. Print the worksheet. Select 'File' from the menu bar or press Ctrl P to print your worksheet. Verify that the selected row, column or block of text you designed to be hidden does not appear on the printed worksheet.
Hiding individual and non-adjacent cells
5. Left-click the cell you wish to hide. To select multiple non-adjacent cells, hold down the Ctrl key and left-click the desired cells.
6. Right-click your selection and select 'Format' from the pop-up menu. In the 'number' category, select 'Custom' and manually type in ';;;' without the quotation marks in the 'Type' box. Then click 'Okay.' You will notice that the cell(s) or block of cells are now hidden.
7. Print the worksheet. Select 'File' from the menu bar or press Ctrl P to print your worksheet. Verify that the selected cells you designed to be hidden do not appear on the printed worksheet.

Read more ►

How to Create Maps in Excel 2007

1. Create your data in an Excel spreadsheet. For example, if you want to map sales figures by zip code, you could put the sales data in one column and zip codes in another. In a third column, write the name of the city that corresponds with the zip code. For example:
$50,000_32206_Jacksonville, FL
$43,000_12801_Glen's Falls, NY
$19,000_80537_Loveland, CO
2. Select the data that you would like to include in the map. Highlight the data by holding down the left mouse key while you mouse over the area. When the data is selected, hit CTRL C to copy the data.
3. Open a blank map in MapPoint. Paste the data you copied from Excel into MapPoint by pressing CTRL V. This will open the Data Import Wizard.
4. Choose the type of map you would like to create and which columns you want to show. Click Finish.
5. Click Copy Map (located on the MapPoint Edit menu). Return to Excel and press CTRL V to paste the map into your spreadsheet.

Read more ►

How to Remove File Properties in Excel 2007

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 'Document Properties' button above the property fields and select 'Advanced Properties' if you want to view additional file properties. Click the 'Summary' tab and use your mouse to highlight information in any of the listed fields. Press your 'Backspace' key to delete information in the field and then click 'OK' when you finish clearing the fields.
4. Click the 'Microsoft Office' button and select 'Save' to save your document with its removed file properties.

Read more ►

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 the 'Format' dialog box. The settings for the fill attribute will be displayed on the right side of the dialog box.
5. Click on a radio button to add a 'Solid fill,' 'Gradient fill' or 'Picture or texture fill,' depending on what type of fill you would like to add to the selected object. Once you have made your choice, more settings will be displayed at the bottom of the 'Format' dialog box.
6. Set the settings that you want to apply to your fill using the options that have appeared. The solid fill will ask you to specify the color and transparency of fill. The gradient fill will want to know the type of gradient, angle, stop positions and transparency. If you have chosen a picture or texture fill you will specify the type of texture or picture, stretch options and transparency.
7. Use the 'Close' button when you are finished setting your options. The 'Format' dialog box will close and you will return to your chart with your newly filled item.

Read more ►

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 Sub
4. 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, if you wanted to copy data from cells C1 to C100 in sheet 4 to cells D1 to D100 in sheet 5, you would rewrite the third line of the code to read:Worksheets('Sheet4').Range('C1:C100').Value = Worksheets('Sheet5').Range('D1:D100').Value
5. Press 'F5' to run the routine.

Read more ►

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 click the 'Paste' button from the 'Clipboard' group to display a drop-down list of options. Choose 'Paste Special' to open the 'Paste Special' dialog box.
6. Select 'Microsoft Office Excel Worksheet Object' from the 'As' list to paste the chart that will continue to be updated if you change the original chart in Excel. Choose 'Microsoft Office Graphic Object' from the 'As' list to paste the chart as it is without leaving it to be updated in Excel in the future.
7. Use the 'OK' button to close the 'Paste Special' dialog box and insert the copied Excel chart into Word.

Read more ►

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 replace text fields, which will tell the program to replace x-word with the proper word.
3. Set the “Auto Format As You Write” tab options. You can check two boxes under this tab: internet and network paths with hyperlinks (which will automatically add links to URLs you type) and include new rows and columns in list (which will add rows and columns as you type).
4. Set the “Smart Tags” tab options. Under this tab you can set the smart tag options you want by checking the corresponding boxes: label date with smart tags (will enable this feature), date (will add proper date format to all dates entered), financial symbol (will add desired financial symbol to all currency entered) and person name (will look up names and email addresses from outlook and implement when recognized).
5. Implement the changes. To implement the changes click on the “Okay” button.

Read more ►

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 screen.

Read more ►

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 through all the Excel basics you need and includes step-by-step instructions and video tutorials. The site is broken up into easy-to-navigate subject areas like Format Cells or Edit Cells. The site offers you a wide array of basic subject videos--there are several videos on each basic topic area--and delves into more complicated formulas and functions with clear instructions.
3. Navigate to Baycon Group's Microsoft Excel 2007 tutorial (see Reference section). The on-screen tutorial is grouped by topic in an easy-to-follow list format. The tutorial starts with a description of every aspect of the Excel window. The tutorial was created with the novice computer user in mind. If you want the basics but don't know where to start, then this could be the tutorial for you.

Read more ►

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 randomly generated values.

Read more ►

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 on 'Format Cells.' Click on the 'Border' tab, then click on a border icon. Click on 'OK.'
7. Enter words into the cells, one letter at a time. In the above example, you might enter 'T' into cell A1, 'E' into cell A2, 'X' into cell A3, 'A' into cell A4, and 'S' into cell A5. Continue typing in words until the word search is complete.
8. Fill in any blank spaces with random letters of the alphabet.
9. Click on the footer, then type the word list for the entries you made into the word search.

Read more ►

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 All' to replace the characters one at a time or en masse, respectively.

Read more ►

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 Excel.

Read more ►

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) file. To do this, choose 'XML Data' in the 'Save as type' drop down box. Change the name of your document as well, so you can tell the difference between the two files.
4. Open the XML file and save it back into the regular XLS file to create a smaller file than the original. Again, rename this file, as well as changing its type. This act removes odd programming left from past calculations since the last 'save.'
5. Check into file compression software such as OzGrid. These products exist because you cannot open a file once it gets too big. Compress the XLS data by compelling the program to recalculate the cells used for your file.

Read more ►

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 'Cells'. The 'Format Cellsw' dialog box will open. Make sure you are on the 'Number' tab.
4. Click 'Fraction' in the 'Category' list. Under 'Type', choose how you want your fractions displayed. You can choose up to one, up to two or up to three digits, or take it even further and choose 'As Halves', 'As Quarters' and so forth, which will round your fraction the the nearest, half, quarter or whatever you choose.
5. Click 'OK'. When you enter your data into the cells you formatted, your fractions will now appear just as you defined.

Read more ►