How to Add a Calendar Date Picker to an Excel Spreadsheet

1. Download the free 'Calendar' tool available at isamrad.com/ExcelCal/default.htm. This plugin is a standard Excel add-in program. It is offered as a compressed ZIP file which must be unzipped after download. Once the XLA file is placed into the Excel 'XLSTART' directory in the 'Program Files' folder of Windows, Excel will show a date picker icon next to cells that are already formatted as dates. Additionally, the date picker can be launched by right-clicking on any cell and choosing the 'Pick from Calendar' option. The applet also installs a toolbar button for the feature.
2. Activate a free 30-day trial of the Pop-up Excel Calendar created by Office Kit. This program offers a robust calendar interface that includes quick jumps to any month or year as well as shortcut buttons. Additionally, the program installs a unique calendar toolbar which features a quick launch for the Pop-up Excel Calendar as well as other features, including a settings button. The applet works on all major versions of Excel. If you are pleased with the demo, Pop-up Excel Calendar costs $20 as of February 2010.
3. Download the WinCalendar utility. The software comes in multiple versions, including a free option. The program is a robust date picker that displays multiple calendars simultaneously for quick selection of any date within a three-month period. Additionally it highlights holidays and offers user customization of new holiday entries. The calendar can be re-sized to suit the user's preference. It also functions in other Microsoft Office programs, or as a standalone program. The free version is functional but excludes emphasis of some holidays and limits the size of the pop-up interface. The free version also limits the number of entries that may be made.

Read more ►

How to Enter Formulas in Excel Divide the Sum of Several Numbers by a Number

1. Click on an empty cell in your spreadsheet.
2. Type an '=' sign.
3. Type the following formula into the cell: UM(A1:A10).
4. Replace 'A1:A10' with the cell locations of the numbers you want to add. In this example, the series of numbers is in cells A1 through A10.
5. Type a division sign '/' followed by the number you want to divide by. For example, if you wanted to divide the total of cells A1 to A10 by 3, type '/3.'
6. Press the 'Enter' key; Excel will perform the calculation.

Read more ►

How to Create a Flow Chart in MS Word

1. Open Microsoft Word, which automatically defaults to a blank portrait-oriented page on the screen. To change your flow chart to landscape orientation, click the 'Page Layout' tab at the top of the screen and click the 'Orientation' button directly below it. The page changes to landscape.
2. Type the name of the flow chart at the top of the page, such as 'Weather Closing Phone Tree.' Highlight the words, click the 'Home' tab at the top of the screen and change their appearance using the options in the 'Font' section of the ribbon/toolbar, such as font style and text color.
3. Click the 'Insert' tab at the top of the screen. Click the 'SmartArt' button on the ribbon/toolbar below it, which opens the 'Choose a SmartArt graphic' window.
4. Scroll through the different flow chart options, including vertical hexagons, triangles of different sizes and boxes and arrows in a horizontal line. The flow chart options in the 'Process' section of the window may be especially applicable to a flow chart.
5. Double-click a SmartArt shape group and it appears on the Word window. Enlarge the flow chart to fit the page by grabbing a corner and dragging it toward one of the edges of the Word workspace.
6. Click one of the '[Text]' words within the SmartArt flow chart shape and type the shape's information, such as a worker's name. Repeat this to fill the rest of the flow chart with labels for each shape.
7. Recolor the flow chart (optional) by double-clicking anywhere on it to bring up a new 'SmartArt Tools' toolbar. Click the 'Change Colors' button on the toolbar and hover your cursor over the options in the drop-down menu. As you hover over each group of colors, the flow chart changes. Click a color group to commit the change.
8. Click the 'File' tab, click 'Save As,' give the flow chart a name and save it to your computer.

Read more ►

How to Exit Out of Header Footer Option in Excel 2007

1. Add a header or footer. Click 'Header Footer' in the 'Text' area of the 'Insert' tab. Click on the document in the area marked 'Click to add header' or 'Click to add footer.'
2. Design the header or footer. Select preformatted options from the menu, type in your own text, or use a combination of menu items and typed text. When you finish the header or footer, click anywhere on the body of the document.
3. Change to Normal View. Click 'Normal' in the 'Workbook Views' area of the 'View' tab. You will leave header/footer mode and return to your worksheet.

Read more ►

How to Print Address Labels in Excel

