+ Reply to Thread
Results 1 to 5 of 5

How to Paste Values without Right Clicking?

  1. #1
    Forum Contributor
    Join Date
    10-23-2004
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    243

    Question How to Paste Values without Right Clicking?

    Places that I need to go to are given to me in GPS coordinates. I use a batch parameter query to recall those locations and give me their corresponding GPS locations.

    Sometimes, they don't have them and I have to look at the paperwork to get it... That's ok.
    Since the recall query extracts the GPS coordinates in decimal degrees (40.446, -79.982), that's what I go with.
    When it isn't provided for me, the paper work gives it to me in degrees minutes seconds (40 26′ 46″, -79 58′ 56″). That's ok

    I input the degrees minutes seconds values in some conversion formula I made in K9, L9, and M9 for North, and K10, L10, and M10 for West.
    N9 and N10 will give the the converted values back to the decimal degrees that I need.

    Having said this, when i want to copy and paste THOSE VALUES from N9 and N10, I ALWAYS HAVE TO right click and PASTE VALUE.
    Is there a way for me to Ctrl+V (Paste) without having to right click? If No, can I use a O9 and O10 formula to just copy what's on N9 & N10 and it will only copy the values and not the formulas?

    I want to avoid the step of ALWAYS HAVING TO RIGHT CLICK to get "Paste Value".

    I broke down the GPS formula (Degrees Minutes Seconds) in a couple of cells. I need the DMS value in just decimals, and one of my cells converts that.

  2. #2
    Forum Contributor
    Join Date
    10-23-2004
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    243

    Re: How to Paste Values without Right Clicking?

    Ignore the last line please. I can't remove it for some reason.

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: How to Paste Values without Right Clicking?

    You can record a macro to paste values using relative references and apply it to a key sequence ie. CNTRL SHFT V for paste values
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Forum Contributor
    Join Date
    10-23-2004
    Location
    Los Angeles
    MS-Off Ver
    2010
    Posts
    243

    Re: How to Paste Values without Right Clicking?

    ??? I know macros... but how do I turn a keyboard shortcut into a macro? I can't grasp the concept.

    Isn't there a hotkey I can create to let me PASTE VALUES?

  5. #5
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: How to Paste Values without Right Clicking?

    Once you've recorded the macro, Open the macro window (View>Macros) and select options. There you can assign a shortcut key to that macro.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Delete cell values upon clicking on submit button
    By markusvirus in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-16-2015, 10:56 AM
  2. how to add values under specific columns by clicking on button in excel macro
    By DURGESH88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2015, 12:00 AM
  3. Replies: 5
    Last Post: 01-03-2014, 09:30 PM
  4. setting a scale by clicking on excel to determine lowest and high x values and .....
    By noideawhatimdoing in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2013, 11:38 PM
  5. [SOLVED] how can I paste text using paste special, without clicking paste button?
    By Exxcel Noob in forum Excel General
    Replies: 6
    Last Post: 05-14-2012, 08:21 PM
  6. Replies: 1
    Last Post: 02-07-2012, 07:09 AM
  7. Choosing different cell values by user clicking a button
    By alymcmorland in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2005, 11:41 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1