Sorting or filtering for rows

A

Amey

Do we have sorting for the rows same as for columns. If suppose I want to
hide the columns containing blank cells in a perticular row.can I do it or
can I filter it? I tried by using go and special and selection blank.
 
J

JLatham

Sorting horizontally:
Excel 2003 & earlier: use Data --> Sort and click the [Options] button,
choose the "Sort Left to Right" option.
Excel 2007 use "Custom Sort" from the Sort & Filter drop down and you'll
find the same option available.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting or filtering the rows 1
Columna to Rows Formula 9
REMOVING A HUGE AMOUNT OF BLANKS ROWS 4
Auto Filter Sorting Issue 1
EDITING A RANGE FOR FILTERATION 2
Sorting by rows with differing numbers of cell entries 3
Excel 2002: Any button to insert blank rows at specific interval? 5
print or copy filtered rows 2

Top