Monday, January 28, 2013

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 ►

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 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 ►

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 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 ►

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 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 ►

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) 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 ►

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 appears in the cell.
4. Select the cell that you've just entered the formula into. Move your mouse to the bottom-right corner of the cell, where the mouse pointer turns into a plus sign. Click and hold the mouse button, then drag the mouse down the column to the cell that contains the last name you want to capitalize. Release the mouse button and all the capitalized names fill in the empty column.
5. Right-click anywhere in the column that holds the formulas. Choose 'Copy' from the pop-up menu.
6. Select the first cell of the original list of names. Right-click the cell and move your mouse over 'Paste Special.' Select 'Values' from the list of options that appear. All of your original names are now capitalized.
7. Right-click on the column letter above the column that contains the PROPER formulas. Select 'Delete' from the menu.
Read more ►

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 of Microsoft Excel, the OpenDocument Spreadsheet, which can be opened with the program Open Office; the PDF format, which can be opened with Adobe Reader; and the XPS format, which can be opened with Microsoft Works.
5. Click 'Save As' to convert your Microsoft Excel 2007 file into the format you've chosen.
Read more ►

How to Save a Worksheet as HTML in Excel 2003


1. Log on to your computer and open your Excel database. 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 'File'. Select 'Save as Web Page'. Choose the folder in which you want to save your document.
3. Type your file name for your worksheet web page. Be descriptive, but concise so it is easy to identify the information in your file.
4. Choose to save your 'Active Sheet' or the entire file. Click 'Save'. Your document is now ready for the web.
Read more ►

Wednesday, January 23, 2013

How to Animate a Cell in Excel 2007


Download and Install the 3-D Animation Engine
1. Download the 3-D Animation Engine for Excel---you cannot animate your cells without it (see References).
2. Select your correct Internet connection from the drop-down menu next to 'Estimated Download Time:' and click the 'Download' button in the upper left-hand corner of the Quick Details information box.
3. Save the download file to your computer's desktop and double-click on the saved file to activate the installation.
4. Install the 3-D Animation Engine, following the prompts provided by the installation wizard.
Animate
5. Open the Excel Binary Workbook that was downloaded when you installed the 3-D Animation Engine.
6. Insert the object you wish to animate by clicking on the 'Insert' tab from the Microsoft Office Fluent Ribbon on the Binary Workbook. Select 'Illustrations,' and click 'Shapes.'
7. Pick your shape and click 'Animate!'
8. View the animation by placing a check in the 'Step Run?' check box and clicking 'Animate!' again.
9. Change the shape's direction by clicking 'Reverse' if you wish. You may also change other parameters of the object by using the Parameter Table in the upper left-hand corner of your worksheet.
10. Click 'Export to Light' once you are satisfied with the animation of your shape.
Create Lighting Effects
11. Open the Lights worksheet to apply lighting and shadow effects to your shape. Your object will automatically appear when you open the Lights worksheet.
12. Click 'Shed Light.'
13. Adjust the light's reflection on your object by using the sun controls on the left-hand side of the worksheet.
14. Apply different textures to your object using the controls on the top of your worksheet.
15. Color your object with the color controls, and click on the shadow controls at the bottom of your worksheet to create mysterious shadow effects.
16. Click 'Snap' and name your object when you are finished adjusting the lighting effects.
Generate Visual Basic Code
17. Open the Recorded Tracks worksheet and your newly-named object.
18. Open your Visual Basic Editor by pressing on 'Alt' and 'F11' at the same time.
19. Select the Microsoft Office Button in the upper left-hand corner of your screen and click on 'Excel Options.'
20. Ensure that the 'Show Developer tab in the Ribbon' button is selected from the Popular submenu and click 'OK.'
21. Click on the 'Developer' tab and select 'Module2.'
22. Press 'F5' to run the code after placing your cursor at the beginning of the Immediate window where the Visual Basic code is shown.
23. Copy and paste your Visual Basic code results, after they have run, into the cell in your Excel spreadsheet to run your animated object.
Read more ►

How to Make an Excel Template a Read


