+ Reply to Thread
Results 1 to 5 of 5

Copy and past - link cells option

  1. #1
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Copy and past - link cells option

    I recently discovered how useful it is to copy and paste and link cells...however I would like to know if there is a keyboard shortcut that can achieve this process....I am using Excel 2003 but if it works on later versions only please feel free to share for the benefit of others...thanks!

    Josh

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Copy and past - link cells option

    CTL + C = Copy
    CTL + V = Paste
    CTL + X = Cut

    There are many more keyboard shortcuts.

    Look here for more: http://www.shortcutworld.com/en/win/Excel_2003.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Re: Copy and past - link cells option

    Forgive me, what I am talking about is....

    i know the shortcuts like ctrl c, alt e s t
    etc.

    but what i want to know is how to link cells when you paste. This link cells option is only available to me at the moment by clicking on the drop down box that appears on any cell you paste information into. thanks

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Copy and past - link cells option

    Perhaps an example of what you are trying to do. The term linking has multiple interpretations and I am not sure which one you are referring to.

  5. #5
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Re: Copy and past - link cells option

    when you paste into a cell a little symbol comes up. When you click on it it lets you paste values or number formatting etc. or indeed to "link cells". I want to know if theres a keyboard shortcut to do that, thanks

+ 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. disable copy past option for particular sheet
    By dingdang in forum Excel General
    Replies: 1
    Last Post: 12-08-2013, 07:55 AM
  2. macro to copy certain cells and past to another sheet.
    By alwinaz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2013, 08:48 AM
  3. Loop copy and past cells to a different word document.
    By tonnerre2000 in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2012, 07:33 AM
  4. loop copy and past cells
    By gill389 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2010, 10:48 AM
  5. problem with code. past link instead of copy
    By Paul in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-20-2006, 04:00 AM

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