| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Clearing multiple cells in 1 click?
A B 1 Liquor $100.00 2 Medical $50.00 3 breakfast $2.50 4 lunch $1.20 5 dinner $5.30 6 *Total:* =SUM(B1:B5) 7 breakfast $13.50 8 water $1.10 9 Dinner $80.00 10 others $13.90 11 *Total:* =SUM(B7:B10) Is it possible to create a button to clear only A1:B5 and A7:B10? Something like if A12=1, A1:B5 and A7:B10 will be cleared? -- Lewis Koh ------------------------------------------------------------------------ Lewis Koh's Profile: http://www.excelforum.com/member.php...o&userid=25712 View this thread: http://www.excelforum.com/showthread...hreadid=391513 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I protect formula cells on multiple sheets? | Excel Worksheet Functions | |||
| Find cells without multiple spacebars and format... | Excel Discussion (Misc queries) | |||
| How do I center data across multiple cells in excel without mergi. | Excel Discussion (Misc queries) | |||
| background formatting across multiple cells | Excel Discussion (Misc queries) | |||
| How do I extract cells from multiple workbooks | Excel Discussion (Misc queries) | |||
Threaded Mode
