Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.



Windows 7: Excel 2010 sorting

25 Nov 2010   #1

Windows 7 Professional 64 Bit
 
 
Excel 2010 sorting

Hi is it possible to lock columns and rows together so when i sort a spreadsheet i make sure all the rows and columns are sorted together and i dont leave out somthing

Regards

My System SpecsSystem Spec
.

25 Nov 2010   #2

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64 Windows 8.1 x64 Ubuntu 12.04 LTS Tri-Boot
 
 

Yes - highlight all the data by selecting all the columns, or highlighting all the data before sorting.
My System SpecsSystem Spec
25 Nov 2010   #3

Windows 7 Professional 64 Bit
 
 

Ok thanks thats what i do now but if i am not carefull and i miss something it makes a mess of the spreadsheet, i was woundering if it could be sorted without me having to select the data, say some sort of a macro, but i dont know how to do it.

Also i dont always want to sort the whole spreadsheet just some of the rows and some of the columns.
My System SpecsSystem Spec
.


25 Nov 2010   #4

Microsoft Community Contributor Award Recipient

Windows 7 Ult. x64 Windows 8.1 x64 Ubuntu 12.04 LTS Tri-Boot
 
 

Mmmm. I'm afraid I cant help you there. The Sort usually requires you to select the cells first. Perhaps some sort of VB script would do the trick....unfortuanetly thats beyond me.

Let us know if you find a method....

Good luck,
Golden
My System SpecsSystem Spec
Reply

 Excel 2010 sorting





Thread Tools



Similar help and support threads for2: Excel 2010 sorting
Thread Forum
Excel 2010 Microsoft Office
Solved Excel 2010 help Microsoft Office
Outlook 2010 - Inbox not sorting by 'From' field Microsoft Office
Solved Excel and Unique sorting Microsoft Office
excel 2010 Microsoft Office
Formatting Excel 2010, Excel 2003 Microsoft Office
outlook 2010, category sorting bug? Software

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 11:39 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33