REQ: keystroke for window pane freeze?

I know there is a keyboard shortcut to move and freeze window panes in
Excel 2000 (rather than moving the dividers around with the mouse)
because I saw someone do it once.

I forgot the keys however and if anyone can tell me what they are I
would really appreciate it.


4/11/2004, 1:39:37 PM

5 replies

In Excel Help, type "keyboard shortcuts". Click on the first link that shows up. There's some shortcut keys in there that appear to be what you're after

Hope this helps
Anne Tro
Author: Dreamboat on Wor
Email: Dreamboat*at*
4/11/2004, 5:01:04 PM
You could try Alt+W to bring the windows list down and then press S tha
will split the window based on where the active cell is.

F6 will switch between panes and Shift + F6 will do it in revers


Message posted from

Pete JM <
4/11/2004, 9:29:08 PM
Hi Charles

Excel has 2 features

1) Freeze Panes

2) Split

I *think* you are speaking of the latter? If so, the only shortcut keys
I know of are;

F6: Move to the next pane in a workbook that has been split


SHIFT+F6: Move to the previous pane in a workbook that has been split

You can Double click the small raised bar, just above the horizontal
scroll, to have a split applied to the active cell. You can also double
click it to remove it.

Perhaps what you saw was a Macro that had been assigned to a ShortCut
key? The macro below will toggle the Window Split

Sub ToggleSplit()
    If ActiveWindow.SplitRow = 0 Then
       ActiveWindow.SplitRow = ActiveCell.Row
       ActiveWindow.SplitRow = 0
    End If
End Sub

Just assign it to your shortcut key.

** Posted via:
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum ***
Dave Hawley
4/12/2004, 1:55:31 AM
Put click on the spot you want the window pane to freeze 
in and then select "Window\Freeze Panes" from the main 

>-----Original Message-----
>I know there is a keyboard shortcut to move and freeze 
window panes in
>Excel 2000 (rather than moving the dividers around with 
the mouse)
>because I saw someone do it once.
>I forgot the keys however and if anyone can tell me what 
they are I
>would really appreciate it.
4/12/2004, 2:04:16 PM
Thanks for replying.

No, it was something else. What I saw was someone moving the pane splits
around with the keyboard, not with the mouse. It impressed me and some
others watching as well. I don't thing it could have been a local macro.
At the time I thought I'd look up the key combo in the documentation
somewhere but I never found it. I should have asked at the time.

Thanks for the ToggleSplit macro anyway, neat and potentially useful.

4/12/2004, 3:48:47 PM

0 replies , 8/4/2003, 7:14:55 PM
When I type the numerical key number 4, a number 3 is typed instead.

Recording Keystrokes
2 replies , 11/27/2003, 5:55:58 AM
I want to write a macro that will execute a number (up to 30) of key strokes from wherever location I select. The macros I've recorded always appear to need a cell reference for their Selection, and will only execute in those cells. I want to highlight and sort selections unequal length (selected by the End Down sequence), anywhere in a worksheet, but my macro recording always executes in the same location, and I don't know how to use relative rather than absolute locations in the VB code. Thanks for any help! Geoff

Geoff Sale
Cool Keystroke
3 replies , 7/23/2009, 11:01:53 PM
Hi, I stumbled accross a cool keystroke today that coudl be very helpful for me but I can't replicate it. Here's what I did. I was pasting a row of data into excel and I somehow pasted in negative signs in front of all of the data at the same time. What is the key stroke to do this? Is there a way to enter in /1000 for a large chunck of data? This is something I deal with all the time and would be super helpful. Thanks for your help. Lisa

Keystroke for Formatting
1 replies , 2/13/2006, 10:24:40 PM
Is there a keystroke for text wrap in a cell? -- Anne Maxwell Workman Nydegger SLC, UT

Keystroke to send
7 replies , 7/15/2005, 5:28:51 AM
Command return is no longer sending. Any ideas thanks! OS 10.4.1 Office 2004

