Excel

Browse » Home » All posts

Saturday, September 15, 2012

How to Use a Calendar in MS Excel 2010 Cells

1. Open Microsoft Excel 2010. A new spreadsheet will open. Click on the Office Button, followed by Open. Select your file by double-clicking on it. It will open up on your screen.
2. Click anywhere on the spreadsheet. Click 'Insert' on the toolbar, followed by 'Object.' Click 'Create from File', followed by 'Browse.' Select your calendar image file. Click 'Insert', followed by the 'OK' button. Your calendar image will show up on your spreadsheet.
3. Refer to your calendar as you enter your equations into your spreadsheet cells or simply input data, such as email addresses or names. Once you have finished referring to the calendar, simply delete it by clicking on it and pressing the 'Delete' button.

How to Use an Excel Equation

Basic Equation Entry
1. Launch Microsoft Excel 2010.
2. Activate the software over the Internet if prompted.
3. Click in any blank cell and type the number '15' into the cell and press 'Enter' to save the entry and move to another cell. Alternately press the 'Tab' or any arrow key or click the mouse in a new cell to save the entry and move to a new cell.
4. Type the number '5' into another blank cell and press 'Enter.'
5. Type the 'Equal' sign ('=') into a blank cell and click once on the cell with the number '15' in it. Click the 'Plus' sign (' ') and click once on the cell with the '5' in it. Press 'Enter' to save the formula and notice that the answer to '15 5' is displayed in the cell that contains the equation.
Using Built-In Functions
6. Launch Microsoft Excel 2010 and enter some sample data into a few of the cells in a blank workbook.
7. Click on the cell that will contain the answer to the desired equation.
8. Click the 'Formulas' tab on the toolbar.
9. Click 'Insert Function' from the 'Function Library' on the 'Formulas' tab.
10. Click the 'Select a Category' pull down menu to choose the general category of equation required.
11. Scroll down if necessary to find the desired function in the 'Select a Function' list. Click once on the function name and click 'OK' to bring up the formula dialog box.
12. Click once in the cell that contains the information required for the first argument listed in the 'Function Arguments' dialog box. Click the next box in the 'Function Arguments' dialog box to save the first argument and change the focus to the second argument in the equation.
13. Click once in the cell that contains the information required for the second argument listed in the 'Function Arguments' dialog box.
14. Click 'OK' if all of the necessary arguments have been entered into the 'Function Arguments' dialog box. Notice that the cell containing the formula will now display the results of the equation.

How to Customizing the Excel Status Bar

1. Right click anywhere on the Excel status bar to bring up the 'Customize Status Bar' window.
2. Click on the left side of the Customize window next to the items that you want to add or remove from the status bar. Any field that has a check mark next to it is active and will show up on the Excel Status bar. Remember that many of the items on the list, like caps lock or permissions, will only show up on the status bar if they are turned on, so placing a check next to them might not show any immediate results.
3. Click anywhere outside of the Customize window to finish customizing the status bar and return to your work. The status bar is not bound to the worksheet, so the changes you made to the status bar will remain even in a new project.

How to Shrink Columns in Microsoft Excel 2003

1. Select the column you want to shrink. Left-click on the column letter to activate and select that column.
2. Shrink the column using the column width menu. Right-click on the activated column and select “Column Width.” Enter the desired column width in pixels and then click 'OK' to change.
3. Select the column you wish to shrink manually. Left-click on the column letter that you wish to shrink manually to activate that column.
4. Shrink the column manually. Hang the cursor over the edge of the column borders at the top of the column until an arrow appears. Then left-click and hold as you drag the column to shrink it.

How to Divide an Excel Spreadsheet

Freeze Panes
1. Double-click on the Excel file that you want to work with in order to open it up in the Microsoft Excel program.
2. Click on the cell that is below and to the right of the point where you want to freeze the panes. If you only want to freeze the top row or leftmost column, you don't need to select any cell.
3. Select the 'View' tab on the toolbar at the top of the Excel window. Find the 'Window' group within that toolbar. If your Excel window is very small, you may have to click on the 'Window' button to view all the buttons in the group.
4. Click on 'Freeze Panes' to open up a drop-down menu.
5. Select 'Freeze Panes' from the drop-down menu to cause everything positioned up and to the right of your selected cell to freeze in place. You can also choose 'Freeze Top Row' or 'Freeze First Column.'
Split Panes
6. Open the Excel file that you want to work on.
7. Select a cell anywhere in the middle of your worksheet. The panes will be created above and to the left of this cell, but the panes are easy to adjust so it doesn't have to be perfect.
8. Click on the 'View' tab and find the 'Window' group in the toolbar. Click the 'Split' button to divide the worksheet into four panes.
9. Double-click on either the horizontal or the vertical separator to remove it, if you only wanted to divide your worksheet into two panes instead of four.

