We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Change the enter direction from row to column in Spreadsheet

Hi Team,

I would like to change the enter direction from row to column in Spreadsheet, like this option in Excel. can I do it? Thanks.

Best Regards,


3 Replies 1 reply marked as answer

VR Vasanth Ravi Syncfusion Team December 19, 2022 03:28 PM UTC

Hi Eric,

Currently, we don’t have support what you mean. However, your requirement can be achieved through keyDownHandler() event. We have prepared a sample that prompts you to navigate through cells on right. We have fetched the address on the near by cell to the active cell and make it to navigate.

Please find the code block and sample for your kind reference.



<ejs-spreadsheet ref="spreadsheet" :created="created" @keydown="onCellSave()">



      var spreadsheet = this.$refs.spreadsheet.ej2Instances;

        if (event.keyCode === 13) {



            var sheet = spreadsheet.getActiveSheet();

            let cellIdx = getRangeIndexes(sheet.activeCell);

            var nextCell = getRangeAddress([ cellIdx[0], cellIdx[1] + 1, cellIdx[2], cellIdx[3] + 1]);





Sample Link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Vue_KeyDown-1665651792

Get back to us if you need further assistance regarding.

If this post is helpful, please mark it as an answer so that other members can locate it more quickly.

Marked as answer

EH Eric Huang December 20, 2022 01:07 AM UTC

Hi Vasanth,

The sample code works and perfect. Thanks for help!

SP Sangeetha Priya Murugan Syncfusion Team December 20, 2022 06:08 AM UTC

You are welcome, Eric. We are glad that your requirement has been fulfilled.

Note: If that post is helpful, please consider Accepting it as the solution so that other members can locate it more quickly.

Live Chat Icon For mobile
Up arrow icon