Reply to thread

Message: [QUOTE="PL, post: 3264028"] 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. [/QUOTE]