Email:      Pass:    Pass?
Advertisements


Free Excel Forum

Keyboard Shortcut To Move Between Non-consecutive Tabs

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

Not sure if this exists, but is there a keyboard shortcut to move from say the 1st tab to the 6th tab in a workbook and back to the 1st tab (much like alt+tab does when switching between programs)? Ctrl+pgup/pgdn takes a long time in large workbooks...

Thanks!


Similar Excel Video Tutorials

Helpful Excel Macros

Display the Print Window in Excel
- This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear when
Reverse Row or Column Order in a Worksheet
- This macro reverses the order of a selected row or column in excel. It will completely reverse the data.
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
Bubble Sort
- This macro will perform a bubble sort in excel. You use it simply by selecting one column to sort and then running the
Close a Workbook after a Time Limit is Reached
- This macro will automatically close the workbook in which it is located after that workbook has been opened for a certai

Similar Topics







Hello!

I need keyboard shortcut for switching through worksheets.

For now, I have this VBA macro and shortcut Ctrl+R:
Code:

Sub next_sheet()
'
' next_sheet Macro
'
' Keyboard Shortcut: Ctrl+r
'
ActiveSheet.Next.Select

End Sub


But, there is a problem: when i am on the last sheet, and want to go to the first, there is Error.

Any suggestions?

Thanks in advance.

Sinke


We know the keyboard shortcut for selecting the total column (CTRL+spacebar).
once when i was using this, some how it got removed. Can any one of you
helpme how to get the shortcut back. Also share some information about
assigning or removing keyboard shortcuts in excel.



I'm looking for a keyboard shortcut (or something) that is like CTRL+right_arrow but will take me to the very last cell in the row that has data. I need the same thing for a column. I've looked all through the keyboard shortcut info that I can find and haven't been able to find this function. I just need to 'go to' that cell. Nothing else.

Any ideas? Or have I overlooked something obvious for a shortcut?


Is there a keyboard shortcut that allows me to edit a particular cell (once the cell is highlighted) without using the mouse to move to the formula bar?

I guess I'm just too lazy to move my hand from the keyboard to the mouse.
Thanks in advance...


After I have traced a formula using Ctrl+[, what is the keyboard shortcut to return to the same cell from where I traced the formula?

I can only get Ctrl+] to work if all the referenced cells are within one worksheet. If I am writing formulas using cells in 1 or more worksheets and I try Ctrl+], I receive the error "No cells were found".

I used to know a shortcut to do this. I thought it was Tab+Tab+F2+Enter, but that is not working.

I really appreciate help. This keyboard shortcut used to save me so much time and I need it again!


When I make a large selection, e.g. ^*, I often want to move the selected cell from 1 corner to anoter in order to add rows or columns. In previous versions of Excel there was a keyboard shortcut for moving the cursor position to different corners of the selection. Is there a keyboard shortcut for that in Excel 2007?

Chuck


I've involuntarily upgraded to Excel 2002/XP. It has lots of lovely
security settings when protecting worksheets. When I _UN_check 'Select
locked cells' when protecting worksheets, the [Ctrl]+[PgDn] and
[Ctrl]+[PgUp] key combinations then function no differently than
[Alt]+[PgDn] and [Alt]+[PgUp] (so the same as they did back in Excel 4
and prior), paging right and left within the protected worksheet rather
than moving between worksheets.

If this isn't a bug, I don't know the meaning of the term. Has anyone
else come across it? There's no mention of it when searching *excel*
newsgroups in Google Groups for Ctrl and PgDn or Page Down or searching
in Microsoft's KB under Excel 2002 for these terms.




I'm trying to assign a keyboard shortcut (Ctrl+Shift+C) to comment a block of code in the Visual Basic Editor. How do i go about doing this? I know there is a toolbar with a button for it, but damn the mouse... I want a keyboard shortcut!


Thanks in advance...


Is there a keyboard shortcut that lets you move to the next tab or previous tab? This would be great instead of having to click on each tab.

Thanks,


I created a macro in Excel 2003 to update old workbooks to a new color palette, but I'm having an odd issue. It works perfectly when selected through the Macro menu, works fine with the keyboard shortcut CTRL+B, but breaks when using CTRL+SHIFT+B.

The VBA code:

Sub colorchange()
wbname = ActiveWorkbook.Name()
MsgBox (wbname)
Workbooks.Open Filename:= _
"Q:\Presentation Materials\New Color Palette.xls"
MsgBox ("Step 2")
Workbooks(wbname).Colors = Workbooks("New Color Palette.xls").Colors
MsgBox ("Step 3")
Workbooks("New Color Palette.xls").Close
MsgBox ("Step 4")
End Sub

When activating it from the macro menu or with CTRL+B, it executes fine all the way through step 4. When using any CTRL+SHIFT keyboard shortcut, however, the macro opens the new color palette and then ends without displaying "Step 2."

