Easy method to delete, remove duplicate cells, columns or rows in Excel 2003.
Change, Change, Change! Everybody is looking for a change this time of the year and we do have some major changes here at LyteByte. With...
How to have Multiple Desktops in Windows? Tutorial on Managing Multiple Desktops in Windows Vista SHARETHIS.addEntry({ title: "How to have...
How to clear private details off the browser automatically? Tips for Firefox, Internet Explorer, Google Search Toolbar...
How to create custom keyboard shortcut to open any application in Windows Xp and Windows Vista? SHARETHIS.addEntry({...
Easy method to delete, remove duplicate cells, columns or rows in Excel 2003.
Login as administrator in vista. Access administrator account from vista login screen. Enable hidden administrator account in vista.
Easy method to delete, remove duplicate cells, columns or rows in Excel 2003.
LyteByte Favicon featured in smashing magazine. Learn how to create simple favicon
Easy method to delete, remove duplicate cells, columns or rows in Excel 2003.
Easy method to delete, remove duplicate cells, columns or rows in Excel 2003.
Login as administrator in vista. Access administrator account from vista login screen. Enable hidden administrator account in vista.
Change, Change, Change! Everybody is looking for a change this time of the year and we do have some major changes here at LyteByte. With my semester end and Christmas break, we did not see any posts in the last two month but we are back again.

It came as quite a suprise when LyteByte’s Icon (Favicon) was featured in the Smashing Magazine today.
![]()
These are formed by the characters L and B. Small b is inside the L and they were turned upside down to form the number 97 but later I turned the angle to give an arrow look.
Long back I wrote an article on how to remove or highlight duplicates in Excel 2007? Though this option is much visible in Excel 2007, it is also possible in Excel 2003 with simple steps which are hidden inside. Also many have been looking for this option in Office 2003.
So, how to remove duplicates in Excel 2003?
As I mentioned in my previous post, I had to run a command as Administrator in Vista. First I was looking if I can access Administrator account from the login welcome screen but unfortunately it is hidden. But you can enable with a simple tweak to show the Administrator account in the welcome screen.
So, how to login as Administrator in Vista from Welcome screen?
Recently I wanted to do some actions in Windows Vista command line prompt but with elevated access as an Administrator. You may need this access to do actions like creating symbolic links etc.
In Windows Vista, when you connect to a wireless network for the first time, you can save those credentials so that it can connect to the same network automatically if available. But sometimes, if you have access to multiple wireless networks, you may want to change the priority in which it connects to different wireless networks.
So, lets see how to change the wireless network priority?
Sometimes it may be needed to calculate the average of a column of cells excluding all the zeros in any of the cells. It may be little tricky for novice Excel users if they don’t know how to use multiple formulas in conjunction. Though we can use same method in both Excel 2003 and Excel 2007, the later gives much easier new features that we can use.
So, lets see how to Average Non-zero values in Excel 2003 and Excel 2007?