top-10-excel-ti-1

Autofill option through mouse is not working in Excel 2007

Autofill option can be implemented in Excel 2007 through mouse by selecting the cells and dragging left or right till the desired cells are filled with the values. 1. Plus sign under ...
top-10-excel-ti-1

Pivot table in Excel

In data processing, a pivot table is a data summarization tool found in data visualization programs such as spreadsheets or business intelligence software. Among other functions, a ...
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 ...
© 2017 Techy Diary. All rights reserved.
Powered by Charvi Groups