0
hopefully your answer can be found here
Excel Tips and Tricks - How to Automatically Download Index Data from NSE - Part One
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
What is true about Excel checker?
Excel Checker is an Excel add-on that can find every occurrence of cells containing Data Validation or Conditional formatting and list them out on a separate sheet.
Can you sort files in ascending and descending orders?
no only data can be sort from the excel sheet.. not in the file
How do you make a result sheet in Excel?
how to create a excel sheet
What is a chart sheet in chart in excel?
A chart sheet just shows a chart by itself, so you don't see the data and there are no rows and columns visible.
What is the full form of PFA in Excel sheet?
Pfa the excel sheet
How do you link data in a row on excel master sheet to row on another sheet on Mac Excel 2011?
Use the name of a sheet, followed by an exclamation mark and a cell reference. The following would take the value in cell C21 on Sheet2 and put it wherever the formula is typed. =Sheet2!C21
How do you transfer data between worksheets in excel for automatic formulas?
To transfer data, enter them in sheet 1, go to sheet 2 and the cell in which you want the linked number to appear and enter the equal "=" sign. Then go back to sheet 1 and the source cell and press Enter.
What is the minimum data value in a data set?
The minimum data value in a data set is simply the lowest value of the set (easily found by arranging the set from lowest-highest values in an excel sheet or by hand).
What is the Excel feature that allows the Excel data sheet to be broken into different columns?
Use the Text to Columns option.Select the column where you have the data you want to split.Go to Data, Text to Columns.Select Delimited.Ensure that the comma checkbox is activated.Select a destination cell (default is current cell).Click Finish.
What is a Datasheet?
The data sheet view in Microsoft SharePoint is a useful tool for quickly editing several list items. It functions similar to an Excel spreadsheet and can be exported to or imported from an Excel spreadsheet.
How do you make a cover sheet in excel?
Add a sheet
What is the difference between Excel sheet and spread sheet?
They are the same thing, excel is Microsoft's spreadsheet programme.