Number of Keystrokes
1 replies , 5/6/2009, 11:11:01 PM
How can I get a count on the number of ketystrokes in a Word document?

Count keystrokes
2 replies , 5/28/2006, 1:44:46 PM
I have a simple data entry form where users are requested to type in a description of work performed. I want to limit the amount of text they can enter and would like to display a "live" counter that tells them how many characters they can enter. This counter would decrease as they made each keystroke and stop at zero. Appreciate any suggestions or alternatives to the counter.

closes with any keystroke
1 replies , 4/16/2004, 7:02:08 PM
Excel 2000...program opens ok. Any keystroke closes program. Any ideas?

Keystroke combination for @?
1 replies , 12/4/2004, 2:01:02 AM
Is there a keystroke combination to equal the symbol @. Such as Ctrl plus keypad numbers? The numeral 2 does not function on my keyboard, but it is a multimedia keyboard that is good otherwise.

Keystrokes Not Working
2 replies , 10/29/2004, 12:58:46 PM
When working in mail, specifically the inbox, several keystrokes (delete message, arrow keys, close �command w�) continually stop working. It is very erratic. They seem to work when first opening the program, then stop, and will often times start working at a later point. Other keystrokes do not seem to have this problem. Help!

Marty Williams
Keystroke for inbox?
10 replies , 4/18/2004, 4:00:53 PM
Is there a keystroke one can make for inbox? OS 10.3.3 Office X

Keystroke question
1 replies , 9/27/2003, 9:26:22 PM
For sending message, it says, command and then left turning arrow. What is that? Is there a keyboard shortcut for sending a message? Also is there keyboard shortcut for cancel out of spellcheck? Thanks!

Keystroke counter
4 replies , 6/14/2007, 10:37:41 AM
Hi guys. I am a translator and often have to overwrite *parts* of longer documents. It would be very useful to have a keystroke counter (not a logger) that displays a little window with the running total of the number characters I have typed. In Windows, apparently, this can be done with some low-level api code but I haven't been able to find out how it's done on a Mac. A Word macro would be ideal, but maybe it's just not possible. Any suggestions are highly appreciated. JP in CH

keystroke shortcuts
3 replies , 1/22/2009, 3:10:43 PM
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC I am keyboard-oriented rather than rodent-oriented (I learned to type on one of those old glass-sided Imperial clunker typewriters!), and new to PowerPoint...I am used to PhotoShop where I can customize keyboard shortcuts, but ppt doesn't seem to allow that. E.g., I use Insert>Duplicate Slide a zillion times a day and would love a keystroke to do it! Also Formatting Palette>Size, Rotation and Ordering>Layering>Send Backward etc...all of which have keystrokes in PhotoShop. Does anyone have any suggestions? Much obliged for any help Roy

Keystroke question
6 replies , 1/17/2006, 9:48:44 PM
Hello: Command-F brings up "Find" in Excel for Mac. The "Find Next" button is highlighted. Is there a keystroke that one can invoke to highlight the "Close" button? I find it quite inconvenient to have to grab the mouse to push the "Close" button. Thanks! --Guy Thurston, OR

Guy Kudlemyer
Switch between sheets with keystrokes?
3 replies , 11/14/2007, 2:40:01 AM
How do I switch between the last two active worksheets (within the same workbook) with keystrokes? I'd appreciate any help you can give. Thanks, Richard

Hmmm... Keystroke ceases to be
0 replies , 3/9/2008, 8:28:19 PM
So I finally managed to get back to English (US) as my default, and reconstruct my Toolbar just the way I want it. Only now I discover the keystrokes I used to navigate to the top or the bottom of a document no longer work. I don't know what they're called on an English physical keyboard (I Use a FRench Canadian one), but I'm pretty sure the bottom of the document key is called "End." (It's "Fin"on mine). It's not a huge deal, but I am in the habit of using those two keys -- and they still work in other apps. I looked under Customize Keyboard, but couldn't see an obvious command for Go To Beginning of Document or Go To End of Document. All input welcome. TIA. -- "Scriptwriting is making a cut and controlling the bleeding�"

