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...
Browse » Home » All posts
Wednesday, January 16, 2013
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)