Jul 28, 2006 · > and press CTRL+SHIFT+END is goes row 14000 where the data originally ended > instead of 6000 where it ends now. > I wondered if there was anyway to reset what excel considers the last used > cell to be? Hi LisaH Save the workbook, the used range will be re-calculated. Regards Steve

Feb 18, 2021 · Try using the on-screen keyboard to check if the same issue persists. Press and hold the Windows key and press 'R' key. A run window will open then type 'OSK' (without the parenthesis), click on OK. Use the on-screen keyboard, press Ctrl+Shift+Down and check if you face the same issue using the mouse/touchpad. Let me know the outcome.

Mar 28, 2018 · I am working with massive excel census data sets on a new laptop (Gigabyte Aero 15) and the CTRL + SHIFT + Direction arrows are not allowing me to select jump to the end of a column of data, which is essential to allowing me to select 30,000 rows in an instant allowing me to do regression analysis on massive amounts of data.

Sep 19, 2019 · So recently, two of my favourite shortcuts - CTRL-SHIFT-END and CTRL-SHIFT-HOME - which i use to quickly select all the text to the end/beginning of a document have stopped working. CTRL-END still works, CTRL-HOME still works, SHIFT-END still works and SHIFT-HOME still works.

Aug 23, 2017 · CTRL + SHIFT + DOWN ARROW normally selects a column of data in an Excel spreadsheet but I am working on someone else's spreadsheet and it is not working; it will only select part way through the data and stop, then I will have hit the DOWN ARROW again and it will go a little further down but won't go to the end unless I keep hitting the DOWN ARROW.

Feb 6, 2016 · The problem is that Ctrl-End goes to the end of the original data region instead of the end of the current data. I've tried Edit / Clear / All, as well as deleting the rows beyond the current data, but Ctrl-End still goes too far.

Jun 13, 2022 · I've been working with Excel for a long time and since last Friday my Excel started to not accept the command CTRL+SHIFT+DOWN to select every populated cell until the end of the filled cells. The weird thing is that specifically the down arrow is not working. All the other keys are working normally in the command CTRL+SHIFT+Right, Left, Up

Oct 5, 2021 · Shift + Page Up / Page Down. Moves the cursor up or down a screen, selecting text. Ctrl + Shift + Home / End. Moves the cursor to the beginning or end of the screen buffer, selecting all text between the cursor and the beginning or end. Ctrl + Shift + Esc. Open Task Manager. Alt + Tab + F4. Restart File Explorer.

Oct 11, 2018 · Ctrl-Home then Ctrl-Shift-End (or Ctrl-End then Ctrl-Shift-Home) will select the entire used range of a worksheet; Ctrl-Shift-* (really Ctrl-Shift-8 or Ctrl-*) or Ctrl-A will select the data area around the active cell - so everything to the next blank row/column in all directions (you have to be in a cell for this to work);

Press Ctrl+End. If you do not see Ctrl+End appear in the box, you probably have a mechanical problem with your keyboard. If Ctrl+End does appear in the box, it shoulds currently be assigned to EndOfDocument. If it is assigned to something else, select that and click Remove. To assign Ctrl+End to EndOfDocument again: