Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2019, 03:50 PM
DBenz DBenz is offline easiest way of turning a sheet into values only ? Windows 7 64bit easiest way of turning a sheet into values only ? Office 2010 32bit
Advanced Beginner
easiest way of turning a sheet into values only ?
 
Join Date: Dec 2014
Posts: 69
DBenz is on a distinguished road
Default easiest way of turning a sheet into values only ?

Hi,

Excel 2010,
I need to convert sheets to values only, what is the quickest way of doing that retaining the formatting ?


At the moment I am creating a new sheet beside a source sheet then name it with suffix nf then select corner of source , select copy, then corner of new and copy paste >values to it then format it same as previous sheet.


There has to be an easier way I hope.





DBenz
Reply With Quote
  #2  
Old 01-24-2019, 12:51 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline easiest way of turning a sheet into values only ? Windows 7 64bit easiest way of turning a sheet into values only ? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

There is a way, it needs some practice
- Select the range

- Move the mouse to the upper limit of the selection, the arrow becomes a cross
- While keeping the right mouse button down, you can move the range around
- Move it to where you need it ( it can be the same place as long as you moved the range around a bit)
- Release the mouse button
-From the menu that pops up select " copy here as values only"


Does that help ?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 01-24-2019, 04:41 AM
DBenz DBenz is offline easiest way of turning a sheet into values only ? Windows 7 64bit easiest way of turning a sheet into values only ? Office 2010 32bit
Advanced Beginner
easiest way of turning a sheet into values only ?
 
Join Date: Dec 2014
Posts: 69
DBenz is on a distinguished road
Default

Hi, Tried that just dont get to see a cross at all.


also tried edit cut then click in top left of selection expecting to see paste values with source formatting but alas that option isnt there.



DBenz
Reply With Quote
  #4  
Old 01-24-2019, 05:31 AM
ArviLaanemets ArviLaanemets is offline easiest way of turning a sheet into values only ? Windows 8 easiest way of turning a sheet into values only ? Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

When you don't need formulas anymore on old location, then copy, and then Paste Values into same range.

When you want to keep formulas in old sheet, then right-click on sheet tab, Select Move or Copy, check Create a copy checkbox, and click OK. After that, copy all data in new worksheet, and use Past Special to write the datarange over with values.

Not much faster, but you don't have to format the sheet, and to set column widths.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple found values from five sheets, multiple returned values in sheet six? irisha Excel Programming 26 09-30-2016 01:20 AM
How to convert VLOOKUP values to text on another sheet AUTOMATICALLY Lady18 Excel 5 09-10-2016 03:12 AM
easiest way of turning a sheet into values only ? How to convert VLOOKUP values to text on another sheet AUTOMATICALLY Lady18 Excel 1 09-10-2016 12:15 AM
Reading Values from another sheet Raabi Excel 2 05-20-2011 02:14 AM
Word - Calculate and paste values from Excel sheet Augf87 Word 1 07-06-2009 10:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft