Drop-down lists in Microsoft Excel
If you would like to make a drop-down list in excel, select a column of cells then go to: Data → Data validation. In the Allow: drop-down choose List, then select source and hit ok.
This tutorial works on all versions of Microsoft Excel.
Auto adjustment is locked on Samsung monitors
Another problem, solution of what i faced today. This tip will help you to unlock your monitor settings adjustment. It works with Samsung monitors, if you can't change any of the setting on your display using external buttons and get the message "Locked/Auto adjustment is locked" try holding menu button for a 5 seconds. Menu will dissappear and after that you can change your settings once again.
Extracting audio track from a video file
If you have a video file, and want to extract audio from it separately, i suggest this method:
You will need a VirtualDub (no installation required). After opening video file, go to File → Save WAV. That's it, you have a .wav audio file extracted!
This method still doesn't work with .wmv files though!
Showing certain number of items in archive category in WordPress
Probably many of you faced a lot of items in archive showing on first page and all other pages in wordpress.
To fix that go to you theme editor in wordpress, find sidebar.php, or left_sidebar.php/right_sidebar.php (depending on the theme you are using). Find something like that:
<?php wp_get_archives('type=monthly'); ?>
Replace with:
<?php wp_get_archives('type=monthly&limit=5'); ?>
Where 5 is the number of items to be displayed.
Wrong characters in application installations
Many of you probably were facing the problem, when you install a game or a software you can't read what is written there. It ussually happens when the application is not in english, but in your native language, for example russian.
To fix that in Windows 7 open Control panel, then "Region and language". Go to administrative tab and change system locale under "Language for non-Unicode programs". You should change it to your native language you should be using more often. After changing that you should restart to apply changes.
In Windows XP go to Control panel, Regional and language options.
Windows automatically restarts
I would like to describe this most common problem for windows users, solution is very simple. This hint probably shall save a lot of nerves and energy of people fighting this problem. If you don't know still i will tell you! This case is actually very common with windows XP, but i advise you to do it on all windows versions just in case.
So here we go:
In Windows 7: Right click "Computer", select properties (or press "win+pause/break"). Then go to "Advanced system settings" then click "Advanced" tab, choose Startup and Recovery Settings. Uncheck "Automatically restart check box under System failure. Click OK several times. That's it!
In Windows XP the process is almost the same. In Windows Vista it is actually the same.
Pages
Categories
Blogroll
Archive
- December 2011
- November 2011
- May 2011
- March 2011
- February 2011
- September 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010