1.
Open a blank worksheet in Excel. Go to the 'File' menu, click on 'Page Setup' and go to the 'Margins' tab in Excel 2003. In Excel 2007, go to the 'Page Layout' tab and click 'Margins.'
2.
Enter '0' in the Top and Bottom boxes. Change the margins in the left and right boxes to '.19.' Under Center on Page, select 'Horizontally' and 'Vertically.' Apply these changes by clicking 'OK.'
3.
Select cells A1 through A10 with the mouse. Go to the 'Format' menu in Excel 2003, point to 'Row' and select 'Height.' In Excel 2007, click 'Format' on the Home tab and click 'Row Height.' Enter '72' and click 'OK.' In the same manner, change the Column Width to 35. Repeat the steps in cells C1 through C10 and E1 through E10.
4.
Use the mouse to select the cells in B1 through B10. Change the width of the column to 1.29. Repeat with cells D1 through D10.
5.
Select all of the cells from A1 through E10 with the mouse. Click the 'Borders' drop-down on the Format toolbar in Excel 2003 or the Font group on the Home tab in Excel 2007. Click 'All Borders.'
6. Enter the names and addresses into the label cells. The cells in columns A, C and E are the label areas. Columns B and D are the margins between labels. Print onto the label paper.

Read more ►

How to Use the Transpose Function in Excel

1. Highlight the range of cells where you want the transposed data to appear. For example, if you want to transpose cells A1:A10 into a row in cells B1:K1, you would highlight B1:K1.
2. Go to the 'Formulas' tab and click on 'Insert Function.' Type 'Transpose' in the 'Search for a function' field and click on the 'Go' button. Select 'Transpose' from the 'Select a function' section and click 'OK.'
3. Highlight the range of cells you would like to transpose. In our example, we would highlight cells A1 through A10. The range will appear in the 'Array' field of the Function Arguments window.
4. Hit 'Ctrl,' 'Shift' and 'Enter' on your keyboard simultaneously. The transposed data will appear in the new location, which is B1 through K1 in the example.

Read more ►

How to Delete Shading From Alternate Rows in Excel 2003

1. Open the spreadsheet which contains the unwanted shading.
2. Click on the row number of one of the shaded rows. This will highlight the entire row. Ctrl-click on each row number where there is shading you want to delete.
3. Click on 'Format' on the menu then 'Format Cells.' Click on the 'Patterns' tab. Click the bar above the color palette that says, 'No Color.' This will delete the shading from alternate rows in Excel 2003.

Read more ►

How to Draw a Histogram in Windows Excel

Load the Analysis ToolPak
1. Open a new Excel spreadsheet. Click on the 'File' tab at the top of the screen, and then click 'Options' on the menu that appears.
2. Click 'Add-Ins' from the list on the left side of the Excel Options menu. Click the drop-down arrow next to the 'Manage' box at the bottom of the window. Choose 'Excel Add-Ins' from this drop-down menu, and click 'Go.'
3. Click the small box next to 'Analysis ToolPak' to place a check in the box. Click 'OK' to close this window.
Create the Histogram
4. Click on cell 'A1' and enter the title for the data that you want to use with the histogram. Then select cell 'A2' and enter your first value. Continue to enter values using the cells in column 'A' until you have added all of your data.
5. Click cell 'B1' and type in 'Bin Range.' This column of cells will contain the numbers that represent the number ranges that will make up the horizontal axis of your histogram. Remember that each bin number represents the top of the range of values that will be counted as part of that bin, so be sure to include the highest possible value for your data as part of the bin numbers. Enter the values starting at call 'B2,' and continue down the column until you have entered all your desired bin ranges.
6. Click the 'Data' tab at the top of the screen, and then click the 'Data Analysis' button on the far right side of the ribbon. Select 'Histogram' from the list of options and then click 'OK.' A small 'Histogram' window will appear.
7. Click in the blank next to 'Input Range' in the Histogram window. Click on cell 'A2' and hold down the mouse button. Drag your mouse down until you reach the last cell that holds data in column 'A'; then release the mouse button. Click on the blank next to 'Bin Range' and do the same thing as you did in column 'A,' but this time do it in column 'B' starting with cell 'B2.'
8. Select the radio button next to the output option that you desire. You can place the histogram somewhere on this worksheet, you can place it on a new worksheet within this workbook or you can place it in an entirely new workbook.
9. Place a check next to any of the bottom three options, if any apply to your desired histogram output. 'Pareto' will sort your data in descending order of frequency, 'Cumulative Percentage' will include another column on the histogram that has the cumulative percentages for your frequency data, and 'Chart Output' will display a chart of the histogram in addition to the standard table.
10. Click 'OK' to close the window and Excel will create your histogram.

Read more ►

How to Remove Multiple Duplicate Rows in Excel 2003

1. Open the spreadsheet and select the cells that may include duplicate rows. The values in the rows can be text or numbers.
2. Click the 'Data' menu, hover over the 'Filter' option and choose 'Advanced Filter' from the submenu.
3. Choose 'Copy to another location,' which leaves the original range of data intact, just in case.
4. Check the prepopulated 'List range' to confirm it's the range of data you want to filter of any duplicate values.
5. Choose, in the 'Copy to' field, the first cell to which you want to copy the filtered cells.
6. Place a tick mark in the box labeled 'Unique records only.' Click 'OK' to close the box and filter duplicates from the list of data.
7. Delete the original data when you're satisfied with the filtered results.

Read more ►

How to Make a 2nd Line on MS Office Excel

1. Click 'Start,' then 'All Programs.'
2. Click the 'Microsoft Office' folder, then click 'Microsoft Office Excel.' This will open a new workbook. To open an existing workbook, click the 'File' tab, then click 'Open' and browse to your file.
3. Click the cell into which you wish to add a second line.
4. Add the data for the first line, then press 'Alt Enter' to create a second line within the cell. You can continue to use 'Alt Enter' to add additional lines to your cell as well.

Read more ►

How to Add Data Labels 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 data labels.
2. Select the chart you want to add the data labels to by clicking it. The chart will be surrounded by a light blur border indicating it is selected.
3. Choose the 'Layout' tab at the top of the Excel 2007 screen to display the options in the 'Layout' ribbon. Locate the 'Labels' group in the 'Layout' ribbon.
4. Click the 'Data Labels' button in the 'Labels' group of the 'Layout' ribbon to display a drop-down list of options.
5. Opt for 'Center' from the 'Data Labels' drop-down list to display the data labels centered on the data points of your chart. 'Inside End' will display the data labels inside the end of the data points while 'Inside Base' will display the data labels inside the base of the data points.
6. Watch as the data labels are added to the selected Excel chart in the position you have chosen.

Read more ►

How to Add a Custom Menu to an Excel Toolbar in Excel 2003

1. Log on to your computer and open your Excel worksheet. 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 'Tools' in the toolbar. Hold the mouse over the arrow to expand the menu and select 'Customize'.
3. Add the functions that appeal to you by checking desired toolbars under the 'Toolbars' heading.
4. Click on the 'Commands' tab. Choose a category from the displayed list, then choose a command and drag it off the dialog box to the toolbar. Repeat as desired.
5. Delete a command by dragging the icon outside the toolbar and letting go of your left mouse button.
6. Determine whether you want a command by selecting the command under the 'Commands' heading, then choose 'Description'. This allows you to view a description of the command.
7. Close your 'Customize' window by clicking the 'X' in the left-hand corner of the window.

Read more ►

How to Multiply in Excel

Single Cell Multiplication
1. Select the cell where the answer will be. You can put a self-contained multiplication problem in one cell anywhere in a workbook and use it just like a calculator.
2. Start with the equals sign in the cell where the answer goes. This is the first step to tell Excel that the cell contains a math function.
3. Use the asterisk sign as the multiplication symbol. Like standard math, insert the asterisk between numbers in the equation with no spaces and hit 'Enter.' The cell should contain the solution to the multiplication problem.
Multiply an Entire Range of Numbers by Another Number
4. Decide what number to multiply the entire data set by and select a random cell in the workbook. This is only a temporary cell entry and is erasable after you complete the function. Enter the multiplier in this cell.
5. Select the cell containing the multiplier, right click and choose 'Copy.'
6. Choose the entire row or column of varied data to multiply. Right click the highlighted row and use the 'Paste Special' function, which brings up a sub-menu window.
7. Click the 'Multiply' option under the 'Operation' section and hit 'OK.' The multiplier now changes all of the data visible in the chosen range within the Excel workbook.

Read more ►

How to Restore the Default Settings in Excel 2007

Tools Menu
1. Log on to your computer and open Microsoft Excel 2007. Open a blank spreadsheet.
2. Click on the 'Tools' menu. Choose 'Customize' from the list of options.
3. Right-click on the menu you want to restore to its default settings. Choose 'Reset' to restore the menu to its original default settings.
Help Menu
4. Open Excel 2007. Click on the 'Help' menu.
5. Choose the 'Detect and Repair' option. Check the 'Restore my shortcuts while repairing' check box.
6. Click 'Start' to begin the repair process. Repairing Excel 2007 will bring it back to its original configuration.

Read more ►

How to Use Visual Basic to Add a Worksheet in Excel 2007

1. Click the Windows 'Start' button and select 'All Programs.' Click 'Microsoft Office,' then click 'Microsoft Excel.' The programming software opens.
2. Click the 'Office' button and click 'Open.' Click your Excel file name to open it in your software. Click the 'Development' tab and 'View Code' to open the VBA coding file for the spreadsheet.
3. Type the following code in your VBA code file:Set newSheet = Worksheet.AddnewSheet.Name = 'New Sheet'newSheet.ActivateThis code creates a new sheet and names it 'New Sheet.' The code then makes it the active sheet.
4. Click the 'Save' button and close the VBA code file. Close the file and reopen it to see a new sheet created in the file.

Read more ►