Forum Discussion
Ctrl+A Not Selecting All Columns in Spreadsheet
Hi - I'm attempting to select all the cells (with data) in a spreadsheet. No matter what I try, only the first 5 columns are selected. Any suggestionw?
You need to stay within the range to select with Ctrl+A the data only , i.e. some data shall be to the right and down from your focused cell. Otherwise Ctrl+A selects entire sheet.
Hi Sergei
I have a similar problem. My sheet is on Sharepoint, but I have downloaded and opened in excel and get the same problem. Ctrl A only picks up rows 1 - 53 out of 87 rows. There is data in every row. CTrl A twice picks up whole sheet. Ctrl end selects the bottom right cell of the data area.
I have added new data on two occasions and will need to add more, so I think that the filter is only picking up the first set of entries. However I haven't had this problem before.
Whatever I try, I can't remove the filter. Mostly the sort & filter button is greyed out.
I have tried copying and pasting the data into another sheet but it behaves exactly the same way.
Any thoughts?
I have a similar problem. My sheet is on Sharepoint, but I have downloaded and opened in excel and get the same problem. Ctrl A only picks up rows 1 - 53 out of 87 rows. There is data in every row. CTrl A twice picks up whole sheet. Ctrl end selects the bottom right cell of the data area.
I have added new data on two occasions and will need to add more, so I think that the filter is only picking up the first set of entries. However I haven't had this problem before.
Whatever I try, I can't remove the filter. Mostly the sort & filter button is greyed out.
I have tried copying and pasting the data into another sheet but it behaves exactly the same way.
Any thoughts?
Perhaps you may share sample file without sensitive data to illustrate an issue?
