1. Type the list items into cells in a column of the current worksheet or another worksheet. Name the list if you enter it into a different worksheet. Select the list and click inside the 'Name' box at the top left corner of the worksheet next to the 'Formula Bar.' Type a name for the list and press 'Enter.'2. Click on the cell in which you want to create a drop-down list. To enter the list into several cells, press and hold the 'Ctrl' key and click on each cell in which you want to use the list.3. Go to the 'Data' menu in Excel 2003. Click 'Validation' and go to the 'Settings' tab of the...
Browse » Home » All posts
Wednesday, March 28, 2012
Tuesday, March 27, 2012
How to Count All Rows With a Blank Cell in Excel 2007
1. Type '=COUNTBLANK(' in an empty cell.2. Highlight the column of data you want to calculate the number of empty cells.3. Press 'Ente...
How to Create a Report in Microsoft Excel 2007
1. Complete the data and calculations in your worksheet. Even if your data and calculations span multiple worksheets, you can pull the data together into one report.2. Roughly lay out how you want the report to look, including what you want in headers and footers, what text you want to be emphasized and what kind of graphical elements you want to include.3. From the Insert tab on the Office Fluent Ribbon, click 'Header Footer' in the Text group to design the headers and footers, which are the text that displays on every page of the report. This opens the Header Footer Tools ribbon, where...
How to Calculate Sample Variance Using Excel
1. Add the numbers in the first column of your Excel 2007 document. For example, add the numbers 100, 200, 300, 400, 500 and 600 in A2, A3, A4, A5, A6 and A7.2. For this example, click on the 'A9' cell. This is the cell where you will calculate the variance. When you calculate another variance, choose any cell at the bottom of the list of numbers you are using.3. Click on the 'Formulas' tab while you are in the 'A9' cell. Click on 'Statistical' on the drop-down menu.4. Click 'Insert Function' on the top left-hand side of the Excel spreadsheet. The 'Insert Function' window will pop open.5....
How to Add a Subtotal to a Pivot Table
1. Select your items, row, or column that you would like to subtotal in your pivot table report.2. Click 'Field Settings' in the 'Active Field' group on the 'Options' tab.3. Click 'Automatic' under 'Subtotals' to subtotal the outer row or column label.4. Select 'Custom' under 'Subtotals' to choose a function for an inner row or column lab...
Monday, March 26, 2012
How to Adjust Chart Fonts in Excel
1. Start Microsoft Excel 2007 and open a spreadsheet from your files that contains a chart in which you want to change the formatting of the font in that chart.2. Right-click on the text in the chart that you want to change the font or other formatting feature. The 'Mini Toolbar' will appear over the shortcut menu that appears. The 'Mini Toolbar' contains everything you need to adjust the chart font.3. Use the 'Font Type' drop-down list to choose a new font for the selected text. The 'Font Size' drop-down list allows you to change the size of the font that you have selected. The 'Increase...
How to Add a Counter in Microsoft Excel
1. Log on to your computer and open Microsoft Excel. Create a new spreadsheet.2. Label the columns in your spreadsheet by giving them descriptive titles. For instance, you could create a 'Description' column, a 'Price' column, a 'Quantity' column and a 'Total Cost' column for a spreadsheet used to track orders.3. Add a column and give it the title 'Count.' Go down to the bottom of the spreadsheet and type '=COUNT(firstrow:lastrow).' For instance, if the first cell in your spreadsheet that contains data is B2 and the last cell containing data is B50, your formula would read '=COUNT(B2:B5...
How To Enable Excel Macros
1. Launch Microsoft Office Excel, click the 'File' tab and click 'Options' to open the Excel Options Window.2. Click 'Trust Center' to open the Trust Center Window from the left pane of the Window.3. Click 'Macro Settings' and choose the option that says 'Enable all macros (not recommended, potentially dangerous code can run).' Click 'OK' and click 'OK' again to close the Windows.4. Exit Excel and restart it to enable all macr...
How to Select Multiple Non
1. Select the first range of cells by holding down the 'Ctrl' key, selecting the fist cell of interest with the left mouse button, and mousing over the range. When you have finished highlighting the range, release the mouse button but keep the 'Ctrl' key depressed.2. Move the cursor to the next range of cells you would like to highlight.3. Press the left mouse key to highlight the cell, then (keeping the left mouse button down) highlight the next area you would like to select. When finished highlighting, release the left mouse button.4. Repeat Step 3 for as many ranges as you would like...
How to Convert XPS to Excel 2003
1. Download a preferred converter software. Websites such as Free Downloads Center or File Buzz have XPS-to-Excel 2003 converter software available for downloading. Simply click on the preferred software and select 'Run' when prompted. Install the software when the download is complete.2. Open Excel 2003. Select 'File' and 'Open.' Browse through the files to find the XPS file. Select the file and click 'OK.' The software will convert the XPS file into a format that Excel 2003 can read.3. Select 'File' and then 'Save As.' Create a preferred name and change the file extension of .xps to the...
How to Un
1. Open the spreadsheet you wish to modify. Hold down the 'Ctrl' key, and tap the 'A' key twice. This should select all of the cells in the spreadsheet. Press 'Ctrl C' to copy the cells to the clipboard.2. Click on the Microsoft Office logo at the top-left corner of the Excel screen and click 'New'. Click the cell labeled A1 to select it, then press 'Ctrl V' to copy the cells into the worksheet.3. Press 'Ctrl S' to bring up the 'Save As' dialog box. Click the 'Tools' button, and select 'General Options'. Make sure the password box is empty. Delete the contents of the box if necessary. Click...
Sunday, March 25, 2012
How to Create Macro Buttons in Excel 2007
1. Open an Excel workbook that contains a macro.2. Click the arrow to the right of the Quick Access Toolbar to reveal a drop-down menu; from that menu choose 'More Commands....'3. Click the left-hand drop-down menu in the resulting window. Choose 'Macros.'4. Double-click a macro in the resulting list to move it into the 'Customize Quick Access Toolbar' list.5. Click the 'Modify' button below the list of Quick Access Toolbar buttons.6. Choose a button image in the resulting window, and type a new display name for the button, if you want. The button name appears in a tooltip when you...
How to Make a Chart on Excel With Coordinates
1. Open a new Microsoft Excel 2010 spreadsheet.2. Click on cell 'A1' and type in the header for the first half of your set of coordinates. This header will not appear on the spreadsheet, but may be of use for referencing purposes when you are entering your data. Click on cell 'B1' and type in the header for the second half of your set of coordinates. This header will wind up as the title for your chart, and will be displayed in the chart's legend as well.3. Select cell 'A2' and enter the first part of your first set of coordinates. This part of your coordinates will be plotted on the horizontal...
How to Spell Check on Excel 2007
1. Launch Excel 2007 and open the file you want to spell-check.2. Click the 'Review' tab at the top of the screen.3. Click the 'Spelling' button in the 'Proofing' section on the ribbon at the top of the screen. The 'Spelling' button is represented by the letters 'abc.'4. Click one of the options in the 'Spelling' window when Excel encounters a potential spelling mistake. You can choose 'Ignore' if the word is spelled correctly or you can select the correctly spelled word under 'Suggestions,' then click 'Change' to fix the misspelled word.5. Click 'OK' after all spelling mistakes have...
Saturday, March 24, 2012
How to Add Gridlines to an Excel Chart
1. Start Microsoft Excel 2007 and open a workbook from your files that contains a chart to which you would like to add gridlines.2. Click the chart you want to add gridlines to so it is selected. You can tell the chart is selected because it will have a light blue border surrounding it.3. Select the 'Layout' tab at the top of the Excel 2007 screen to display the settings in the 'Layout' ribbon. Find the 'Axes' group in the 'Layout' ribbon.4. Choose the 'Gridlines' button in the 'Axes' group of the 'Layout' ribbon and point to 'Primary Horizontal Gridlines' to display the horizontal gridline...
Subscribe to:
Posts (Atom)