Replacing the contents of a cell
To replace the contents of a cell with something else, just activate the cell and type your new entry, which replaces the previous contents. Any formatting that you previously applied to the cell remains in place and is applied to the new content.
You can also replace cell contents by dragging and dropping or by pasting data from the Clipboard. In both cases, the cell formatting will be replaced by the format of the new data. To avoid pasting formatting, choose Home?Clipboard?Paste and select Formulas or Paste Values.
// Related Posted - GOOGLE!
Loading
Related Websites
- The Key to a Successful Blog In the last post, regarding keys to a strong blog, we talked about some of the keys to successful blogging....
- RSS – A Marketing Tool To Improve Search Ranking More and more online applications are being built to extend the potentials of online content media. RSS plays a daring...
- How to Clean Up Outlook Contact Phone Numbers using VBA Introduction [/caption] I got a new phone and when synchronised with Microsoft Outlook, the phone numbers don't dial out properly...
- Excel Tip: Have Your Cell Contents = Tab Names It's time for another edition of Stupid Excel Tricks! One of my coworkers recently asked me an Excel question. He...
- Plasma HDTV A Plasma HDTV is an essential piece of equipment for anyone that loves watching television and wants to do so...
