Shortcut for jump into last page in excel 2016


Finance Professional

Dear Expertz,

I am using Excel 2016, now am facing problem to jump into last sheet of Excel file (if Excel file have more sheets...).

earlier left pan @ bottom of Excel sheet, there was <> <> buttons are there for do the same. now it was disable in Excel 2016.

pl advice, any shortcut is there to resolve this.

 

 
Reply   
 
Professional Accountant

press ctrl+page down to go next sheet
 
Reply   
 
Article Assistant

There is no such shortcut to switch over from 1st page to last page. Either you have to use Go to option or Macros to move into last sheet in the workbook in a single shortcut
 
Reply   
 

I am using Excel sheets for accounting. This is really a nice software. Excel has a lot of features. This is not easy to learn. If you have any issue with chrome browser and Firefox. Then simply contact err spdy protocol error. They help you out. 

 
Reply   
 
Software

You may download workbook navigation addins from below site for working with multiple worksheets and workbooks..

https://sites.google.com/site/exshail/excel-addins

Thanks,

Exshail Software

 
Reply   
 
Finance Professional

Thank you sir,

I am getting this error

pl advice, how to resolve this

 

 
Reply   
 
Software

If you see Addins tab as per screen shoot you can try to reach your list of sheets from their and press home or end key to jump. It works fine in Excel-2007 but no idea in higher version.

 

 
Reply   
 
Finance Professional

my Excel version is 2016

 
Reply   
 

LEAVE A REPLY

Your are not logged in . Please login to post replies

Click here to Login / Register  

 


×

  CCI MENU