How to Create Online Forms in Excel

1. Download a utility to convert Microsoft Excel spreadsheets into online HTML forms. Excel does not offer native support for interactive forms. Spreadsheets may easily be saved as HTML files, but the resulting web pages are static and do not allow data entry. A good utility program is not free, but free trials are available. Spreadsheet Converter is an excellent option for making online forms out of Excel. The program may be tried for 30 days with no charge.
2. Install the spreadsheet utility from the downloaded file. Spreadsheet Converter downloads as an '.exe' file. Double-click the file and follow the onscreen instructions until installation is complete.
3. Open Excel. Note the new menu at the top of the program window called 'SpreadsheetConverter.' All of the features of this utility are available through this menu.
4. Build the online form in Excel as you would like it to appear on the web page. For example, type a label of an input field, and leave an empty adjacent cell where the user will enter the data. Cell A1 could be labeled as 'First Name' and cell A2 as 'Last Name.' Cells B1 and B2 would be kept empty for the user response.
5. Code the user data entry cells in Spreadsheet Converter. This is necessary so the utility knows how the resulting online form should function. The program must be told which cells are for data entry. Click on a data entry cell and select the SpreadsheetConverter menu. Choose the appropriate option. The 'Mark Input Cell' command will identify the selected cell as a form field for data input.
6. Create a dropdown list menu for the online form, if desired. Many online forms offer pre-set choices for users to select. Pick a cell for this menu and choose the 'Dropdown List' item from the SpreadsheetConverter menu. A pop-up window will appear. Type in the name of each menu item and press 'OK.'
7. Convert the Excel spreadsheet to an online form. Choose the 'Convert' command from the SpreadsheetConverter menu. Press the 'Next' button on each screen until conversion is complete.
8. View the online form. SpreadsheetConverter automatically opens the HTML version of the Excel spreadsheet in Internet Explorer when the conversion is complete.

Read more ►

How to Create Summary Workbooks in Excel 2003

1. Launch Excel, and open all of the workbooks you want to summarize.
2. Click the 'New' icon to start your summary workbook. Format the cells as you would like them to appear before importing your data.
3. Go to the first workbook you want to include in the summary, and click the cells you want. Click 'Ctrl C' to copy them.
4. Return to your summary workbook, and click the empty cell where you want to include the data. Click the 'Home' button and select 'Paste' and then 'Paste Link.' Repeat Steps 3 and 4 with the data in all of your workbooks until your summary is complete.

Read more ►

How to Track History on Microsoft Excel

1. Click on the 'Review' tab in Excel 2007 or the 'Tools' tab in Excel 2003.
2. Click on 'Track Changes.'
3. Click on the 'Track changes while editing. This also shares your workbook' check box.
4. Click on any feature's check box that you want to track. For example, if you want to track who made changes, click on the 'Who' check box.
5. Click on the drop-down box to the right of the feature you checked in Step 4 to select what kind of changes you want to track. For example, click on 'All' changes.
6. Make sure the default option 'Highlight changes on screen' box is checked, then click on 'OK.' Any changes made to the document will be highlighted on your Excel spreadsheet.

Read more ►

How to Remove All White Spaces to the Right of a Word in Excel

1. Launch Microsoft Excel 2010. Open your spreadsheet by choosing 'Open...' from the 'File' menu or pressing and holding 'Control' ('Command' for Mac) and then pressing 'O.' Navigate to your Excel spreadsheet file and either double-click its name or click on it once and press the 'Open' button.
2. Click on the header of the first column of cells that contains text you need to edit. Go to the 'Home' tab and choose the 'Cells' group. Click on the arrow alongside 'Insert.' Click on 'Insert Sheet Columns' to create a new column to the left of the column you selected.
3. Click in the first cell of the column you just inserted. Type an equal sign and then the letter 'T.' Scroll down the list of functions that comes up till you reach 'Trim' and click on it. Click on the first cell in the column you need to edit. Your cell contents should say '=TRIM([cellnumber]),' where [cellnumber] is the column/row reference to the first cell you need to edit. Press 'Enter' to confirm your formula.
4. Click in the cell in which you just added the 'TRIM' function and place your pointing device cursor at the bottom right corner of the cell. Your cursor will change from an outlined plus sign to a black plus sign. Pull down on the lower right corner of the cell until you drag down to the bottom of the column of data from which you need to remove extra spaces. Let go of the pointing device when you have dragged all the way down. The data column you inserted should be filled with the same information that's in the original column to its right, but without the extra spaces.

