ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to switch between worksheets without using mouse? (https://www.excelbanter.com/excel-discussion-misc-queries/42649-how-switch-between-worksheets-without-using-mouse.html)

Joe Magiera

How to switch between worksheets without using mouse?
 
How can you switch between worksheets tabs (within the same workbook) without
using a mouse? i.e., what keyboard sequences do you need to do this? The
only way I've found is opening a second instance of Excel and alt-tab between
them, but then one spreadsheet is open in read only format. Can this be
done? Please help the carpal tunnel people out there! Thanks,

Joe (joemagiera at ameritech dot net)


Dave Peterson

ctrl-pgup and ctrl-pgdn

Joe Magiera wrote:

How can you switch between worksheets tabs (within the same workbook) without
using a mouse? i.e., what keyboard sequences do you need to do this? The
only way I've found is opening a second instance of Excel and alt-tab between
them, but then one spreadsheet is open in read only format. Can this be
done? Please help the carpal tunnel people out there! Thanks,

Joe (joemagiera at ameritech dot net)


--

Dave Peterson

Joe Magiera

Thank you very much!

"Dave Peterson" wrote:

ctrl-pgup and ctrl-pgdn

Joe Magiera wrote:

How can you switch between worksheets tabs (within the same workbook) without
using a mouse? i.e., what keyboard sequences do you need to do this? The
only way I've found is opening a second instance of Excel and alt-tab between
them, but then one spreadsheet is open in read only format. Can this be
done? Please help the carpal tunnel people out there! Thanks,

Joe (joemagiera at ameritech dot net)


--

Dave Peterson



All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com