's Forum Archives - Non-Cycling Discussions

Archive Home >> Non-Cycling Discussions(1 2 3 4 )

Question for MS Excel Geniuses(8 posts)

Question for MS Excel GeniusesTJeanloz
Aug 7, 2002 10:18 AM
O.K., so my exciting job requires a fair amount of data manipulation in MS Excel, which is the easy part. The tedium is getting the data into MS Excel in the first place. Often, it gets plagerized (or shall I say "cut-and-pasted") from a web source, which requires one to "Paste Special" the data as "Text" to eliminate formatting.

"Paste Special" requires at least four mouseclicks, but a straight up "Paste" requires only one keystroke. Is there a keystroke shortcut to paste as text? Or can I customize the regular "paste" function to paste as text instead of as whatever format it's in?

This might seem trivial, but the difference between four mouseclicks and one keystroke would be surprisingly helpful to me.
dont think so, but why not just create a macro? (nm)ColnagoFE
Aug 7, 2002 12:26 PM
or "alt, e, s, v" on your keyboard seems to work (nm)ColnagoFE
Aug 7, 2002 12:30 PM
Lesson 1: Disconnect Your Mousejose_Tex_mex
Aug 7, 2002 1:07 PM
Seriously, if you are using a mouse it is absolutely slower than the keyboard shortcuts. Once I learned a few simple shortcuts I never used the mouse again.

I used to do the alt + e + s + v so often it was a reflex and took a fraction of a second to complete. The problem with the mouse is the time it takes to line up and select.

AGAIN - ABSOLUTELY try not using a mouse. I cannot type for my life but when it comes to Excel - it's all keyboard.

Do you have the transition keys turned on? If not this is an ABSOLUTE must. When copying data you just have to do a shift + end + down. When you select a range of data cells do you use the mouse? If so these keys will help your life enormously.

Definitely a macro would help. However, if memory serves me correctly, I believe you can make you own hot keys. Let me know if this helps - I'll bust out the Excel book.
I'd like to,TJeanloz
Aug 7, 2002 1:43 PM
I agree that life would be simpler if I could toss the mouse, but copying the data requires that I select it with the mouse (because I'm copying generally off of a web page), so the transition from mouse to keyboard is awkward. If I'm working exclusively in Excel, I almost never use the mouse, but for these data dumps, it seems unavoidable.

Programmable hot keys is just what I'm looking for- so that I could copy with my right hand and paste special with my left.
Aug 7, 2002 3:55 PM
I will have to see if this can be done for Excel. I think I saw what you want done in Word at

However, for now creating a hotkey to a macro that does what you want would probably be best. You could even have the macro program itself to move to the bottom of the data + 1 cell in case you are always pasting at the bottom of columns.

If I find the programmable hotkeys - I will post it here or start a new thread.

If it can be done in Word then then it should be do-able in Excel. You might also want to spend a few minutes at Microsoft's site. I had a very picky excel question once that got answered in a matter of minutes on their Excel forum - I wish I had the link...
re: Question for MS Excel Geniuseskyvdh
Aug 7, 2002 6:24 PM
There is a way to get an icon on the top bar that will do the paste special - text. I am at home right now and don't have excel here. There is a way to customize the toolbar with different icons. You might try looking in Help for customize toolbar. If you haven't gotten the answer before I check tomorrow at work, I'll post a more specific procedure. It's a nice feature because there are lots of icons out there that can save all the point and clicks you mention. Another one I use alot is insert row or column. I'll check back tomorrow (Thursday).

re: Question for MS Excel Geniuseskyvdh
Aug 8, 2002 7:51 AM
Here is the procedure:

Go to VIEW in the menu bar at the top
Select TOOLBARS - CUSTOMIZE from the pull-down menu
Select the COMMANDS tab in the customize window
Select the EDIT category
Scroll down the commands list until you come to PASTE VALUES
Drag the icon up to your toolbar and now it will be available to you.

Hope this helps.