ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Reset End Cell - Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/246371-reset-end-cell-excel-2007-a.html)

justwondering

Reset End Cell - Excel 2007
 
Several spreadsheets are only 50 rows or so but CONTROL + END takes me to
cell H57459. The irritation is that the sliding bar on the right is a tiny
one and slight movements of the cursor on this bar along the screen result in
large jumps in rows. I have tried going to the END cell and DELETE-ing but
the same end cell prevails. How do I reset the END cell and, as a result,
regain a larger slide bar? Thank you.

Jacob Skaria

Reset End Cell - Excel 2007
 
Check out the below link by Debra Dalgleish

http://www.contextures.com/xlfaqApp.html#Unused

If this post helps click Yes
---------------
Jacob Skaria


"justwondering" wrote:

Several spreadsheets are only 50 rows or so but CONTROL + END takes me to
cell H57459. The irritation is that the sliding bar on the right is a tiny
one and slight movements of the cursor on this bar along the screen result in
large jumps in rows. I have tried going to the END cell and DELETE-ing but
the same end cell prevails. How do I reset the END cell and, as a result,
regain a larger slide bar? Thank you.


David Biddulph[_2_]

Reset End Cell - Excel 2007
 
After you've deleted, save, close, and reopen.
--
David Biddulph

"justwondering" wrote in message
...
Several spreadsheets are only 50 rows or so but CONTROL + END takes me to
cell H57459. The irritation is that the sliding bar on the right is a tiny
one and slight movements of the cursor on this bar along the screen result
in
large jumps in rows. I have tried going to the END cell and DELETE-ing but
the same end cell prevails. How do I reset the END cell and, as a result,
regain a larger slide bar? Thank you.





All times are GMT +1. The time now is 01:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com