Excel 2010 Preview #2: Copy & Paste Special Magic
Loading...
Loading...
22,208
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (10)
-
Has there ever been a feature that computes the formulas, but then pastes them as values?
I've been using CTRL+V to paste the formulas, and then, since I didn't need so many active formulas in a sheet, was copying (CTRL+C) and pasting over with a special paste for values only (CTRL+SHIFT+P). If there is a way to do that in a single step, that would be a great feature for me.
-
Thanks for pointing that out. There are random values generate from a formula - so that is why the values are changing...
-
is it an excel bug, or you are doing something wrong, cause your copy&paste values does not match with each other....
Loading...
2:49
Excel 2010 Preview #4: Pivot Table Slicer (Report/Page Filter Slicer)by ExcelIsFun42,734 views- 4:14
Excel 2010 Preview #3: New Percentile Function PERCENTILE.EXCby ExcelIsFun12,013 views
- 3:00
Excel 2010 Preview #1: New Rank Function RANK.AVEby ExcelIsFun17,611 views
- 3:00
Excel 2010 Preview #5: Conditional Formatting Negative Data Barsby ExcelIsFun16,135 views
- 12:22
Excel Magic Trick 718: Calculate Hours Worked (Day or Night Shift) & Subtract Lunchby ExcelIsFun14,106 views
- 6:54
Consolidating Data from Multiple Excel Worksheets By Positionby DannyRocksExcels23,058 views
- 7:28
Paste Special Options in Excel Save You Time!by DannyRocksExcels3,618 views
- 4:57
How To...Copy Formulas in Excel 2010by eoloughlin4,011 views
- 3:41
Excel 2010: Conditional Formattingby gcflearnfree23,349 views
- 6:32
Part 1 - Fundamentals of Excel 2010by learnexcelfunctions33,899 views
- 1:43
Excel Magic Trick #20: Lightening Fast Copy Trick!by ExcelIsFun22,048 views
- 6:56
How to Use Multiple Pivot Table Summaries in Excel 2007by DannyRocksExcels6,338 views
- 19:53
Office 2010 Class #20 What Is Excel?, Editing Ribbons & Quick Access Toolbar, File Extensionsby ExcelIsFun27,243 views
- 6:46
Working with Pivot Tables in Excel 2010 - Part 3by titantechtraining22,824 views
- 3:25
Excel 2010 - New Featuresby gcflearnfree13,173 views
- 7:50
Creating a simple macro in Excel 2010 - Part 1by learnexcelfunctions80,104 views
- 3:50
Excel Dynamic Chart #3: Table Feature (Excel 2010 / 2007) List Feature (Excel 2003)by ExcelIsFun25,197 views
- 22:32
Office 2010 Class #23: Excel Functions & Defined Names, SUM, COUNT, COUNTA, SUMIF, COUNTIFby ExcelIsFun12,010 views
- 7:18
Microsoft Excel 2010 Expert Level 1 Introductionby 599CD13,168 views
- 6:51
Part 2 - Fundamentals of Excel 2010by learnexcelfunctions21,733 views
What program you have registered you and me plz ?
lords60 1 year ago
I do not understand you question. Can you re-state your question?
I am using excel 2010.
ExcelIsFun 1 year ago
excel 2010 hangs when I try to copy & paste then it doesn't paste anything. I get nothing when I hover as in this video. All the boxes are checked by default in the options, advanced, copy and paste section. Tried unchecking the last option, it did nothing. The same thing happens with format painter, just hangs & doesn't copy the formatting. I have searched for hours on google & microsoft, I cannot find any solution. Has anyone else experienced these problems? I am using windows xp pro sp3.
MyNipNip 1 year ago
I do not know how to fix that. But no problem, THE best site for Excel questions such as the one you are asking is:
mrexcel[dot]com/forum
ExcelIsFun 1 year ago
Can you copy the formulas without the data being copied, as well? I just want to use the same forumlas but my data will be different.
bgw73 1 year ago
Copy and paste special formulas will do that.
ExcelIsFun 1 year ago