top-10-excel-ti-1

LookUp in Excel

In Excel, the Lookup function returns a value from a range (one row or one column) or from an array. vLookup – Vertical lookup hLookup – Horizontal lookup Lets see how to ...
top-10-excel-ti-1

Record macro in Excel

Record Macro option in Excel helps you to record all the operations that you are performing in the excel sheet when the record macro is enabled. This option facilitates users who do ...
top-10-excel-ti-1

Shortcut key for accessing in-built functions in excel

In Excel, to open the dialog box for editing in-built functions (i.e.,Function Arguments) when you’re staying in a cell, follow the below steps. Step 1 Type part of the name of ...
top-10-excel-ti-1

How to get Developer’s tab in Excel?

By default, developer’s tab in Excel will be invisible. To get Developer’s tab, go to Microsoft Office Button¬†¬†> Word Options Check “Show Developer Tab in the ...
top-10-excel-ti-1

How to add drop down list box in Excel

To add drop down list box in Excel, proceed with the following steps: 1. Click, Data > Data Validation > Data Validation 2. Select List from Allow drop down list box under Validation ...
download

Could not copy from remote desktop to local computer

If you are trying to copy some text / image / file from remote desktop to local computer, the process rdpclip.exe should be up and running. Check Task Manager of the remote desktop, ...
unix

Unix command for removing specific list of files from a directory

To remove a specific list of files (like .txt, .log, etc.,) from a directory, we can proceed with two ways. 1. Using rm command directly to remove .txt or .log or any kind of specific ...
download

How to unlock android phone after too many failed pattern attempts?

Hi Friends, This is the most common and very critical situation for android users. In this situation unlock android phone after too many failed pattern attempts is very hard to new ...
© 2017 Techy Diary. All rights reserved.
Powered by Charvi Groups