Home

Ctrl+A Not Selecting All Columns in Spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-886551%22%20slang%3D%22en-US%22%3ECtrl%2BA%20Not%20Selecting%20All%20Columns%20in%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886551%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20attempting%20to%20select%20all%20the%20cells%20(with%20data)%20in%20a%20spreadsheet.%20No%20matter%20what%20I%20try%2C%20only%20the%20first%205%20columns%20are%20selected.%20Any%20suggestionw%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-886551%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886583%22%20slang%3D%22en-US%22%3ERe%3A%20Ctrl%2BA%20Not%20Selecting%20All%20Columns%20in%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886583%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F418151%22%20target%3D%22_blank%22%3E%40JLH64%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20you%20have%20data%20in%20non%20contiguous%20range%20i.e.%20you%20may%20have%20one%20or%20more%20blank%20columns%20in%20between.%3C%2FP%3E%3CP%3ETo%20select%20all%20the%20non%20contiguous%20data%2C%20select%20cell%20A1%20and%20press%20%3CSTRONG%3ECtrl%2BShift%2BEnd%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886590%22%20slang%3D%22en-US%22%3ERe%3A%20Ctrl%2BA%20Not%20Selecting%20All%20Columns%20in%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886590%22%20slang%3D%22en-US%22%3EThanks%20-%20Ctrl%2BShift%2BEnd%20selects%20every%20cell%20in%20the%20spreadsheet%20(A1%20-%26gt%3B%20XFD%201048576).%20How%20can%20I%20select%20just%20the%20cells%20I%20know%20I%20have%20data%20in%3F%20I'm%20not%20sure%20if%20this%20is%20the%20reason%20why%20when%20I%20sort%20a%20column%20of%20numbers%20that%20not%20all%20cells%20are%20part%20of%20the%20sort.)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886707%22%20slang%3D%22en-US%22%3ERe%3A%20Ctrl%2BA%20Not%20Selecting%20All%20Columns%20in%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886707%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F418151%22%20target%3D%22_blank%22%3E%40JLH64%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20press%20%3CSTRONG%3ECtrl%2BEnd%3C%2FSTRONG%3E%20which%20cell%20gets%20selected%3F%3C%2FP%3E%3CP%3EIdeally%20this%20should%20be%20the%20last%20cell%20used%20on%20the%20worksheet%20either%20for%20entering%20data%2C%20applying%20a%20formula%20or%20any%20kind%20of%20formatting%20to%20it.%3C%2FP%3E%3CP%3EWhichever%20cell%20you%20get%20after%20pressing%20%3CSTRONG%3ECtrl%2BEnd%3C%2FSTRONG%3E%2C%20is%20it%20really%20the%20last%20cell%20used%20on%20that%20worksheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886730%22%20slang%3D%22en-US%22%3ERe%3A%20Ctrl%2BA%20Not%20Selecting%20All%20Columns%20in%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886730%22%20slang%3D%22en-US%22%3EIf%20you%20press%20Ctrl%2BA%20twice%20may%20select%20all%20cells.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886889%22%20slang%3D%22en-US%22%3ERe%3A%20Ctrl%2BA%20Not%20Selecting%20All%20Columns%20in%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886889%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F418151%22%20target%3D%22_blank%22%3E%40JLH64%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20need%20to%20stay%20within%20the%20range%20to%20select%20with%20Ctrl%2BA%20the%20data%20only%20%2C%20i.e.%20some%20data%20shall%20be%20to%20the%20right%20and%20down%20from%20your%20focused%20cell.%20Otherwise%20Ctrl%2BA%20selects%20entire%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886910%22%20slang%3D%22en-US%22%3ERe%3A%20Ctrl%2BA%20Not%20Selecting%20All%20Columns%20in%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886910%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20press%20%3CSTRONG%3ECtrl%2BEnd%3C%2FSTRONG%3E%2C%20the%20last%20cell%20selected%20is%20Column%20CD%2C%20Row%20296.%20In%20reality%2C%20the%20last%20cell%20in%20use%20is%20Column%20AY%2C%20Row%20226.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886915%22%20slang%3D%22en-US%22%3ERe%3A%20Ctrl%2BA%20Not%20Selecting%20All%20Columns%20in%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886915%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20press%20%3CSTRONG%3ECtrl%20%2B%20A%3C%2FSTRONG%3E%2C%20Columns%20A%20thru%20D%2C%20thru%20Row%20226%20are%20selected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20C%20contains%20numbers.%20And%2C%20even%20though%20Column%20C%20is%20selected%2C%20I'm%20not%20able%20to%20sort%20the%20column%20sequentially%20and%20a%20few%20numbers%20don't%20even%20appear%20in%20the%20selection%20list%20for%20that%20column.%3CBR%20%2F%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886923%22%20slang%3D%22en-US%22%3ERe%3A%20Ctrl%2BA%20Not%20Selecting%20All%20Columns%20in%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886923%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20does%20it%20mean%20to%20%22stay%20within%20the%20range%22%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-886952%22%20slang%3D%22en-US%22%3ERe%3A%20Ctrl%2BA%20Not%20Selecting%20All%20Columns%20in%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-886952%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F418151%22%20target%3D%22_blank%22%3E%40JLH64%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20are%20somewhere%20here%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20264px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134974i2C48FDD0FDB9C75F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ECtrl%2BA%20selects%20the%20range.%3C%2FP%3E%0A%3CP%3EIf%20here%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20358px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134976iA071925EDD60C960%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E-%20entire%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
JLH64
Occasional Contributor

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?

9 Replies

@JLH64 

Maybe you have data in non contiguous range i.e. you may have one or more blank columns in between.

To select all the non contiguous data, select cell A1 and press Ctrl+Shift+End.

Thanks - Ctrl+Shift+End selects every cell in the spreadsheet (A1 -> XFD 1048576). How can I select just the cells I know I have data in? I'm not sure if this is the reason why when I sort a column of numbers that not all cells are part of the sort.)

@JLH64 

When you press Ctrl+End which cell gets selected?

Ideally this should be the last cell used on the worksheet either for entering data, applying a formula or any kind of formatting to it.

Whichever cell you get after pressing Ctrl+End, is it really the last cell used on that worksheet?

Highlighted
If you press Ctrl+A twice may select all cells.

@JLH64 

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.

@Subodh_Tiwari_sktneer 

 

When I press Ctrl+End, the last cell selected is Column CD, Row 296. In reality, the last cell in use is Column AY, Row 226.

When I press Ctrl + A, Columns A thru D, thru Row 226 are selected.

 

Column C contains numbers. And, even though Column C is selected, I'm not able to sort the column sequentially and a few numbers don't even appear in the selection list for that column.
 

@Sergei Baklan 

 

What does it mean to "stay within the range"?

@JLH64 

If you are somewhere here

image.png

Ctrl+A selects the range.

If here

image.png

- entire sheet.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies