Technology Compilation - Internet, Android and Windows

Got a spreadsheet, full of values/text content and you want to search for a specific word in a row or column then excel with its Find utility (CTRL+F) will let you strike through the search word from the selected position of excel sheet in no matter of time one by one until the last matching search term is found. But if you want to highlight the search word to filter out the field containing the search term then unlike other tools it doesn't highlight all the search term containing fields by default. For instance: A column with n rows of data like Home Addresses and you want to filter out address fields containing the street name as New Jersey. Read Also:  How to highlight Matching values of other columns in Excel How to Highlight MS Excel Search Results In Color? Just follow the below steps to emphasize the search term containing fields in colors of your choice from the color palette. Open the excel sheet containing the data. Press Ctrl+A to select for sea...

Searching for the existence of similar values between the excel worksheet columns manually is fine when we have few values in a column, but if you have thousands of values in a column which has to be compared with another column for identical values, it may take a decade to do so. Microsoft Excel is a powerful tool that can be used efficiently to do such a complex task in no time. Read Also: How to protect Microsoft Excel documents with password  How to Find Duplicate Values In Excel by Comparing Columns:- For example, in the below image representation, In an Excel worksheet, we have values in two columns A and column C. In order to identify and highlight the values of column A which are also available in column C, Microsoft's Excel tool has several built-in functions and techniques to do so, whereas not every option is simple and efficient, so here we share one of the easiest ways among them. Sample Data With Employee ID's in Column A and Column C Step...

Most of us are aware of the concatenation utility support provided in MS Excel to combine two cell fields values into one. Whereas how many of us are really aware of splitting the concatenated values from a specific field into two or more fields values. To achieve this scenario, like programming languages that use a separator called Delimiter to isolate different variables. Excel uses similar delimiter logic to separate the data values of excel cells into two or more values in different consecutive cells. Read Also: How to Highlight Excel Search word In colors of Choice Separate Excel Data Values of One Cell to Many Cells Just follow the below screenshot and explanation to achieve this split cells event in Microsoft Excel. Split Excel Values Into Several Columns Step: Select a column containing rows of data that have to be separated and then Go to Data -> Text to Columns. Select Values then Data - >Text to Column   Step:  Select Delimite...

Protecting your computer user accounts with a password doesn't mean important files were really safe and secure if anyone who has the privilege to access your user account is free to view and make changes by default, in spreadsheet application called Excel developed by Microsoft. Microsoft has designed this spreadsheet application, which has several features such as calculating, graphing tools, pivot tables, etc. Sharing desktop is not the only threat to excel files when you send excel files online via email to a group of mates that you want to share with, but sent to an unknown mail id by mistake, which has confidential information that shouldn't be disclosed. To prevent such situation add password's to Excel files and limit the user from making changes and viewing, with the right password. Read Also: How to make your computer speak whatever you type with notepad. Why Add a password for excel file?  When you have one for the computer. It's better to protect ...