Password protecting your Excel Worksheet can prevent others open your works with your permission. To allow only authorized users to view or modify your data, you can help secure your entire workbook file with a password.
To do it, just follow below steps:-
- Open your Excel workbook, on the File menu, click Save As.
I found a very useful feature in Excel that allows you to split your data in one column into multiple columns based on a simple condition. This useful feature is ‘text to columns’ which is a option under the Data menu that allows information in a cell or range of cells to be split into columns.
Below is a simple tutorial to show you how to use this useful Excel feature.
I have a product list that represents product model and serial number. How do I split the product number (Sample A) into two separate columns (Sample B) by using excel? Continue reading
A dropdown list enable user to enter the data in more efficient way and standardized.
User is allowed to select the data from the list and to make the data easier to maintain.
To create the list for the drop down ,enter the data in a single column cells Continue reading