Hi, I am Rajesh Kunder from Bangalore.
*Tip Name : * We all know how to split a worksheet using keyboard shortcut(ALT+W+S). But there is one more tricky way of doing it!. Create a horizontal split by clicking on the little bar shape next to horizontal scroll-bar near top right corner of the excel window( See attachment). Similarly you can also create a vertical split by clicking on the little bar shape next to horizontal scroll-bar near bottom right corner of the excel window. [image: How to add a split to excel worksheet?] (If you are wondering where the split would be created, it will be created at selected cell’s row (or column)) Then double click on the split to remove it :-) Thank You, Rajesh Kunder --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
<<attachment: Double Click and Split.jpg>>
