Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

Shortcut for jump into last page in excel 2016

Satya N Dharani (Finance Professional) (491 Points)

29 October 2018

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
Follow
Share

7 Replies

Santosh Raut (Professional Accountant) (46 Points)
Replied 29 October 2018

press ctrl+page down to go next sheet

Upgrade to CAclubindia Pro. Subscribe Now!

THARUNKUMAR.R (Article Assistant) (168 Points)
Replied 29 October 2018

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

Elen Walker (2 Points)
Replied 31 October 2018

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.

Exshail (Software) (1576 Points)
Replied 31 October 2018

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

Satya N Dharani (Finance Professional) (491 Points)
Replied 31 October 2018

Thank you sir,

I am getting this error

pl advice, how to resolve this

Upgrade to CAclubindia Pro. Subscribe Now!

Exshail (Software) (1576 Points)
Replied 31 October 2018

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.