http://www.whizblaze.com/blog Find answers to technical issues ! Wed, 18 Nov 2009 15:31:48 +0000 http://backend.userland.com/rss092 en 1. Remove formats wherever it is not necessary Removing colors, shading, and borders from the cells where is it not necessary would drastically reduce the size of a workbook. ( For example, the above picture shows borders even on empty cells.) Selecting Clear > All from Edit menu would help you ... http://www.whizblaze.com/blog/?p=14 If you have to select a long column of data, using the mouse can take a while. And if someone is sitting behind you in your office trying to help you with your spreadsheet, they really don't want to wait for you to select 1,000 cells with your mouse.  That's ... http://www.whizblaze.com/blog/?p=12 If clicking on hyperlinks within Internet Explorer does not open or ends up in error "This operation has been cancelled due to restrictions in effect on this computer. Please contact your administrator. ", follow this steps ( This procedure can be followed to deny or allow access to ... http://www.whizblaze.com/blog/?p=9 Often you might want to validate cell content in Microsoft Excel with a list of values. Say, only this content should the cell accept. E.g.: A cell should only accept the following names ôSam, Cathy, and Tomö. Most of us would know that, Data Validation is option to use. For those ... http://www.whizblaze.com/blog/?p=5 Text to columns Though I have heard about this feature, I never used it until I had a task of splitting up an address column. Microsoft ExcelÆs Text to column feature allows you to split data to multiple columns easily. LetÆs say you have thousands of names in format ôFirst, Last Nameö ... http://www.whizblaze.com/blog/?p=4 Is the text too long to fit in within the standard size a cell? Option 1: Adjust the column width. Double-click the left column border in the column header to set the column to Best Fit. (Or) Drag the left column border in the column header to ... http://www.whizblaze.com/blog/?p=3 There are situations where you can connect to your wireless network but will not be able to access Internet. This could be due to the following reasons: 1. DNS settings 2. Your Browser Settings. 3. Anti-virus / Firewall settings. 4. Rarely due to Virus/Trojan infection. DNS settings: DNS (Domain Name System) ... http://www.whizblaze.com/blog/?p=1