An 'Excel in Minutes' Tip
A Super-Quick Trick to Convert Formulas to Values
by Francis Hayes (The Excel Addict)
Here's a
super-quick way to convert your formulas to values that very few Excel
users are aware of.1) Select the cells containing formulas (must be one contiguous range);
2) Move your mouse to the edge of the selected range until the mouse pointer changes to a 4-headed arrow;
3) Using the right mouse button, click and drag the cells to the next column, BUT DON'T RELEASE THE MOUSE BUTTON YET. Keeping the mouse button pressed, drag back to the original location and release the mouse button.
4) Click the 'Copy Here as Values Only' option from the menu that pops up.
5) Voila!
| If you've found this tip helpful,
please share it with your friends |
|
Would you believe me if I told
you that
you can DOUBLE your productivity in Excel? How about TRIPLE it ? or QUADRUPLE it ? or MORE ? If I showed you a tip where you could do a task in Excel in five seconds that would typically take you 20 minutes to an hour or more, what would you call that? Productivity on steroids? ...and that's just ONE tip! "Give me 10 or 15 minutes each week and I will show you how learning a few of my time-saving 'Spreadsheet Tips From An Excel Addict' on a regular basis will seem almost effortless BUT will quickly help you BOOST your productivity in Excel beyond your imagination" - Francis Hayes, The Excel Addict Get my FREE Twice-Weekly
Newsletter
"Spreadsheet Tips From An Excel Addict" Now being read by more than 37,000+ Excel Addicts all over the world |
Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.