Hiding blocks of cells1. 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...
Browse » Home » Archives for January 2013
Monday, January 28, 2013
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, CO2. 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...
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...
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...
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 w...
Wednesday, January 23, 2013
How to Animate a Cell in Excel 2007
Download and Install the 3-D Animation Engine1. 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.Animate5. Open the Excel...
How to Make an Excel Template a Read
Excel 20031. 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....
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...
Tuesday, January 22, 2013
How to Use Excel for Correlation
Measuring Correlation With Excel1. 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,'...
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 'Rese...
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...
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 'O...
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...
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,...
Sunday, January 20, 2013
How to Use Excel for Birthdays
Arrange Your Spreadsheet1. 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...
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' butt...
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 fil...
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...
Thursday, January 17, 2013
How to Create a Project Plan Template
Excel 20101. 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 Documents4. Access the Google Documents website. Click 'Create New'...
How to Convert CSV File to Excel
Save CSV File as Excel Spreadsheet1. 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 Excel7. Open Excel and click 'Data' and then point to 'Import External Data.'8. Click 'Import Data.'9. Use the...
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 workshe...
How to Place a Tick in an Excel Spreadsheet
Symbol1. 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...
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'...
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...
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'...
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...
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-1...
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 spreadshe...
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...
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,...
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...
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 ...
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...
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...
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 workbo...
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....
How to Make Lined Columns in Microsoft
Insert a Separator Line Between Columns in Word1. 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 Columns8....
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 ($)...
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...
How to Change the Default Owner Name for Microsoft Excel
Change owner name in Excel 20071. 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 Excel6. Launch the Excel and click the 'Tools' option at the top of the screen, then select the 'Options' choice.7. Click on the 'General'...
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 spreadshe...
Subscribe to:
Posts (Atom)