Saturday, June 18, 2011

How to Create a Password for an Excel File

1. Open Excel and search for a file that you want to protect. Open the file by clicking the 'Open' icon on the Quick Access Toolbar. Browse your computer and locate the file. Click 'Open.' Select a cell to lock. This cell will not be accessible by people who use this spreadsheet. Right click on the cell and select 'Format Cells.' Select the 'Protection' tab and make sure 'locked' is selected. Click 'OK.'2. Select the 'Review' tab on the ribbon. Select 'Protect Sheet.' Verify that the 'Protect worksheet and contents of locked cells' is selected. Remove the check from the 'Select locked...
Read more ►

How to Round a Number Using VBA

VBA Round Function1. Open the Excel 2010 worksheet that contains the VBA code you want to work with. Press 'Alt' and 'F11' to launch the VBA console.2. Click the module on the left side of the VBA console that holds the Excel macro you want to edit. Place your cursor on the code on the right side of the window, where you want to round a number.3. Enter the following code into the VBA console:x = round(y)Where 'x' is a variable or function name in your code and 'y' is a numeric variable or an actual number. You can also place a comma after 'y' and input the number of decimal places you want...
Read more ►

Friday, June 17, 2011

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...
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 comple...
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...
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...
Read more ►

How to Remove All Carriage Returns

Removing carriage returns manually - documents1. 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 - documents6. Open your computer's...
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...
Read more ►

Thursday, June 16, 2011

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...
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...
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 chang...
Read more ►

Wednesday, June 15, 2011

How to Display All Help Topics for Excel

Microsoft Office Website1. 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 Help4. Launch a Microsoft Excel window. Click 'File.'5. Click 'Help.'6. Click 'Microsoft Office Help' to launch the Excel help me...
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 docume...
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...
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...
Read more ►

Blogger news