Assigning Save As to a Keystroke
0 replies , 3/10/2008, 12:27:37 AM
I want to assign Save As to Ctrl-Shift S -- can't find the command. Is it called something obscure? -- "Scriptwriting is making a cut and controlling the bleeding�"

Change sounds after keystrokes.
1 replies , 3/5/2006, 6:56:28 PM
After I have struck the last key in a series of kewystorkes,there is a short delay and then an annoying "dingaling". How can I change that? Is there a way that I can get just a simple click for each keystroke?

XL navigation with keystrokes
2 replies , 10/15/2003, 10:57:26 PM
Help! I simply want to use the keyboard to enter/active the Formula Bar area so that I can of efficiently edit imported data. Right now I am clicking on each cell then clicking in the Formula Bar then using keyboard to make edits. Very cumbersome

Keystrokes Erased as I type
1 replies , 8/15/2009, 4:47:01 PM
While I am typing in excel, word or outlook I will loss ten to twenty keystrokes which I cannot recover. It actually happened twice while I was typing this message. I have run a number of virus checks to no avail.

VBA to disable keystrokes?
3 replies , 5/24/2006, 5:56:12 AM
I have customised a file which removes toolbars, menus etc and some of the sheets (accessed by macros linked to buttons) I want to keep private. However, I have realised that the sheets can be accessed by using ctrl+page up or page down. Is there a macro I can use to disable these keys? Another way would be to hide the sheets I don't want people to access but I cant unhide them and rehide them using a macro for some reason (worksheets.visible) when I need to access them. Any help would be appreciated. Mark

assign keystroke to object or button
0 replies , 3/6/2006, 9:35:06 AM
Hi is it possible to assin a key stroke (i.e. Ctrl+V) to a button or object? Many Thanks rufusf -- rufusf

