Tag Archives: Copy

How to remove a formula but keep the value in an Excel spreadsheet

When you delete a cell in an Excel spreadsheet, both the formula and value are deleted. If you want to keep the value, then you can delete the formula only.

Procedure:

  1. Select the cell or group of cells you wish to remove the formulae from.
  2. Select the ‘Home’ tab from the menu bar.
  3. Click ‘Copy’. (You can alternatively do this using the keyboard shortcut: Ctrl+C.)
  4. Press the down arrow under ‘Paste’ and click ‘Paste Values’. (You can alternatively do this using the keyboard shortcut: Ctrl+V instead, then a small icon should appear in the corner of the pasted area with ‘Paste Values’ available within a context menu.)

How to capture snapshot of the screen in Windows

All PC keyboards have a key marked ‘Print Screen’. This may be abbreviated to say¬†‘PrtScn’, ‘PtSn’ etc.

Historically these would literally print out what was on the screen, however the modern usage is to capture the current screen and copy it as an image to the Windows clipboard. If you open an image editor, e.g. Paint, you can use Ctrl+V to paste it in.

To capture the current window only, e.g. the internet browser you are currently using, then hold down ‘Alt’ when pushing ‘Print Screen’

How to keep Track Changes when copying text from Microsoft Word

If you are copying and pasting¬†text from one Microsoft Word document to another, then any track changes in the original will be lost in the new document. However if you ‘cut’ the text using a key combination and then paste you can keep this markup.

Procedure:

  1. As you are cutting text from the original document, it would be best to make a backup.
  2. Ensure ‘Tracked Changes’ is switched OFF in the new document. Otherwise, the entire paste will appear as new text.
  3. In the original document, select the text you wish to copy.
  4. Press ‘CTRL + F3’ to cut the text.
  5. In the new document, press ‘CTRL + SHIFT + F3’ to paste the text.
  6. If you wish to undelete the text in the old document, simply press ‘Undo’ or ‘CTRL + Z’. If this doesn’t work for some reason, then don’t worry as you have hopefully made a backup in Step 1!