Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CTRL + END moves to the blank cell where data used to be
I had 40 rows of data and deleted the last 20 of them using right-click
delete. When I use the CTRL+END keyboard shortcut, it still brings me to the 40th row, even though it's blank. I've already tried selecting the last 20 rows and clearing the contents (thinking that the formatting may still be there causing the problem) but it didn't do the trick. Any ideas?? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Leave cell blank if no data | Excel Discussion (Misc queries) | |||
Removing a blank cell between data | New Users to Excel | |||
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA | Excel Worksheet Functions |