LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"