****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 14">****** name="Originator" content="Microsoft Word 14">
I have customized a lot of keyboard shortcuts in 2003 and now the company is switching to 2010. For example, I have set alt+, as increasing decimals. How can I do the same in 2010? I have spent quite some time googling about the solution but is not yielding any results.
Thanks!
Is there any way to create keyboard shortcuts to open files or webpages? I want to be able to press a keyboard shortcut and have a specific webpage or file open. thx
Hi, I'm trying to build a macro in excel that will use a keyboard shortcut (ctrl arrow-down) the same way that I do, however when I run the macro, rather than acting the same (ctrl-arrow-down usually goes down to the next full cell) the macro is going literally the same number of cells as were recorded in the macro.
Is there a way to get macros to act the same as your keyboard shortcuts. I did click on relative reference but that didn't solve this issue for me.
More specifically:
I have a spreadsheet with one column (many thousands of records)
Many of the rows are blank.
I want to start at the top of the column and press ctrl-arrow down which takes me to the bottom record that is full and then begin my macro recording...
copy that cell (ctrl-c)
press ctrl/shift-arrow down to select the empty cells down to the next full cell
press shift-arrow up once to deselect that full cell (now at the bottom of my selection with all but the top cell selected)
paste the value that I copied in all those cells (ctrl-v)
and press ctrl-arrow down to set the cursor in the bottom full record for the next action.
Stop recording and save the macro and use it over and over.
(I'd like to set Ctrl k as the keyboard shortcut)
***
When I run the macro however, it runs the action on the exact same number of cells as the recording rather than going down to the first full cell and then selecting up. It doesn't act the same as my keyboard shortcuts. I did select the Use Relative References button. It is just recording the number of cells literally rather than going to the next full cell.
***
Below is a copy of the macro I've recorded. It seems that it should be simple.
I'm using Excel 2007.
***
Sub Macro9()
'
' Macro9 Macro
'
' Keyboard Shortcut: Ctrl+k
'
Selection.Copy
Range(Selection, Selection.End(xlDown)).Select
ActiveCell.Range("A1:A24").Select
Application.Width = 632.25
Application.Height = 723.75
Application.Left = 37
Application.Top = -7.25
ActiveWindow.SmallScroll Down:=6
ActiveSheet.Paste
Selection.End(xlDown).Select
ActiveWindow.SmallScroll Down:=30
Application.Run "Document2.txt!Macro9"
ActiveWindow.SmallScroll Down:=-51
Application.CutCopyMode = False
Application.Goto Reference:="Macro9"
End Sub
***
Any help or ideas are appreciated.
Joe
When you record a macro in Excel and set it to a keyboard shortcut...Where/How does it save this? The VBA code shows it commented out. When you delete the code it removes the shortcut from memory. Any help would be appreciated.
Thanks!
Is it possible to drag a formula and autofill using a keyboard shortcut?
Many thanks.
Two questions. Does anyone know how to get into the formula bar to edit a formula without using the mouse. Is there a keyboard shortcut to enter the formula bar to start editing the contents? Second question. Does anyone know the Mac shortcut for the above?
Hi
Does anyone have a list of Keyboard shortcuts for excel? like ctl s, ctl c , ctl v etc
thx
Is there something that would turn off some of the keyboard shortcuts
in Excel?
I can hit CTRL + SHIFT + END but instead of going to the end of the
sheet, I go to the end of the row. If I open the same xls file on
another computer, I can get to the end of the sheet, as I'm supposed
to. The same goes for using CTRL + SHIFT + <ARROW KEY>. On my PC, it
selects the entire row or column. On his, it may go 2 or 3 cells in
the direction I press, but that is it.
The user of the computer where this issue is occurring is a power user
of Excel, but may have tripped a setting that I'm not familiar with.
Does anyone have an idea as to why this may occur?
Why can't we post to the keyboard shortcuts area of the site anymore? I am trying to do things faster in excel and would like a more comprehensive illustration of the shortcuts in excel
Does anyone know where to go to find this?
I found something on another site: keyboard shortcuts in excel
but have yet to find much else like that.
I used to use the following keypad sequence to delete a row: / e d r, or column / e d c
For some reason this / e (slash edit) stopped working.
I use the / i r (slash insert) and that seems to work fine.
Assign Keyboard Shortcuts to Macros