With the right drag method
With a hyperlink
With the copy and paste special commands
With the copy and paste buttons on the standard toolbar.
Word
Smart cell
Excel
Lotus 1-2-3
Workbooks
Worksheets
Charts
Worksheets and charts
Xls
Xlw
Wk1
123
You can use the format painter button on ly one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing the Alt key and clicking the format painter button