Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:


Advertisements


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)
joemagiera@ameritech.net


View Answers     

Similar Excel Video Tutorials

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?

TIA.

Bob


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.........

jim


Is there any keyboard shortcut to switch between worksheets within the same
workbook? (i.e. much like I use alt-tab to switch between programs within
windows). Should be an easy one, but excel paperclip is silent.
Cheers,
Damon



hi there,

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


regards





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.

Thanks

Tim



Hello
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
Cheers

http://documentation.caseware.com/la..._Protocols.htm

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:

Keyboard
Mouse
Mouse
Monitor
Keyboard
Computer
Keyboard


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?
Thanks


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?

-----UPDATED------

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)?

Thanks


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!


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
websites):

http://www.techonthenet.com/excel/formulas/switch.php

but when I try this:

=switch(J4=F2,1,J4=G2,2,3)

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.




Hi

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 http://i33.photobucket.com/albums/d9...ck-taskbar.jpg. )
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. http://i33.photobucket.com/albums/d90/gQgler/IT/1.png
Can anybody help me with this annoying problem?


Hi

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 http://i33.photobucket.com/albums/d9...ck-taskbar.jpg. )
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. http://i33.photobucket.com/albums/d90/gQgler/IT/1.png
Can anybody help me with this annoying problem?


Hi,
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?


Hi,
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?

Hi,
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!