keyboard shortcut #4

Hi.
It would speed my productivity no end if I could use a 
keyboard shortcut for edit/paste special.../text.  Does 
anyone know how to set this up?

Many thanks 


0
anonymous (74717)
4/20/2004 4:55:26 PM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
499 Views

Similar Articles

[PageSpeed] 32

If you mean paste VALUES then right click on toolbar>customize>edit>look for
the one with the 12 in a box>drag to toolbar.

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"Grayling" <anonymous@discussions.microsoft.com> wrote in message
news:1b6a01c426f8$479887e0$a301280a@phx.gbl...
> Hi.
> It would speed my productivity no end if I could use a
> keyboard shortcut for edit/paste special.../text.  Does
> anyone know how to set this up?
>
> Many thanks
>
>


0
Don
4/20/2004 5:04:43 PM
> It would speed my productivity no end if I could use a
> keyboard shortcut for edit/paste special.../text.

If you *mean* Paste Special, you can rightclick a toolbar and select
Customize. On the Commands tab, under the Edit category, find the Paste
Special command and drag it to a toolbar or the menu bar.

Once it's there, you can use ALT+S -- T -- Enter.

If you mean Paste *Values*, Don told you how. But you can also customise it
to show as Image & Text and thus invoke with ALT+P.

HTH,
Andy


0
andy.j.brown (443)
4/20/2004 5:15:34 PM
Grayling

Record a macro while doing this then give it a shortcut key.

Sub Macro1()
    ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
        False
End Sub

OR  ALT + E + S then downarrow then <ENTER>

Gord Dibben Excel MVP

On Tue, 20 Apr 2004 09:55:26 -0700, "Grayling"
<anonymous@discussions.microsoft.com> wrote:

>Hi.
>It would speed my productivity no end if I could use a 
>keyboard shortcut for edit/paste special.../text.  Does 
>anyone know how to set this up?
>
>Many thanks 
>

0
Gord
4/20/2004 5:30:40 PM
Very many thanks for ideas. I should have said that I'm 
pasting an html table (I think!) so Paste Special... 
offers the options HTML, Unicode text or Text and I 
choose the latter.  I'm afraid I don't understand Gord's 
suggestion about recording macros but will look into it.

Regards
Grayling


>-----Original Message-----
>Hi.
>It would speed my productivity no end if I could use a 
>keyboard shortcut for edit/paste special.../text.  Does 
>anyone know how to set this up?
>
>Many thanks 
>
>
>.
>
0
anonymous (74717)
4/20/2004 6:48:01 PM
Reply:

Similar Artilces:

Conditional Sum #4
Hi, I am trying to get some information out of a sheet using conditiona sum wizard. BookCode BookYear StatementDate Deposit TotalReceivable SL 03 9/1/2005 180.00 1,195.00 SL 03 9/1/2005 704.00 4,689.00 SL 03 9/1/2005 703.35 4,689.00 NH 04 9/1/2005 2,250.0 15,000.00 RR 04B 9/1/2005 10.00 55.0 DP 03 9/1/2005 - 1,343.00 WH 02 ...

Custom Workflow Step (4.0): Error Setting Property Value
I have created a custom workflow step in CRM 4.0. I can add this step to my workflow without any issues. The code requires the order id from the workflow. So I go to "Set Properties" for the workflow step and set my property to the Order ID. I can save changes and it seems to work fine, but then when I open up the "Set Properties" window again, the system seems to have saved the value twice. I have tried to delete the value and resave, using other values from the object and I still get the same error. My workflow step then errors, because it's receiving an incorrec...

Updates #4
Version: 2004 Hello, I am not sure how works updates for Office for Mac 2004 so I hope you can help me. Customer's last update is 10.1.4 . He would like to install update 11.5.0 . To be able install new update he needs install all updates which was released among version 10.1.4 and 11.5.0 . Is it true? How he can get these updates? He strongly insist on downloading updates from webste. Could you plese recommend me what he should do? Is it possible to donwload all updtates via webste (I am able to search maily last versions)? Thanks If he has version 10.x the release is Office X whic...