Read more ►

How to Remove All Carriage Returns

Removing carriage returns manually - documents
1. Open your computer's word processing or text editor.
2. Open the document you want to remove carriage returns from by navigating to the directory containing the document and double clicking on the file's name.
3. Place your cursor at the end of the line of characters.
4. Press the 'Delete' key on your computer's keyboard until the line below the one you are on has moved up next to your cursor.
5. Repeat Steps 3 and 4 for each carriage return code you want to remove.
Removing carriage returns using automation - documents
6. Open your computer's word processing or text editor.
7. Open the document you want to remove carriage returns from by navigating to the directory containing the document and double clicking on the file's name.
8. Place your cursor at the end of the line of characters. Highlight the area with your mouse to the beginning of the next line of characters.
9. Press and hold the 'CTRL' key on your computer's keyboard. Press the 'C' key to copy the contents highlighted, if using Windows. If using a Mac, press and hold the 'Apple' key and press 'C.'
10. Click 'Edit,' 'Find Replace' to open the Find Replace utility.
11. Click in the box under the heading 'Find What' or 'Search For.' Press and hold the 'CTRL' key. Press the 'C' key to paste the contents highlighted if using Windows. If using a Mac, press and hold the 'Apple' key and press 'V.'If using Microsoft Word or OpenOffice, place '^p' in the 'Find What' or 'Search For.' box.
12. Leave the 'Replace With' box blank. Click on 'Replace All.' All carriage return codes are now removed from your document.
Removing carriage returns using automation -- spreadsheets
13. Open the spreadsheet you want to remove carriage returns from by navigating to the directory containing the spreadsheet and double clicking on the file's name.
14. Enter '=SUBSTITUTE(XX,CHAR(13),'')' in any blank cell of your spreadsheet. Replace the 'XX' with the 'Column' letter and 'Row' number of the cell containing the carriage return you want to remove. Note, the '13' is the ASCII code for a carriage return on both Windows and Mac systems.
15. Press the 'Enter' or 'Return' key on your computer's keyboard to execute the formula.
16. Change the 'Column' and 'Row' values for each cell you want to remove carriage returns from. Press the 'Enter' or 'Return' key to execute the formula.

Read more ►

How to Find and Replace Space Strings in Excel 2007

1. Open your Excel spreadsheet in Microsoft Excel 2007.
2. Hold the 'Ctrl' key and press 'H' to open the 'Find and Replace' window.
3. Click the 'Find what' field and press the space bar to enter a space in the field.
4. Enter the replacement text in the 'Replace with' field. This is the text that appears in place of the spaces. If you prefer to simply remove the spaces, then leave this field blank.
5. Click 'Replace all' to automatically replace all spaces in your spreadsheet. Alternatively, click 'Find next' to locate each occurrence, one at a time, and click 'Replace' to selective replace the spaces.
6. Click 'Close' to close the Find and Replace window.

Read more ►

How to Encrypt a Spreadsheet in Excel 2003

