PC Review


Reply
Thread Tools Rate Thread

What is the command that takes you to the last cell in a spreadshe

 
 
=?Utf-8?B?U2Ft?=
Guest
Posts: n/a
 
      7th Sep 2007

 
Reply With Quote
 
 
 
 
PCLIVE
Guest
Posts: n/a
 
      7th Sep 2007
Ctrl+End should do what you want.

Regards,
Paul


--

"Sam" <(E-Mail Removed)> wrote in message
news:6CBDB1CD-E4DF-4208-9E60-(E-Mail Removed)...
>



 
Reply With Quote
 
=?Utf-8?B?U2Ft?=
Guest
Posts: n/a
 
      7th Sep 2007
Thankyou, I have tried it, and it takes you to the last cell that you have
inserted data into, and i need the command that takes you to the last cell in
the entire spreadsheet? Does such a thing exist?

"PCLIVE" wrote:

> Ctrl+End should do what you want.
>
> Regards,
> Paul
>
>
> --
>
> "Sam" <(E-Mail Removed)> wrote in message
> news:6CBDB1CD-E4DF-4208-9E60-(E-Mail Removed)...
> >

>
>
>

 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      7th Sep 2007
Nothing built into excel.

But you could use ctrl-end to get to the bottom right corner of the usedrange.
Then end-downarrow, then end-rightarrow



Sam wrote:
>
> Thankyou, I have tried it, and it takes you to the last cell that you have
> inserted data into, and i need the command that takes you to the last cell in
> the entire spreadsheet? Does such a thing exist?
>
> "PCLIVE" wrote:
>
> > Ctrl+End should do what you want.
> >
> > Regards,
> > Paul
> >
> >
> > --
> >
> > "Sam" <(E-Mail Removed)> wrote in message
> > news:6CBDB1CD-E4DF-4208-9E60-(E-Mail Removed)...
> > >

> >
> >
> >


--

Dave Peterson
 
Reply With Quote
 
PCLIVE
Guest
Posts: n/a
 
      7th Sep 2007
Maybe a three stroke combination.

Holding Ctrl - press and release End and then Down-arrow
Release Ctrl

Then if you want to be in column A
Home

There may be another way, but that's one way.

Regards

--

"Sam" <(E-Mail Removed)> wrote in message
news:26778C8D-CF9F-4E1B-80D5-(E-Mail Removed)...
> Thankyou, I have tried it, and it takes you to the last cell that you have
> inserted data into, and i need the command that takes you to the last cell
> in
> the entire spreadsheet? Does such a thing exist?
>
> "PCLIVE" wrote:
>
>> Ctrl+End should do what you want.
>>
>> Regards,
>> Paul
>>
>>
>> --
>>
>> "Sam" <(E-Mail Removed)> wrote in message
>> news:6CBDB1CD-E4DF-4208-9E60-(E-Mail Removed)...
>> >

>>
>>
>>



 
Reply With Quote
 
=?Utf-8?B?U2Ft?=
Guest
Posts: n/a
 
      7th Sep 2007
Thank You, That helps me entirely,

"Dave Peterson" wrote:

> Nothing built into excel.
>
> But you could use ctrl-end to get to the bottom right corner of the usedrange.
> Then end-downarrow, then end-rightarrow
>
>
>
> Sam wrote:
> >
> > Thankyou, I have tried it, and it takes you to the last cell that you have
> > inserted data into, and i need the command that takes you to the last cell in
> > the entire spreadsheet? Does such a thing exist?
> >
> > "PCLIVE" wrote:
> >
> > > Ctrl+End should do what you want.
> > >
> > > Regards,
> > > Paul
> > >
> > >
> > > --
> > >
> > > "Sam" <(E-Mail Removed)> wrote in message
> > > news:6CBDB1CD-E4DF-4208-9E60-(E-Mail Removed)...
> > > >
> > >
> > >
> > >

>
> --
>
> Dave Peterson
>

 
Reply With Quote
 
MartinW
Guest
Posts: n/a
 
      7th Sep 2007
Don't know if I'd call it a command but if you hold down
Ctrl then tap end, down arrow, right arrow and let go Ctrl
You will be at IV65536

HTH
Martin


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Nothing built into excel.
>
> But you could use ctrl-end to get to the bottom right corner of the
> usedrange.
> Then end-downarrow, then end-rightarrow
>
>
>
> Sam wrote:
>>
>> Thankyou, I have tried it, and it takes you to the last cell that you
>> have
>> inserted data into, and i need the command that takes you to the last
>> cell in
>> the entire spreadsheet? Does such a thing exist?
>>
>> "PCLIVE" wrote:
>>
>> > Ctrl+End should do what you want.
>> >
>> > Regards,
>> > Paul
>> >
>> >
>> > --
>> >
>> > "Sam" <(E-Mail Removed)> wrote in message
>> > news:6CBDB1CD-E4DF-4208-9E60-(E-Mail Removed)...
>> > >
>> >
>> >
>> >

>
> --
>
> Dave Peterson



 
Reply With Quote
 
Dana DeLouis
Guest
Posts: n/a
 
      8th Sep 2007
Just another idea to add.
Ctrl+Home to take you to A1.
Ctrl+A to select all cells.
Shift+Tab to back up to the last cell.

--
Dana DeLouis
Windows XP & Excel 2007


"Sam" <(E-Mail Removed)> wrote in message
news:3DEFCCD3-4875-4DB7-B3FF-(E-Mail Removed)...
> Thank You, That helps me entirely,
>
> "Dave Peterson" wrote:
>
>> Nothing built into excel.
>>
>> But you could use ctrl-end to get to the bottom right corner of the
>> usedrange.
>> Then end-downarrow, then end-rightarrow
>>
>>
>>
>> Sam wrote:
>> >
>> > Thankyou, I have tried it, and it takes you to the last cell that you
>> > have
>> > inserted data into, and i need the command that takes you to the last
>> > cell in
>> > the entire spreadsheet? Does such a thing exist?
>> >
>> > "PCLIVE" wrote:
>> >
>> > > Ctrl+End should do what you want.
>> > >
>> > > Regards,
>> > > Paul
>> > >
>> > >
>> > > --
>> > >
>> > > "Sam" <(E-Mail Removed)> wrote in message
>> > > news:6CBDB1CD-E4DF-4208-9E60-(E-Mail Removed)...
>> > > >
>> > >
>> > >
>> > >

>>
>> --
>>
>> Dave Peterson
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tab to next cell takes me 5 rows away!! tash Microsoft Excel Misc 1 10th Dec 2007 02:16 PM
Generic class which takes command string and returns datareader? =?Utf-8?B?UGV0ZXI=?= Microsoft VB .NET 7 28th Aug 2007 11:02 PM
Formula that takes a cell value over another? StargateFanFromWork Microsoft Excel Programming 6 30th Oct 2006 08:26 PM
One cell takes multiple inputs csw78 Microsoft Excel Misc 4 27th May 2005 03:46 AM
Edit cell automatically takes you to cell =?Utf-8?B?Y2dyYW50?= Microsoft Excel Worksheet Functions 1 20th May 2005 04:30 PM


Features
 

Advertising
 

Newsgroups
 


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