Excel 2003
 

Hi

An average user with some Qns.

1) I have a spreadsheet with many columns filled up. I wish to select
mutiple columns simultaneously but when I press Shift + arrow key I end up
selecting almost all the columns. I have tried this command with other
spreadsheets and it works fine. What is the problem with this particular
spreadsheet?

2) I wish to auto-filter a column, but each time I choose autofilter Excel
refuses to insert the filter. The column contains some random blank rows and
highlighted rows, is that why the filter doesn't appear?



Thank you.

Excel 2003
 

Some guesses ..

Q1: There's merged cells somewhere causing the selection problems. Try
selecting the entire sheet, remove all merge cells via clicking
FormatCellsAlignment (click the Merge cells box until its clearedOK).

Q2: Try selecting the entire range (with the header rows), then only apply
autofilter. Don't leave it to Excel to guess the range. You control it.

Above guesses any good? hit the YES below
--
Max
Singapore
xde
---
"PL" wrote:
An average user with some Qns.

1) I have a spreadsheet with many columns filled up. I wish to select
mutiple columns simultaneously but when I press Shift + arrow key I end up
selecting almost all the columns. I have tried this command with other
spreadsheets and it works fine. What is the problem with this particular
spreadsheet?

2) I wish to auto-filter a column, but each time I choose autofilter Excel
refuses to insert the filter. The column contains some random blank rows and
highlighted rows, is that why the filter doesn't appear?