How to Write a VBA Script

1. Open the Microsoft Office application that you want to write a script for. For example, open Microsoft Excel, Word or PowerPoint.
2. Click on the 'Developer' tab and then click on 'Visual Basic.' The Visual Basic Editor (VBE) screen will open. Alternatively, you can press the 'Alt' and 'F11' keys to open the VBE.
3. Click on the 'Insert' tab and then click on 'Module' to open a blank window. This is where you will type your script.
4. Type your script into the open window. You should start by typing 'Function [function name]()' if your script is a function or 'Sub [subroutine]()' if your script is a subroutine. Type the body of your script, then end with either 'End Function' or 'End Sub.' Use a function if you want to return something (like a value) or a subroutine if your script performs a task without returning anything (like formatting a document). Microsoft's website offers an extensive help section for writing VBA code.
5. Press 'F5' to run the script.

How to Use Excel Countif

1. Select the desired cell on the spreadsheet to display the calculated formula.
2. Type '=countif(' and select the range of cells to be evaluated by clicking the first cell, holding down the mouse button and dragging the cursor to the last cell before releasing the mouse button.
3. Type ',' and then identify the criteria for counting each cell's content as 'TRUE' for one point, making sure to enclose characters between quotation marks. For example, type 'purple' within quotation marks to count those cells containing the word; type '>9' within quotation marks to count the number of cells containing a number above nine; type A2 to count those cells containing information matching the contents in cell A2.
4. Type ')' and then press the 'Enter' key to complete the formula.

How to Create an Option Group in MS Excel

1. Display the Developer tab if it is not already visible. To turn this tab on, click the Microsoft Office Button (a round button with the mutli-colored Office logo) and choose 'Excel Options'. In the section called 'Top Options for Working with Excel', find the 'Popular' category. Place a check next to 'Show Developer Tab' in the Ribbon checkbox and click 'OK'.
2. Access the Developer tab and enter the 'Controls' section, then click the 'Insert' menu.
3. Select the 'Form Controls' option inside the 'Insert' menu, then click on the 'Option' button.
4. Click the cell on the spreadsheet that you want to contain the option button.
5. Launch the 'Properties' setting from the 'Controls' group in the 'Developer' tab.
6. Configure the settings for the new option button using the fields in the 'Properties' area. The 'Value' option allows a default state for the button that remains in effect until the user changes it. An option button is either on or off, so the 'Value' field accepts these two states as 'Checked' or 'Unchecked'.Each option button in a group carries a numerical value, with the first button equaling the value 1. The 'Cell Link' field copies the value of the option button as numerical data stored in any cell. Identify the cell using standard Excel cell referencing. For example, A1 is the upper left cell in a worksheet.
7. Add a checkbox to the option group in the same manner as the option button, if desired. In the 'Form Controls' option inside the 'Developer' tab's 'Insert' menu, click on the 'Checkbox' button.
8. Add more option buttons or checkboxes until the option group is complete.

How to Insert a Zip File Into Excel

1. Open the Excel file that you want to insert a Zip file into.
2. Select the worksheet you want to add the Zip file to and click the 'Insert' tab located in the Excel ribbon.
3. Click 'Object' from the 'Text' section of the ribbon. The 'Object' window will open.
4. Select 'Create from File' and then click 'Browse' so you can search for the Zip file you want to insert.
5. Click the Zip file you want to insert in your Excel workbook and then click 'Open.'
6. Click 'OK' to insert the Zip file you selected. The Zip file will show up as a folder icon in your Excel spreadsheet.

Friday, September 14, 2012

How to Create a Form in Excel 2003

1. Open Excel 2003 from your 'Start' menu.
2. Click the 'New' button that looks like a blank sheet of paper. Delete 'Sheet 2' and 'Sheet 3' by right clicking on the Tab, and then select 'Delete.'
3. Enter any questions and instructions you want in the corresponding cells.
4. Input any calculations you want for the form.
5. Change the font, color, highlighting and formatting to fit your preferences.
6. Save the form as a template. Print the form if you desire by clicking the 'Print' button.

