Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-24-2009, 11:54 AM
psmaster@earthlink.net psmaster@earthlink.net is offline CAUTION!! Sorting a spreadsheet with hidden columns will trash your data. Windows XP CAUTION!! Sorting a spreadsheet with hidden columns will trash your data. Office 2007
Novice
CAUTION!! Sorting a spreadsheet with hidden columns will trash your data.
 
Join Date: Nov 2009
Posts: 1
psmaster@earthlink.net is on a distinguished road
Angry CAUTION!! Sorting a spreadsheet with hidden columns will trash your data.

I just found out the hard way, lost several hours of work, and I guess I am somewhat stunned I haven't run into this earlier. Apparently sorting with hidden columns only sorts the unhidden columns. Why Excel chose to do this is quite beyond me, but let's say for arguments sake there is a valid reason. Excel should warn users when sorting with hidden columns that the hidden columns will not sort, thereby trashing your data.

Could someone please explain the rationale behind not sorting hidden columns? Thank you.

How do I notify Microsoft Excel team that this is a BAD idea? Is it addressed in 2010?
Reply With Quote
Reply

Tags
sorting hidden columns

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting columns in Excel - please advise Jonre Excel 2 08-21-2009 02:38 AM
macro for comparing data from 3 columns and pasting into another worksheet ashukla Excel 1 06-24-2009 05:01 PM
hidden blank pages mljm Word 3 06-19-2009 03:18 AM
CAUTION!! Sorting a spreadsheet with hidden columns will trash your data. Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM
deleted items not going in to trash glg4e Outlook 0 06-27-2006 10:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:58 AM.


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