Instantly Paste Special

Home Forums Keyboard Tricks Instantly Paste Special

This topic contains 0 replies, has 1 voice, and was last updated by Avatar Neil Parsont 4 years, 9 months ago.

  • Author
    Posts
  • #955
    Avatar
    Neil Parsont
    Keymaster
    Directions: Hold ctrl plus alt and press V to instantly paste special. 
    
    Example: Here, we want to paste the correct names from the capitalized column into the First Name column without changing the format.
    The capitalized column has a formula (PROPER) which capitalized John's name. Thus, we want to paste special with only the values to 
    correct the first names and keep the formatting. After pasting, we would delete the Capitalized column.
    
    Paste Special

You must be logged in to reply to this topic.