Excel Keystrokes
I used to work for a financial analysis company developing Excel macros/applications in VBA. There were — and still are — some 10th level Excel blackbelts that work there. I picked up quite a few keystroke tricks while working there. Even though I don’t work there anymore, I use these every time I’m in Excel.
- ctrl-Space – select column
- shift-Space – select row
- ctrl-Arrow Key – depending on which arrow key you hit, it will move the cursor along a series of cells*
- ctrl-Page Up, ctrl-Page Down – cycles through worksheets
- ctrl-Home – selects A1 on the current worksheet
*Longer explanation: Say that A2 is selected, and column A is populated from A1 to A50. If you hit ctrl-Down Arrow cell A50 will now be selected. If you then hit ctrl-Up Arrow it will take you to A1. The same holds true for left and right. Let’s also say that cells A60-A100 are populated. If, with A1 still selected, you hit ctrl-Down Arrow once (taking you to A50) and then a second time, it jumps over the blank gap from A51-A59 and selects A60. If you hit it a third time you will be at A100. It will probably make a little more sense if you tinker around with it a little.
What are your favorite Excel keystrokes?
- Published by jason in: Excel Tips 'n Tricks
- If you like this blog please take a second from your precious time and subscribe to my rss feed!
103 Responses to “Excel Keystrokes”
#1
¬ Lifehacker
February 20th, 2007 at 8:33 am
Keyboard shortcuts for Excel…
Excel user Jason shares a few of his favorite keyboard shortcuts for navigating spreadsheets: Ctrl-Space – select columnShift-Space – select rowCtrl-Arrow Key – depending on which arrow key you hit, it will move the cursor along a series of……
#2
¬ Matthew
February 20th, 2007 at 9:09 am
F2 F2 F2 F2
Hit the F2 key to edit a cell. When I first discovered this keystroke, it was like the clouds parted and the light of God beamed down on my keyboard. Give it a shot right now if you haven’t used the F2 key before. (Hint: it will allow you to edit the data in the selected cell)
#3
¬ Marshall
February 20th, 2007 at 9:17 am
Command-T on a mac, or F4 on a PC.
This changes a reference from relative to absolute or vice-versa. Repeating the command will cycle through all potential variants of partial and full references. Don’t know how people live without this one.
#4
¬ Blog Mirrors » Keyboard shortcuts for Excel
February 20th, 2007 at 9:18 am
[...] your favorite Excel key commands? Post ‘em up in the comments. — Gina Trapani Excel Keystrokes [TechJive] Original post by [...]
#5
¬ Jack
February 20th, 2007 at 9:34 am
My favourites:
Ctrl+1: Brings up the “Format cells” dialog box for your current selection
Ctrl+Shift+4 (i.e. Ctrl+$): Formats your current selection as currency
Ctrl+Shift+5 (i.e. Ctrl+%): Formats your current selection as a percentage
Ctrl+Shift+6 (i.e. Ctrl+^): Formats your current selection as scientific notation
F4 (when editing a formula), as mentioned above
Ctrl-Shift-Arrow key: As per the description of Ctrl-Arrow above, but it also selects all the cells in between. The Ctrl-Arrow, Shift-Arrow, Ctrl-Shift-Arrow and Ctrl-Backspace combinations also work in most Windows apps for word-wise movement, selection, word-wise selection and word-wise deletion respectivelyc.
#6
¬ JASon
February 20th, 2007 at 9:49 am
@Jack:
The Ctrl-$ and Ctrl-% are brilliant! I’m going to have to find a reason to use those today.
Another combination I use very regularly before saving sets the focused cells on every tab to A1. First you’d select your last (or first) tab. Then while holding Ctrl down alternate between Home and Page Up (or Page Down). This cycles you through every tab moving it to A1. I’ll do this before I send a workbook out for review.
#7
¬ JASon
February 20th, 2007 at 9:57 am
@Marshall:
As you are probably aware, the F4 (cmd-T) keystroke you cite is when you have the referred to cell highlighted in your formula. Another use of the F4 keystroke is to repeat the last action. If you insert a row, column, or cell then hit F4, it will duplicate the action that just took place. Quite handy when you need to insert 10 rows without having to do them one at a time.
#8
¬ Donovan
February 20th, 2007 at 11:25 am
Very useful. I do a lot of work with database output into Excel. A favourite keystroke combination of mine is select a formula, F2 (edit), F9 (calculate), converting the formula to a value. Often use ‘&’ in a formula to concatenate text, then F2, F9, ctrl+c to copy it so I can paste a “sentence” into other apps.
#9
¬ oldTom
February 20th, 2007 at 12:16 pm
Using F4 for the absolute/relative edit doesn’t seem to work in Excel 2007 — or am I missing something?
#10
¬ jeffron
February 20th, 2007 at 12:27 pm
OMG!! F2! F2! *faints on desk*
#11
¬ Ezra
February 20th, 2007 at 12:47 pm
Ctrl+PgUp and Ctrl+PgDn — to navigate through worksheets within a workbook — was briefly mentioned by JASon above, and is huge.
Ctrl+Minus and Ctrl+Shift+Plus do the Delete and Insert commands respectively, and are extra-huge if you use them immediately after pressing Shift+Space or Ctrl+Space to select entire rows or columns.
I like Ctrl+Shift+8 to highlight the active range.
Ctrl+9 and Ctrl+Shift+9 hides and unhides rows.
Ctrl+0 and Ctrl+Shift+0 hides and unhides columns.
Basically, Ctrl+Shift+[any key on the top row of your keyboard] does something interesting!
#12
¬ Excel Shortcut Keystrokes at sprignaturemoves.com
February 20th, 2007 at 12:59 pm
[...] can have enough shortcut keys… Here’s some good ones for [...]
#13
¬ Gary
February 20th, 2007 at 4:30 pm
I know it involves the mouse but i find it very helpful
Ctrl + moving scroll wheel on the mouse up or down adjust the zoom of the sheet.
#14
¬ Eoghan
February 20th, 2007 at 4:46 pm
Ctrl + D
This copies whatever is in the above cell or if you select a number of cells and use Ctrl + D it will copy what is in all of the above cells into those selected.
#15
¬ Derek
February 20th, 2007 at 5:09 pm
One keyboard shortcut that I have been looking for but have not found is paste formulas. (as in edit/paste special, formula button) This is very handy and a value or a formula without disturbing formatting. I always make a macro on my home machine to do this but miss it on other machines.
#16
¬ popxpop
February 20th, 2007 at 6:18 pm
ちょっと覚えておくと便利なExcelのショートカット5つ…
Excelをよく利用する方は覚えておくと便利なショートカットのご紹介。ちょっと……
#17
¬ JASon
February 20th, 2007 at 6:30 pm
@Derek:
If I’m reading your comment correctly, you are wanting to paste the value of the cell over the top of the formula that created that value. While this solution isn’t exactly a single keystroke, it does achieve your end goal rather quickly (this assumes you have already copied the cell(s)): Alt-E (opens the Edit menu), S (chooses the Paste Special option from the menu), Alt-V (selects the Value option from the form), Enter. When you actually use it you can go pretty quick, Alt-E S Alt-V Enter. Hope that helps out some.
#18
¬ How to edit a cell in Excel or Openoffice at Holy Shmoly!
February 21st, 2007 at 12:08 am
[...] been up to my eyeballs in receipts working on my VAT return. Luckily, Lifehacker linked to this Excel keystrokes post which has a couple of magic key combos but look in the comments for the real [...]
#19
¬ Brian
February 21st, 2007 at 5:51 am
ALT+= (equal sign): Insert the AutoSum formula
#20
¬ Tim Knight
February 21st, 2007 at 6:26 am
Wish I’d found this three weeks ago, after I had just broke my hand and found using a mouse a bit painful!
F2! Sheesh…
#21
¬ Jarrod
February 21st, 2007 at 6:35 am
Ctrl+” is another way to do the fill in exactly as above, great when you are filling in some redundant data.
#22
¬ Will M
February 21st, 2007 at 8:34 am
Wonderful post, thanks… I wish I had found this yesterday, as things at the office have been miserably slow this week, I’ve decided to teach myself more about Excel.
Does anyone know if there’s a keyboard shortcut for auto-sorting a column? And if there’s a modifier to make it do only the column and not the ones beside it (I am really new to Excel, obviously)? In fact, anything keyboardy and related to filtering and sorting would be ideal (I remember there being a “show all” key for Filter Mode but I’ve forgotten it).
Guess where I’m writing all of these shortcuts? Excel!
#23
¬ Djon
February 21st, 2007 at 11:41 am
Matthew, you are my hero!!! F2! Actually this was a question that I’ve been wondering about half a year!
#24
¬ Chris
February 21st, 2007 at 6:24 pm
If you liked [F2], you’re going to love [ / ].
I’m surprised nobody else has mentioned this. It’s a holdout from when Lotus 1-2-3 was the standard spreadsheet, and Excel was the plucky newcomer.
When you hit that little forward slash key [ / ], it moves your cursor up to the menu bar. You can now get at all the commands on the pull down menus using the underlined letters you see in each of the menus.
So Will M, you can do a sort by hitting [ / ] [ D ] [ S ]
And JASon’s example can also be done with [ / ] [ E ] [ S ] [ V ]. It’s one that I use all the time. It’s faster in my mind because you don’t have to worry about doing finger gymnastics to find the [ ALT ] key.
If it isn’t working, or you don’t like the “/” key, check the “Tools | Options | Transition” menu. The “Microsoft Office Excel menu key” lets you enter any character you want in here.
#25
¬ aziz
February 22nd, 2007 at 7:38 am
At least of French Windows Excel version I use these shortcuts, probably slightly different on Mac and/or english versions
Ctrl + : inserts the current hour
Ctrl + ; inserts the current date
Ctrl + End selects the last bottom right cell of the edited zone
#26
¬ Jonathan
February 22nd, 2007 at 11:39 am
Insert a new row…
1 – Shift Space to select the row
2 – Control + to insert a new row
Delete a row
1 – Shift Space to select the row
2 – Control – to remove row
#27
¬ Landon
February 24th, 2007 at 4:11 pm
Derek, Jason, Chris
paste the value of a formula in the same cell as the formula by F2, F9
You can also use the F9 to check pieces of a nested formula. Highlight the piece(s) you want to test, press F9, it will replace that portion of the formula with the value. Then hit ESC to get your formula back.
#28
¬ catharsis » one down. one moved. three to go.
February 27th, 2007 at 4:01 pm
[...] what’s special about this number excel keystrokes =] the dragon in my [...]
#29
¬ the evangelical outpost
February 27th, 2007 at 8:40 pm
Yak Shaving Razor #81…
Yak Shaving — [MIT AI Lab, after 2000: orig. probably from a Ren & Stimpy episode.] Any seemingly pointless activity which is actually necessary to solve a problem which solves a problem which, several levels of recursion later, solves the……
#30
¬ vista opening party
March 2nd, 2007 at 1:51 pm
Actually, to be honest: Ctrl + Alt + $ or % or anything else is pretty sweet, it formats the cell accordingly automatically.
#31
¬ JASon
March 2nd, 2007 at 1:59 pm
Calling a halt to the dorky commenting and all associated follow-ups. Not that I don’t appreciate getting comments, but the point of this is to help people to work more efficiently, not to bag on anyone because they may or may not be a dork.
Now, any new nuggets of Excel wisdom?
#32
¬ Terry
March 3rd, 2007 at 4:03 pm
F2 for the Mac?
Recent Mac convert here.. and Excel whiz on the PC. Not knowing the keyboard shortcuts for Mac is killing me, though.
F2 only works for the PC and seems to be a “copy” command on the Mac. What keystroke let’s me enter the cell on a Mac? Any help appreciated!
Terry – Washington, DC.
#33
¬ JASon
March 4th, 2007 at 3:47 pm
@Terry in DC:
I use a Mac at home, but rarely use Excel on it so I hadn’t caught this nuance before. I did some digging, and the keystroke you are looking for is ctrl-U. Also, if you launch the Excel help, and search for “keyboard shortcuts,” the first returned value (at least for me) is a very extensive list of Excel shortcuts. Hope this brightens your day a little.
#34
¬ DaDestroya
March 9th, 2007 at 11:19 am
Ctrl+F is basic of course, but how many of us were saved hours of needlessly searching pages of code, when one of the most useful of the keystrokes was right before us?
Ctrl+F. It finds EXACTLY what you’re looking for.
What a lifesaver.
#35
¬ paul from NY
April 18th, 2007 at 10:00 am
JASon thanks for the alt e s alt v tip — i was looking for the key strokes for copying and paste special formula but ms doesn’t show the key stroke. ctrl c, alte, s, alt f, enter for those following along at home.
#36
¬ chris
April 19th, 2007 at 7:53 pm
dont think i saw this one.
ctrl+shift+any directional arrow = selects from the active cell to the last cell with data in the selected direction.
#37
¬ Carol the billing coordinator
May 7th, 2007 at 12:54 pm
I am a billing person and I create bills from a spreadsheet of information. I use a macro to extract information from the spreadsheet and paste it into a billing template form. But I have not found a way to insert into the macro a function that will ensure that the data format matches the destination format. When I do this manually, I use the mouse to click on the Match Destination Format option in the Paste Options dialog box. But I cannot use a mouse click in the macro. The options in the Paste Options dialog box have the first letter underlined, so I am thinking that there must be a way to access them via keystroke, but how? Thank you so much to anyone who can help — this is a time monster!
#38
¬ Senthilvel.s
May 30th, 2007 at 9:16 pm
When we are pasting something copyed from excel. We can find one more menu like paste option what is the short cut for to move on to that menu.
#39
¬ Serena Knutz
June 20th, 2007 at 9:04 am
Whenever I select a range that spans multiple pages, I frequently use Ctrl +. (period) to check the four corners of the range to make sure I’ve selected what I intended. Each time you press Ctrl+. it jumps to the next corner in a round-robin fashion.
#40
¬ Project Finance Consultant
July 13th, 2007 at 3:14 pm
The Excel shortcut sheet at the site below contains all shortcuts mentioned in the posts above, all in a nice one page PDF layout.
http://www.navigatorpf.com/Downloads/Downloads/Excel_Shortcuts_/
#41
¬ Lepton
July 21st, 2007 at 9:32 am
Maybe someone can confirm this one I found as I tried out some of the keystrokes I learned here.. It is not documented in Excel Help’s extensive list or on this page: ctrl+> (ctrl+shift+.) .. it appears to copy the cell to the left and paste into currently selected cell, or for a selected range, copy the top-left cell in selection and paste into each cell in selection. The corresponding ctrl+
#42
¬ Lepton
July 21st, 2007 at 9:34 am
I forgot to encode my < sign there. The last sentence should read, “The corresponding ctrl+< however does not appear to be implemented.”
#43
¬ Lepton
July 21st, 2007 at 9:36 am
Actually I’m incorrect about the exact behavior of that keystroke. To be honest I don’t understand it.
#44
¬ Stuart
July 29th, 2007 at 12:15 am
Is there a shortcut key or combination to go back to the last cell you were looking at (ie the equivalent of SHIFT + F5 in Word)?
#45
¬ Chandra
August 15th, 2007 at 5:07 pm
Anybody know what the keystroke is for jumping into edit mode in the tab holders? Say you’re in a cell and you want to change the name of your worksheet tab. I usually click on the tab then F2 –or– simply double-click. Is there a keystroke that takes you from the cell to the tab then into edit mode? Would that take 2 keystrokes? One keystroke would be awesome. LOL I’m just being lazy. Thanks!
#46
¬ Chandra
August 15th, 2007 at 5:10 pm
Actually, i only double-click. I don’t click-and-F2. I don’t know why I said that. That doesn’t work.
#47
¬ ben
August 29th, 2007 at 12:15 am
I have seen people add one row to another with a few keystrokes. For example, adding A1:A4 to C1:C4 resulting in C1 containing +A1, C2 containing +A2, etc. Any ideas on how this is done?
#48
¬ Sheri
August 30th, 2007 at 8:24 am
In Excel, I want to wrap with a keystroke shortcut. Even though the W is underlined, I can’t get anything to work.
#49
¬ marymacster
September 5th, 2007 at 9:09 am
Does anyone know a shortcut for “insert comment”??? any ideas would be greatly appreciated!!!
#50
¬ brelly
September 10th, 2007 at 8:52 am
Shift + F2 is “insert comment”. Esc twice exits comment edit. To delete a comment, the right click button on the keyboard if you have it, then ‘m’.
#51
¬ Rob
September 19th, 2007 at 10:43 pm
I agree with project finance consultant above, the following PDF answers most questions in this forum and is also easy to print.
http://www.navigatorpf.com/Downloads/Downloads/Excel_Shortcuts_/
#52
¬ Lisa
October 16th, 2007 at 9:22 am
I would like to be able to select the autofilter option on the cell and have it open with a keystroke.
I am currently building a macro that requires this step, and I am having no luck so far. I do not want it in VBA language if possible.
#53
¬ Corrupt Excel Repair
October 17th, 2007 at 11:04 pm
Your excel keystrokes topic contain good shortcuts for excel. And new user takes more advantage after reading your article.
Thank you
Damon Thomas
http://www.excelfilerepair.com
#54
¬ Fix Xls
October 17th, 2007 at 11:07 pm
All the shortcuts are good but I used ” ctrl-Page Up, ctrl-Page Down – cycles through worksheets” a lot.
Thank you
http://www.excelfilerecovery.com
#55
¬ 131 Applicazione per Email - InstantMessaging - Word - Exel e Altro | INFORMATICANET
October 18th, 2007 at 6:58 am
[...] Excel Keystrokes: Save yourself some time and the perils of carpal tunnel syndrome by checking out these easy Excel keystrokes. [...]
#56
¬ B Nowack
October 24th, 2007 at 11:18 am
I often work with data in scientific notation. Is there a shortcut for entering numbers using only the number section of the keyboard? (i.e., entering 1.7E+09 without using the ‘e’ character)
#57
¬ Deepti
November 26th, 2007 at 2:35 pm
Any suggestions for the following: I have a set of cells, say 10 and need to get the mean +/- s.d. While I can do this in two separate steps, i.e., mean in one cell, then s.d. in another, is there a way that I could combine the two in one cell? I tried using a semi-colon in the formula bar, but
.
Thanks.
#58
¬ Dawn Buzbee, The Software Pro
November 30th, 2007 at 10:19 am
Thanks, TechJive, for the excellent time-savers. The Edit shortcut, [F2], has been one of my favorites for years but is often unknown even by the experts. I also like [Alt] + [Enter] to move to a new line in the same cell when typing long text entries. For a handout of Excel keyboard shortcuts for moving and selecting plus other Excel tips and tricks go to:
http://www.softwarepro.com/tips/handouts.htm#excel
#59
¬ Instructify » Blog Archive » Excel at Excel with Keyboard Shortcuts
February 19th, 2008 at 12:49 pm
[...] this sounds familiar, TechJive can help you become an Excel master with a listing of Excel shortcut keystrokes that streamline common tasks like selecting columns and rows, or cycling through various [...]
#60
¬ Mitchell
February 24th, 2008 at 9:08 pm
I get cramps clicking “check boxes” in Pivot Tables anyone know how to choose a range in stead of hundreds one after another.
#61
¬ Lou
February 26th, 2008 at 10:41 am
Does anyone know of a shortcut for repeating a command or macro. I seem to recall in older versions of office there was some simply keystroek that you display a dialog box that you simply typed in the number of times to repeat a command. Once the quantity was entered, the command was selected and it was repeated that number of times. Does this ring a bell for anyone?
Thanks!!
#62
¬ startswithj
March 3rd, 2008 at 10:48 am
for the mac users, f2 doesn’t work. to edit cell contents right in the cell, press ctrl-u instead.
#63
¬ Nik Burns
March 19th, 2008 at 6:29 am
kind of a shortcut, well I like it. Found this gem on google a while ago. Useful when you need to do a lot of autofilling on large worksheets.
highlight blanks that need to be ‘copied into from above’ (F5 special, blanks)
then just type
=
up (up arrow)
ctrl-enter
voila, all data copied down without having to do it individually.
Nik
#64
¬ sho
April 8th, 2008 at 12:12 pm
ctrl+space is not working on excel 2007 on my desktop. help please
#65
¬ shrini
April 22nd, 2008 at 11:46 pm
I was desperate to find out how to cycle through the sheets. Thanks much.
My favorite shortcut – Ctrl+5 for strike through formating.
-Shrini
#66
¬ Tom O'Connor
April 24th, 2008 at 10:18 am
Here are some more tips on navigation with your mouse.
http://www.wikihow.com/Navigate-in-Excel-Without-Using-Scrollbars-or-Arrows
#67
¬ Best Excel Shortcuts
May 7th, 2008 at 7:30 am
Nothing beats the good old F11 to create a graph! Just select the range, press F11 and you are done. If you want it to be more pretty, simply modify your default chart. To delete, press Alt-E-L, but be careful not to delete the wrong sheet (you can’t undo!)
#68
¬ JP
May 7th, 2008 at 5:23 pm
Shift-F11 inserts a new worksheet
#69
¬ blu
May 8th, 2008 at 6:15 pm
if you have one of those apple wireless keyboards ( the ones that don’t have the PgUp, PgDn etc)
then you might like this….on the Ctrl+PgUp and Ctrl+PgDn — to navigate through worksheets within a workbook tip do fn+option+left/right-Arrow for it to work…big find for me
#70
¬ AW
May 10th, 2008 at 9:11 am
I can’t use my arrow keys to navigate cells in a sheet. Pushing an arrow key just scrolls the sheet over and leaves the selected cell the same. What happened and how can I change this back? I’m very frustrated. Thanks
AW
#71
¬ JP
May 10th, 2008 at 6:42 pm
To AW:
You have Scroll Lock on. Turn it off.
HTH,
JP
#72
¬ logicbit
August 1st, 2008 at 12:26 am
“Command-T on a mac, or F4 on a PC.
This changes a reference from relative to absolute or vice-versa. Repeating the command will cycle through all potential variants of partial and full references. Don’t know how people live without this one.”
as to the PC keystroke, dude that’s frakn funny.
nice folllow up as well.
oh what a wicked web we weave…
#73
¬ Carolyn
August 8th, 2008 at 9:24 pm
Not sure if this is where I ask a question? But here goes.
Column A = 1500 Column B=800 Column C needs to return the difference (if any) OR 0 (if no difference)
#74
¬ Jayminator
August 21st, 2008 at 8:19 am
Every time I paste on Excel there’s a drop down menu (paste options), which is not too bad. The only thing is that sometimes I’m pasting too much desiring having less clicks on this menu. For example, today I’d like to leave it in “Match Destination Formatting” as default, instead of opening and clicking it for every paste I do.
Is there somehow that I can do this?
Thanks in advance!
#75
¬ Rickard Warnelid - Navigator Project Finance
August 26th, 2008 at 9:24 pm
Carolyn,
The way you have described it suggests that you could simply do A1-A2 to get the difference, but I am guessing that what you are really after is something like =MAX (A1-B1,0) ?
Hope it helps
Rickard
#76
¬ Matt
October 30th, 2008 at 4:13 am
Lisa Oct 16th 2007 wrote: “I would like to be able to select the autofilter option on the cell and have it open with a keystroke. I am currently building a macro that requires this step, and I am having no luck so far. I do not want it in VBA language if possible.” I couldn’t get this to work either so I asked a colleague to “Bob the builder” my VBA. The result of his endevours works;
Sub AutoFilter()
Dim intCol As Integer
intCol = ActiveCell.Column
Selection.AutoFilter Field:=intCol, Criteria1:=ActiveCell.Value
End Sub
You can set up a keyboard shortcut so you can filter by selection like access. I find this extremely useful, hope this is what you were after?
#77
¬ JW
May 22nd, 2009 at 10:52 am
I recently discovered ALT-[ENTER] to wrap words in a cell when you do not want to format a cell with word wrapping.
#78
¬ gwe
May 25th, 2009 at 8:03 pm
What is ctrl orig?
#79
¬ Serdel
June 16th, 2009 at 8:07 am
When You want to insert the same value to some range – simple highlight it type value You want to insert and pres Ctrl+ Enter – all cell will be filled with entered value
Ctrl + ~ show all formulas instead of values – great for long and complicated sheets
#80
¬ Mushtaq
June 22nd, 2009 at 1:04 am
we can copy text/values from a cell to the immediate below cell using Ctrl+D keystroke.
#81
¬ Mushtaq
June 22nd, 2009 at 1:51 am
Hello Everyone,\n\nPlease let me know the shortcut keys to rename a worksheet.\n\nThanks
#82
¬ Ramakrishna
June 24th, 2009 at 6:43 am
I need small help from you when user press some key in keyboard, how that stroke will be captured using excel VBA
#83
¬ Bejamin
September 23rd, 2009 at 2:59 pm
One of my favorites keystroke combinations when working with formulas is the CTRL + ~ combination. It allows you to see all formulas inside your Excel worksheet. Type in the same keystrokes to undo the command.
#84
¬ Sean0
September 27th, 2009 at 2:11 am
Any one know what the short cut is to get the hash symbol, have seen it done can’t find it.
Thanks
#85
¬ Dan
October 22nd, 2009 at 11:33 am
Ever any answer to post #9
toggle absolute cell reference f4 key doesnt seem to work in excel 2007.
Is there another shortcut short of having to instal $ into every position needed in the formula string?
#86
¬ Schawn
October 27th, 2009 at 3:47 pm
There used to be a way to put a return in a cell of Excel – does any one remember the key strokes?
Thanks
#87
¬ alan
October 28th, 2009 at 11:54 am
schawn, it’s alt-Enter.
#88
¬ caheidelberger
January 20th, 2010 at 12:38 pm
@dan + #9: F4 does switch absolute/relative refs in Excel2007. It only works in the cell, while editing the contents (hit F2! I love that! Thanks!). If you just select a cell, F4 does bupkis (or repeats your last action).
–Start typing a formula — “=sum(a2″. when you finish typing the cell reference, hit F4. You should see A2 cycle through the various $ combos. You can do this one cell ref at a time.
–Or, if you have a range — “=sum(a2:g8)” — you can select the range, hit F4, and cycle the whole shebang.
–Oh! and I just tested this on a formula: if you select an entire forumla and hit F4, you’ll switch every cell reference at once! I love the keyboard!
#89
¬ Mary Ann
February 10th, 2010 at 11:53 am
Thanks for all the ideas so far, have found a few new ones. What I would like to know is if there is a way to repeat a formula in many sheets ( Jan to Dec) that adds the previous month to the current month giving you a year to date figure. I can go in and do one in each sheet separately , but was hoping that after I select all sheets Jan …hold shift key… Dec , and add a formula that would do this on all sheets at once.
#90
¬ David
March 8th, 2010 at 12:42 pm
Question: In Excel 2000 What keystrokes needed to remove a row or group of rows
#91
¬ Rickard Warnelid
March 31st, 2010 at 5:25 pm
The Navigator Project Finance Excel shortcuts sheet is not posted on a new URL:
http://www.navigatorpf.com/tutorials/excel-keyboard-shortcuts-basic
#92
¬ Jen
April 8th, 2010 at 6:05 am
http://www.asap-utilities.com/excel-tips-shortcuts.php
#93
¬ kumar
April 29th, 2010 at 5:07 am
When I copy on one cell then I want to paste other cell but I want to entire row whatever I copy on cell.
#94
¬ Office 2007 Training « Edtech411
August 23rd, 2010 at 11:46 am
[...] http://techjive.net/2007/02/02/excel-keystrokes/ [...]
#95
¬ John
January 5th, 2011 at 10:17 am
when you add a formula to a cell just to the right of a
column and double click the small square in the bottomright of that
cell, then that cell will copy down as far as the column to its
left. This is the same as dragging that small square down but
easier if the previous column is many pages high.
#96
¬ John
January 5th, 2011 at 2:36 pm
If you can call it a “short-cut” my most significant
improvement is to use the mouse with my left hand. This leaves the
right hand for the numbers, arrows etc. It took a few months to get
used to but I’ve been doing it for the last 15 years. If only there
was an easy way to get a remapped keyboard then there would be no
finger stretching required for all the ctrl+alt+F#
functions.
#97
¬ Deb
March 12th, 2011 at 9:09 am
I have to type the same info in a worksheet, but not in a way that I can use draging, or copying and pasting ( I’m going back and forth between various documents). Is there a way to “program” a key to always type the same thing?
#98
¬ eb
March 13th, 2011 at 8:47 am
On the mac, to wrap text in a cell, use control+option+enter
#99
¬ Christy
May 3rd, 2011 at 11:06 am
I need to move a letter by 1/2 a space in my excel spreasheet. I’m not sure if there is a way to do this. Anyone know?
#100
¬ James
July 14th, 2011 at 2:45 am
Regarding the F2, F9, enter sequence… is there a way to do this for a whole column in one go? For instance, I regularly have to Trim text from a database extract, and 256 character wide columns are annoying!
Rather that going down several hundred rows and F2 F9 them all, an all-in-one route would be a life-saver!
#101
¬ Greg
July 21st, 2011 at 2:38 pm
@James – if you’re just trying to copy values over a range to remove the formulas, select the range and hit ctrl-c (copy), ctrl-alt-v (paste special), v (values), enter
#102
¬ Dheeraj Kumar
July 23rd, 2011 at 2:03 pm
ok but not very usefull shortkut command
#103
¬ Rony
July 25th, 2011 at 6:09 pm
Hi! one key is “shift”, with this you can do this in Excel:
http://runakay.blogspot.com/2011/07/moving-cells-in-excel-without-copying.html
Leave a reply