+ Reply to Thread
Results 1 to 2 of 2

Clear contents in a matrix by clicking on a cell

Hybrid View

sealpino Clear contents in a matrix by... 11-26-2012, 07:18 AM
RHCPgergo Re: Clear contents in a... 11-26-2012, 08:08 AM
  1. #1
    Forum Contributor
    Join Date
    11-10-2012
    Location
    Sweden, Stockholm
    MS-Off Ver
    MS Excel 365
    Posts
    198

    Clear contents in a matrix by clicking on a cell

    I know that by marking an area in a matrix and then right click and roll down to clear contents is easy for those who knows.

    But I want to do mine a safe sheet for "dummies" when using my excel document.

    How can I set a function in a cell that defines the act to clear contents by clicking on a cell?

  2. #2
    Valued Forum Contributor
    Join Date
    08-13-2012
    Location
    Gardony, Hungary
    MS-Off Ver
    Excel 2003
    Posts
    558

    Re: Clear contents in a matrix by clicking on a cell

    Hi,

    I don't think it can get any easier than right click --> clear contents... but as an alternative, you could make a button and assign a macro to it. Something like this:
    Sub ClearContents()
    
    Selection.ClearContents
    
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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