We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide

Anyone who can help me with Excel?

I'm hoping someone can tell me how to do this. I'm not sure how difficult or easy this is.
I want to create a button that will clear the contents of certain cells. Could someone tell me how to go about it? I've tried googling a description of what i'm trying to do, but I can't find what I mean to do.

Thanks x

Comments

  • ManAtHome
    ManAtHome Posts: 8,512 Forumite
    Part of the Furniture Combo Breaker
    F1 just starting - try googling EXCEL COMMANDBUTTON - think this is what you're after. Come back if you get stuck.
  • Larumbelle
    Larumbelle Posts: 2,140 Forumite
    Thank you both for your help. I have figured it out

    (not really. A friend is coming round to do it for me :rotfl:)

    Thanks though. I've bookmarked that page for next time I get stuck.
  • Stubert
    Stubert Posts: 733 Forumite
    You need to create a button, and then assign a macro too it. Start recording and then clear the cells then stop recording. Thats probably a bit simplistic but I think thats how you do it!
  • waynedance
    waynedance Posts: 673 Forumite
    Part of the Furniture 500 Posts Combo Breaker
    Stubert wrote: »
    You need to create a button, and then assign a macro too it. Start recording and then clear the cells then stop recording. Thats probably a bit simplistic but I think thats how you do it!

    you got it record a macro and use a shortcut.........
    Google gives you answers use it.........
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 353.9K Banking & Borrowing
  • 254.3K Reduce Debt & Boost Income
  • 455.2K Spending & Discounts
  • 247K Work, Benefits & Business
  • 603.6K Mortgages, Homes & Bills
  • 178.3K Life & Family
  • 261.1K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.7K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.