NPR: Excel help

lilpiglet

Does anyone know if there is a way to sort multiple tabs at one time.  Or do i have to go into each tab and sort one at a time?

joy143dh

If the data that you want to sort is in the same column on each tab, you can click on the 1st tab, hold the SHIFT key and click on the last tab which will select all the tabs.  Then do your sort on the 1st tab and it should sort on all the tabs.

JOEBunny

You can highlight all the tabs and do the same thing to each column in all the worksheets at the same time, so you could sort say column B in each worksheet all at the same time, but they have to set up the exact same way.

lilpiglet

:-/  I'm doing what you girls are telling me to do, but everytime i click on the last tab it takes away my sorting option... I have excel 2007 is that an outdate version?

joy143dh

If any of your cells are merged on your tabs, you may not be able to do a bulk sort.  Check to make sure there are no merged cells.

JOEBunny

You also have to sort on the 1st tab.  If you try to sort on a tab that is not first, it takes away the sort option.