1. Create a strong document password. After opening the file you want to encrypt in Excel, click the 'Tools' item in the menu bar at the top of the screen, then select 'Options.' In the dialog box, click the 'Security' tab. Enter a strong password in the field labeled 'Password to open.' Strong passwords are at least 10 characters in length, not easy to guess, and include a combination of letters, numbers and symbols.
2. Set the document encryption type. Click the 'Advanced' button next to the password field you just completed. Excel presents you a list of cryptographic algorithm collections used to secure spreadsheets. Encryption of 128 bits or more is considered strong, but some encryption types only support 40 or 56 bits. Scroll down the list and click the 'Microsoft Strong Cryptographic Provider' option, then enter a value of 128 in the field labeled 'Choose a key length.' Click 'OK' to close the dialog box. Click 'OK' a second time to close the Options box.
3. Save your document. Click the 'File' menu at the top of your screen, then select 'Save.' Your Excel spreadsheet is now protected with a strong password and 128-bit encryption.

Read more ►

How to Use a Cell in Excel As a Checkbox

1. In Excel, click 'File' from the menu bar.
2. Click 'Options' from the left pane. The 'Excel Options' window will open.
3. Click 'Customize Ribbon' from the left pane.
4. Check the box next to 'Developer' in the 'Customize the Ribbon' section on the screen's right side. Click 'OK.'
5. Switch to the 'Developer' ribbon.
6. Click 'Insert' from the 'Controls' tab.
7. Click the check box icon under 'form controls.' You cursor will turn into cross-hairs.
8. Click on the cell you want to change into a check box. A box will appear there.
9. Drag the check box to align it with the cell. Change the box's label, which is 'Check Box 1' by default.
10. With the check box still selected, click 'Properties' from the Developer ribbon's 'Controls' tab. The 'Format Control' window will open, with the 'Control' tab selected.
11. Enter the cell address in the 'Cell link' box. Click 'OK.'

Read more ►

How to Reduce a Worksheet Size in Excel 2007

1. Open the Microsoft Excel 2007 file on your computer that contains the worksheet for which you want to reduce the size.
2. Click the 'Page Layout' button from the bottom of the application to switch to the Page Layout view.
3. Select the 'Page Layout' tab and then select the '1 page' option from the 'Width' drop-down menu in the 'Scale to Fit' group.
4. Select the 'Automatic' option from the 'Height' drop-down menu.
5. Click the 'Scale' drop-down menu to select a smaller scale size if you want to reduce the worksheet size even more. Click 'OK' to save your changes.

Read more ►

How to Display All Help Topics for Excel

Microsoft Office Website
1. Navigate to the Microsoft Office support website.
2. Locate and click 'Excel' in the list of applications under the 'Current Product Help' box.
3. Click 'All Categories' at the end of the list of Excel 2010 help topics.
Embedded Office Help
4. Launch a Microsoft Excel window. Click 'File.'
5. Click 'Help.'
6. Click 'Microsoft Office Help' to launch the Excel help menu.

Read more ►

How to Make a Duplicate Copy of a Word File

1. Launch Word and open the file you wish to duplicate.
2. Click 'File' to view the saving options.
3. Click 'Save as.' A box will open allowing you to choose a location for the duplicate file.
4. Locate the folder to which you want to save the duplicate document. You can browse your computer directory by clicking the folders and drives in the left or right pane.
5. Click the 'File Name' text box and type a new name for the duplicate file. You can also leave the file name the same so long as you save the file in a new folder.
6. Click 'Save' to create the duplicate document.

Read more ►

How to do a Fast Fourier Transform (FFT) in Microsoft Excel

1. Enable the ToolPak if you have not already done so. Click the 'Office' button, and then choose 'Options.' Click 'Add-In Options,' highlight 'Analysis ToolPak,' and press 'Go.' Highlight 'Analysis ToolPak' a second time, and then press the 'OK' button.
2. Open Excel and create a new spreadsheet file. Add the title 'Time' to the A column, followed by the titles 'Data,' 'FFT Frequency,' 'FFT Complex' and 'FFT Magnitude' to columns B through E respectively.
3. Input the data from your samples into the Data column. Make a note of the number of data points and the sampling rate used.
4. Write the time at which each data point was taken in the Time column. Determine this by dividing the total time by the number of data points.
5. Open the 'Data' tab, and then select 'Data Analysis.' Select the 'Fourier Analysis' option and press the 'OK' button. Set the input range as the information in the Data column and the output as the FFT Complex column.
6. Type the equation '=IMABS (E2)' into the first cell of the FTT Magnitude column. Drag the equation downward to fill every cell of the column. This equation creates real numbers, instead of complex numbers, in the previous column.
7. Fill column F with the corresponding data, from column A, point minus one. Create a separate cell with the equation '=(S/2)/(N/2),' replacing 'S' with the sampling rate and 'N' with the number of samples.
8. Enter the equation '=F2*SG$4' in the first cell of the FTT Frequency column. This time, drag the equation only to the halfway point in the column.
9. Create a graph, using the FTT Magnitude column for the y-axis and the FTT Frequency column for the x-axis. The graph displays the dominant frequencies as peaks.

