advertisement
Forums

The Forum is sponsored by 
 

AAPL stock: Click Here

You are currently viewing the Tips and Deals forum
Question for Excel gurus
Posted by: john-o
Date: February 28, 2006 06:04PM
I'm trying to figure out if there's a keyboard equivalent to double-clicking on a cell to edit right there in the cell. Seems like I found one once, but now no luck. Also, once in edit-in-cell mode, is there any way to move the cursor forward or backward from the keyboard? This is in Excel '04, fwiw.

John-o the keyboard-shortcut addict
Options:  Reply • Quote
Re: Question for Excel gurus
Posted by: davester
Date: February 28, 2006 06:44PM
1. F2

2. arrow keys

These are for windows but they're probably the same for mac.

Just go to help and type in "keyboard shortcuts". It'll list more shortcuts than you can shake a stick at.





"In science it often happens that scientists say, 'You know that's a really good argument; my position is mistaken,' and then they would actually change their minds and you never hear that old view from them again. They really do it. It doesn't happen as often as it should, because scientists are human and change is sometimes painful. But it happens every day. I cannot recall the last time something like that happened in politics or religion." (1987) -- Carl Sagan
Options:  Reply • Quote
Re: Question for Excel gurus
Posted by: davester
Date: February 28, 2006 06:47PM
Does anyone have a shortcut for pasting unformatted text? I do that all the time and it is a nuisance doing it with menus.



"In science it often happens that scientists say, 'You know that's a really good argument; my position is mistaken,' and then they would actually change their minds and you never hear that old view from them again. They really do it. It doesn't happen as often as it should, because scientists are human and change is sometimes painful. But it happens every day. I cannot recall the last time something like that happened in politics or religion." (1987) -- Carl Sagan
Options:  Reply • Quote
Re: Question for Excel gurus
Posted by: Baby Tats
Date: February 28, 2006 06:50PM
davester Wrote:
-------------------------------------------------------
> Does anyone have a shortcut for pasting
> unformatted text? I do that all the time and it
> is a nuisance doing it with menus.

You're gonna need a macro for that one. Easy enough to do though. Just do a google search.







BT


Signed parental releases are on file for all tattooed minors.
Options:  Reply • Quote
Re: Question for Excel gurus
Posted by: Don C
Date: February 28, 2006 08:48PM
Would not Paste/Special/Values do that?

I have the icon for this function on my icon bar. It pastes just the text that is on the copy clipboard.
Options:  Reply • Quote
Re: Question for Excel gurus
Posted by: davester
Date: February 28, 2006 09:01PM
That doesn't quite do it. When you are copying and pasting a lot of cells, the extra step of going up to the toolbar each and every time really cuts your production rate. It's much faster to use the mouse only for selecting data and use the other hand for keyboard shortcuts to do the cut and pasting.



"In science it often happens that scientists say, 'You know that's a really good argument; my position is mistaken,' and then they would actually change their minds and you never hear that old view from them again. They really do it. It doesn't happen as often as it should, because scientists are human and change is sometimes painful. But it happens every day. I cannot recall the last time something like that happened in politics or religion." (1987) -- Carl Sagan
Options:  Reply • Quote
Re: Question for Excel gurus
Posted by: john-o
Date: February 28, 2006 11:14PM
Davester wrote:

1. F2

2. arrow keys

These are for windows but they're probably the same for mac.

Just go to help and type in "keyboard shortcuts". It'll list more shortcuts than you can shake a stick at.


Sorry Dave, but you must have misunderstood my question. F2 simply does a command-c: Copy. I'm trying to do what a double-click with the mouse does: inserts your cursor into the given cell, allowing you to type directly in that cell from there. Unfortunately, when you use the arrow keys in that mode, you simply jump to the neighboring cell, but out of the direct-edit mode you were using in the original cell…

Damn Micro$oft; I just wish they'd make everything as customizable as the stuff they think is important!

Thanks anyway,
John-o
Options:  Reply • Quote
Re: Question for Excel gurus
Posted by: john-o
Date: February 28, 2006 11:16PM
And Davester,

Anything you can do from a toolbar or a menu, you can add a keyboard shortcut for using Tools->Customize… You just have to be able to find it from there.

Problem is, I can't find what I want in there!

Options:  Reply • Quote
Re: Question for Excel gurus
Posted by: davester
Date: March 01, 2006 08:32PM
I didn't misunderstand the question, it's just that F2 works differently on the mac than on the PC. What you need is Control + U which should do exactly what you want (of course this is Excel v. X...I don't know if that command will hold up for your version.



"In science it often happens that scientists say, 'You know that's a really good argument; my position is mistaken,' and then they would actually change their minds and you never hear that old view from them again. They really do it. It doesn't happen as often as it should, because scientists are human and change is sometimes painful. But it happens every day. I cannot recall the last time something like that happened in politics or religion." (1987) -- Carl Sagan
Options:  Reply • Quote
Re: Question for Excel gurus
Posted by: john-o
Date: March 01, 2006 10:54PM
Davester! You're my hero!!

Not only does Control-u do exactly what I want, but I then discovered that control-[right/left] arrow allows you to move one word either direction within that cell without jumping to another cell!

Finally. Thanks again,

John-o
Options:  Reply • Quote
Re: Question for Excel gurus
Posted by: davester
Date: March 02, 2006 02:11AM
john-o Wrote:
-------------------------------------------------------
> Davester! You're my hero!!

Let's not get carried away now.

BTW, let's make it a mutual admiration society. You really helped me out with the comment on how to make your own keyboard shortcuts. I didn't realize it was so easy to do.





"In science it often happens that scientists say, 'You know that's a really good argument; my position is mistaken,' and then they would actually change their minds and you never hear that old view from them again. They really do it. It doesn't happen as often as it should, because scientists are human and change is sometimes painful. But it happens every day. I cannot recall the last time something like that happened in politics or religion." (1987) -- Carl Sagan
Options:  Reply • Quote
Re: Question for Excel gurus
Posted by: john-o
Date: March 02, 2006 08:47AM
…let's make it a mutual admiration society.

Cool. I like it when we both can gain from a thread like this.

Later,
John-o
Options:  Reply • Quote
Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 240
Record Number of Users: 186 on February 20, 2020
Record Number of Guests: 5122 on October 03, 2020