Macro 4: copying to current cell 
/////////////////////////

Sub toCurrentCell()
    ActiveCell.FormulaR1C1 = Range("A1")
End Sub

/////////////////////////

ctrl-d to clean our spread sheet
/////////////////////////

 Step 1: click "Developer" on the menu bar

 Step 2: click "Record Macro"
 
 Step 3: for Short-cut enter
         d
         then click "OK"

 Step 4: choose a big area to delete 

 Step 5: move your cursor to cell A1

 Step 6: Click "Stop Recording"

     Now, you can hit Ctrl-d to clean your spreadsheet

/////////////////////////

ctrl-h to unhide 
/////////////////////////

 Step 1: click "Developer" on the menu bar

 Step 2: click "Record Macro"
 
 Step 3: for Short-cut enter
         d
         then click "OK"

 Step 4: chose several columns to hide 

 Step 5: move your cursor to cell A1

 Step 6: Click "Stop Recording"

     Now, you can hit Ctrl-d to clean your spreadsheet

 Q: How about hide rows?

/////////////////////////

ctrl-u to hide 
/////////////////////////

 Step 1: click "Developer" on the menu bar

 Step 2: click "Record Macro"
 
 Step 3: for Short-cut enter
         u
         then click "OK"

 Step 4: chose several columns to unhide

 Step 5: move your cursor to cell A1

 Step 6: Click "Stop Recording"

     Now, you can hit Ctrl-u to unhide your spreadsheet

 Q: How about unhide rows?

/////////////////////////

File extension should be *.xlsm
/////////////////////////

When saving your Excel file which contains macros or VBAs

   the correct extension should be *.xlsm

/////////////////////////

Link a button with a macro
/////////////////////////
Assume that we have a macro called "clean", see c27(21), 
which cleans our spreadsheet from A1 to N31. Now, 
we want to create a button linked to this macro. 

  Step 1: click "Developer" on your menu bar
  Step 2: click "Insert"
  Step 3: Under "Form Controls", choose the first image 
  Step 4: Move your cursor to a location beyond H columns, 
          highlight an area

  Step 5: Link your button to a macro name, i.e., the clean macro
          then click "OK"

          Now, you can use your macro by clicking it to clean an area of 
          A1 to H35. 

  Step 6: (optional) format your button 
           Right click the button you will see the following entries

           Cut
           Copy 
           Paste
           Edit Text
           Group
           Order
           Assign Macro
           Format Control

/////////////////////////