Formatting and the "go to" command
KK,
A lot depends on the structure of your sheet, and where you actually want to go:
End then down arrow, or End then right arrow, unless you have intermediate blanks, in which case
you can use Special / Current region, then Shift-Tab. That will work unless you have completely
blank rows or columns interspersed.
HTH,
Bernie
MS Excel MVP
"kleivakat" wrote in message
...
I'd like to use the "go to" command where the cursor goes to the last row
with data. When I use the "Special" command and select "last" it goes to the
last formatted cell, not the last cell with data in it.
Can I go to the last cell with data entered in it without going to the last
formatted cell (that may be empty?)
If not, how do I delete formatting? I formatted rows and columns with
borders for ease of reading, and if I go in and change to show "no borders",
it still seems to be reading that as formatted because it still goes to the
last cell that I highlighted to get no borders. ???
Thanks for any info.
KK
|