Automate keystrokes w/ VBA?
1 replies , 2/17/2006, 6:44:30 PM
[Posted also in microsoft.public.outlook.program_vba, so if that's a better place for this inquiry just let me know] Goal: Allow user to jump to a certain screen/field in Outlook 2003 to quickly tag a contact record. Essentially I want to automate the following sequence of keystrokes: ->Contacts ->All Fields tab ->All Contact Fields ->User Field 4 & enter a value of "HH" I had imagined I'd just go into Macro and say "start recording keystrokes" but that doesn't seem to exist. Correct? Then I thought I could write something in VBA but I'm a VBA novice and I don't quite know how to do what I want. Does anyone know/have any code that would do this? And if it can be done w/ VBA, can I trigger it from a hotkey combination or a custom toolbar button? Or if there's another/better way (other than VBA) of accomplishing what I want, I'm all ears. Thanks in advance for an advice! -Rich

Rich Roller
simple keystroke macro code?
1 replies , 5/2/2007, 2:33:07 PM
Does anyone know how I would write a macro that would perform the following keystroke: Alt,S,R Thanks! Chris

How do I enter dates with one keystroke
2 replies , 7/30/2008, 6:50:45 PM
I am new to excel. This may be the stupidest question of all time, but I would like to know how to assign, program, or whatever you call it in excel a date to a key so that when I am in a cell and want to enter that date all I have to do is use one keystroke. For example, can I somehow assign a date like 07/26/08 to the F10 key so that every time I press F10 the date 07/26/08 is entered into the cell where the cursor is? Thanks in advance for any help you can provide me. -- barefoot

Keystroke print button not working
1 replies , 6/12/2004, 11:54:10 PM
When I keystroke the return button to print, it wont work. Ok with mouse though. This usually goes away with a restart. This is a long time annoying problem. Someone on this forum said this problem should go away with 2004, but I guess not. OS 10.3.4 Office 2004

Lotus keystroke option not appearing
2 replies , 3/2/2005, 4:49:03 AM
In almost every version of Excel I have ever used, except the Student and Teacher Edition 2003, there is an option to change to use "/" for lotus keystrokes. For whatever reason, it does not come up under tools-->option-->transition on here.. What gives?

Keystroke launcher within Office
0 replies , 6/12/2008, 1:35:02 PM
Have you ever forgotten where to find certain features/options/settings within an MS Office application and found yourself searching through the menus/tabs. I know I have. It can be simple things like customizing tabs or table of contents, or changing macro settings. If you do not do this all the time, you may forget. Although you may know what you want to do, you may have forgotten where to find it. Now my questions is, have you ever tried a keystroke launcher? Like Launchy (the open source keystroke launcher) or if you have Windows Vista, the start menu search feature? I started using Launchy a while ago (I still have XP). Now I cannot live without it. Those of you that have Vista probably say the same thing about the start menu search feature. In case you haven't tried one yet, you should! With that said you probably figured out where I'm going with this. A keystroke launcher within Office. It would greatly enhance productivity. Well I guess I can only speak for myself, but this is my honest opinion. It would work like this: hot key - type some letters - hit Enter - BOOM, you're there Simple yet very efficient. This could even be used for simple things like text formatting: hot key - "bold" - Enter - done Eventually if bold is the option starting with b you use the most, this quickly becomes: hot key - "b" - Enter - done Couldn't be more simple. Maybe eventually you could hide the ribbon, giving you the entire screen to work with. Stupid idea or great new feature? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.

Assigning keystrokes in Mac Excel?
1 replies , 5/17/2008, 1:02:24 AM
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel I use lots of keystrokes when I work with financial modeling in microsoft excel at work. When I bought my Mac I was surprised to learn that the key strokes (for instance for formatting row height "alt+o+e" ) are different or don't seem to exist. Is there a way to assign keystrokes in Mac exel? If not are there plug-ins or downloads I can use to make this possible? Many thanks!

keystroke to close active workbook window
4 replies , 12/7/2005, 10:36:06 PM
Is there a keystroke to close an active workbood window with Excel 2003? I am trying to use the mouse as little as possible. I do not wish to close ALL windows, just one at one time. Thank you.

Repeat keystrokes to delete character in column
5 replies , 10/4/2007, 3:29:01 PM
Hi, I have a column with mobile telephone numbers. e.g. 0846578902. (The cell is format to text not number) Now I need to add a 27 in front of each to become 27846578902 I'm sure this can be done with a macro but am not too familiar with vb. I had seen this in an earlier thread; Sub Remove4() Dim myCell As Range For Each myCell In Selection myCell.Value = Left(myCell.Value, Len(myCell.Value) - 4) Next myCell End Sub But that deletes the last 4 characters. 'm not sure how it is identifying the last 4!

How do I get Excel filename using a single keystroke
5 replies , 10/19/2006, 4:35:01 PM
I'm trying to create a single icon which will give me the filename and path of my spreadsheet. I know the longhand way - ie cell"filename") - I'm looking for a quicker way. Can anyone help?

For example, let's say I have 'autofilter' at the top of my column called 'Date.' How do I use keystrokes instead of the mouse to activate the drop down box so that I can select different dates? Thanks. Leslie

-- I have a spreadsheet with multiple worksheets that I use to manage/account for ammunition for army units. The first two cols in each worksheet are exactly the same: Col1 Col2 Col3 Col4 Serial Type Row1 0040 5.56MM Ball Clip Row2 0050 5.56MM Blank Clip Row3 0060 5.56MM Ball Link Row4 0070 5.56MM Blank Clip Row5 0080 5.56MM 4Bit etc........ Is there a command/function that will let me insert 2 new rows, say between Rows 4 & 5, and automatically do it for the other 25 worksheets in the spreadsheet as well ? 0071 5.56MM Ball [TR] 0072 5.56MM AP .. .. ~~~~~~~~~~~~~~ regards....'Ole ~~~~~~~~~~~~~~ "There are four boxes to be used in defense of liberty: soap, ballot, jury, and ammo. Please use in that order." -Ed Howdershelt