At 10:18 10/07/2009 +0530, Ashish P Aghera wrote:
While applying filter to spreadsheet data, complete data needs to be selected. But is there any option by which we can apply the filter to the top row (selected row) and all continuous data below that row comes in filter data.

Yes, I think there is. Just select any *single* cell in the block (not necessarily in the header row) before applying the filter. Calc expands the range to be dealt with as you desire.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to