Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

How To Switch Between Worksheets Without Using Mouse?

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

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)

View Answers     

Similar Excel Tutorials

Quickly Switch the Columns and Rows of a Data Set in Excel
How to switch a data set in Excel so that the columns become rows and the rows become columns. This will save you ...
Link to Cells on Other Worksheets in Excel
It is very easy to link one cell to another cell in Microsoft Excel. The steps needed are listed below as well as p ...
Hide Data Within a Worksheet in Excel
In Excel you can actually hide data that is stored within a worksheet. This allows you to show data that is useful ...
Loop through All Worksheets in Excel using VBA and Macros
Ill show you how to loop through all of the worksheets in a workbook in Excel using VBA and Macros. This only take ...

Helpful Excel Macros

Vlookup Function That Searches The Entire Workbook - UDF
- This UDF is a Vlookup function that searches the entire workbook in Excel. The syntax and usage of the function is exac
Enter Text/Characters with a Double-Click of the Mouse
- This macro allows you to enter any text or number, that you specify, in a cell on which you double-click. In the exampl
Excel Macro that Searches Entire Workbook and Returns All Matches
- This is the ultimate Lookup Macro for Excel. It will search every worksheet in the workbook and return all of the mat
Name Worksheets Based on Cell Contents
- This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This means
Sort Worksheet Tabs - Ascending or Descending Order
- This macro will sort all of the worksheets in the current workbook. It can sort in ascending or descending order. This

Similar Topics

I've got an application where I switch between workSheets and the mouse stays in the same location. As all of my actions are predicated on mouse right-clicks or double-clicks, the first thing that I have to do as move the mouse back to the active cell. Is there a way to reposition the mouse to the activeCell upon returning to the workSheet?



I have the excel 2010 beta, and when i want to switch the tabs with arrow keys, I can't. Only way to change it is by mouse. when i try to switch tabs left-right it moves the whole screen.
Thank you for your help.

Anyone have a link or source for all the little keyboard shortcuts to avoid "clicky-clicky"?

Trying to avoid carpal tunnel.........


hi there,

can some body guide me that how we can switch b/w 2 worksheets of a workbook
using the keyboard keys?


I've been working on an Excel spreadsheet and noticed that I could switch between standard keyboard and number pad (for formula editing). Switched to Number Pad fine, but now it doesn't switch back! When I press the ABC, the keyboard hides and when I press 123, it appears, hence, I can only access the Number Pad. This is for any cell in the spreadsheet. ABC keyboard will appear if I use the search function (magnifier) at the top, then while it's open, if I edit a cell I can get the ABC to work. But as soon as the keyboard is hidden, it will not show the ABC keyboard, only Number Pad.

Has anyone seen this, can't find anything on it.



For Christmas I received a Razer keyboard/mouse combo, installed the Synapse software & started playing with it as you do & found that when I tried opening an excel file with DDE formulas, excel opened & then froze up. I tried a multitude of ways to open a file & unless it was a file without any DDE formulas, it wouldn't open. I uninstalled the software & everything returned to normal. I dug out an old Logitech keyboard/mouse combo, installed the Setpoint software & got exactly the same thing. I found that even with a new blank workbook, a DDE formula manually typed in will cause excel to freeze as soon as enter is pressed. I did some googling & it seems that DDE is an ancient protocol & should be phased out eventually, so I don't expect to much in the way of assistance from the hardware people. It seems that you have to convert the DDE formula to a UDF formula. I've read that you can convert the document from DDE to UDF, but I can't find how, at least not in plain English I can't. Not only that, how can I do that if I can't open it. I'm presuming any solution is going to be via VBA. Below is a link to one of the places I've looked at
Any ideas? I haven't lol

I have the excel 2010 beta, and when i want to switch the tabs with arrow keys, I can't. Only way to change it is by mouse. when i try to switch tabs left-right it moves the whole screen.
Scroll lock is off.
Thank you for your help.

Is there any Excel mouse over function with formula support?
Purpose is to display cell content in another currency with floating text when pointed with mouse cursor.
Formula is simple cell value under mouse cursor x currency rate (11.2 for example).

There should also be option to limit this function somehow to certain named areas or capability to switch it easily on/off with keyboard shortcut.

Is this task possible in Excel 2003?

Hi there,

Here is my problem.

I have several columns or various inventory names

for instance:


I want a way that I can view this sheet somehow where rather than show me all the instances that component exists by cell....
I want it to show me it ONE time and give me a total of how many times it appears like:

Keyboard 3
Mouse 2
Monitor 1
Computer 1

Can anyone give me a hand with this?

A friend has somehow managed to switch the functionality of the mouse scroll wheel in Excel from moving the spreadsheet up and down to making it move right to left.

I found an old post from 2002 of someone with a similar problem and the only posted solution told him to check the mouse settings in Control Panel. I did this and could not find anything that would cause this.

I also checked MS Word and Internet Explorer and in both programs the mouse wheel moves the pages up and down as expected.

Does anyone know how Excel might have switched it to move left and right?


The problem seems to have corrected itself overnight (and with a re-boot).

Still, why it happened is bugging me. Could it be some kind of hotkey that he accidentally hit?

Is there a keystroke you can use to switch between tabs in the same Excel file (as opposed to having to click on a tab with the mouse)?


Can I change from one worksheet to another in the same open workbook without
using the mouse (i.e., using keyboard only)?

I have an Excel 2007 workbook that's been used for 5 months or so now. Recently, people I email it to say they can only see one worksheet in the workbook when they open it, and are unable to switch to any other worksheets in the workbook (they can't even see the tabs). They are in the "normal" view, and I have no idea what else could be wrong. Did I mess something up with the protection? Any other ideas to check??? Thanks so much!

