Friday, June 17, 2011

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 ►

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

How to Break the Y Axis on Excel

1. Launch Excel and open a new workbook. For illustration purposes, type “10,” “12,” “13,” “500” in the first column from cells A1 through A4. If you created a chart from these values, the last value would overwhelm the chart, making the smaller numbers nearly indistinguishable.2. Highlight the column of numbers by dragging the cursor over them. Press “Ctrl-C” to copy them. Click cell “B1” and press “Ctrl-V” to paste them in the second column. Click cell “B4” and change the value from “500” to “50.” Adding this column allows you to customize the chart without changing the original data in...
Read more ►

How to Convert Multiple Excel Sheets to PDF

1. Create your Excel file sheets. Save all the sheets as a PDF by clicking the first sheet and holding down the 'shift' key and clicking on the last sheet. All sheets in between will be selected.To select some but not all sheets, click the first sheet you want to convert and hold down the 'ctrl' key and click the other sheets to convert.2. Click 'File' at the top of the Excel screen. Click 'Save As.'3. Name the file. Choose 'PDF' from the document type drop down menu.4. Click 'Save.' The Excel sheets have been saved as a P...
Read more ►

Tuesday, June 14, 2011

How to Print Avery Labels in Excel 2007

1. Navigate to Avery's Avery Wizard website.2. Click the 'Free Download' link in the center of the page. The download should start automatically. If it doesn't click the 'click here' link.3. Install Avery Wizard by following the on screen instructions.4. Open Word 2007, then click the 'Avery' tab.5. Click the 'Avery Wizard.'6. Follow the instructions in the wizard to select your Avery product. The wizard will prompt you to tell it where the data is saved. Click 'Merge data from existing file' and select the location of your Excel file.7. Preview your file and print the labels by...
Read more ►

How to Use Indirect in Excel 2007 to Link to Another Worksheet

1. Create a tab for links to external sources by right clicking on the tab named Sheet1 and selecting 'Create New Tab.' Name it 'Links.'2. Enter an '=' in the formula bar in the cell you want the data imported into, and then switch to the spreadsheet you're pulling data from, and click on the cell the data is in. This will create a formula in the form of ='[Accounting.xls]Sheet1'!$A$1 where '[Accounting.xls]' is replaced with the name of the spreadsheet, 'Sheet1' is replaced with the name of the tab in the work sheet you're pulling data from, and '$A$1' is replaced with the reference to...
Read more ►

How to Hide the X Axis on MS Excel

1. Click on the chart you want to edit in Excel.2. Click 'Axes' on the 'Layout' tab at the top of the Excel application.3. Click 'Primary Horizontal Axis,' then 'Non...
Read more ►

Blogger news