Read more ►

How to Do Combination Charts in Excel 2007

1. Launch Microsoft Excel and open the spreadsheet containing data by selecting 'Open' under the Office ribbon, selecting the desired file and clicking the 'Open' button.
2. Check that the data is organized in columns, with the first column containing the categories and the second and third columns containing values.
3. Highlight all three columns by selecting the top of the first column and the bottom of the third column by clicking the mouse button and holding it down to highlight before releasing the mouse button.
4. Click the 'Insert' tab in the top toolbar and click the button for the desired chart type in the 'Charts' group (such as 'Column'). Note: additional options will be displayed for that chart type; select a thumbnail image for the desired presentation of the first data series (the second column).
5. Check that the chart is inserted on the same sheet as the data.
6. Click the second set of data on the chart from the third column (the second colored set of data).
7. Right-click the data series and select 'Format Data Series.'
8. Select the category in the left-hand frame for 'Series Options.'
9. Click the option for 'Secondary Axis' in the section, 'Plot Series On' and click the 'Close' button.
10. Click the 'Insert' tab in the top toolbar.
11. Select a chart type in the 'Charts' group for the selected data series (such as line). Note: additional options for the selected chart type will be displayed; select the thumbnail to present the data series in the third column.

Read more ►

How to Change the Default Font in Microsoft Excel 2007

1.
Click on the 'Office' button and choose the 'Excel Options' button toward the bottom of the menu.
2.
When the 'Excel Options' dialog box opens, make sure that the 'Popular' tab on the left is selected. In the center of the window you will see the font options. You can select the options you would like to become your new defaults.
3. When you have finished making your selections, click the 'OK' button on the bottom of the dialog box. Your choices will now be the new default font.

Read more ►

How to Change Text Based on CheckBox Value in Excel

1. Open the Excel 2010 workbook that contains the checkbox that you want to manipulate.
2. Click the 'Developer' tab at the top of the screen. Click the 'Design Mode' button in the middle of the ribbon. This lets you interact with your checkbox.
3. Click on the checkbox to select it. Then, click the 'Properties' button in the 'Controls' area of the ribbon. A small Properties window will open up. Take note of the entry in the 'Name' field at the top of this window, which is usually 'CheckBox1,' or something similar. This is the name of the object, and you will need to know it to write your code. Click the 'X' to close the Properties window.
4. Right-click the checkbox and choose 'View Code' from the pop-up menu. The VBA editor window will appear, with the line 'Private Sub CheckBox1_Click()' already entered into the editor. Place your cursor on the line directly beneath this first one.
5. Enter the following code into the cell:If CheckBox1.Value Then[A1] = 'XXX'Else[A1] = 'YYY'End IfChange 'CheckBox1' to your checkbox's name. Change 'A1' to whatever cell you want the checkbox to manipulate. Change 'XXX' to whatever text you want in the cell when the checkbox has a check in it, and 'YYY' to whatever text you want in the cell when the checkbox is blank. To have one of the options leave a blank cell, just remove the letters but leave the quotes in place.
6. Click the 'X' to close the VBA editor. Click the 'Design Mode' button to turn it off. You can now add or remove a check mark from the checkbox, and your desired cell's text will change.

Read more ►