Cum sa cream o lista drop-down in Microsoft Excel

Advertisements

Pentru a introduce datele mai usor intr-un fisier Excel sau pentru a limita intrarile la un numar de itemuri definit deja, puteti sa creati o lista drop-down (vizibila doar cand celula sub care este creata este activa), compilata din mai multe celule aflate pe aceeasi foaie de lucru sau pe o foaie de lucru diferita. Dupa ce lista drop-down este creata pentru o anumita celula, aceasta afiseaza o sageata in jos langa celula respectiva. Daca dati click pe sageata, lista de intrari valide va fi afisata, iar daca doriti sa introduceti informatii in celula sub care este creata lista, dati click pe oricare dintre intrarile valide din lista.

Pentru a crea o lista drop-down in Excel dintr-un anumit numar de celule este necesar sa folositi comanda Data Validation, aflata sub tab-ul Data.

1. Creati o lista drop-down alcatuita din intrari aflate pe aceeasi foaie de lucru (worksheet)

Sa presupunem ca doriti sa creati o lista cu muzica dvs preferata in functie de numele artistilor preferati:

introduceti numele artistilor intr-o singura coloana, fara a lasa randuri libere intre acestea (de exemplu, de la A1 la An, in functie de numarul de artisti introdus)pe o coloana diferita introduceti numele pe care vreti sa-l dati listei, de exemplu Muzicape coloana din stanga (sau dreapta) acesteia, introduceti cu un rand mai jos, informatia in functie de care doriti sa catalogati muzica, de exemplu Artistselectati celula aflata imediat sub Muzica (si imediat in stanga sau dreapta celulei Artist), apoi dati click pe tab-ul Data (aflat in ribbon – portiunea ingusta alcatuita din butoane si iconuri, aflata de-asupra spatiului de lucru)in sectiunea Data Tools, dati click pe Data Validation, apoi selectati Data Validation din meniul afisat

in fereastra deschisa, in tab-ul Settings, deschideti meniul de sub Allow si selectati Listdati click pe campul din dreptul Source, apoi mergeti la coloana in care ati introdus numele artistilor si selectati toate celulele care contin intrari (folositi drag-select – dati click-stanga pe o celula si fara a da drumul butonului trageti cursorul peste un anumit nr de celule), apoi dati click pe OK.

 

in dreapta celulei sub care ati creat lista va aparea o sageata; daca dati click pe aceasta se va deschide o lista drop-down care va afisa numele artistilor

2. Creati o lista drop-down alcatuita din intrari aflate pe o foaie de lucru diferita de cea pe care va aparea lista

Sa presupunem ca doriti sa creati o lista drop-down care sa contina diferite genuri de muzica:

selectati in partea de jos a fisierului Excel foaia de lucru pe care veti introduce intrarile ce vor alcatui lista drop-down (de exemplu Sheet2)pe o singura coloana, introduceti genurile de muzica care doriti sa fie afisate in lista, fara a lasa randuri goale intre intrariselectati (drag-select) toate celulele care contin intrari, apoi dati click pe Name Box (aflat in partea stanga-sus a fisierului, intre ribbon si foaia de lucru), introduceti un nume general pentru toate intrarile (de exemplu muzica), si apasati tasta Enter

selectati foaia de lucru unde doriti sa creati lista drop-down (de exemplu Sheet1)scrieti numele listei drop-down oriunde pe foaia de lucru, apoi selectati celula aflata sub cea care contine numele respectivdati click pe tab-ul Data > Data Validation, apoi selectati Data Validation din meniul afisatin campul de sub Allow selectati List, apoi tastati in campul de sub Source semnul = si numele introdus in Name Box pe foaia de lucru care contine intrarile (Sheet2) si dati click pe OK

dati click pe sageata aparuta in dreapta celulei sub care ati creat lista pentru a afisa intrarile care alcatuiesc lista respectiva

Optional puteti adauga o descriere a listei drop-down create, aceasta fiind vizibila doar cand celula sub care este creata lista este activa. Dati click pe Data > Data Validation > Data Validation si mergeti la tab-ul Input Message. Scrieti descrierea in campul de sub Input message (maxim 225 caractere), adaugati titlul acesteia (doar daca vreti) si dati click pe OK.