Excel 2003
1. Click on 'Tools' in the toolbar, then highlight 'Protection' by hovering over it with your mouse. Select 'Protect sheet' from the menu that appears.
2. Make sure none of the boxes in the list that appears have check marks except the top box that says 'Protect worksheet and locked cells.' Click in the boxes to toggle the check marks on or off.
3. Enter a password to ensure you are the only one who can remove the protection, then write down the password and safe it in a secure location. If you choose not to password-protect your change, other users can remove the workbook protection.
4. Click 'OK' to save your changes and protect the worksheet.
5. Repeat the process for each worksheet within the workbook if it has multiple sheets.
Excel 2007
6. Click on the 'Review' tab from the tool ribbon, then select 'Protect document.'
7. Select 'Restrict formatting and editing' from the available options.
8. Select all options for elements you want to protect, such as formatting, data and sorting.
9. Enter a password if you wish to password-protect the workbook limitations. If you do not enter a password, others can unprotect the workbook through the 'Protect document' menu.
10. Click 'OK' to save your changes and close out of the protection dialog box.
Read more ►

How to Create a Pivot Chart in Excel 2007


1. Open the Excel workbook that has the data you want to use to create a pivot chart.
2. Highlight the data you want to add to the pivot chart.
3. Click the 'Insert' tab and look to the 'Tables' section of the ribbon.
4. Click 'Pivot Table' and select 'Pivot Chart' from the drop-down menu. The 'Pivot Chart' dialog box will open.
5. Select a range of cells to add to the chart if you want to include more data than you have already selected. You can also select data from an external source. If you want to do this, check the box next to 'Use an external data source' and then click 'Choose connection.' Select a data source from the box that opens and click 'Open.'
6. Choose where you want the pivot chart to be placed. You can insert the chart in the worksheet you have open or you can insert it in a new worksheet.
7. Click 'OK.' The pivot chart will be inserted in your Excel spreadsheet.
Read more ►

Tuesday, January 22, 2013

How to Use Excel for Correlation


Measuring Correlation With Excel
1. Enter the data to be analyzed. If you are examining the correlation between two variables, a single variable can represent one column in a spreadsheet. Enter the values of each variable in the cells under the corresponding column.
2. Unlock and install the Data Analysis tool from the Excel add-ins menu. This tool is included in all options of Excel, but must be installed by the user before it can be used. To do this in Excel 2007, click the Microsoft Office help button in the top left corner of an Excel spreadsheet. Then click the button labeled 'Excel Options,' which opens a window with a set of options on the left side. Choose 'Add-Ins' and select 'Analysis ToolPak.' This makes the data analysis tool available for use. In earlier versions of Excel, click the 'Tools' menu and then choose 'Add-ins' and select 'Analysis Tool Pak,' which places the Data Analysis option in your Tools menu for use.
3. Choose the two variables for which you wish to examine the correlation. Selecting the values to analyze in Excel requires you to click on a cell or column and drag your mouse to choose or define the range of values for the two variables under consideration. This means the variables must be adjacent to each other in your Excel spreadsheet.
4. Open the Excel Data Analysis tool (under the Data tab in Excel 2007, in the Tools menu in earlier versions), which opens a window with a set of analysis options. Choose 'Correlation' and click 'OK.' This opens the Excel correlation wizard, which asks you to enter the range of data to be analyzed by clicking a column or cell and dragging. For example, if the two variables you want to analyze are in columns A and B in your spreadsheet, then click and drag across these two columns and down the rows until all values are included. Click 'OK' when you are finished.
5. Examine the value of the correlation coefficient, which Excel will display in a new worksheet. Remember that correlation signifies a relationship between two variables, but does not prove causation.
Read more ►

How to Reset Excel 2003 Keyboard Commands


1. Launch Microsoft Excel 2003. Click 'Tools' and then 'Customize.'
2. Select the 'Commands' tab from the menu.
3. Select 'Rearrange Commands.'
4. Click the command menu you want to reset.
5. Select 'Reset.'
Read more ►

How to Create a Balance Sheet in Microsoft Excel


1. Go online to the official Microsoft Office Template Download Center. In the left column of the page, under the subheading 'Collections,' click 'Finance and accounting.'
2. Select 'Balance Sheets' under the 'Accounting' section in the middle of the page.
3. Browse through the available balance sheet styles and choose the one that best suits the needs of your business.
4. Click the title of your chosen template and click the 'Download' button. Accept the Microsoft service agreement to begin downloading.
5. Open the template in Microsoft Excel. Customize the layout for your business by adjusting the colors, font size and type and text.
6. Enter all of the data about your current and fixed business assets. Enter all of your current and long term business liabilities. Enter any equity or capital your business may have.
Read more ►

How to Remove the Date From a Cell on an Excel Spreadsheet


1. Right-click on the cell.
2. Choose 'Format Cells'.
3. Click on the 'Number' tab. Click on a number format that you would like. For example, choose 'decimal'.
4. Press 'OK'.
Read more ►

Monday, January 21, 2013

How to Create an Excel Formula


