SBX - Search With Button

SBX - Forum Post Title

Short cut key to Copy Nav Data Table to Excel Sheet

Microsoft Dynamics NAV Forum

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

Question Status

Verified

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
Mohana Yadav responded on 11 Oct 2017 8:00 AM
My Badges
Suggested Answer

did you try Ctrl+E?

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

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
My Badges

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
Chris D'silva responded on 12 Oct 2017 12:36 AM
My Badges
Suggested Answer

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
Zaid Tariq responded on 12 Oct 2017 1:26 AM
My Badges
Verified Answer

- 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
Zaid Tariq responded on 11 Oct 2017 1:20 PM
My Badges
Verified Answer

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
Zaid Tariq responded on 12 Oct 2017 1:26 AM
My Badges
Verified Answer

- 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
Mohana Yadav responded on 11 Oct 2017 8:00 AM
My Badges
Suggested Answer

did you try Ctrl+E?

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

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

SBX - Two Col Forum

SBX - Migrated JS