|TechBook will reward the Top Ten Users for the month of October with a One Year FREE Web Hosting Account
- Newbie on TechBook
- Posts: 28
- Joined: Sat Aug 05, 2017 4:30 pm
When you perform a normal copy and paste on a cell in Microsoft Excel 2016, 2013, 2010 and 2007 that has been calculated by a formula, the formula gets pasted as well. This means that once the generating cells have been altered or even deleted, they result cell gets affected too. There is a simple way around this if you wish to just copy and paste only the value within the cell and nothing more. Just follow these steps.
- Select the cell (or cells) or ranges you wish to copy.
- Select “Copy” in the “Clipboard section (or right-click to copy).
- Select the cell (or cells) you wish to paste your values to.
- Right-Click and select "Paste special".
- From the extended menu that appears, select “Values“.
You have successfully pasted a value in Excel without including the formula.
kuchnie kraków opinie
Who is online
Users browsing this forum: No registered users and 2 guests