How to correct #NA error in vlookup function – MS Excel.Sum and average do not appear in Excel status bar.MS Excel not searching within the selection range.How to truncate fractions and convert decimals to whole numbers (value changed)?.How to copy and paste only non blank cells in Excel?.Ctrl + Shift + Down (or any arrow key) not working properly in MS Excel.Good Practices to follow in using Excel Spreadsheets.How to calculate interest rate in Excel for a one time deposit?.How to solve if excel do not filter blank cells? (Filter checklist do not show blanks).How to solve when filter function does not work properly in MS Excel?.Solving Equations in MS Excel 97-2003 version.How to change the width of multiple columns? How to change the height of multiple rows?.How to handle error message “This workbook contains one or more links that cannot be updated” ?.How to delete all spaces in a selection (or how to delete spaces in a sheet)?.How to copy or drag down a condition in Conditional formatting? – MS Excel.How to combine multiple cells in excel without losing data?.Excel Spreadsheet Applications and Tips.Search engine keywords for this question:Ĭtrl Arrow combination not return desired selection If the key combination is not at all working, try changing the settings by going to Excel Options> Advanced> Tools>Options>Uncheck Transition Navigation Keys. Step 4 – Now press Ctrl+Down to navigate up to the bottom (up to the row which you selected in Step 2)Īnother problem with Ctrl+Down function is associated with Transition Navigation Keys. Excel fills in all blank cells with the value 0. Step 2 – Select the range of cells that you need to navigate.

Step 1 – Before entering values in blank cells One solution to avoid this issue is to fill in the blank cells with value 0 (zero) if it doesn’t affect the purpose of the sheet. This is because it stops at the first blank cell in the column. Users often find that Ctrl Down key function stops at an intermediate cell and does not navigate up to the bottom of the sheet.

Ctrl v stopped working