1. Start Microsoft Excel and open the file you want to change.
2. Double-click on the cell where you want the total to appear.
3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell.
4. Enter the formula, then press Enter. Follow the steps below for an example.
5. Enter an opening parenthesis character: (.
6. Enter a cell name. For example: =(E2.
7. Press the key.
8. Enter another cell name and a closing parenthesis character: ). For example: =(E2 E3).
9. Enter a minus sign and a third cell name. For example: =(E2 E3)-E4.
10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell.
Read more ►

How to Float a Row on Excel 2007


1. Click the 'View' tab in the Ribbon.
2. Click the 'Freeze Panes' button in the Window group. This opens a drop-down menu. Click 'Freeze Top Row' to freeze the first row at the top of the spreadsheet. All other rows will disappear when you scroll through the spreadsheet, but the first row will stay in place.
3. Select an entire row in your spreadsheet by clicking its number in the left-most column, then click the 'Freeze Panes' button in the Window group. Select 'Freeze Panes' in the drop-down menu. All rows above the selected row will be frozen in place; all others, including the one selected, can be scrolled.
Read more ►

Sunday, January 20, 2013

How to Use Excel for Birthdays


Arrange Your Spreadsheet
1. Create a series of columns in Excel for the information you need to track. Potential column headings include First Name, Last Name, Address and Birthday. Make these headings bold to set them apart from the rest of the spreadsheet.
2. Enter the names, birthdays and other information into the spreadsheet under the corresponding columns. Enter the dates in a format that Excel understands. You can access the format options by right-clicking the cell that contains a date. Once that cell is formatted correctly, you can copy and paste it into the rest of the column. This will eliminate the need for you to format the dates again.
3. Use the 'Sort' function in the 'Data' menu of Excel to sort the data by date. This will rearrange the data on the spreadsheet so that birthdays are listed in chronological order. You can choose to sort data in ascending or descending order. For data listed from January through December, select ascending order.
Apply Conditional Formats
4. Create a conditional format so that only birthdays occurring in the next week or month are highlighted on the spreadsheet. To access the conditional formatting tool in Excel 2010, go to the 'Style' menu located under the 'Home' tab of Excel.
5. Click 'Highlight Cells Rules' and 'Manage Rules' from the Conditional Formatting menu. Choose the option to create a new rule.
6. Apply the rule to the entire Excel spreadsheet by checking the cell range selected in the 'Manage Rules' section.
7. Click 'Format only cells that contain' as the rule type and select the option to format by date.
8. Click to select the 'Dates Occurring' option and then select the formatting rule you want to implement, such as highlighting dates occurring next week or this month.
9. Click the 'OK' button to save your changes and apply the conditional format to the spreadsheet.
Read more ►

Saturday, January 19, 2013

How do I Create a CSV File in Excel 2003?


1. Open the Microsoft Excel 2003 file. Click 'File' on the top menu.
2. Choose 'Save As' from the list of options.
3. Name your CSV file. Choose a location on your computer in which to save the file.
4. Choose 'Comma Separated Value' from your list of 'Save as type.'
5. Click the 'Save' button.
Read more ►

Friday, January 18, 2013

How to Make My Spreadsheet Look Like an Excel 2003 Spreadsheet


1. Complete your spreadsheet as normal and save it. This copy will be for your future use and is still in 2007 format.
2. Click on the 'Office' button in the upper left corner. This is a stylized version of the Windows logo. Many people mistake it for just a graphic, but several useful functions are hidden beneath it.
3. Click on 'Save as' and then select the option that says 'Excel 92-2003 Workbook.' Give your file a new name. The file extension of this file will be '.xls' instead of '.xlsx,' but you should give it a meaningful name to easily differentiate it from your 2007 files.
Read more ►

How to Insert an Excel Spreadsheet Into Word


1. Open the Word document into which you want to insert an Excel spreadsheet. Open the worksheet in Excel that you want to insert into Word.
2. Use your mouse to select the data on the Excel worksheet that you want to insert into the Word document. Copy the selected data using the keyboard shortcut 'Ctrl C' or by clicking the 'Copy' button on the standard toolbar in Excel 2003 or on the 'Home' tab in Excel 2007 or 2010.
3. Place your cursor in the Word document where you want to insert the Excel worksheet.
4. Click 'Paste' on the formatting toolbar in Word 2003 and then click the Paste Options button next to the pasted data. In Word 2007 or 2010, click the 'Paste' drop-down arrow on the 'Home' tab.
5. Click on 'Match Destination Table Style and Link to Excel' if you want the formatting to match the Word document, or click on 'Keep Source Formatting and Link to Excel' to retain the spreadsheet formatting.
Read more ►

Thursday, January 17, 2013

How to Create a Project Plan Template


Excel 2010
1. Open Excel 2010 and select the 'File' tab on the ribbon. Type 'project plan' in the search box. Excel will display the available project plan templates.
2. Click the templates to see a preview of them. Download the template by clicking the 'Download' icon in the right task pane. The template downloads to your computer.
3. Type your project details in the action columns. Add the date specific information in the date columns. Save your changes by clicking the 'Save' icon on the Quick Access Toolbar.
Google Documents
4. Access the Google Documents website. Click 'Create New' and 'From Template.' Type 'project plan' in the search box. Google displays a list of available project plans.
5. Download the template by clicking the 'Use This Template' button.
6. Type your project details in the action columns. Add the date specific information in the date columns. Save your changes by clicking the 'Save' icon.
OpenOffice
7. Access the OpenOffice website. Type 'project plan' in the search box. OpenOffice displays a list of available project plans.
8. Download the project plan template by clicking the 'Use This' link.
9. Type your project details in the OpenOffice Calc action columns. Add the date specific information in the date columns. Save your changes by clicking the 'Save' icon.
Read more ►

How to Convert CSV File to Excel


Save CSV File as Excel Spreadsheet
1. Open Excel and click 'File' and then click 'Open.'
2. Click the down arrow next to 'Look in' to locate the folder containing the CSV file.
3. Use the down arrow next to 'Files of type' and select 'Text Files (*.prn; *.txt; *.csv).'
4. Double-click the CSV file to open it.
5. Click 'File' and then select 'Save As.'
6. Use the down arrow next to 'Save as type' and select your desired Excel version format; click 'Save.'
Import CSV File to Excel
7. Open Excel and click 'Data' and then point to 'Import External Data.'
8. Click 'Import Data.'
9. Use the down arrow next to 'Files of type' and select 'Text Files (*.txt; *.prn; *.csv; *.tab; *.asc).'
10. Click the down arrow next to 'Look in' to locate the folder containing the CSV file and then click 'Open.'
11. Click 'Next' three times, using the wizard default settings. Next, click 'Finish' and then click 'OK.'
Read more ►

How to Copy a Worksheet in Excel 2003


1. Open your Excel worksheet.
2. Highlight the entire worksheet or those cells with text in them. To highlight the entire worksheet quickly, press 'Ctrl A.' For individual cells, hold down the Ctrl key and click on each cell or drag the mouse across a group of cells.
3. To copy the selection, press 'Ctrl C.' Or you can click on the 'Edit' button in the top toolbar and select 'Copy' from the list of options.
4. Paste into a new worksheet.
Read more ►

How to Place a Tick in an Excel Spreadsheet


Symbol
1. Open your Excel workbook and navigate to the specific spreadsheet that needs to have a tick. The spreadsheets in the workbook are listed at the bottom of the window. Click the specific cell where you want the tick to be placed.
2. Navigate to the 'Insert' tab at the top of the screen, which is positioned to the left of the 'Page Layout' tab and to the right of the 'Home' tab. Click the 'Symbol' button in the 'Text' heading at the top-right side of the window.
3. Click the 'Font' drop-down menu and select the 'Wingdings' option. Scroll down to the bottom row of the available Wingdings symbols. Click the specific tick option you want to use and click 'Insert' to place the tick in your selected spreadsheet cell.
Check Box
4. Open the workbook you want to use and navigate to the appropriate sheet. Click the 'Developer' tab in the ribbon at the top of the screen. The 'Developer' tab is at the far right side, to the immediate right of the 'View' tab.
5. Click the 'Insert' button in the 'Controls' heading, which is located to the right of the 'Code' heading. Click the 'Check Box' option underneath the 'Form Control' sub-heading.
6. Click the location on your spreadsheet where you want the tick box to be placed. Click the edge of the box and drag it if you need to move it to a different location. Highlight the text in the box and press 'Backspace.' Type whatever text you need to appear next to the tick box.
7. Press 'Enter' to save the tick box. Click the box to add the tick, or click it again to remove the tick.
Read more ►

How to Create a Pie Chart in Excel 2007


1. Enter the data series in an Excel 2007 worksheet. Type the labels for the data series into the cells in one column. Type the numbers for the data series into the corresponding cells in the next column. For example, you might enter the name of each sales team into the cells in column 'A' and their corresponding sales figures into the cells in column 'B.'
2. Select the cells containing the data series by clicking on the first cell in the series, holding the mouse button down and dragging the pointer over the rest of the cells in the series.
3. Go to the 'Insert' tab of the ribbon. Click 'Pie' in the 'Charts' group.
4. Choose the subtype of pie chart you want to use, such as 'Exploded Pie' or '3-D Pie.' The pie chart appears on the current worksheet.
5. Click on the pie chart to select it. Go to the 'Design' tab under 'Chart Tools' to select a different chart style. Go to the 'Layout' tab to add effects such as '3-D Rotation.' Save the worksheet by clicking the 'Save' button on the 'Quick Access Toolbar.'
Read more ►

How to Drag Chart Markers to Change Data in Excel 2007


1. Enter any additional data you wish to add to the chart in cells that are adjacent to your existing worksheet data.
2. Use your mouse to select the chart by left-clicking in the chart area. Notice that a blue rectangle appears around the existing worksheet data used to generate the chart.
3. Move your mouse over one of the corners of the blue rectangle that is adjacent to the new data you just entered. A 2-sided arrow will appear. Drag the blue sizing handle to include the new data and labels in the rectangle.
4. Left-click and hold on the 2-sided arrow, then drag it to increase the size of the rectangle to include all the new data you have just entered. When you release the mouse button, the chart will automatically update to show the new data.
5. Add new data series only, as well as new categories and data points, by dragging the green and purple sizing handles respectively. Green and purple rectangles will also appear when you select the chart, if applicable, just as the blue rectangle did in Step 2.
Read more ►

How to Create Stacked Bar Chart


1. Open your spreadsheet program. If you do not have a spreadsheet program, check out the link below for a free trial of Microsoft Excel, which has the appropriate functionality to create stacked bar charts.
2. Populate the spreadsheet with the data for which you want to create a stacked bar chart. Note that you will need to have at least two values for one category in order create a stacked bar chart.
3. Click the 'Insert' drop down menu and select the 'Chart' option. This action will launch the 'Chart Wizard' in a separate window.
4. Click once on the 'Bar' option under the 'Chart type' listings.
Click once on the 'Stacked bar' option under the 'Chart sub-type' listings.
Click once on the 'Next' button.
5. Choose the 'Rows' option on Step 2 of the 'Chart Wizard' window.
Adjust the data range, if necessary, by clicking in the first cell of the range and dragging to the last while holding down the mouse button.
Click the 'Next' button.
6.
Click the 'Next' button on step 3 of the 'Chart Wizard' window.
Choose whether you want the stacked bar chart to appear in the same sheet as the source data or on a new sheet.
Click the 'Finish' button to view your stacked bar chart.
Read more ►

Wednesday, January 16, 2013

How to Build a Waterfall Chart in Excel


1. Open a new spreadsheet in Excel.
2. Place your data in column C, starting at cell C5. For example, you might have a list of children’s heights.
3. Write the word “Total” in cell B5.
4. Fill in column B with item numbers. Each piece of data in column C should have an item number in the cell to the left. Run the numbers sequentially, starting at “Item 1.” For example, in cell 6 write “Item 1” and in cell 7 write “item 2.” Continue writing item numbers until each piece of data in column C has a corresponding item number.
5. In column D, Sum the numbers below the current row for each item listed in column C. For example, in cell C6, click on the cell and add the formula “=sum(c7:C$11)” into cell D6.
6. Place a zero in the total and last item fields in column D.
7. Highlight all of the data in your spreadsheet by left-clicking at the top left corner of your data and dragging the cursor down to the bottom right.
8. Insert a column chart into the spreadsheet. In Excel 2003, run the chart wizard and choose “column.” In Excel 2007, click the “Insert” tab and then choose “Column-2D Column.”
9. Hide the set of columns that you do not want to appear on your chart. Left-click on the set of bars and choose “Format Data Series.” In Excel 2003, click the series order tab and then move series 2 over series 1. Then click on the “Patterns” tab and click the radio tab next to “none” for area and border. In Excel 2003, select “Fill” and then click the 'no fill' radio button. Set the Gap Width to 'no gap' by moving the slider.
Read more ►

How to Determine Quarter in Excel 2003


1. Open Microsoft Excel.
2. Type a date in cell A1. For example, type '4/11/2010' in cell A1.
3. Type the following formula in cell A2, '=CHOOSE(MONTH(A1),'Q1','Q1','Q1','Q2','Q2','Q2','Q3','Q3','Q3','Q4','Q4','Q4') '-' RIGHT(YEAR(A1),2).' Cell A2 now displays 'Q2-10.'
Read more ►

How to Footnote in Excel


1. Select the 'Page Layout' tab.
2. Click on the dialog box launcher on the 'Page Setup' group. The dialog box launcher is the little arrow in the bottom right corner of the box. The 'Page Setup' window will pop up.
3. Click on the 'Sheets' tab.
4. Locate the 'Comments' drop down menu. Select 'At end of sheet.' This will make sure all of your footnotes appear at the bottom of the document.
5. Click 'Print.' All comments that are hyperlinked to a cell will be included below the spreadsheet.
Read more ►

Tuesday, January 15, 2013

How to Print a Chart in Microsoft Excel With Lines


1. Open the Microsoft Excel document that you want to print with gridlines.
2. Click on the worksheet tab that you want to print, in the bottom left of the document.
3. Highlight all of the cells and gridlines that you want to print.
4. Click on the 'Page Layout' tab and find the 'Print Area' group. Click 'Set Print Area' to select the highlighted cells as the printable area of the document. This is an optional step. Note that if you do not set the print area, Excel will only print the data and its accompanying cells.
5. Locate the 'Sheet Options' group in the 'Page Layout' tab. Place a checkmark next to 'Print' in the 'Gridlines' section.
6. Preview the document by pressing 'Ctrl' and 'F2' simultaneously. This opens the 'Print Preview' window. Click 'Close Print Preview.' Make necessary changes and repeat this step until you are happy with your document.
7. Click the 'Office' button in the top left of the window and select 'Print.' Click 'OK' to print the document with lines.
Read more ►

How to Create Graphs in Excel with Multiple Columns


1. Enter the data for the desired chart into an Excel spreadsheet. Title any columns or rows as required.
2. Highlight all data you wish to include in the chart. To highlight cells, click your mouse, and while holding down, drag it to include all desired information.
3. Click the 'Insert' tab, and in the charts group, click 'Column.' Select the 2-D stacked column chart and it will be generated automatically.
4. Edit the layout and style of the chart, label the various components and edit the size of the chart by clicking on the chart to generate a chart tools tab with three sub-tabs of design, layout and format.
5. Save your work by clicking 'File' then 'Save As' and a window pops up. Insert a name for the file and click 'Save.'
Read more ►

How to Merge a Last Name and First Name in Excel 2007


1. Launch Microsoft Excel. Locate the spreadsheet that contains your name information and open the file.
2. Click in the first cell of an empty column beyond the spreadsheet area that contains your data. Click 'Insert Function' from the 'Function Library' group of the 'Formulas' command tab and choose 'Text' from the list in the dialog box.
3. Select 'Concatenate' from the 'Select a function' list and click on the 'OK' button. Click in the 'Text1' box in the dialog box and enter the ID of the cell that contains the part of the name--last or first--that you want to be the first part of your concatenated text. To choose the cell by clicking on it instead of entering its ID, click on the 'Collapse Dialog' button. It looks like a set of spreadsheet cells with a small red arrow pointing up toward the top left corner of the button. Once the dialog box is out of your way, click on the cell that contains your desired data, then click on the 'Restore Dialog' button. This button has a small red arrow pointing down from a box that represents a cell boundary.
4. Type a double quote mark into the 'Text2' box, followed by any text you want to appear between the two parts of the name, then another double quote mark. If you're combining last name first, then first name, you'll want a comma and a space between the names, so you'll type ', ' in the 'Text2' box. If you're combining first and last names in that order, you'll only need a space between them, so just type ' ' in the 'Text2' box.
5. Type the ID of the cell that contains the second part of the name into the 'Text3' box in the 'Function Arguments' dialog box. The ID consists of a reference to the cell by its column letter and row number. To choose by clicking on the cell that contains your data, click the 'Collapse Dialog' button next to the text field, click on the data cell, then click the 'Restore Dialog' button.
6. Click on the 'OK' button when you have finished entering or selecting all your data and cell IDs. Your concatenated text now shows in the cell, while the 'Formula Bar' at the top of your document shows the formula you constructed in the 'Function Arguments' dialog box.
7. Propagate your formula down the column of cells by placing your pointing device at the bottom-right corner of the cell in which you entered your formula and dragging down till you reach the end of your data. When you release the pointing device, you'll see your formula applied throughout the column, with the cell references updated to use the data from each row.
Read more ►

Sunday, January 13, 2013

How to Reduce Padding in Excel 2007 Cells


1. Start Excel 2007 and open the spreadsheet from which you want to remove padding.
2. Highlight the columns from which you want to remove the padding. Place the cursor between any two highlighted column headers. The cursor changes to a double arrow. Double click and the width reduces to the minimum needed to display the contents of the column or columns.
3. Highlight the rows from which you want to remove padding and double click between rows to remove it.
Read more ►

How to Use a Cell as a Checkbox in Excel 2007


1. Open the Microsoft Excel 2007 file to which you want to add checkboxes, then click on the “Microsoft Office” button. Click on “Excel Options” at the bottom of the window.
2. Click to select the box next to the “Show Developer tab in the Ribbon” field, then click “OK.”
3. Click on the “Developer” tab, then click “Insert” in the “Controls” group. Select the “Check box” option from the “Form Controls” section.
4. Use your mouse to select the cell in your worksheet in which you want the checkboxes to appear.
5. Click the “Developer” tab again and select “Properties.” Click the box next to the “Checked” field to make sure a check mark can be displayed in your added checkboxes.
6. Click “OK” and the checkboxes will be added to your worksheet.
Read more ►

How to Use Excel's CONVERT Function


1. Learn the syntax for CONVERT. It's CONVERT(number,old_unit,new_unit) where number is the value to convert, old_unit is the current units of the value and new_unit is the units to which to convert the value.
2. Install the Analysis ToolPak if CONVERT returns the #NAME? error value. Select the Add-Ins menu item from the Tools menu, check the box next to the Analysis ToolPak and click on the OK button to install the Analysis ToolPak.
3. Interpret the error values for CONVERT. It will return the #VALUE! error value if the number is not a numerical value. CONVERT will return the #N/A error value if either unit does not exist or the units are for different measures.
4. Refer to the CONVERT function help topic in Excel for the complete list of units that can be used with CONVERT. This list is extensive and includes all standard units of measure.
5. Look at some examples of CONVERT. =CONVERT(6,'C','F') will return 42.8. 'C' stands for Celsius and 'F' stands for Fahrenheit. 6 degrees C is therefore equal to 42.8 degrees F. Similarly, =CONVERT(6,'in','ft') will be 0.5 because 6 inches is equal to half a foot. =CONVERT(6,'ft','sec') will return the #N/A error value because feet and seconds measure different things.
Read more ►

How to Separate the First Name Last Name in Excel


1. Open Excel 2010 and click the 'File' tab. Select 'Open.' Browse the files and locate a workbook. Click the workbook and the 'Open' button. The workbook opens.
2. Highlight the column containing the combined first and last name. Right-click the column and select 'Insert' to insert a blank column. This will provide the column for the last name once the split has occurred.
3. Click the 'Data' tab and click 'Text To Columns.' The Text To Columns dialog box appears. Click 'Next' and check 'Space.' Click 'Finish' to split the first and last name in the workbook.
Read more ►

How to Use Indirect in Excel 2007


1. Start Excel 2007. Open the workbook containing a cell or range to which you refer in another cell.
2. Click inside the cell in which you want to refer to the first cell or range and enter the formula you want to use. For example, if you want cell A2 to contain the sum of cells E4 through E21, enter the formula '=SUM(E4:E2)' into cell A2.
3. Click inside the cell in which you want to indirectly refer to the same cell or range.
4. Click inside the Formula Bar. Type '=Indirect( )' and enter the cell reference containing the reference to the range or cell to which you want to indirectly refer. For example, if you want to refer to the sum of cells E4 through E21, which is entered in cell A2, the formula would be '=INDIRECT($A$2).'
5. Press the 'Enter' key. Save the changes to the worksheet. If you change the reference or contents of cell A2 (or whatever cell to which you are indirectly referring), the cell containing the indirect function will change to reflect the contents of that cell.
Read more ►

How to Make Lined Columns in Microsoft


Insert a Separator Line Between Columns in Word
1. Open the Word document.
2. Click the 'Page Layout' tab on the command ribbon.
3. Click the down-arrow for the 'Column's button in the 'Page Setup' group. A list of column formats appears.
4. Click the 'More columns' button. A 'Columns' dialog window displays a list of column formats.
5. Click the preferred format or type a value in the text box. For example, type '3' to set three columns.
6. Select the check box for 'Line Between.'
7. Click 'OK.' A vertical separator line appears between the columns.
Insert Line Borders for Excel Columns
8. Open the Excel worksheet.
9. Click the 'Home' tab on the command ribbon.
10. Click and drag the mouse to select a range of cells or a column. The column and row headers change color.
11. Click the down-arrow on the 'Borders' button in the 'Font' group. This button is located between the 'U' and paint can symbols. A list of border styles appears.
12. Click the preferred border style. For example, 'All Borders' outlines every cell. You can opt to draw borders for certain cells or columns.
Read more ►

Saturday, January 12, 2013

How to Use Excel to Balance a Checkbook


1. Open Microsoft Excel. Click cell “A1” and type “Date.”
2. Type “Check Number” in cell 'B1' and type “Description” in cell “C1.”
3. Click cell “D1” and type “Amount.” Type “Balance” in cell 'E1.'
4. Click the column “A” header at the top of your spreadsheet. Right-click the header and select “Format Cells” from the drop-down menu. Click the “Number” tab and click “Date” in the Category section. Select the format “3/14/01” in the Type section, and click “OK.”
5. Click the column “D” header and drag your mouse to column “E.” This action will select both columns. Click the dollar sign ($) located in the Number section on the “Home” tab.
6. Click cell “A1” and drag your mouse over to cell “E1.” Click the “Center” button in the Alignment section and the “Bold” button in the Font section. Click the arrow next to the “Border” button and select “Bottom Border.” If you have trouble finding a button, hover your mouse over a button to view a description.
7. Hover your mouse between column header “B” and “C.” Your mouse cursor will change to a vertical line with two arrows. Click your mouse and drag your mouse right to resize the column. Resize the column to 13.57 (100 pixels). Hover your mouse between column header “C” and “D.” Resize the column to 20.71 (150 pixels). Resize column D and E to 10.71 (80 pixels.)
8. Enter your beginning checking account balance in cell “E2.”
9. Enter the following formula in cell “E3” and press enter: =IF(A3,IF(ISNUMBER(FIND('Deposit',C3)),E2 D3,E2-D3),' ')
10. Click cell “E3” and hover your mouse over the lower-right corner of the cell. Your cursor will change to a plus sign ( ). Click the corner of the cell and drag your mouse down approximately 10 cells. This procedure copies the formula from cell “E3” and pastes it in the following cells. The formula adjusts to coincide with the row.
11. Enter the date of your first transaction in cell “A3” to activate the formula. If you omit this step, the register will not calculate your transaction.
12. Enter the check number in cell “B3,” if applicable. If the transaction does not involve a check, leave this cell blank.
13. Enter the transaction’s description in cell “C3.” If this transaction is a deposit, you must include the word “Deposit” in your description for the formula to recognize that the deposit is an addition to your balance.
14. Enter the amount of your transaction in cell “D3.” Cell E3 displays your current balance.
Read more ►

How to Increase the Height of a Row to Pixels in Excel 2007


1. Open an Excel spreadsheet. You will see on the left side of the spreadsheet that the rows are numbered (1, 2, 3, etc.).
2. Place the cursor on the line under the row you want to increase the height of. For example, if you want to increase the height of row 2, place the cursor on the line between row 2 and row 3. Note that the cursor changes from the usual arrow to what looks like a plus sign ( ).
3. Click your mouse and while continuing to hold it down, drag the row to increase (or decrease) to the height you want. When you click your mouse on the line between rows, you will see a small dialogue box appear that will say 'Height: 20.25 (27 pixels)'--or whatever height the row is.
4. To increase the height of several rows at once and to ensure they are all exactly the same size, place the cursor over the number of the first row in your selection. You will see that the cursor is now a black arrow. Do not place the cursor on the line as you did in Step 2.
5. While holding down the mouse, drag it to select as many rows as you want. Now perform Step 2.
Read more ►

How to Change the Default Owner Name for Microsoft Excel


Change owner name in Excel 2007
1. Launch Excel and click on the Windows icon at the top left-hand corner of the screen.
2. Select the 'Excel Options' button at the bottom of this window.
3. Click on the 'Popular' tab in the left column.
4. Change the 'User name' under the 'Personalize your copy of Microsoft Office' section at the bottom of the screen.
5. Click the 'OK' button at the bottom of the screen.
Change user name in earlier versions of Microsoft Excel
6. Launch the Excel and click the 'Tools' option at the top of the screen, then select the 'Options' choice.
7. Click on the 'General' tab.
8. Enter your desired user name into the 'User name' box.
9. Click 'OK' at the bottom of the window.
Read more ►

How to Automatically Use Absolute Cell Reference in Excel


1. Open Excel.
2. Click the empty box in the upper-left corner of the spreadsheet. This is the box that is to the left of column A and on top of row 1. This highlights every cell in the spreadsheet.
3. Click in the formula tab.
4. Press F4 to toggle to the absolute value reference. Since all cells are highlighted, this toggling will affect every cell in the spreadsheet.
Read more ►

Blogger news