Hello: I've searched everywhere and haven't been able to find anyone else who has had this issue.

I have a workbook that runs some auto_open code whenever the sheet is opened. This code is fairly short and simple. About 20% of the time, this code activates my keyboard/mouse switcher and causes control to be passed to my other computer.

My code contains no "send keys" statements at all and I find no other obvious suspects. The problem does not happen when I step through the code manually. I've tried changing my switch to only accept manual commands, but the problem still exists.

Does anyone know what may be causing this issue?

Thanks a lot for any suggestions!

I have just installed Office 2007 and it is working fine apart from Excel. When I open multiple workbooks, they all appear on the taskbar at the bottom of my screen, but when i click on each one with my mouse, it does not fire open that particular workbook. Instead, it stays on the first workbook opened. To navigate between workbooks, i have to eith do "Ctrl Shift" or select from the "switch window" button on the new Excel ribbon. Please can you help?
I am on Vista Home Premium and didn't have this issue with Excel 2003.

Hi. I need to use something like a switch function.

I thought it was just "Switch" as it says here (and a couple of other

but when I try this:


I get a name error. I'm using Excel 2003 SP2.

I don't want to use VLookup because I want the value that the function
returns to be from an evaluated formula not from a table and I'm using
references from multiple worksheets.


I have a pretty huge spreadsheet with +25 worksheets tabs. My problem is that sometimes I can not switch between them when clicking on the tabs. When I click the tabs either nothing happens or I get a standard windows right click menu even though i left click (like this one, but don't mind that this it taken from the windowns menu bar, it is the same right click menu i get )
I am aware that I am able to switch between the worksheet tabs by holding ctrl and pressing PgUp or PgDn however with 25 or more sheets clicking is much much easier.

I thought that another program could be blocking the tabs somehow, so I to a screenshot of all running processes.
Can anybody help me with this annoying problem?

From a word macro, how can I switch to an excel workbook that is already open to run an excel macro within it?

Any examples online of working with excel through word show the need to open a new instance of excel and open the file in order to have access to it. I would like to avoid this as it takes a long time to open the workbook. And if this cannot be answered, then how could I switch to a specific document in word that is currently open through word vba?

My users (who are accountants) use dual monitors and would like to open a
different Excel file on each monitor for the purposes of reviewing changes
between the two. I know that one method of doing this is by opening Excel
twice with its shortcut, then highlighting one Excel window and opening an
Excel file, then highlighting the other window and opening the other Excel
file. Unfortunately, the software that my users use to organize the Excel
files does not allow this to be done; it always opens every Excel file in the
first Excel window no matter which instance is highlighted. We had a similar
problem with Adobe Acrobat, but there is a command line switch that forces
Acrobat to open a new instance for each file.
Is there a similar switch for Excel, or some other method of forcing Excel
to open a new instance of itself for each file? We are running Excel 2003 on
Windows XP. Thank you in advance for your replies.

Hi, I am trying to find a way to select 2(+) discontinguous ranges without having to use my mouse. I am not sure if there is already a keyboard shortcut to do this, or if I can create my own keyboard shortcut with a macro. I haven't had any luck finding an answer on my own so would really appreciate any suggestions.

Here is an example of what I am trying to do: I want to select A5:A20 and E5:E20 (say because I want to graph these 2 sets against each other).

Is there a way to do this without using the mouse?

Currently, I select through the keyboard A5:A20, and then holding down the Ctrl key I select E5:E20 with my mouse.

Thank you!

I open the Find and replace Dialogue Box using CTRL+F and then enter
the value I am looking for. Excel moves the cursor to the cell in
question with the found value.
Is there anyway to then use the keyboard to move from the dialogue box
into the actual worksheet, without having to mouse click back into the
open file? It seems there has to be some type of way to use the
keyboard to move from the Find Dialogue box without using the mouse.
I hope I am being clear on what I am trying to do, it seems very
simple yet I cannot figure out what keyboard command to use to
basically select the Excel Window while leaving the Find Dialogue box
open. I am basically trying to use only the keyboard to jump back and forth between the the Find box and then the found cell in the work sheet.
Thank you. - BWP

I am trying to create a macro that will switch tabs within a workbook. Currently I have 2 shortcuts set ctrl + q and ctrl + w to just switch back and forth between 2 sheets that I switch back and forth from often. The code I currently have just goes to a sheet with a specific name. Is there a way to program it to go to the next tab? Will there be a problem when I reach the last tab or do I need to send it back to the first tab when it reaches a certain count or the end?



hi All,
in a excel workbook i have some 25 worksheets. now whenever i want to select any of the sheet i need to right click on the buttons (left side of the sheet tab) with the mouse and then need to select the desired sheet.

i am looking for a shortcut for this. can i do it without the help of mouse, i want to use keyboard only.



I suddenly have a strange problem. Usually you cann fill by using the mouse and pulling a corner of a field. This does not work anymore. How can I switch on this functionality again?



I am attempting to create a macro that will repeat a range of data as many times as specified on the spreadsheet.

So for instance, in Column A, I have the following values:


In Cell B2, I have the number of times I want those options to repeat. So let's say it says 4 in cell B2.

I would want the data returned in Column H as follows:


What I am getting is this:


This is what my code looks like:

Sub NaturalAccounts()
' NaturalAccounts Macro
' Keyboard Shortcut: Ctrl+n

Dim i, j, k As Long
i = 1
j = 1
k = Range("B2")
For i = 1 To k
Range("H" & j + i).PasteSpecial xlPasteValues
Next i
End Sub

Any idea why that may be?