Click on Subtotals in the menu
View the sum in the Formula Bar
Press Alt++ on the keyboard
Select the last two cells and drag the fill handle over the range you want, for instance 18 more rows.
Select the range you want, including the three cells, point to Fill on the Edit menu, and then click Down.
Copy the third cell, click in the cell below it, on the Standard toolbar click the down arrow on the paste button, and select Paste Special
Go to File->Save As->Save as Type->Excel 4.0 Worksheet
Right-click on the spreadsheet tab and click Delete
Right-clik on the spreadsheet and click Insert-Entire Column
Triple-clicking with the right mouse button in the spreadsheet.
Using the Edit->Select All menu item.
Pressing Ctl+A on the keyboard
Press Alt+F11 on the keyboard
Use the View->VB Editor menu
Go to the Developer ribbon and select 'View Code'
Private Sub system32.msgbox.udf() msgbox "Hello World" End Sub
Public Function Hola(one as integer) msgbox "You entered " & one End Function