Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Flip Cells In Excel

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 


Back to Excel Model Builder Start

Flip cells    
 
This interesting tool permits the interchanging of values of a selected range.
In other words, the value of the first cell is positioned as the last value of the selected range; and the value of the last cell will now be in the first cell. The second value will become the penultimate value, and the penultimate value will be come second ... and so on ...
See the example below:
We wish to interchange the values of the selected range.
 
 
 
After applying this tool
 
 
 
To reverse the changes, simply apply the tool again.
View Demos

Excel Model Builder  Secure Payment Options

Pricing:
1 License $129.95 USD
2 - 5 Licenses $110.95 USD
6 - 10 Licenses $97.95 USD
11+ Licenses $64.95 USD

Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH!  Purchases MUST be made via this site. Send payment confirmation to [email protected] 31 days after purchase.

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us