Short cut key to Copy Nav Data Table to Excel Sheet

Question Status

Verified
Vishwas Kumar asked a question on 11 Oct 2017 7:14 AM

Dear All,

How to copy opportunity table or to do list table of navision to excel sheet with using of export to excel.

Provide any short cut key to copy navision table and past on excel sheet.

Reply
Suggested Answer
Mohana Yadav responded on 11 Oct 2017 8:00 AM

did you try Ctrl+E?

Reply
Verified Answer
Zaid Tariq responded on 11 Oct 2017 1:20 PM

Hi,

Please try as follow:

- Run the table, and select all the rows (Ctrl + A)

- Press Ctrl+Shift + C

- Open Excel Sheet and Do Ctrl + V

Reply
Vishwas Kumar responded on 11 Oct 2017 11:23 PM

Sir I want selected row to past on Excel sheet not complete table.

Ctrl+E for export complete table to Excel sheet.

Reply
Manish Sharma responded on 11 Oct 2017 11:59 PM

You should clearly mentioned what you want.

If you want specific row the select that row and copy in excel else you need to write a report which will export the required data into excel.

Reply
Suggested Answer
Chris D'silva responded on 12 Oct 2017 12:36 AM

Hi Vishwas,

If you want to select rows of a table based on certain condition then you'll have to code for it or if not based on condition you can copy(Ctrl + C) the selected fields and paste (Ctrl + V) them in excel

Reply
Verified Answer
Zaid Tariq responded on 12 Oct 2017 1:26 AM

- If you want to copy selected rows then press the CTRL button and click on the rows you want to select. Then do CTRL+Shift+C and CTRL+V on excel. 
- If you want to copy filtered record then apply the filter at your list page and after that do the copy past as described.
- If you want export data with can some other desired filters, use configuration packages or  do custom development.

Ask again if still have problem, anytime. 

Reply
Verified Answer
Zaid Tariq responded on 11 Oct 2017 1:20 PM

Hi,

Please try as follow:

- Run the table, and select all the rows (Ctrl + A)

- Press Ctrl+Shift + C

- Open Excel Sheet and Do Ctrl + V

Reply
Verified Answer
Zaid Tariq responded on 12 Oct 2017 1:26 AM

- If you want to copy selected rows then press the CTRL button and click on the rows you want to select. Then do CTRL+Shift+C and CTRL+V on excel. 
- If you want to copy filtered record then apply the filter at your list page and after that do the copy past as described.
- If you want export data with can some other desired filters, use configuration packages or  do custom development.

Ask again if still have problem, anytime. 

Reply
Suggested Answer
Mohana Yadav responded on 11 Oct 2017 8:00 AM

did you try Ctrl+E?

Reply
Suggested Answer
Chris D'silva responded on 12 Oct 2017 12:36 AM

Hi Vishwas,

If you want to select rows of a table based on certain condition then you'll have to code for it or if not based on condition you can copy(Ctrl + C) the selected fields and paste (Ctrl + V) them in excel

Reply