 |
|
|
|
|
||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||
Information You Can Use |
Lynn Page, Editor, Crystal River Users Group, Florida February 2011 issue, CRUG newsletter www.crug.com newsletter (at) crug.com |
To copy the contents of a cell and not the underlying formula on the Home tab, in the Clipboard group, click Copy. Move to the cell to paste into and on the Home tab, in the Clipboard group, click Paste, and then click Paste Values.
Cell references are important and it is important to be aware of what can happen to these references, whether absolute or relative, when moving a formula by cutting and pasting it, or by copying and pasting the formula into a new location.
When moving a formula, the cell references within the formula do not change regardless of the type of cell reference used.
When copying a formula, the cell references may change based on the type of cell reference used. Verify that the cell references in the formula produced the desired result. If not, switch the type of reference.
Many times I like to have two Word documents open side by side. To open multiple copies of an application so that different files are shown in separate windows, shift click the icon on the Task Bar to open an additional application window.
To have a folder quickly available in Windows Explorer pin it to the Explorer Jump List. Find and select the folder, then drag and drop it to the Windows Explorer icon on the Task bar. To quickly open the folder right click the Windows Explorer icon and select the folder from the jump list.
USB flash drives are wonderful for transporting files between computers. Just remember that if one computer is infected with a virus or malware can come along on the flash drive. So for security before transferring files scan the flash drive with up to date virus and antimalware before copying files.