1. Open the workbook in Excel 2003.2. Click 'Window,' then 'New Window.' Excel will now feature two windows for the document. You can select a different worksheet in the new window if you like. Repeat this until you have as many windows open as necessary.3. Click 'Window,' then 'Arrange.' Choose whether to arrange the windows horizontally, vertically or one of the other ways. This will equally split the windows; you can drag their corners to resize th...
Browse » Home » Archives for April 2013
Sunday, April 28, 2013
How to Add a Workbook to Microsoft Excel
Excel 20031. Log on to your computer and open Microsoft Excel. Open a new or existing spreadsheet.2. Place your cursor to the right of where you want the new workbook to appear. Click on the 'Insert' menu.3. Choose 'Workbook' from the menu and click 'OK.' You will now see a new tab at the bottom of the spreadsheet.4. Click on the 'Format' menu and choose 'Sheet' from the menu. Choose 'Rename' and give the new workbook a descriptive name.Excel 20075. Log on to your computer and open Microsoft Excel. Open a new or an existing spreadsheet.6. Locate the bar at the bottom of the spreadsheet...
How to Open Excel Without Macros
Starting Excel from the Desktop or Start Menu1. Press and hold the 'Shift' key on your computer's keyboard.2. Click on the Excel icon on your computer's Desktop or click 'Start,' 'All Programs,' 'Excel.' Excel's splash screen will appear and the program will open.3. Release the 'Shift' key once the default blank workbook appears on your computer's screen.Starting Excel from the Office Shortcut Bar4. Click on the Excel icon on the Office Shortcut bar on your computer's Desktop.5. Press and hold the 'Shift' key on your computer's keyboard immediately. Excel's splash screen will appear...
How to Print Continuing Row and Column Headings in Excel 2003
1. Open the Excel file that you want to work on. With Excel open, go to 'File > Open' and find your file.2. Click on 'File > Page Setup.'3. Click on the Sheet tab.4. Click on the chart icon next to the box for 'Rows to Repeat at Top.' This will take you back to your Excel sheet. You can now click on the row that you would like to appear on subsequent pages. For example, if there is a row with headings you'd like to repeat, choose that one. After you click each row, your choice will appear in a box on the main screen. Hit 'Enter' to return to the dialog box.5. Click on the chart...
How to Make Bold Letters in Excel
1. Open the Excel file in which you want to make bold letters. Enter text in a cell or multiple cells.2. Click the cell or group of cells in which you want to add bold font. If you want an entire row or column to contain bold font, select the entire row or column by clicking the letter or number at the beginning of the cell or row.3. Click the 'Home' tab.4. Click the 'Bold' button. The Bold button is represented by a 'B' and is located in the Font gro...
Saturday, April 27, 2013
Step
1. Click the Windows 'Start' button, and select 'All Programs.' Click 'Microsoft Office,' then click 'Excel 2003.' The software opens on the computer to the main window. Excel automatically starts a new spreadsheet for you, if you want to create a new worksheet.2. Click the 'File' menu item, then click 'Open.' The 'Open' dialog window lets you open an existing spreadsheet. Double-click an XLS file to load it in the Excel software, if you want to edit an existing spreadsheet.3. Create the data in your spreadsheet. The type of data you enter into the spreadsheet is determined by what you intend...
How to Use MS Excel to Make an Age
1. Create six column headers in row one, starting in column A. From left to right, the column headers should be “Male,” “Female,” “Total,” “Age Range,” “% Male” and “% Female.”2. Input the age ranges that you have the information for under the “Age Range” column. If you are using a hyphen to denote the age range, like “11-14,” right-click the cells and choose “Change Format.” Then change the format to “Text.” Otherwise, Excel may automatically change your ranges to dates.3. Place the population numbers for males and females that correspond to the age range in the row, under the “Male” and...
How to Format Cells to Make Negative Numbers Appear Like 0000.00 in Excel
1. Open the Excel 2010 spreadsheet where you want to adjust the number format.2. Click on the top-left cell in the area where you want to adjust the number format. Hold the mouse button down and drag your mouse pointer to the bottom-right cell, then release the button to select the entire area. Alternatively, you can select the column letter, or row number, to select an entire column or row.3. Right-click your mouse while your pointer is located anywhere within your selection. Choose “Format Cells” from the small menu that appears and the Format Cells window will appear.4. Click on “Custom”...
Thursday, April 25, 2013
How to Graph a Line Graph in Excel 2007
1. Open the Microsoft Excel 2007 application on your computer and click on the 'Microsoft Office' button. Click on the 'Open' option.2. Locate the Excel 2007 file on your computer that contains the data you want to turn into a line graph. Select the file and then click on the 'Open' button.3. Click on the 'Insert' tab and then click on the 'Line' option from the 'Charts' group. Click on the 'Line with Markers' option.4. Use your mouse to highlight the data within the spreadsheet that also contain labels for the rows and columns. The Chart Tools feature now becomes available.5. Click...
How to Lose the Zeroes in Excel
All Zero Values1. Move your mouse pointer to the 'File' tab and left-click. Click 'Options.'2. Find the 'Advanced' category at the top and click it. Locate 'Display options for this worksheet' and select your worksheet.3. Remove the check beside 'Show a zero in cells that have zero value.' The cells with zero values now appear blank and contain no numbers.Selected Cells4. Move your mouse pointer to the cells with zero values that you want to lose. Hold down the left button and drag your mouse. This highlights the cell(s).5. Locate the 'Cells' group in the 'Home' tab. Click 'Format.'...
How to Do Addition in Excel
Using the Plus Sign1. Open the Microsoft Excel 2010 spreadsheet that you want to work with.2. Click on an empty cell on the spreadsheet, wherever you want the results of your addition to be listed.3. Type '=' -- the 'equals' symbol -- which indicates the start of a formula, then type in the number or cell reference of the first thing you want to add. If entering a cell reference, place the column letter of the cell in front of the row number, so that the first cell on the spreadsheet is 'A1' and the one under that is 'A2.'4. Enter a ' ' sign into your formula, then enter the second number...
How to Make a Bar Graph in Excel 2010
1. Open a new Excel 2010 spreadsheet. Identify two or more variables you want to include in your bar graph. For example, to graph the number of lung cancer cases occurring over the past 100 years, use the variables 'Decade' and 'Lung Cancer Cases.'2. Place the independent variable on the x-axis of a bar graph. Type the variable name, such as 'Decade,' into cell A1. Type the second variable name in cell B1. This variable goes on the y-axis of your bar graph. Add additional variables to the spreadsheet if necessary.3. Type numerical data under each variable. Include as many cells as necessary...
How to Create Line Graphs With Two Groups in Microsoft Excel
1. Open the Microsoft Excel file that contains the data sets you wish to graph.2. Click the 'Chart' button on the Excel toolbar. A pop-up chart wizard will appear.3. Select the 'XY Scatter' chart type and any chart sub-type you prefer. The options provide four types of line graphs to suit your style. Press the 'Next' button.4. Delete anything that is displayed in the 'Data Range' field. Select the 'Columns' option in the 'Series in' field. Then click the 'Series' tab.5. Create a new series for each line you wish to graph based on a group of data. If you have two groups of data, you will...
How to Use Absolute Cell Referencing
Creating an Absolute Reference1. Determine if a formula should be absolute or relative. When designing a formula, look for hard-coded numbers. A sample formula for the discount could be 'discount = cost of merchandise * 20%'. The 20% is a hard-coded number and has the potential to change. Instead, create a cell titled Discount Amount. The new formula would be 'discount = cost of merchandise * discount amount'. That way, if the discount ever increased, you would need to change only the amount in the Discount Amount cell, and all the formulas would automatically update.2. Create the formula....
Wednesday, April 24, 2013
How to Add the Word 'Draft' As a Watermark to Excel Documents
1. Open your Excel document and click 'Insert,' then 'Word Art.'2. Select the style you want your watermark to look like.3. Type 'Draft.'4. Right-click your word art and select 'Format Text Effects.'5. Check that 'Solid Fill' is selected and drag the transparency bar to a setting that allows you to see the data on the spreadsheet and the word 'Draft' on the spreadshe...
How to Add Two Cells in Excel
1. Start Microsoft Excel, and open the file you want to use.2. Click on the cell in which you want the total to appear.3. Press the key on the keyboard. This character will appear in the cell and in the Formula Bar.4. Click on the first cell you want to add. That cell's name, such as B6, appears in the Formula Bar after the sign.5. Press the key again.6. Click on the second cell you want to add. That cell's name appears in the Formula Bar.7. Press Enter to complete the equation. The total will appear in the initial ce...
How to Create a Bar Code in Microsoft Office Publisher
1. Start up Microsoft Excel and prepare your data. This will include all the pertinent information you wish to associate with the bar code. You will also need to create a column for your bar code data. This is simply a code that will translate into a bar code and act as a reference point for that specific row of data.2. Highlight all of the data in the bar code column and in the 'Custom Toolbar' of Excel; click on 'Settings,' and choose the appropriate bar code type. You will also need to click on the drop-down box below 'Convert To' and select 'Image File.' At this point, click 'Generate...
How to Make Excel 2007 Behave Like 2003
1. Visit AddInTools.com and download 'Classic Menu for Office 2007.' This product costs $29.99, as of September 2010, and you will be asked to pay with a credit or debit card. You will not be able to proceed until you have successfully purchased and downloaded this product to your computer.2. Open Excel 2007 on your computer. To do this, click the computer's Start menu. Click 'Microsoft Office 2007,' then click 'Microsoft Excel 2007'. Once you open Microsoft Excel 2007, you will notice a new task on your toolbar: 'Menu,' located right before 'Home.'3. Click the new 'Menu' task on the toolbar...
How to Find Lost Excel Files
Windows XP1. Click 'Start' in the lower-left corner of your computer screen.2. Place your mouse pointer over 'Search,' then select 'For files or folders.'3. Click on the 'Documents' option, then select 'Use advanced search options,' then click 'More advanced search options.'4. Click the appropriate box for when the file was last modified. If you don't know, leave this section blank.5. Type '.xls' (without quotes) in the box that asks for all or part of the document name. If you are using Excel 2007 or later versions, type '.xlsx' instead of '.xls.' This will limit your search to Excel...
Tuesday, April 23, 2013
How to Use Excel 2007 to Estimate Linear Functions
1. Open a new or existing Microsoft Excel spreadsheet. If you start with a blank spreadsheet, enter your x-values into column A and y-values into column B. Each pair of numbers creates a data point on a chart, so they need to correspond to each other.2. Label your columns with descriptions of your data, such as 'Month' and 'Hours.' In this example, if you worked 160 hours in the month of June, those two values create one data point on your chart. Highlight your data set and select the 'Insert' tab on the Ribbon at the top of the page.3. Click the 'Scatter' drop-down box in the 'Charts' area,...
Monday, April 22, 2013
How to Work Out Percentages in Excel
1. Open the Microsoft Excel program and type the numerator (given amount) into cell A1.2. Highlight cell B1.3. In the 'fx' box in the toolbar at the top of the screen, type '=A1/X' (without the quotes), replacing X with the denominator (the total amount) . For instance, if you are calculating a percentage score out of 60 points, you would type '=A1/60'.4. Hit enter. This should calculate a decimal (eg, .75) in cell B1.5. Hit the '%' button on the formatting toolbar near the top of the screen to convert to a percentage. Alternatively, you can simply multiply by 1...
How to Remove the Password Required to Open Excel
1. Open the Microsoft Excel application by clicking 'Start' and typing 'excel' into the search bar. Click on 'Excel' in the list that appears to open it. You can also click 'All Programs' and open Excel from there. You don't need a password to open Excel this way -- you only it when you double-click on a protected file.2. Click 'File,' then 'Open.' Click on the name of the file that is password-protected. Type the password and hit 'Enter' to open the document.3. Click 'File,' then 'Info' and 'Permissions.' Click 'Encrypt with Password.' The password entry box opens.4. Delete the password...
Sunday, April 21, 2013
How to Detect Repair Excel 2003
1. Open Excel 2003 by clicking on the 'Start' button, then 'All Programs,' 'Microsoft Office' and 'Microsoft Office Excel 2003.'2. Click 'Help' on the main menu, then select Detect and Repair. The Detect and Repair dialog box is displayed on your screen. You may be prompted to select an installation source. If so, browse to the location of your Microsoft Office installation files or insert the installation disc.3. Choose if you want to restore your shortcuts or discard any customized settings by selecting the appropriate check boxes.4. Click 'Start' to begin the Detect and Repair process....
Saturday, April 20, 2013
How to Make a Cell in Excel 2007 Act Like a Checkbox
1. Open the Excel worksheet you want to modify by adding in a check box. Navigate to the 'Developer' tab in the ribbon at the top of the window.2. Click the 'Insert' icon in the 'Control' heading to bring up a drop-down menu. Select the 'Check Box' icon in the 'Form Controls' grouping.3. Locate the cell that needs to act as a check box. Click the cell to create the new check box. Click the outline of the box and drag it to any other cell if you need to move it.4. Highlight the text that reads 'Check Box 1' and press the 'Backspace' key. Type in the text you want to appear next to the check...
Friday, April 19, 2013
How to Create an XY Chart
1. Open Excel and in a new workbook, create a data spreadsheet for the XY chart to reference. Enter the months, as shown in the graphic depiction in cells 'A1' through 'M4.' (NOTE: You can create a chart similar to the one shown instead.)2. Select 'Insert' from the menu bar. Next, choose 'Chart.' (NOTE: You can choose the chart icon on the menu bar if it is available.)3. Go to the 'Standard Types' tab and select the 'XY(Scatter)' chart from the Chart Type list box.4. Press the 'Press and Hold to View Sample' button to preview the chart before making your final selection. When ready, click...
How to Create a Family Tree on Microsoft
1. Open PowerPoint 2010 and click the 'File' tab. Click 'New.' Type 'Family Tree' in the search box. Review the available family tree templates that appear.2. Click the family tree template to see a preview of it in the right task pane. Click the 'Download' icon to download the template.3. Click in the text boxes and highlight the default text. Type in your family information. Save your changes by clicking the 'Save' icon on the Quick Access Toolb...
How to Use Excel's GETPIVOTDATA Function
1. Understand the syntax of the GETPIVOTDATA function. The formula is =GETPIVOTDATA(pivot_table, name). Pivot_table references a cell in the PivotTable or a range of cells in the PivotTable, a label of a cell above the PivotTable or the name of the range that contains the PivotTable. 'Name' is text enclosed in quotations marks that describes the data.2. Create a new workbook to practice using pivot tables. Label columns A, B and C with the headers 'Name,' 'Month' and 'Sales.' Under the header row, fill in several of the rows with data. Include the same name and month more than once.3. Hold...
Thursday, April 18, 2013
How to Use the Find the Method in Excel 2003 Using Visual Basic
1. Launch Excel 2003.2. Open the 'File' menu at the top of the screen and click 'Open.' Double-click the spreadsheet that needs to use the 'Find' method.3. Click the 'Tools' menu at the top of the window and scroll down to the 'Macro' entry. Click the 'Visual Basic Editor' entry in the sub-menu.4. Click the name of the worksheet you need to use in the list of worksheets at the left side of the screen. Click inside the code editor screen at the left side of the window.5. Type the phrase 'Sub Finding()' at the top of the screen to let the Visual Basic editor know where the code should...
How to Find the Weighted Mean in Excel 2007
1. Input your data points into column A in your Excel 2007 worksheet, one number per cell. For example, you might input the numbers 90, 86, 45, 67, 78, 76, 79, 82.2. Input the weight of each of the numbers in column B. The weight of each number should sit directly to the right of the number. The weights you choose do not matter, they are only meaningful relative to each other. For example, if a data point has a weight of 1 and another point has a weight of 2, the second point will be twice as important to the mean, but if both data points have a weight of 2, they will be identically important....
How to Calculate a Standard Error Regression
1. Open Microsoft Excel 2007. Input your data into the spreadsheet into two columns. You should have known values for y (your dependent variable) and each independent variable.2. Go to the 'Data Analysis' command under the 'Data' tab on the user interface. If you do not have this function, you must add it in. To add the analysis to Excel, go to the 'Microsoft Excel' button in the right-hand corner of your screen. Go to 'Excel Options and Add-ins.' Select the 'Data Analysis' toolpak. Download to your Excel program.3. Select 'Data Analysis.' A list of statistical choices will appear. Choose...
How to Make a XY Graph on Excel
Create XY Graph In Excel 20031. Open Microsoft Excel 2003.2. Place your data such that all the X-values are in the same row or column. Place your other set of data in an adjacent row or column. For example, if you have six X-values and six Y-values, place all the X-values in column A and all the Y-values in column B.3. Select the range of values to be included in the XY chart. To select the range of the six XY-value example, click the first cell included, which is A1, then drag your mouse to the last cell to be included, which is B6.4. Go to the 'Insert' menu, and click 'Chart.'5. Select...
Wednesday, April 17, 2013
How to Disable Links in Excel 2007
1. Click the Excel button on the top toolbar, and then select the 'Excel Options' button at the bottom. Choose 'Proofing' from the left menu.2. Click the 'AutoCorrect Options...' button under the 'Autocorrect options' section. Select the 'Autoformat as you type' tab, then uncheck 'Internet and network paths as you type' under the 'Replace as you type' section. Click 'Ok' to save the changes.3. Click 'Ok' in the 'Excel Options' window to close it and return to the spreadsheet. Type or paste a URL into a blank cell then hit the space bar or enter key to verify the chang...
How to Turn on Sounds in Excel 2007
1. Click the 'Microsoft Office' button. A list of commands opens.2. Click 'Excel Options.' The 'Excel Options' window opens.3. Click the 'Advanced' tab.4. Scroll down to the 'General' section.5. Check the box for 'Provide Feedback With Sound.'6. Click 'O...
How to Reset the Excel 2003 Application to Default Settings
1. Save and rename your workbook and worksheet settings templates if you want to use them again. Save them in the Templates folder, which is located here: C:\Documents and Settings\user_name\Application Data\Microsoft\Templates.2. Click on your computer's start menu and search for the following in the search dialog box at the bottom of the menu: C:\Program Files\Microsoft Office\OFFICE11\XLSTART. Delete any template files in this folder. If you'd only like to delete workbook settings templates, delete templates with 'Book.xlt.' If you'd only like to delete worksheet settings templates, delete...
How to Make an Excel Chart With a Negative and Positive Axis
Numerical (Value) Axis1. Open the Microsoft Excel 2010 file that contains the chart you want to alter.2. Click anywhere on the chart. Select the 'Format' tab at the far-right end of the ribbon. Click the drop-down box that appears on the far-left end of the ribbon. Select your desired axis from the list. Then, choose the 'Format Selection' button located right below the drop-down box.3. Click the radio button next to 'Fixed' under the 'Minimum' heading. Place your cursor into the text box next to this button and enter the lowest number you want displayed on your axis. Place a dash before...
Tuesday, April 16, 2013
How to Import an Excel Spreadsheet into Another Sheet
Linking1. Launch Microsoft Excel and open the source file that contains the data to be linked.2. Open or create the destination file in which the data will be displayed.3. Navigate to the source spreadsheet and highlight (or 'Select') the cell or range of cells to be imported by clicking the cell, or clicking the top left corner of the range of cells and holding the mouse button down while dragging the cursor to the lower right corner of the range of cells and then releasing the mouse button. Alternately, click the gray button that contains the row number or column letter to select an entire...
How to Remove Duplicates From Access Query
1. Open an Access 2007 database on your computer. Make sure it has a table that contains duplicate data. Select the 'Office' button and select 'Open.' Search your computer and locate the database. Click on the database and select 'Open.'2. View the tables in your database in the Navigation Pane. Open one of the tables and visually note the duplicates and note the total number of records. Select the 'Create' tab on the ribbon. Click on the 'Query Design' button. Add the table you have just viewed by clicking on the table and selecting 'Add.' Select 'Close.' Add some fields to the...
How to Insert a Dynamic Date and Time in Excel
1. Start Microsoft Excel 2007, and open an existing spreadsheet from your files that you want to insert a dynamic date and time into. Or, start a new, blank spreadsheet.2. Click to select the cell into which you want to insert the dynamic date and time. The cell will be outlined in a thick, black line indicating it is selected.3. Use your keyboard to type '=now()' (without the quotation marks) into the selected cell. This is the formula that is used to instruct Excel 2007 to insert the dynamic date and time.4. Press the 'Enter' key on your keyboard to enter the formula into the selected...
How to Convert a Word Document to a CSV File
1. Open the Microsoft Word document in Word and save it as a '.txt' file. To do this, select 'File' and then chose 'Save As.' Next, use the down arrow next to 'File as Type' and select '.txt.'2. Open the Microsoft Word document in MS Excel by selecting 'File' and then 'Open.' Find the file in the 'Look in' directory from within the 'Open' dialog box.3. Click option 'Delimited' and then click '1' beside 'Start Import at Row' to indicate the first row to import the data. Next, select the geographical location of the original file format beside 'File Origin.' When done, click 'Next.'4. Click...
Monday, April 15, 2013
How to Convert Word to Excel 2003
1. Open the Word document with the data you want to convert to Excel 2003.2. Highlight the data with your mouse. Choose 'Convert Text to Table' from the 'Insert' menu and convert the text into a table if it is not already.3. Hover your mouse over the table until you see a ' ' appear in the upper-left corner. Click on the ' ' sign to select the entire table.4. Click 'Edit' and then 'Copy.'5. Launch Excel 2003 and click into a blank cell.6. Click 'Edit' and then 'Paste.' Your data will appear within Excel.7. Click 'File' 'Save As' and choose 'Excel Workbook (.xls)' from the 'Save as...
How to Change the Axis on Excel 2007
Swap X and Y Axes1. Open the Excel file that contains the chart you want to manipulate.2. Right-click anywhere within the chart itself. Choose 'Select Data' from the pop-up menu. A small data window will appear on the screen.3. Click the 'Switch Row/Column' button in the middle of the window. Click 'OK' to confirm your changes. Your X and Y axes will now be swapped on the graph.Alter an Individual Axis4. Open the Excel 2007 file that holds the chart you want to change.5. Select one of the cells that contain the information used in the axis you want to alter. Press 'Delete' to remove...
How to Recover an Excel 2007 File
After an Excel Crash1. Restart Microsoft Excel 2007. You may also need to restart your computer if you had a system crash or power outage. The document recovery task pane should automatically open on the left side of the screen.2. Scroll through the documents in the 'Available Files' list. Excel will try to recover up to three versions of the document you were most recently working on.3. Select a file from the list. Click the down-arrow icon.4. Click 'Open' to view the recovered document. If you know you want to keep the file, click 'Save as' to rename it. Click 'Delete' if you want to...
Sunday, April 14, 2013
How to Merge Data From Two Spreadsheets
1. Open Excel 2010 and locate the workbook containing the worksheets that will be merged. Click the 'File' tab and select the 'Open' icon. Find the workbook and double-click it.2. Click in the next blank worksheet in the workbook. Select the 'Data' tab. Click 'Consolidate.' The Consolidate dialog box opens.3. Select the function you will use to merge the data. If you are adding the merged values, select 'Sum.' Click the red box in the reference section.4. Click the worksheet that contains the first set of data that will be merged. Highlight the range and click the 'Add' button....
How to Define Cell Ranges in Excel
1. Enter Microsoft Excel and open a worksheet.2. Select the range of cells (or even the nonadjacent cells) that you want to name.3. Locate the name box at the top-left of the formula bar, just above the row and column headings.4. Click in the box and type the name you want for the cell range.5. Press Enter to accept the name.6. Use the name in formulas you crea...
How to Disable a Date Autofill in Excel
Disable the AutoComplete Option1. Open the Excel file.2. Click the 'File' tab on the command ribbon. A list of basic commands appears.3. Click 'Options.' The 'Excel Options' window appears. The left pane includes the 'Advanced' command.4. Click 'Advanced.' A list of editing options appears.5. Clear the check box for 'Enable AutoComplete for cell values.'6. Click 'OK.' This button is located at the bottom of the dialog window. The 'AutoComplete' command no longer copies the cell data to new cells. The worksheet is open for editing.Disable the AutoFill Option7. Open the Excel file.8....
How do I Create Mailing Labels in MS Word From an MS Excel Spreadsheet?
Prepare the Mailing List1. Open a new spreadsheet and use the first row to create column headers across the top of the document. Name the top cell of each column to correspond with the address fields on your labels, for example: 'First Name,' 'Last Name,' and so on.2. Start in the first cell on the second row and enter the data that corresponds with the cell header. For example, enter the recipient's first name in the row under the 'First Name' label. Continue until you have entered all of your mail recipients and save your document.3. Highlight all of the data in the mailing list. Single-click...
How to Subtract Using Excel 2007
1. Double-click the Excel 2007 icon on your desktop or in your 'Programs' list to open the program to a blank worksheet.2. Enter the numbers you want to subtract in separate cells in the spreadsheet.You can select any cells you would like, but it's usually convenient to place the numbers next to one another either horizontally, in two separate columns, or vertically, in two separate rows.If you want to work with data from an existing spreadsheet, open that file to begin working on it.3. Enter a subtraction formula in a blank cell. The formula is an equal sign, followed by the first cell...
How to Fill Cells With Colors in Microsoft Excel 2003
1. Select the cell that you wish to fill. You will need to left-click on the cell that you wish to fill with color in order to activate that cell.2. Access the color-fill palette. The color-fill palette is located on the command bar and looks like an icon of a paint bucket spilling out paint. Simply left-click on this icon and a color palette will open.3. Select a fill color. Once the color palette is open, just click on the desired color.4. Fill the cell with the desired color. Once you click on the desired color, the cell will automatically fill with that color. You can easily change...
Saturday, April 13, 2013
How to Divide a Cell in Two
1. Launch Microsoft Excel. Double-click the name of the document you want to edit on your hard drive to open it in Microsoft Excel.2. Insert a blank column next to the cell or column of cells you want to split. Highlight your cell by clicking on it (or the whole column by clicking on the column heading) and hold down the 'Alt,' 'I' and 'C' keys at the same time to insert a new column.3. Open the 'Convert Text to Columns Wizard.' In Excel 2003 and earlier versions, drop-down the 'Data' menu and select 'Convert Text Into Columns.' In Excel 2007 and 2010, navigate to the 'Data' tab and click...
How to Speed Up Excel 2007 Calculations
1. Open Excel. Click on the 'Formulas' tab at the top of the spreadsheet, which is between 'Page Layout' and 'Data.' Click on the 'Calculation Options' button that appears to the right; a drop-down menu appears. You will see that the 'Automatic' option is checked.2. Select the 'Manual' option from the drop-down menu in order to disable automatic recalculations of all cells whenever a change is made to one. Now Excel will only recalculate when you explicitly tell it to do so. Alternatively, you may choose the option 'Automatic Except for Data Tables,' which will automatically make changes to...
Friday, April 12, 2013
How to Turn Off AutoCorrect in Excel
1. Open the Excel file in which you want to disable AutoCorrect. Access the AutoCorrect Options dialog. In Excel 2007 or later, click the 'Office' button in the top left, then 'Excel Options,' then 'Proofing' and then 'AutoCorrect Options.' In earlier versions of Excel, click the 'Tools' menu, then 'AutoCorrect Options.'2. Uncheck the box next to whatever AutoCorrect features you want to disable. To disable AutoCorrect entirely, uncheck every box.3. Click 'OK' to finalize the changes and disable AutoCorre...
Microsoft Excel: How to Remove a Drop
1. Left-click on the Office ribbon button and click on the 'Excel Options' button.2. Select “Popular” in the Excel options box and then check the “Show the developer tab in the Ribbon” box3. Click the “Review” tab and make sure the spreadsheet is an “Unprotected Sheet.”4. Select “Design Mode” in the “Developer” tab.5. Right-click on the drop-down box and select “Delet...
How to Make an Excel Spreadsheet Expire
1. Open Microsoft Excel, go to the “File” menu and choose “Open.” Browse for the Excel file that you want to make expire and double-click the file name to open it.2. Press “Alt F11” to launch the Visual Basic Editor from Excel. Use either “Ctrl R” to switch to the “Project Explorer” window or go to the “View” menu, point to “Other Windows” and choose “Project Explorer” from the list of options.3. Right-click “ThisWorkbook” in the “Project Explorer” window. Select “View Code” from the list of available options.4. Type the code that makes the spreadsheet expire into the code box provided....
Thursday, April 11, 2013
How to Calculate Cells in Excel 2007
1. Open Microsoft Excel and create a worksheet with the data you want to calculate. Place your cursor in an empty cell below or beside the column you want to calculate.2. Select the 'Formula' tab from the Ribbon and click on 'AutoSum' under the 'Function Library' group. To add all the numbers in a column, click on the 'AutoSum' button. Excel 2007 will select the calculated cells on the worksheet for you.3. Press the 'Enter' key to accept the calculation or manually select the cells you want to calculate, then press the 'Enter' key.4. Repeat the calculation for additional columns or rows,...
How to Convert Quicken to Excel 2003
1. Open the 'Report' menu from the top of the Quicken window.2. Select 'Reports and Graph Center.' Choose the information that you want to export to Microsoft Excel. Specify the start date and end date of the information you want to export. Quicken will turn that information into a report that will open on screen.3. Click the 'Copy' button in the Quicken toolbar. This will copy all of the data contained in your Quicken report to the Windows clipboard.4. Open Microsoft Excel 2003 on your computer. Select 'New' and 'Blank Spreadsheet' to create a new blank spreadsheet on screen.5. Use...
Subscribe to:
Posts (Atom)