How to sort rows in Excel 2007
By default, you can sort columns easy in Excel 2007 (and other Excel versions). But what to do when you need to sort rows? Of course, you can do that manually but Excel 2007 can do that for you, too.
Sellect rows you want to sort.
In Ribbon, sellect Data card.
In "Sort & Filter" chose "Sort".
In Sort window, click Options button.
In "Orientation" chose "Sort left to right" radio button.
Click OK.
In Sort window with drop-down menus you can chose order and way you would like to sort rows.
Click OK.
Labels: Excel
Subscribe in a reader
What is my IP address
You would like to know what is your IP address when you are connected on the Internet? You can get your answer on several different ways. You can go to whatismyipaddress.com and you'll see your IP and where are you on Google map. But if you need more information you can go to Start - Run, than type CMD and press ENTER. There, just type
"ipconfig/all" (without quotes) and press ENTER. You will get more than IP address, you'll see full profile of your connection like on image bellow:
Labels: internet
Subscribe in a reader
How to make folder private
If you are not the only user on your computer, you can make some forlders private and only when you log in with your username you can see them. This option is only available for folders included in your user profile. Folders in your user profile include My Documents and its subfolders, Desktop, Start Menu, Cookies, and Favorites. If you do not make these folders private, they are available to everyone who uses your computer.
Open My Computer. Then, double-click the drive where Windows is installed (usually it's drive (C:), unless you have more than one drive on your computer). Double-click Documents and Settings folder. Open your user folder. Right-click folder in your user profile you want make private, and then click Properties. On the Sharing tab, select the Make this folder private so that only I have access to it check box. When you make a folder private, all of its subfolders are private as well. For example, when you make My Documents private, you also make My Music and My Pictures private. When you share a folder, you also share all of its subfolders unless you make them private.
Labels: folder, private, sharing
Subscribe in a reader
Dont type http
While typing the website URL address in Internet Explorer of Mozilla Firefox url bar, there is no need to bother with typing the http://. All you need to do is start typing the WWW. Both Firefox and Explorer will add http:// in automatically when you start typing. For some websites you don't even type WWW, just what's after www. That other trick depends on website, although, so on some sites it won't work. But first tip for http will fork for all websites.
Labels: http, internet, www
Subscribe in a reader
How to email a group of contacts in Gmail
Another interesting and useful Gmail option is possibility to email a group of contacts . And that you can do on this way. Go to "Contacts". Than click on Group you would like to e-mail. On "Select" click "All". Or select just contacts you want to email. When contacts are selected, on right side just click "Email". Gmail will automatically redirect you to new message with field "To" filled. That's if you would like to everyone who receive this message see who else you mailed message. If you don't want that, copy addresses from "To" field to "Bcc" field and after that, leave just one address in "To". Than you can write Subject and message body and send it.
Labels: gmail
Subscribe in a reader
Gmail - How to add contact in group
You need to add some email adress (contact) in your Gmail group (eg friends). And that contact is only in suggested contacts and you don't see Group menu on right side in Gmail. You need first add that suggested contact to My contacts or into Most contacted. Go to Suggested contacts, check particular check-box infront that e-mail adress and click Move to my contacts on right. Now, go to My contacts, check box by adress, click Groups menu right, and Add to group you want.
Labels: contact, gmail
Subscribe in a reader
How to merge rar files with Winrar
How to merge rar files with Winrar?
You have several rar files (file1.rar, file2.rar, file3.rar) you downloaded from internet and now you have to merge them into one file. First all that files must be in one folder. Do right click on file1.rar and go to Extract here. Chose folder what you like and extract. If you get pop up while extracting, like this:
that means you need password to merge files. Go to that page where you downloaded part rar files and you will see password there.
Labels: download, files, merge, rar
Subscribe in a reader
How To Copy CD
To make a copy of a CD, you'll need a master to copy,
a blank disk, a CD-RW drive, and the proper software.
Most computers now include either a CD-RW or DVD-RW
drive. If not, you can purchase the appropriate drive reasonably cheaply.
Check out online prices or nip in to your local computer store for advice.
If you have a DVD-RW drive, you'll be able to copy
both CDs and DVDs. The rate of copying will vary,
with 4X being the slowest and up to 48X being the
fastest at the moment. If your drive supports 48X, you can duplicate
a CD in a matter of minutes.
Once you have the CD-RW or DVD-RW drive and some
blank CD-R media, all you need is the software to
duplicate. There is a huge range of CD buring software from freeware
to commercially available packages such as Nero. You will be spoiled for choice!
Once you have everything set up, just run the
software and create your disk. You can copy many
types of media, including pictures, video, audio,
and even data from your computer to a CD. Depending on what
you want to copy, all need to do is select it from the
software menu then sit back and let it rip.
You can back up just about anything - the
choices are entirely up to you.
Article Source: http://www.kokkada.com
For further information on CD Duplication Visit www.cdduplicationweb.com right now!
Labels: cd-rom
Subscribe in a reader
Change the default custom dictionary in MS Word
Word has simplified the way you work with custom dictionaries.
You don't need to use Notepad to make changesIn previous versions of Word, you opened a separate text editor, such as Notepad, to work with custom dictionary content.
In Word, you don't have to leave your document environment to make changes to your custom dictionaries. Instead, you use a simple, streamlined dialog box that's easily available by selecting the dictionary in the Custom Dictionaries dialog box, and then clicking Modify.
Dictionaries are clearly organized by languageWhen you create or install a custom dictionary, you can associate a particular language with it so that Word only uses the dictionary when you check spelling of text in that language.
The dictionaries are then grouped by language in the Custom Dictionaries dialog box, making it easy to locate and switch between them.
You can quickly change the default custom dictionaryIf you use one custom dictionary more than others, you can quickly make it the default dictionary directly from within the Custom Dictionaries dialog box. The default custom dictionary is the one that words are added to when you select Add to Dictionary during a spelling check.
Labels: Microsoft Office, Word
Subscribe in a reader
Make business cards in MS Word
You can quickly create attractive and professional business cards in two ways using Word:
* Use ready-made business card templates from the Microsoft Office Online Templates Web site.
* Create your own business cards from scratch with the Envelopes and Labels dialog box.
Choose the right paperYou can either have a professional printer print your business cards or you can purchase paper and print them yourself at home. For home printing, Avery® is a popular do-it-yourself brand and provides standard business card paper: 2" X 3.5" cards on 8 1/2" X 11" heavyweight cardstock sheets. The tiny perforations in the sheets allow you to separate your business cards easily with professional results.
If you choose ready-made business cards from the the Microsoft Office Online Templates Web site, look for the Avery product number listed with the template. If you use the Envelope and Label feature in Word, the dialog box shows the product numbers for the Avery business card size you need.
Choose the business card paper you want from the Product number list. The Label information area to the right shows a description of each paper or label type you select.
Work with a ready-made templateIf you start with a template to make your business cards, all you need to do is change the default text to match your company and contact information. In just a few minutes, you'll be ready to print your cards.
Work from scratch using the Envelopes and Labels dialog boxUsing the Envelopes and Labels dialog box, you can either print directly or insert your business cards in a new document for later use.
To make and print your business cards
1. On the Tools menu, point to Letters and Mailings and then click Envelopes and Labels.
2. Click the Labels tab, and in the Address box, enter the company and contact information you want to display on your business card.
3. Right-click to show the shortcut menu, and then choose the formatting and alignment options you want.
4. Under Print, leave the default selected, Full page of the same label. This allows you to print multiple business cards on a perforated, heavyweight cardstock sheet by Avery.
5. Click Options, and under Printer information, choose the printer you want.
6. Under Label products, leave the default selected, Avery Standard.
7. Under Product number, choose the business card number you want, and then click OK. If the product number you want is not listed, one of the listed labels still may be the size paper you want.
8. In the Envelopes and Labels dialog box, do one of the following:
* To print one or more business cards, insert your sheet of Avery heavyweight cardstock into the printer and then click Print.
* To save your business card for later use, click New Document, and then click Save on the Standard toolbar.
1 Address box: Enter your contact information. Using the shortcut menu, you can format and align your text.
2 Print button: Click to print your business cards directly from this dialog box.
3 New Document button: Click to insert your business card information into a Word document for later use.
4 Options button: Click to choose the type and size of Avery paper for your business cards.
5 Label area: View the paper type and size based on your selection in the Label Options dialog box.
Labels: Microsoft Office, Word
Subscribe in a reader
