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
sam49

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
Golden
Microsoft MVP

Windows 7 Ult. x64
 
 

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
sam49

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
Golden
Microsoft MVP

Windows 7 Ult. x64
 
 

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
Thread Forum
Bug in Excel 2010?
For my workbook, I have defined the default font to be 11 pt Calibri. However, when I select a row (or column) and select Clear Formats, the cells are reformatted to 10 pt Arial. To me, this seems like a bug. Am I missing something?
Microsoft Office
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Outlook 2010 - Inbox not sorting by 'From' field
The problem I'm having is that when sorting my inbox by 'From', it says no items are there and the bar spins along as if it's searching. If I choose to sort my inbox by anything else it works fine. I can also sort all other folders by every attribute, including 'From's so am unsure as to why I...
Microsoft Office
Excel and Unique sorting
Excel 2010. Trying to do an "unique" sort (as in data/sort/advanced/unique) for a simple data set of 3 columns and 4 rows. i.e. Sort the data on the first column but leave only the first instance of the name. An example perhaps: 3 columns 4 rows Before: Jones | Bob | Fl Smith | ...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Excel 2010
Hi all I'm trying to add a little Calculator function to a Spreadsheet I use for trading shares. I pull basic data from YAHOO finance and would like to have at the bottom of a spreadsheet a calculator which would allow me to enter Nr of shares bought, Price Paid and return things like Profit /...
Microsoft Office

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 12:56.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App