I'd prefer to use a CTRL+SHIFT shortcut in order to match all of my other excel shortcuts, but mostly I'm just curious as to why that keyboard shortcut would break this macro but none of the other macros I use.

Thanks.


Hello, everyone. Can anyone tell me if there's a keyboard shortcut to
increase or decrease the number of decimal places displayed? If not, can I
create a keyboard shortcut? I've done that in Word, but I can't find a
similar feature in Excel.
Thanks!



I know that you can use Ctrl+[ to link to a cell automatically where a formula might be in use. What is the keystroke combination to go back to the original cell?

This keystroke combination doesn't normally show up on any shortcut list, so please don't suggest I go to Help and click on keyboard shortcuts. This seems to be one that is not documented or else is a customer generated shortcut. If that is the case and there is a way to create a custom shortcut to enable this process, please let me know how to do this. I am not as proficient in Excel as I would like to be, which is the reason I am asking for help.

I am using Excel 2003.

Thanks!


Is there any keyboard shortcut to move forward and backward between previous location within excel sheet?

If no such shortcut, is there an add-on to achieve this?

Thanks.


Hi all,

Just a quick query regarding a keyboard shortcut, wondered if anyone might be able to point me in the right direction if it's possible. I have looked high and low so i'm thinking maybe not, but thought i'd ask the experts anyway....

Is there a keyboard shortcut key for bringing up the tab menu? I.e. when you right click on a tab and get the various insert / delete / rename / move copy / etc options.

I am forever having to reach for my mouse for these options, just wondered if anyone knows of a shortcut key to bring up that menu without clicking?

BTW using excel 2007.

Many thanks in advance!

Wayner


Hi:
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


all of my googling and help searching has come up empty on what I thought would be a simple search.
I just want to find the keyboard shortcut to change the active tab in Access 2007. You know like what Ctrl+Page Up (or Down) does in Excel or Ctrl+Tab in IE
Does anyone know how to do this?


Hey all, I know that in Excel 2003, you can use CTRL+PgDown/PgUp to navigate through worksheets, however in one of my workbooks, it is not working. When I CTRL+PgDown/PgUp, it will scroll the page right/left a page at a time. I have absolutely 0 code that alters shortcut keys, but I do have protected sheets.

I've narrowed the issue down to specifically the protected sheets where you cannot select locked cells. Any idea how I can restore this time-saving shortcut?

Thanks!


Hello
I have a problem, I need to asign a keyboard shortcut that gives the degree sign.
The thing is that the person that needs it, doesn't have the degree sign in the keyboard, and he says that in word he presses CTRL or ALT +d and it inserts the sign, but it doesn't work with excel.
I tried recording a macro that inserts the degree sign, and then assigned a shortcut, but it works only if the cell will only have that symbol.
My boss needs to be typing any phrase and in any moment while typing press any keyboard shortcut and it should work.
Hopefully you guys understand me.
Thanks a lot


I use the keyboard shortcut "CTRL + ;" frequently to enter the current date. It now does nothing. "CTRL + :" still enters the time and all other shortcuts appear to be working.

I have run "detect and repair" and have not changed anything (intentionally) in the program. I have searched everywhere for a solution w/o success and am reduced to begging for help.


Any thoughts?

Gene Y.


Please see the illustrated example (attachment). I use this "auto-fill feature" all the time... and I am so tired that I have to move the mouse everytime!! There MUST be a keyboard-shortcut for this. All I can find is ctrl+D which does NOT do the same as you HAVE to select a RANGE.

Rgds,
Peter


When I do a printpreview with the menu
File->Printpreview
I can use the PgUp and PgDn to go to another page.

But when I use the code

ActiveWindow.SelectedSheets.PrintPreview

I can not use the PgUp and PgDn buttons on my keyboard.
Is this because my sub is interrupted.

Anyone any suggestions how to solve this????

greets

Koen


I was wondering if anyone knew whether or not it was possible to assign a keyboard shortcut such as Ctrl+Shift+m to a particular sheet, so when the key command is pressed it activates a macro.

The purpose being I have several sheets in a workbook, and the first one acts as a home base. From every other sheet I wanted to assign a quick keyboard command to return to the first sheet. Perhaps there is another way to do this without using macros. Anyone have any suggestions?

Thanks.


I have two Excel workbooks open, displayed side by side. I can't remember the
keyboard shortcut for moving the cursor back and forth between the two
windows. .... ?

Art



How can I define a custom keyboard shortcut using non-letter letter keys. For example, I'd like to create a negative indent keyboard shortcut assigning the strokes as CTRL + SHIFT + <


Hi Guys,

Is it possible to write VBA code that effectively works as if I pressed "CTRL+Q" on my keyboard? The keyboard-shortcut refers to another program I have running in the background.

Or perhaps create some sort of Windows shortcut i can run via macro that does it?

Excel 2010 on Win 7