Last Chance: Get 10% OFF on CAclubindia Pro Subscriptions. Subscribe Now!

Shortcut for jump into last page in excel 2016

667 views 7 replies

Satya N Dharani

Finance Professional

491 Points Posted on 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.

Replies (7)

Santosh Raut

Professional Accountant

46 Points Posted on 29 October 2018

press ctrl+page down to go next sheet

THARUNKUMAR.R

Article Assistant

168 Points Posted on 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

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

1586 Points Posted on 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 Posted on 31 October 2018

Thank you sir,

I am getting this error

pl advice, how to resolve this

Exshail

Software

1586 Points Posted on 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.