How Can I Put Text a Formula Into the Same Cell in an Excel Spreadsheet?

Test the theory
1. Open a new workbook or spreadsheet and click in cell A1. Type the number 2.
2. Click in cell A2 and type the number 2 there.
3. Click in cell A3 and type:=SUM(A1,B1)
4. Press 'Enter' or click elsewhere on the spreadsheet and the cell will show the number 4 (as this is the sum of 2 2). Note that the function bar (the long white strip next to the 'fx' symbol) still shows the formula '=SUM(A1,B1).'
5. In the function bar, place your cursor after the equal symbol and type:'The sum of 2 2 is 'Include both quotation marks and the space after 'is' but no other spaces.The complete formula should read='The sum of 2 2 is 'SUM(A1,B1)
6. Click anywhere else on the table and cell A3 will now show: 'The sum of 2 2 is 4.'

Read more ►

How to Format Numbers in Excel 2003

1. Open your Excel worksheet and select a group of cells. Press the left mouse button and drag over the cells.
2. Click 'Format' on the top menu bar. A list of options for formatting your worksheet will appear.
3. Click on the 'Cells' option. This will open a window of tabbed options for formatting cells.
4. Click on the 'Numbers' tab (it's the default tab). You will see a list of categories of numbers on the left and options for formatting them on the right.
5. Click on the category you want to format (Number, Currency, Accounting, etc.) and choose how you want these numbers to appear using the options provided on the right.
6. When you are done formatting, click 'OK.'

Read more ►

How to Drop Decimal Places Without Rounding in Microsoft Excel

1. Open a blank worksheet in Excel and type a decimal number in the A1 cell. Use this worksheet for practice before applying the procedure to an actual file.
2. Type the 'integer function' into cell B1 as follows: f=INT(A1). The integer function lops off the decimal value of a number leaving only the whole number digits to the left of the decimal place. The formula in cell B1 instructs Excel to find the integer value of cell A1 and place that value in cell B1.
3. Click any other cell in the spreadsheet to exit from cell B1. The cell will now display the integer value of the number in A1. For example, if A1 contains the number 10.54, cell B1 will display the number 10.
4. Type another decimal number in cell A5.
5. Copy cell B1 and paste it into cell B5 to put a copy of the integer formula in B5. Click out of the cell to show the integer value of A5 in B5. As you copy and paste the integer formula, Excel automatically adjusts the parameters to find the integer value of A5 rather than A1.
6. Use the integer function in an actual spreadsheet to drop the decimal values of a number and leave only the whole number.

Read more ►

How to Make Bullets in Excel Entries

Insert a Bullet to a Cell
1. Open the Excel worksheet.
2. Double-click the cell where you wish to insert the bullet symbol.
3. Press “Alt” and “7” using the numeric keypad on the keyboard. A black bullet appears in the cell. To create a bullet with a white interior and a black outline, press “Alt” and “9” on the numeric keypad. If you prefer a different bullet style, click the “Insert” tab on the command ribbon. Click “Symbol” in the “Symbols” group. Select a font. Select the bullet symbol. Click “OK” and “Close.”
4. Add more bulleted lines in the same cell by pressing “Alt” and “Enter.” The cell will contain a line break. Repeat the “Alt” and “7” or “Alt” and “9” keyboard shortcut to insert the bullet symbol on the new line.
Insert a Bullet to a List
5. Open the Excel worksheet that contains the list.
6. Add a bullet to a list in one cell by double-clicking the cell.
7. Place the insertion point on the line where you wish to insert the bullet.
8. Click the “Insert” tab on the command ribbon.
9. Click the blue “Symbol” button in the “Symbols” group. A chart with symbols displays.
10. Click the “Font” text box arrow. Select your preferred font. For example, “Arial Narrow.”
11. Scroll to view the symbols. For example, certain fonts display squares, diamonds, flags and arrows. Click your preferred bullet symbol.
12. Click “Insert.” Click “Close.” The selected symbol appears on the selected line in the cell.

Read more ►

How to Check Each Control of a Group in Excel VBA

1. Click the 'Developer' tab's 'Visual Basic' button to enter the VBA programming environment, then click the 'Insert' menu's 'Userform' item to create a new form on which to place controls. If the 'Developer' tab does not appear among your menu choices in Excel, you may need to turn on its display in Excel's options.
2. Click the 'Button' control on the tool box, then drag on the userform to create a button. Click the 'OptionButton' control from the tool box, then drag on the userform to create an option button. Right click this button and click 'Properties' to display a list of attributes for the control.
3. Click in the 'Enabled' row of the 'Properties' window, then type 'False' to indicate that the option button is unable to process input. Note that the command button, which you created in Step 2, is enabled by default.
4. Click the 'Frame' control on the tool box, then drag on the userform. Click the button control you made in Step 1, then press 'Control' and 'X' simultaneously to cut this control to the clipboard.
5. Click the 'Frame' control, then press 'Control' and 'V' simultaneously to paste the button inside the frame. Repeat the cut and paste with the option button to paste it into the frame as well. By placing both controls into the frame, you've made one group that contains both controls. You'll now write code that checks a property of each control.
6. Double click the userform to display the programming window, then paste the following program into the window. This program iterates through each control in the frame, reading the 'Enabled' property you set in step 3, and printing the value of that property.Private Sub UserForm_Click()Dim ct As ControlDim s As StringFor Each ct In Frame1.ControlsIf ct.Enabled = True Thens = ct.Name ' is enabled.'Elses = ct.Name ' is disabled.'End IfMsgBox sNextEnd Sub
7. Click the 'Run' menu's 'Run' command to display your userform, then click anywhere on the form that doesn't have a control. Your program will run, displaying message about the 'Enabled' property described in Step 3.

Read more ►

How to Stop Rounding in Excel

1. Open the Excel workbook that currently uses rounded numbers. Click on the affected worksheet.
2. Highlight the cell(s) that hold the numbers. Do so by clicking a single cell, dragging the cursor across several cells, clicking a row number or a column letter.
3. Right-click on the highlighted cell(s). Select 'Format Cells' from the menu, which opens the Format Cells dialog box.
4. Select the 'Number' tab. Click 'Number' in the Category pane. Press the up arrow next to the Decimal Places box to increase the number of digits after the decimal, such as '5' or '7' places after the point.
5. Click the 'OK' button to save the changes to number-rounding.

Read more ►

How to Plot a Titration Curve on Excel

1. Open a new worksheet in Excel, and create two column headings with the titles 'Titrant Amount' and 'pH Level.' Fill out the two columns with the data you have measured.
2. Highlight your entire data set, including your column headings, by clicking and dragging your mouse across it.
3. Click the 'Chart Wizard' button in the toolbar. Click the XY (Scatter) chart type to select it, then select a 'Scatter with data points connected by smoothed Lines' chart. Click 'OK'; Excel will generate the chart with the smoothed titration curve on top of the data series.

Read more ►

How to Unlock Spreadsheets

1. Click on the 'Start' button, and then click on 'All Programs.'
2. Click on 'Microsoft Excel.' The Microsoft Excel program will open.
3. Click on 'Review,' and then click on 'Unprotected Sheet.' You may be prompted to input your password if you used one to lock your spreadsheet.

Read more ►

How to Add a Footer in Excel 2003

1. Launch Excel 2003 and open the file to which you want to add a footer. Click once on the worksheet.
2. Click the 'View' menu and select the 'Header Footer' option. This action will launch a separate dialogue window.
3. Click the 'Header Footer' tab on the Page Setup window. Click the 'Custom Footer' button. This action will launch another dialogue window.
4. Click once in one of the three available footer sections (left, center and right). Type the desired text in any of the fields or use the appropriate buttons to add the date, page number or other spreadsheet information, as desired.

Read more ►

How to Uninstall an Excel 2007 Add

1. Start Microsoft Excel 2007.
2. Click the Microsoft Office Button located in the upper left corner.
3. Click on 'Excel Options' and choose 'Add-Ins.'
4. Choose 'Excel Add-Ins' in the 'Manage' box and click 'Go.'
5. Clear the check box next to the add-in or add-ins you wish to uninstall in the 'Add-Ins available' box. Press 'OK' when finished.
6. Close Excel and all other programs.
7. Open the 'Control Panel' from the 'Start Menu' and double-click the 'Programs/Programs and Features' icon (Vista) or the 'Add/Remove Programs' icon (XP).
8. Choose Microsoft Excel from the list and click 'Change.'
9. Follow the onscreen instructions to select the correct add-in and uninstall it from the list.

Read more ►

How to Create Multiple Formulas for the Same Space in Excel

Parenthetical Nesting
1. Locate the cell in which you would like to create multiple formulas.
2. Press the equal button on the keyboard to start a formula in that cell.
3. Combine multiple formulas into one nested formula using parenthesis organization. It is often necessary in Excel to arrive at a formula result after the processing of several intermediate formulas. While these could be split into individual cells, Excel allows many formulas to be combined into one. For example, if one formula requires that a cell range be added together, and another formula must subsequently multiply the sum by a constant, write the combined formula as '=(sum(a1:a15))*15' where the 'a1:a15' represents the cell range and '15' the constant multiplier.
4. Combine arithmetic formulas together into one formula using the standard order of mathematical operation. For example, if you need two separate formulas to calculate the products of two sets of numbers, and a third formula to find the difference in these two outcomes, combine them all in a simple formula as '=a1*3-a2*6'. This could be split into three formulas, but by using standard order of operation, the multiplication is handled first for each product before the subtraction is calculated.
'IF()' Function
5. Press an equal sign in the cell where you would like to create multiple formulas.
6. Type 'if(' to begin an 'IF()' function. These functions allows multiple separate formulas to be run depending on conditions. You can have one cell house at least two formulas that do not interact with each other or depend on each other's results.
7. Determine the condition for the 'IF()' statement. For example, perhaps you wish to calculate a number by another if that number is positive, but calculate it by a different number if the number is negative. Type the condition next, such that the formula currently reads '=if(a1>0', where 'a1' is the cell that determines which formula to use. Type a comma in the formula before proceeding.
8. Type the formula that will occur if the condition is true. The 'IF()' statement will thus currently read '=if(a1>0,a1*10' where 'a1*10' represents one of the two formulas you will include in this one single overall formula.
9. Type a comma followed by the second formula that is run if the condition is false. Close the formula with an ending parenthesis. The formula may read '=if(a1>0,a1*10,a1*12)'. The two formulas that are included in this statement are 'a1*10' and 'a1*12' based on the outcome of the test, 'a1>0'.

Read more ►

How to Remove the Blue Titlebar From UserForm in Excel 2003

1. Launch Microsoft Excel 2003. Press the “Alt” and “F11” keys on your computer keyboard at the same time to launch the Microsoft Visual Basic Editor application inside Excel.
2. Click “Insert” in the main navigation menu. Select “UserForm” from the drop-down menu.
3. Double-click the “UserForm1” window to open the code window. Highlight and delete any code in the window.
4. Paste the following code into the window:Option ExplicitPrivate Sub UserForm_Initialize()Call RemoveCaption(Me)End Sub
5. Click “Insert” in the main navigation menu. Select “Module” from the drop-down menu.
6. Paste the following code into the Module window:Option ExplicitPrivate Declare Function FindWindow Lib 'User32' _
Alias 'FindWindowA' ( _
ByVal lpClassName As String, _
ByVal lpWindowName As String) As LongPrivate Declare Function GetWindowLong Lib 'User32' _
Alias 'GetWindowLongA' ( _
ByVal hwnd As Long, _
ByVal nIndex As Long) As LongPrivate Declare Function SetWindowLong Lib 'User32' _
Alias 'SetWindowLongA' (ByVal hwnd As Long, _
ByVal nIndex As Long, _
ByVal dwNewLong As Long) As LongPrivate Declare Function DrawMenuBar Lib 'User32' ( _
ByVal hwnd As Long) As LongSub RemoveCaption(objForm As Object)Dim lStyle As Long
Dim hMenu As Long
Dim mhWndForm As LongIf Val(Application.Version)
mhWndForm = FindWindow('ThunderXFrame', objForm.Caption) 'XL97
Else
mhWndForm = FindWindow('ThunderDFrame', objForm.Caption) 'XL2000
End If
lStyle = GetWindowLong(mhWndForm, -16)
lStyle = lStyle And Not HC00000
SetWindowLong mhWndForm, -16, lStyle
DrawMenuBar mhWndFormEnd SubSub ShowForm()UserForm1.Show FalseEnd Sub
7. Click the “x” button in the top right-hand corner of the Visual Basic Editor window to close the application and all windows. You don’t need to save the contents of the code boxes.
8. Click “Tools” in the main menu. Select “Macro” followed by “Macros.” Select “ShowForm.” Click the “Run” button. The Excel user form now displays without the title bar.

Read more ►

How to Modify Microsoft Excel

Microsoft Excel 2007
1. Modify Excel 2007 by changing the Quick Access toolbar, Themes and Styles to meet individual needs. Right-click on the three default buttons (\'Save,\' \'Undo\' and \'Redo\'), and select \'Customize.\' A two-pane window will open.
2. Select commands for the Quick Access toolbar. The left pane accesses all available Excel commands; the right pane shows the existing three buttons. Highlight a command and press the \'Add\' button to move the command to the Quick Access pane. Controls are available to move commands up and down, add the separator bar creates a group and organizes commands to meet individual needs. Only one row is possible. When finished, click \'OK.\'
3. Modify the Quick Access Gallery. From the Home Tab, the Quick Access Gallery shows a number of default styles of font weight, size, color and backgrounds. Customize styles by right-clicking on any style and selecting \'Modify.\'
4. Locate and modify Themes on the Page Layout tab. Customizing Themes adds significant flexibility for spreadsheet design in terms of colors, fonts and styles. Colors, Fonts and Effects can be individually modified, then three modified features are saved as a group in a Theme for easy future access.
5. Select the \'Fonts\' button. A window appears with font selection boxes for \'Heading\' and \'Body.\' Select the desired font pair, add a name for the pair and click \'Save.\' In the future, when the Font button is clicked, this pair will show in the \'Custom\' grouping. Creating a font pair automatically changes all of the default styles in the Quick Access Gallery to the theme's body and heading fonts.
6. Modify theme colors by pressing the \'Colors\' button and choosing \'Create new Theme colors\' from the very bottom of the drop-down menu. A window will open, showing the current theme colors for different aspects of the spreadsheet. Colors can be selected from drop-down menus. Two interactive graphics will show the results of the colors selected. The color grouping can be named and saved for future use.
7. Select an effect to be the default with the new colors and fonts. Then press the \'Theme\' button and select \'Save current Theme\' at the bottom of the drop-down window. Give it a name; it will appear in the Custom grouping in the future. Changing the spreadsheet Effects is not possible as part of the Themes. Graphic features can be modified individually when used in the spreadsheet.
Excel 2010
8. Right-click on the Ribbon and select \'Customize the Ribbon.\' Here you can select commands, place them in a new or existing Group, then add them to existing or new Tabs.
9. Use the same instructions from Section 1, Step 2 to modify the Quick Access toolbar. Select commands for the toolbar to speed program usage. When you are finished with the Ribbon and Quick Access toolbar, there will be a command to \'Import\' or \'Export\' both the Ribbon customization and the Quick Access toolbar customization. \'Export\' creates a back-up copy to be placed in a folder that is somewhere other than \'\\Programs\\Microsoft\\Office.\' This ensures that the back-up does not get erased if Office needs to be reinstalled.
10. Restore a lost Ribbon or Quick Access toolbars by importing them from the Customize screen. Both the Ribbon and toolbar modifications are saved in the same export file.

Read more ►

How to Convert Inches to Millimeters in Excel 2003

1. Enter your measurement data (in inches) into Excel, and label the column so that you know what units the data are in (for example, 'Length (inches)'). Here you can assume that the first data point is in A2, and the rest follow in the same column (A3, A4, A5).
2. Label the next column so that you know that the data is expressed in millimeters (for example 'Length (mm)').
3. Enter the following formula in cell B2:=CONVERT(A2,'in','mm')This tells Excel to look up the value in cell A2, and convert it from inches to millimeters.
4. Copy and paste this formula down so that all your data are converted. Excel will automatically look up the correct cell, so the formula in B3 will be converting the value in A3, the formula in B4 will be converting the value in A4, and so on.

Read more ►

How To: Custom Name for the X Y Axis in Excel 2007

1. Open your Excel document and click on a chart to edit it.
2. Click the 'Layout' tab on the Microsoft Office Ribbon at the top of the Excel window.
3. Click the 'Axis Titles' drop-down menu on the Layout tab, then select 'Primary Horizontal Axis Title' or 'Primary Vertical Axis Title' and click on a display option. For example, click 'Horizontal Title' to display the axis title horizontally.
4. Type a name for the axis in the 'Axis Title' text box and press 'Enter.'

Read more ►