Unable to switch sheets in Excel

Question

Hi, I recently bought an Asus Zenbook and my PgDn button is together with my down arrow key as shown. And I did the shortcut of Ctrl-PgDn but it doesn’t change to the next sheet in Excel. It work on other laptops if the button is not together with the down arrow. I am using the Excel on Microsoft 365 app on student account. Thanks

Answer 1

Hi Ryan,

 

If so, you can send the feedback in Excel app and related product team could get informed about the issue with specific PCs. Sorry to convey that engineers here have limited resources on further investigate the issue.

If the button is also unable to work in other Office apps like Word or OneNote, I would suggest you post a new thread under the category: Excel / Windows 10 / Microsoft Office Programming and let engineers there know that you need a VBA to realize the function of switching between sheets. You will get response in hours and don't worry if it's the first time to use VBA as they will show you the detailed steps.

 

Hope this workaround could meet your deadline to assignment. Sorry for the inconvenience caused by the feature incompatible. And I have submitted the feedback with the button issue on specific PC model.

 

Best Regards,

Mia

Hi Mia,

I have figured the correct shortcut key to change tabs for laptops who have PgDn key in the down arrow. It is not taught in google apparently.

Thanks for your help.

Answer 2

Hi Ryan,

Could you please share me What did the laptop side say about how to press the buttons to enable the PgDn function?

Try the way to active the PgDn function for a PDF and make sure it can be used in other files besides Office files. I made a PDF test file for you and you can directly open it to test: https://m365forumsupport-my.sharepoint.com/:b:/g/personal/admin_m365forumsupport_onmicrosoft_com/Ea__VIt-qFZJrEQtIAeLABoBgPtoLvUVmfcRLhXFP_ykag?e=yXcFM6

If the shortcut can be used for a PDF file but not Office files, you may have to submit the feedback in Excel to let the related product team get aware of this issue for the current version. But as this could be a long-time process, I would suggest you use other classmate's PC to finish the assignment if you are in emergency.

Appreciate your understanding.

Best Regards,

Mia

Answer 3

Hi Ryan,

 

Could you please share me What did the laptop side say about how to press the buttons to enable the PgDn function?

 

Try the way to active the PgDn function for a PDF and make sure it can be used in other files besides Office files. I made a PDF test file for you and you can directly open it to test: https://m365forumsupport-my.sharepoint.com/:b:/g/personal/admin_m365forumsupport_onmicrosoft_com/Ea__VIt-qFZJrEQtIAeLABoBgPtoLvUVmfcRLhXFP_ykag?e=yXcFM6

 

If the shortcut can be used for a PDF file but not Office files, you may have to submit the feedback in Excel to let the related product team get aware of this issue for the current version. But as this could be a long-time process, I would suggest you use other classmate's PC to finish the assignment if you are in emergency.

 

Appreciate your understanding.

 

Best Regards,

Mia

Hi Mia,

The laptop side are unsure how to activate the button and said it is a Windows issue, not Asus issue. I tried using Fn to activate the PgDn key but it does not work. 

The Down Arrow can definitely scroll down the pages but it does not work in the Excel. I have attached a picture to show you what happen to my Excel when I press Ctrl-PgDn. 

I only have 1 laptop and the lecturer insists that it must be working in all laptops to pass. Hence I am in big trouble. 

Regards,

Bryan

Answer 4

Based on my search through the Internet, you can have a try with Alt + up arrow or Fn + up arrow and see the result.

But since you mentioned your laptop is Asus, it seems like other users also don't have the PgDn keys natively.

Best Regards,

Mia

Answer 5

Based on my search through the Internet, you can have a try with Alt + up arrow or Fn + up arrow and see the result.

But since you mentioned your laptop is Asus, it seems like other users also don't have the PgDn keys natively.

Best Regards,

Mia

Hi Mia,

I reached out to Asus and they firmly mentioned it is the Excel issue for those with PgDn button with Down arrow. It works for PDF but not Excel.