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.