How to Open Excel 2007 Files As Separate Windows

1. Open Microsoft Excel.
2. Click the 'Office' icon located in the upper-left corner of Microsoft Excel.
3. Click 'Excel Options.'
4. Select 'Advanced.'
5. Scroll down to 'Display.'
6. Check the box next to 'Show all windows in taskbar.'

How Do I Vertically Center in Excel?

Instructions
1. Type some text into a cell. Keep the cursor on this cell.
2. Select 'Format' from the top menu bar. The top menu bar includes all the commands.
3. Select 'Cells' from the drop-down menu.
4. Select the 'Alignment' tab from the 'Format Cells' menu that pops up. The alignment tab sits between the 'Number' and 'Font options
5. Select 'Vertical' from the 'Text Alignment' menu. Look for the 'vertical' option right below the 'horizontal' option.
6. Select the vertical alignment position you want for your text. For instance, when you click the 'vertical' option, a drop-down list will show four options: Top, Center, Bottom and Justify. If you want your text to rest along the top of the cell, click 'top. If you want the text to align in the very center of the cell and have a slight margin around all the edges, select 'center.' If you want the text to vertically along the bottom of the cell, select 'bottom.' If you want to distribute the text evenly throughout the cell, select 'justify.
7. Click the 'OK' button and save your preferences.

How to Alphabetize an Excel Spread Sheet

1. Highlight the data you want alphabetized (including the headers). If the employee payroll spreadsheet has columns for 'First Name,' 'Last Name,' 'Hours Worked' and 'Pay Drawn,' and you want to sort data in an alphabetic order by 'Last Name,' then you will have to highlight data under 'Last Name' as well as 'First Name,' 'Hours Worked' and 'Pay Drawn.' If you don't highlight data in other columns, i.e. 'First Name,' 'Hours Worked' and 'Pay Drawn,' then the information in the 'Last Name' would be alphabetized, while information in other columns would not be sorted, and you'd end up jumbling all the data.
2. Select 'Data' from main menu bar and click 'Sort.'
3. Select 'Header Row' in the small new window, if your top row is a header row and you do not want it alphabetized with the other rows. Select 'No Header Row' if otherwise.
4. Select the column header you want to sort data by in the 'Sort by' list of the same window. Here, we want to sort all information by 'Last Name.'
5. Select 'Ascending' if you want to sort this information in an ascending order.
6. Click 'OK' at the bottom of the window. The spreadsheet will be sorted alphabetically.

How Can I Sort Dates on an Excel Spreadsheet by Months Instead of Years?

1. Insert a blank column to the left of the column that has your date range. Go to the top menu and select 'Insert' and choose 'Columns.'
2. Click the first blank cell that is next to your date cell and type =TEXT( cell number,'MMDD'). For example, if your first date range is B4 and your date range is 03/25/1970, your formula would be =TEXT(B4, '0325').
3. Copy the cell with the formula and highlight the remaining blank cell and click 'Paste.' You will see just the months of your date range for each cell.
4. Sort your data by the new-month column. Go to the top menu; click 'Data' and then 'Sort.' The sort dialog box will pop up and continue to select the 'Expand the Selection'option to sort a series of columns or rows. Click 'OK' in the sort dialog box. Your data range is now sorted by month.

Thursday, September 13, 2012

How to Use Inches in Excel

1. Select the cells that you would like to format as inches. To do this, click and drag to highlight the cells. You can also click the letters at the top to highlight entire columns or the numbers on the side to highlight entire rows.
2. Right-click the selected cells to open the context-sensitive menu. If the cells contain numbers or are empty, one of the options will be 'Format.' Select 'Format.'
3. Select the 'Number' tab in the Format Cells screen to show settings for number cells. In most cases, this will be the default tab when the Format Cells screen opens.
4. Scroll down, and choose 'Custom' from the category list on the 'Number' tab. This will show options for setting up a custom format for numbers that is not provided by any other options.
5. Type '#0 [$ inches]' to format the selected cells as inches. If you would rather the cells show the abbreviation of inches, use '#0 [$ in].'

Subscribe to: Posts (Atom)