View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kleivakat kleivakat is offline
external usenet poster
 
Posts: 29
Default Formatting and the "go to" command

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