Pentru a sterge o lista drop-down, selectati celula sub care aceasta este creata, dati click pe tab-ul Data > Data Validation > Data Validation, apoi dati click pe butonul Clear All si pe OK.

Nota: Valabil pentru Microsoft Excel 2007 si Microsoft Excel 2010.

Advertisements
?at????s? a?apt?ss?µe??? ??sta? se excel, excel validation 2003, cum fac in Excel la o celula sa fie o lista in jos cu sageata, p?? ?a d?µ??????s? ??sta se ?e?? excell, superantispyware slovencina, download programa gia ious free, cum pot crea un antivirus, p?? ?a ???s? ???µa p?a?s??? excel, excel dropdownlist ayari, cum sterg in excel, cum trec din excel in word, EXCEL 2010 DA AÇILIR LISTE , keylogger via email, Excel 2010 vypnút zaokrúhlenie, EXCELDE AÇILAN LISTE , d?µ??????a ??sta? se excel, drop-down in excel, cum creez i lista dropdown in excel 2003, word otomatik sigdir, lista in excel, download lista cu celule Orange , cum sterg in excel?, cum trec in romina ofisul 2007, xls ded?µ??a Data Validation, dowmloa muzica,

View the original article here

Download Microsoft Security Essentials 2.0 (Final Version)

Advertisements

La 5 luni dupa lansarea versiunii beta a popularului antivirus Security Essentials, Microsoft lanseaza in sfarsit si versiunea finala a acestuia.

Microsoft Security Essentials 2.0 vine la pachet cu cateva caracteristici si functii noi, cum ar fi:

un nou motor anti-malware (heuristic) dotat cu o putere de detectare mult mai mare si care are capabilitatea de a curata mult mai eficient sistemele (nu se bazeaza doar pe updateurile definitiilor despre virusi pentru a detecta noi potentile pericole),integrarea in Internet Explorer (pentru a putea bloca scripturile periculoase chiar dinainte ca acestea sa fie rulate) si compatibilitatea excelenta cu Windows Firewall (permite activarea si/sau dezactivarea firewall-ului direct din interfata antivirusului),

optiunea de a limita consumul de resurse (CPU, memorie) in timpul scanarii si optiunea de a monitoriza comportamentul aplicatiilor si fisierelor de pe un sistem

De asemenea, MSE 2.0 se integreaza in retea, monitorizand traficul fara a afecta performanta PC-urilor, in felul acesta detectand potentialele pericole inainte ca acestea sa ajunga in computere.

Download Microsoft Security Essentials 2.0 (versiune finala)

Daca deja folositi acest antivirus, cel mai probabil veti primi o notificare care va va cere sa faceti upgradeul. Daca nu folositi MSE, poate ca este timpul sa incercati si dvs acest antivirus, gratuit pentru utilizatorii Windows cu licenta genuine. Posibil sa deveniti fani. ;)

Advertisements
microsoft securiti essentials 64 bits, nastavit antivirus zdarma, skin yahoo mess 8, download microsoft security, dezactivare security essentials, avg 8.5 free antivirus download, microsoft security essentials v 2.0, essential antivirus vlastnosti, microsoft securiti client, Actualizarea Windows live virus?, microsoft sekuriti, antivirus s?µe??se??, microsoft security essentials download, Actualizarea Windows live virus, image burn, virus, p??ß??µa e??µe??s?? kaspersky, windows security essentials pc de görünmüyor, e??µe??s? a?t?ßa?????, kituri windows 7 free, essentials 2.0, comment désactiver le silver screen, virus Actualizarea Windows live, " Actualizarea Windows live", Microsoft Security Essentials.dowland,

View the original article here

Microsoft Anti Spyware

Trust Microsoft not to be left behind in the anti Spyware Rage

When the need for anti spyware solutions became in demand, who do you think was one of the pioneers who came to the rescue? Microsoft, of course. The best in the computer technology were gathered to formulate an anti spyware that could be considered one of its finest. The result is Microsoft anti spyware.

This anti spyware was introduced as a free beta version that is downloadable from the internet. Those who wanted to try out what Microsoft has to offer can simply go over the main homepage and download it there.

Today, people can have the complete software installed in their computer. The beta software has in it all the basic protection that computers need. From spyware to how it can easily be detected, Microsoft anti spyware software has everything put in there.

