Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Earl
 
Posts: n/a
Default Setting Control End Limit

I can use the control / end keys to go to the last row that I have formatted.

The problem is that it takes me to the last column and I only have data in
the first ten columns.

I removed the frozen panes with the same results.

How can I set the limits to be the bottom right formatted column?

TIA

Earl
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Setting Control End Limit

If I understand correctly...

Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused

Earl wrote:

I can use the control / end keys to go to the last row that I have formatted.

The problem is that it takes me to the last column and I only have data in
the first ten columns.

I removed the frozen panes with the same results.

How can I set the limits to be the bottom right formatted column?

TIA

Earl


--

Dave Peterson
Reply
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
ActiveX control with chart Tanihera Charts and Charting in Excel 1 April 11th 06 05:36 PM
control limit CaptAndy Excel Worksheet Functions 0 March 29th 06 02:49 PM
sum limit and marking Sum Limit and marking Excel Worksheet Functions 1 December 20th 05 01:01 PM
How to insert date using a pop up calendar control in a cell i Iain the scout Excel Discussion (Misc queries) 4 December 17th 05 08:10 PM
Copying list-box control Excel Discussion (Misc queries) 1 January 6th 05 01:39 AM


All times are GMT +1. The time now is 02:59 PM.

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"