+ Reply to Thread
Results 1 to 7 of 7

How do I move the end of the spreadsheet place where (ctrl + end).

  1. #1
    onthe_brink
    Guest

    How do I move the end of the spreadsheet place where (ctrl + end).

    After I have deleted data in a spreadsheet, when i use (ctrl+end) it takes me
    back to the same position even though the end of the data is rows and columns
    above it?

  2. #2
    JulieD
    Guest

    Re: How do I move the end of the spreadsheet place where (ctrl + end).

    Hi

    one way to solve this is to go to the end of your data (the actual data) and
    then from there do control & shift & end and then delete the rows.

    now close & save the workbook - when you reopen it the "ending" point should
    have been reset.

    Cheers
    JulieD

    "onthe_brink" <[email protected]> wrote in message
    news:[email protected]...
    > After I have deleted data in a spreadsheet, when i use (ctrl+end) it takes
    > me
    > back to the same position even though the end of the data is rows and
    > columns
    > above it?




  3. #3
    Paul B
    Guest

    Re: How do I move the end of the spreadsheet place where (ctrl + end).

    Have a look here

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

    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "onthe_brink" <[email protected]> wrote in message
    news:[email protected]...
    > After I have deleted data in a spreadsheet, when i use (ctrl+end) it takes
    > me
    > back to the same position even though the end of the data is rows and
    > columns
    > above it?




  4. #4
    onthe_brink
    Guest

    Re: How do I move the end of the spreadsheet place where (ctrl + e



    "JulieD" wrote:

    > Hi
    >
    > one way to solve this is to go to the end of your data (the actual data) and
    > then from there do control & shift & end and then delete the rows.
    >
    > now close & save the workbook - when you reopen it the "ending" point should
    > have been reset.
    >
    > Cheers
    > JulieD
    >
    > "onthe_brink" <[email protected]> wrote in message
    > news:[email protected]...
    > > After I have deleted data in a spreadsheet, when i use (ctrl+end) it takes
    > > me
    > > back to the same position even though the end of the data is rows and
    > > columns
    > > above it?

    >
    >

    That worked- I didnt think of the save and reopen file.
    >


  5. #5
    JulieD
    Guest

    Re: How do I move the end of the spreadsheet place where (ctrl + e


    glad it worked and thanks for the feedback - some versions need the save &
    close - others don't - and as i can't remember which do & which don't i
    always suggest it!

    "onthe_brink" <[email protected]> wrote in message
    news:[email protected]...
    >
    >
    > "JulieD" wrote:
    >
    >> Hi
    >>
    >> one way to solve this is to go to the end of your data (the actual data)
    >> and
    >> then from there do control & shift & end and then delete the rows.
    >>
    >> now close & save the workbook - when you reopen it the "ending" point
    >> should
    >> have been reset.
    >>
    >> Cheers
    >> JulieD
    >>
    >> "onthe_brink" <[email protected]> wrote in message
    >> news:[email protected]...
    >> > After I have deleted data in a spreadsheet, when i use (ctrl+end) it
    >> > takes
    >> > me
    >> > back to the same position even though the end of the data is rows and
    >> > columns
    >> > above it?

    >>
    >>

    > That worked- I didnt think of the save and reopen file.
    >>




  6. #6
    Myrna Larson
    Guest

    Re: How do I move the end of the spreadsheet place where (ctrl + end).

    Just to clarify, DELETE on the Edit menu, not the Del key (which only clears
    contents).

    On Wed, 9 Feb 2005 23:18:58 +0800, "JulieD" <[email protected]>
    wrote:

    >Hi
    >
    >one way to solve this is to go to the end of your data (the actual data) and
    >then from there do control & shift & end and then delete the rows.
    >
    >now close & save the workbook - when you reopen it the "ending" point should
    >have been reset.
    >
    >Cheers
    >JulieD
    >
    >"onthe_brink" <[email protected]> wrote in message
    >news:[email protected]...
    >> After I have deleted data in a spreadsheet, when i use (ctrl+end) it takes
    >> me
    >> back to the same position even though the end of the data is rows and
    >> columns
    >> above it?

    >



  7. #7
    Registered User
    Join Date
    09-10-2014
    Location
    Calgary, Alberta, Canada
    MS-Off Ver
    2010
    Posts
    3

    Re: How do I move the end of the spreadsheet place where (ctrl + end).

    Thank you all for your replies. Unfortunately nothing worked. The program wouldn't allow me to delete almost 1.5 million rows and a couple of thousand columns.

    Ended up copying the actual spreadsheet cells to a blank sheet, deleting the problems sheet, and then renaming the new sheet to the same as the deleted sheet. Associated formulas and macros seem to keep working. Took the file size from over 19 Meg to about 650 KB.

    Thanks again everyone.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1