Saturday, July 11, 2009
Importance of Files and Recovery Techniques
Development is the regular scene with business. But have you thought which thing is solely responsible for this growth? The whole information, research results, efforts, innovative ideas and clear cut objectives of the business, all set to take it for progress. Precisely, the one word which defines as is the ultimate source of development is called data which are further classified into files and gain extensions based on the application in which they are stored. Each file has different objectives and hypotheses which help business to grow and develop. Some of these files are also contributing in giving a steady continuation to the businesses, while are meant for a specific purpose. All are important and hence a loss can give these organizations a real shock. A customer database, applied either in SQL, MS Access or some other application, significantly important text, written in MS Word or Notepad, worksheets, maintained in MS Excel like applications and so on, serve the same purpose of helping the business, in one or the other way. The quantity, quality, sampling and measuring ways, these have the implications for the choice and effectiveness of the data analysis. That’s why files retain the utmost magnitude.When we talk about losing a file, the first idea which runs in mind is losing it while deletion. Not all deletion cases can be considered for loss, but those in which some important file has lost its existence from the media. File loss is not only limited to deletion, but the incidents like formatting; file system crash, operating system malfunctions, virus attack and other such incidents can pull the file for loss.Now, the relevance, file loss effects and other business reasons let the innovators to think about file recovery measures. After an in-depth analysis of data storage, the scene of file deletion and the operating system limitations of not finding the file, even whilst its existence gave rise to file recovery techniques. These innovators were further called as data recovery geeks who fused their efforts in the form of file recovery software.Now, the file recovery software will get void if they are doing some write operation on the data, so data recovery people thought of making them safe by the read-only design. Note: This feature may still be absent in few file recovery programs.Additional developments of interactive interface, identifying power to all types of files, applicability in all data loss incidents and others made these file recovery products a real help to the users. Now, data recovery industry stands as the helping hand, offering number of file recovery treatments to all types of media and operating systems. Use these assistances and grab what you have lost till.Stellar Information Systems Limited is the leading company which serves the purpose of file recovery through its efficient products. Incident of data loss and the operating systems is not an issue with these file recovery products as they are present for all of them with high-scanning ability. Moreover, the read-only conduct and intuitive interface make these products an absolute cure.
Create A Drop Down List In Excel
The procedure for creating a drop down list is fairly simple to follow.
There are 3 stages involved:
i) Creating a list of values you want to appear in the list – normally on a separate sheet in the same workbook
ii) Naming the list
iii) Using Data Validation to create the drop down list
1) Start with a new workbook which has at least two worksheets. Switch to Sheet2, this is where you will create your list of values. You may want to consider the order you enter the values as this will be the order they will appear in the drop down.
2) Enter your values, one value in each cell, working down a column. I’m going to list some UK cities, you might think of another list that relates more closely to what you do.
London
Sheffield
Manchester
Leeds
Brighton
Edinburgh
Cardiff
3) Now you are going to name your list. If you have not named cells or ranges previously I’ll give some explanation as to why we want to do this. Currently my list is in the range Sheet2!A1:A7. It’s going to be a lot easier to refer to this list later on if we give it a meaningful name as a substitute for this current range description.
How do we name this range? First thing to do is to select the list – I’ll assume you know how to do this: make sure each cell that contains a list value is selected. Now find the Name Box which is to the left of the formula bar. The Name Box will show the cell address of the first cell you selected in the range. In my example this would be A1. Click into the Name Box and the cell address gets highlighted; now you are ready to type the name you want to give your list. I am going to call my list cities. Once you have typed your name you must use the Enter key on your keyboard to confirm, otherwise the name will not be stored.
Names are not case sensitive but they do need to follow some basic rules:
- Names must start with a letter or an underscore but can contain a number
- Names cannot contain spaces but can contain underscores to separate words
- Names cannot contain any other characters other than underscores, letters or numbers
Switch to Sheet1 and click into the cell that you want the drop list to appear in. If you want the list to be available in more than one cell, select those cells as well. Now click Data > Validation. This opens the Data Validation dialogue box. For Allow: select List. Now click into the Source: box and press the F3 key on your keyboard. F3 shows the Paste Name box. Select the name you created from this box and click OK. The source box now reads =cities for my example. Click on OK in the Data Validation box and you are done: your cell will have a drop down list.
If you want to prevent users or even yourself entering any value other than a value from your list, select the cell and go back to Data > Validation. Then click on the Error Alert tab. The default Stop style error alert prevents the entry of values that are not in the list but also displays an error message if an invalid value is attempted. The Title and the Error Message appear in a box when a user enters such a value. In my example the Title might be City and the Error Message Sorry you must select a city from the list, your entry is not valid.
Click on OK and test you error message.
As a last thought you might want to think about hiding the sheet that holds the named list – Sheet2. That way things look a bit tidier and the list is likely to be inadvertently changed or deleted. Select the the Sheet2 tab and then click Format > Sheet > Hide.
For future reference to Unhide the sheet click Format > Sheet > Unhide.
There are 3 stages involved:
i) Creating a list of values you want to appear in the list – normally on a separate sheet in the same workbook
ii) Naming the list
iii) Using Data Validation to create the drop down list
1) Start with a new workbook which has at least two worksheets. Switch to Sheet2, this is where you will create your list of values. You may want to consider the order you enter the values as this will be the order they will appear in the drop down.
2) Enter your values, one value in each cell, working down a column. I’m going to list some UK cities, you might think of another list that relates more closely to what you do.
London
Sheffield
Manchester
Leeds
Brighton
Edinburgh
Cardiff
3) Now you are going to name your list. If you have not named cells or ranges previously I’ll give some explanation as to why we want to do this. Currently my list is in the range Sheet2!A1:A7. It’s going to be a lot easier to refer to this list later on if we give it a meaningful name as a substitute for this current range description.
How do we name this range? First thing to do is to select the list – I’ll assume you know how to do this: make sure each cell that contains a list value is selected. Now find the Name Box which is to the left of the formula bar. The Name Box will show the cell address of the first cell you selected in the range. In my example this would be A1. Click into the Name Box and the cell address gets highlighted; now you are ready to type the name you want to give your list. I am going to call my list cities. Once you have typed your name you must use the Enter key on your keyboard to confirm, otherwise the name will not be stored.
Names are not case sensitive but they do need to follow some basic rules:
- Names must start with a letter or an underscore but can contain a number
- Names cannot contain spaces but can contain underscores to separate words
- Names cannot contain any other characters other than underscores, letters or numbers
Switch to Sheet1 and click into the cell that you want the drop list to appear in. If you want the list to be available in more than one cell, select those cells as well. Now click Data > Validation. This opens the Data Validation dialogue box. For Allow: select List. Now click into the Source: box and press the F3 key on your keyboard. F3 shows the Paste Name box. Select the name you created from this box and click OK. The source box now reads =cities for my example. Click on OK in the Data Validation box and you are done: your cell will have a drop down list.
If you want to prevent users or even yourself entering any value other than a value from your list, select the cell and go back to Data > Validation. Then click on the Error Alert tab. The default Stop style error alert prevents the entry of values that are not in the list but also displays an error message if an invalid value is attempted. The Title and the Error Message appear in a box when a user enters such a value. In my example the Title might be City and the Error Message Sorry you must select a city from the list, your entry is not valid.
Click on OK and test you error message.
As a last thought you might want to think about hiding the sheet that holds the named list – Sheet2. That way things look a bit tidier and the list is likely to be inadvertently changed or deleted. Select the the Sheet2 tab and then click Format > Sheet > Hide.
For future reference to Unhide the sheet click Format > Sheet > Unhide.
Subscribe to:
Posts (Atom)