10.1.4: First Class--as far as it goes
The improvements found in version 10.1.4 clearly signal that Microsoft listens to users and has been responsive in making some of the improvements that a number of us have advocated in our email to mswish@microsoft.com I had hoped for more bug fixes and improvements, particularly in Entourage, but will have to look forward to the next version. The installation and my subsequent test of Office components went well. I had, as required, previously installed 10.1.2. None of Office's components were renamed. I ran Repair Permissions first, turned off Office Notifications, disabled Norton Anti...

Dynamics 4.0 error
By accident, one of our network admins removed the crm server from Active Directory. We got back onto the machine and it thought it was still part of the domain. We unjoined and then rejoined the domain. Now when any user attempts to log in, an error message appears stating: Business Management Error: The user ID associated with the current record is not valid. Please help thanks On Oct 29, 2:54=A0pm, Irshard <Irsh...@discussions.microsoft.com> wrote: > By accident, one of our network admins removed the crm server from Active > Directory. =A0We got back onto the machine an...

English keyboard
Hi All, How can I switch the keyboard to English (or to any other) from Access ? Thanks in advance Imre ...

Keyboard
Hi, I need to catch the keyboard key`s ctrl+alt+e in my MFC application how can I catch the combination of those three key`s??? How can I catch the F5 key??? For a normal key`s I use appwizard OnChar function or KeyDown. Thanks. hi, I guess you can try GetKeyState(VK_MENU) and GetKeyState(VK_CONTROL) when you response the OnChar or KeyDown message. "Dave" wrote: > Hi, > I need to catch the keyboard key`s ctrl+alt+e in my MFC application > how can I catch the combination of those three key`s??? > > How can I catch the F5 key??? > > &...

hook keyboard and send as other keyvalue
hi, i have a problem to deal with global keyboard hooking . my application has to deal with a special keyboard, whitch asking that when press Shilft + A, it actually come out "#", Shift + B , it comes out "&".. and when shift is not pressed, the A is still A. i can not come out with the functionality no matter what.. i have to use global keyboard hooking since it is for the whole application LRESULT CALLBACK keyProc(int nCode,WPARAM wParam,LPARAM lParam) { PKBDLLHOOKSTRUCT hook = (PKBDLLHOOKSTRUCT)lParam; ??????? return CallNextHookEx(gHook, nCode, wPa...

Create an exel 2007 shortcut key
How do I create an excel shortcut key? For instance, I want to create a shortcut key for Moving or Copying a worksheet. I added it to the quick access toolboar, but cannot figure out to create a shortcut key for that command. Thank you for your help. Not sure why you need a shortcut key, when a button is already handy, but here are the instructions from the Excel help file. You'll need to put the command in a macro, then: "To assign a CTRL combination shortcut key to run the macro, in the Shortcut key box [click View Macros - select macro - click Options], type any lowerc...

Office 11.4.3 update breaks entourage
Is anyone else having problems with the latest office update? I updated and now Entourage crashes on exit and I have to use force quit. I've deleted the preferences but that didn't help. Hi Jason: Yes, there are sporadic oddnesses for a tiny fraction of users who update to the latest update. Download the latest Combo Updater for Mac OS X and re-apply that. It seems to cure a variety of these ills :-) It won't hurt to Rebuild the Entourage Database also, as described in the help. Cheers On 11/3/07 5:00 PM, in article C21A1042.1414%jasonmcd@mfaproductions.com, "Jason Mc...

KEYBOARD NOT WORKING
I know some people may help better if I give more specific details to my problem.. So here goes: My keyboard works correctly with any other application, such as MSN, ICQ, Wordpad.. etc. However, when I open an Office application such as Word or Excel, it doesn't seem to type for me. I cannot type in the help section, can I type in the document or in those toolbars at the top for Fonts, etc. But if I specifically go to "Format >> Font", then yes, I can type in it. I have tried reinstalling Office already, that doesn't work. The hardware is fine, I can still...

Business Portal 4.0 Timesheet restriction for 24 hours
Hi Is there a way to restrict user from not entering more than 24 hours of a day in Timesheet wherein user enters multiple timesheets in a day. Ex : Total number of hours for all the timesheet in a day should be less than or equal to 24 hours. Regards Sandeep Sandeep, There is currently not a way to limit the employees over a range of timesheets. The restriction is only done on a specific timesheet. Thanks Rob -- Rob Bernhardt Software Quality Assurance Microsoft Business Solutions This posting is provided "AS IS" with no warranties, and confers no rights. "Sande...

User Defined Fields #4
I cannot seem to find any information about how to use user-defined fields. How does one define these fields and their use and can the caption on the screen (e.g. Vendor Maintenance) be changed to reflect the proper name we wish to assign to the field(s). Is there any chance of conflict between sets of UD fields, say between customers and vendors? I.e. If I assign a use of field 1 in customers, is it distinct from field 1 of vendors? Thanks in advance from a newbie to GP. Bryan: UDF's generally store just static text. The exceptions to this are date fields, drop-down lists, a...

Outlook and XP Keyboard Access
I just had Windows XP installed on my machine and I am having problems with keyboard access in Outlook 2002. I do not use a mouse and I have my inbox set up with the preview pane. Prior to XP I could get to my inbox with CTRL+Shift+i and then tab around the panes (mail list, preview pane and folders). With XP I can not get a selection in any pane without turning off the preview pane and then turning it on again. Which I then have to repeat every time I use the shortcut to get back to the inbox. This is making me very frustrated. Does anyone have a solution? Thanks in advance! It m...

Desktop shortcut
I know there have been several posts about this but can't seem to figure out some of the answers. I have lost, for some reason, the Create a Desktop Short cut from my right click context menu. I tried one thing and all I got was the Desktop icon on my Desktop. I did more searching but can NOT find: "the file *Desktop (create shortcut)* from the Default user folder." I went to my User folder and there is no such item. Am I looking in the wrong area? And while I'm at it, what could I have done to remove it in the first place. Don't want to do that aga...

Startup from keyboard
Hi to you all I have been using m/s XP for the last 5 years with computer set to start at the touch of any key on the keyboard . I recently got a new computer with Vista installed but can not remember how I set computer up to do this. Can anyone jog my memory. Thanks in anticipation. Bob This is the wrong newsgroup. Try the Windows Vista newsgroup. BTW, what does Great Plains or GP or Dynamics have to do with waking a computer up from sleep? ;-) -- Japheth Nolt Microsoft SBF Specialist Landis Computer www.landiscomputer.com 6/19/2007 11:39:30 AM blackbob wrote: > Hi to you all ...

newusers: 4 Millions Domains data with Category
Successfull Internet and Direct Marketing products on www.promotionsite.net * NEW * DOMUS Domains Toolkit Fall 2004 - Unique on the Net 4 Millions "Whois" Domains data with Expiration Date and Category*. Ultimate Version (October 2004) - Our best rate starts from US *$149*. A wonderful tool for Internet and Direct Marketing. Available in Basic, Advanced and Full Editions. It contains a domain database with 4 millions *FRESH* October 2004 New records .com, .net, .org. 4 Gigabytes MS Excel data zipped on CD-Roms/Dvd. Compression 3:1. MS Excel or Text tab del...

Shortcut Key or Macro for (Insert -> Entire Row)
Is there a shortcut key or macro I could do that would automatically insert a new row? I'm getting tired of Right Click -> Insert -> Entire Row... Press these keys in succession: [alt] I R That's the [alt] key (which activates the menu) then the letter I (which is the underlined letter in Insert) then the letter R (which is the underlined letter in Row_ Does that help? *********** Regards, Ron XL2002, WinXP "akumaxyz@gmail.com" wrote: > Is there a shortcut key or macro I could do that would automatically > insert a new row? I'm getting tired of Right...

Ganhar umas massas/Earn real money !!! #4
Se queres ganhar uns Euritos s� tens de instalar esta barra de publicidade, que podes at� minimizar ou fechar em caso de utilizar programas de ecr� completo. N�o incomoda nada, nem consome recursos. Apenas d� dinheiro, �ptima para quando deixas o comptdor a sacar a noite toda... Recebes o dinheiro na tua conta PayPal. http://www.eurobarre.com/index_fr.php?p=373093897695 100% seguro by CrashOverride If you want to earn money just by sitting in front of your PC, just install this Bar that shows some publicity now and then. 100% safe, no malicious ware. http://www.eurobarre.com...

Age verification #4
Is there any add on for liquor stores that would prompt for ID, scan, and determine birth date? Thanks, Sacha Yes Rite Age Verification, Works great -- Maurice Gordon Maurice@americanretailsupply.com Sales/Support 1-800-426-5708 XT 1307 "Sacha Favelevic" <sacha@chiacgocashregister.com> wrote in message news:u7HfutG6JHA.6004@TK2MSFTNGP02.phx.gbl... > Is there any add on for liquor stores that would prompt for ID, scan, and > determine birth date? > > Thanks, > > Sacha > I bought this feature from rite.us last year It was about $500. The onl...

Exchange 2003, inetinfo.exe pegging cpus (all 4)
Shortly after a reboot on a 4 cpu Proliant 6500 with 1.8gig of ram, running E2k3 on server2k3, with webmail enabled, and Trend Micro's Scan Mail 6, the inetinfo.exe process jumps to 100% of processor utilization (all 4). This grinds the system to nearly a halt, of course. If the process is killed, it will restart itself after a second or so, and then jump back to 100% util within about 3 seconds. But, for 3 seconds the mail gets through. What's going on here? How does inetinfo.exe interact with the other pieces of exchange and the OS? No Exch service pack. But OS is fully patched...

4.0 enterprise edition license
Hi all, We plan to install ms crm 4.0 enterprise edition for one of our customer. 5 organizatons will be created and 20 users will be users of each organization. My question is: A new license is necessary for each user for every organization? I mean, do I need to purchase 100 licenses (20 users X 5 organizations) or 20 license is enough? Hi, if you use 20 different users, you need 100 licences mit freundlichen Gr��en Michael Sulz ieQ-network AG eMail: michael.sulz@ieq-network.de Thank you for the reply. In the test environment, I have created 5 organizations and 3 users. These 3 us...

Touchscreen Keyboard
I am having to replace a machine with a new one. When I restore the database I don't see the touchscreen keyboard that was created. Where is the file located or how do I activate on new system? -- SG In POS, Crtl-F6 "Screen" You need to adjust the window sizes on both the Transaction Screen and the Touch Screen so that the windows don't over lap. The screen settings are one of the few things that are stored locally rather than in the DB, so you have to reset them after installing to a new machine. Slso, make sure that you reset the EDC settings in SO Administrator...

crm 4.0 application exams
I took the CRM 4.0 Applications exams today, but I failed. I didn't expected it to be tricky. Anyone passed this exam? On Jun 3, 11:19=A0am, "Benjamin Fallar III" <bfall...@hotmail.com> wrote: > I took the CRM 4.0 Applications exams today, but I failed. I didn't expect= ed > it to be tricky. Anyone passed this exam? General consensus on the web is it is very difficult and experienced consultants who have worked with CRM for years are getting tripped up by it and the other two new CRM exams. My recommendation is wait for the braindumps. Leon Tribe I'm a...

Keyboard Shortcuts
Is there any lists of keyboard shortcuts, specifically a shortcut to clear transaction in my checkbook. Thanks, Tim in Portland A search for "keyboard shortcuts" in Money help yielded the following list. But the quick answer to your question is "ctrl-M" will mark a transaction as cleared in the advanced register. "ctrl-shift-M" will mark it reconciled. Keyboard shortcuts Keyboard shortcuts allow you to quickly access and use features without using a mouse. To Press Copy text CTRL+C Insert today's date in the Date field CTRL+D ...