Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Short cut key to Copy Nav Data Table to Excel Sheet

Posted on by Microsoft Employee

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.

*This post is locked for comments

  • Verified answer
    Zaid Tariq Profile Picture
    Zaid Tariq 2,266 on at
    RE: Short cut key to Copy Nav Data Table to Excel Sheet

    - 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. 

  • Suggested answer
    CDsilva Profile Picture
    CDsilva 4,184 on at
    RE: Short cut key to Copy Nav Data Table to Excel Sheet

    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

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Short cut key to Copy Nav Data Table to Excel Sheet

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Short cut key to Copy Nav Data Table to Excel Sheet

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

    Ctrl+E for export complete table to Excel sheet.

  • Verified answer
    Zaid Tariq Profile Picture
    Zaid Tariq 2,266 on at
    RE: Short cut key to Copy Nav Data Table to Excel Sheet

    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

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: Short cut key to Copy Nav Data Table to Excel Sheet

    did you try Ctrl+E?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans