Forum Discussion
Regarding the Paste value with copy formula
Dear, I have a concern about pasting values with the "copy" formula. When we use the shortcut Ctrl+arrow key to navigate, it takes us to the last cell, skipping any empty cells in between. However, ...
Dear, NikolinoDE
- Formula Results & Ctrl + Arrow:
If you paste a formula that results in an empty string (""), Excel still considers the cell as non-empty because a formula technically occupies it. This means that when you use Ctrl + Arrow, Excel navigates to the last "used" cell, even if the formula returns no visible value.
As per your comment, Excel never exist empty values without using clear formatting or a delete button.
Yes, you're right. In Excel, cells are never truly "empty" after a value, formula, or any type of formatting has been applied to them, even if the visible result is an empty string (""). Excel considers the cells as "used" or "occupied". Even if a cell looks empty, formatting like borders, cell styles, or conditional formatting can make Excel consider the cell as "used." This will affect how Ctrl + Arrow behaves.
If you want to leave the formulas in place but still navigate more easily:
- Use the Find and Replace feature: Search for cells that return "" and clear them manually, but this requires constant checking.
Thank you for your understanding & time
- Dear Concern,
Thanks for your response. But there is an my question in this regard.
When using the shortcut keys Alt+H+F+D+S+K to select only blank cells, empty strings ("") are not considered as blank cells and are not selected. If empty strings ("") are not considered as blank cells, this should be indicated by a code() number. Can you please explain this?