What are the things that Microsoft anti spyware can offer you?

1. It exterminates hard to eliminate spyware.

The initial scanning function of Microsoft anti spyware is quick and thorough. Just like its veteran counterparts, it is able to identify the number of spyware that has gotten into your system.

One thing that makes Microsoft spyware stand out is that it does the work quicker than any other anti spyware available. If you compare it with other anti spyware, you will notice that it can do the job faster than what you have before. This saves valuable time that you can set aside for other stuff.

When the scan is finished, the program will give you detailed information about the spyware. The information will go as far as pointing out where the spyware is located in the computer, risk rate and the necessary actions needed to avoid such threats.

You have the capability to schedule when the next scan is going to take place. It is better to do this on a regular basis so that the risks will be avoided completely. You can input this information into your computer so that it will automatically start the scanning process.

There is a network community that is responsible for keeping users in tune with the updates that is going around in these programs. You will receive real time notification about these updates so you will know what is happening lately.

2. State-of-the-art features.

Microsoft anti spyware offers advanced features that you can take advantage of.

You can have default settings to Microsoft in your browser. This makes browsing easier when you already have them existing in the browser that you use.

Another feature is setting modifier. You have the choice of putting as many objects in your browser as possible.

The last feature the capability to erase automatically the number of histories to programs that you used and gone through. This way, the fear of anyone going through them will be eliminated. It will also save you the trouble of looking up each one and deleting them manually.

3. Easy access and free of charge.

You are pared the worry of paying for this program since it comes for free. Over the Internet, you can search for and download it directly to your computer.

Microsoft anti spyware is a recommended anti spyware support if you are after the quality that is known only with Microsoft. Get all the features combined with the assurance that you are well protected from intruders with Microsoft anti spyware.

Microsoft Spyware

The New Spyware Removers from Microsoft

The spyware is a type of software that changes a computer performance or normal operation. In some cases, it partially controlled by someone who is not authorized user of that system. Usually a spyware is installed in your computer without you knowing about it. Sometimes it is part of software that is being downloaded in the internet and when you install it there is a spyware included in it.

Many internet users do not have knowledge in spyware that’s why when there are instances that spyware tried to invade users’ computer it can easily pass on. Once infected the owner or author of the spyware will be able to track your online activity and send your information to their side.

Moreover, the threat that the spyware poses can weaken your computer’s resources. It causes instability, slow performance, hang programs, crash the system and eventually destroy your computer. Since we are all computer dependent or uses computer spyware might be able bring to productivity killer for your business.

Another threat of spyware is that it can monitor all your action in your computer like visiting websites, typing your account and password information and then send it back to a third party. The worst case is that the owner of spyware will use your account without your permission.

With the growing threats and impact that can have your system of spyware, it is now important that you have knowledge on this and start to protect your computer with this spyware. Look for the best spyware remover programs that can be use in conjunction with other anti-virus to completely protect your computer.

Now to be able to protect your PC, Microsoft has developed a spyware remover tool that can be used to detect and remove spyware to your PC using a windows operating system.

The Microsoft beta spyware tool is free to download if you are using genuine software of Microsoft XP operating system. Microsoft had implemented a validation test to check for illegal copies of Windows XP. So to be able to get a copy of Microsoft beta spyware tool for free, get first genuine Windows XP operating system.

Once you have downloaded and installed Microsoft spyware beta version on your computer, it immediately protect your PC against spyware invaders. The software is comprised of scanner that will detect, remove and fix files infected with spyware.

Scanning your system will just take for about 15-20 minutes depending on the size of your hard drive. After completing the scan it will show you the list of detected spyware.

Microsoft had also released the Beta 2 version of windows defender a Microsoft spyware remover tool. It easily and quickly finds spyware and other unwanted programs and eventually removes it. And if you accidentally uninstalled important program, you can easily restore it using this version. Beta 2 version runs in background so it would not distract you while you’re working. And it has an automatic updates you can download to prevent your computer from new threats.

Microsoft spyware remover tool also restores the default settings of your Internet Explorer that may have been altered by spyware infections. If you do not have this spyware remover, it would be a problem to you to return the normal features of your Internet Explorer after spyware has infected it.

Get a copy of Microsoft Beta Spyware for a complete protection of your computer from the latest threat of spyware.