Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Paste special shortcut?

  • 13-02-2012 8:16pm
    #1
    wb
    Registered Users, Registered Users 2 Posts: 1,752 ✭✭✭


    In excel, quite a bit, I need to use:

    Paste ---- Paste Special ---- Text

    I've figured out how to add a paste special icon but I still have to select 'text' when I click on it. Is there any way (without doing a marco) that I can have a Paste Special, Text shortcut?


Comments

  • #2
    glynf
    Registered Users, Registered Users 2 Posts: 3,387 ✭✭✭glynf


    wb wrote: »
    In excel, quite a bit, I need to use:

    Paste ---- Paste Special ---- Text

    I've figured out how to add a paste special icon but I still have to select 'text' when I click on it. Is there any way (without doing a marco) that I can have a Paste Special, Text shortcut?

    Not sure what you mean by text, but CTRL+ALT+V opens the dialog box-as in after you select what you want to copy, hit CTRL+ALT+V instead of right clicking and selecting paste special from the drop down menu.


  • #3
    wb
    Registered Users, Registered Users 2 Posts: 1,752 ✭✭✭wb


    Thanks - but that is still two steps - the CTRL ALT and V (step one) and then I have to select 'text' from the box that appears (step two).

    I want a button that will automatically do this in one step.


  • #4
    wb
    Registered Users, Registered Users 2 Posts: 1,752 ✭✭✭wb


    For example, I want a button that will go straight to text, as highlighted here


  • #5
    glynf
    Registered Users, Registered Users 2 Posts: 3,387 ✭✭✭glynf


    wb wrote: »
    For example, I want a button that will go straight to text, as highlighted here

    Ok got you now, only way I know is using a keyboard that can record macros.

    There is a website called that i got good advice from on their forums before, you should try there:

    http://excelexperts.com/forum

    G.


Advertisement