Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Mac > Excel Office for Mac > Re: How jump to...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 6 of 12 Topic 5550 of 6461
Post > Topic >>

Re: How jump to the last row of text? What shortcut?

by Phillip Jones <pjones1@[EMAIL PROTECTED] > Apr 29, 2008 at 07:01 PM

click in first cells then scroll to end of data
Then hold ****ft key while clicking in last cell

you can also do this if you want to select all the cells that have 
information

Click in first cell then scroll down while holding down ****ft key to the 
last row with Data. Then scroll sideways until last column is selected. 
you now have all cells selected that have data

You can do a variation on the above. click in first cell at top left and 
mouse to bottom left of you worksheet (last cell that has data). then 
hold down ****ft and click in cell.

roblake@[EMAIL PROTECTED]
 wrote:
> Is there a keyboard shortcut that will copy a selected set of
formula-containing cells rightward across the rows to the end of data?
> 
> roblake

-- 
------------------------------------------------------------------------
Phillip M. Jones, CET   |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street      |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112   |pjones@[EMAIL PROTECTED]
 ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto:pjones@[EMAIL PROTECTED]
>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>
 




 12 Posts in Topic:
How jump to the last row of text? What shortcut?
kevs1@[EMAIL PROTECTED]   2008-04-29 06:54:24 
Re: How jump to the last row of text? What shortcut?
JE McGimpsey <jemcgimp  2008-04-29 09:09:10 
Re: How jump to the last row of text? What shortcut?
roblake@[EMAIL PROTECTED]  2008-04-29 07:31:58 
Re: How jump to the last row of text? What shortcut?
JE McGimpsey <jemcgimp  2008-04-29 09:43:02 
Re: How jump to the last row of text? What shortcut?
kevs1@[EMAIL PROTECTED]   2008-04-29 14:18:47 
Re: How jump to the last row of text? What shortcut?
Phillip Jones <pjones1  2008-04-29 19:01:33 
Re: How jump to the last row of text? What shortcut?
kevs1@[EMAIL PROTECTED]   2008-04-30 12:03:25 
Re: How jump to the last row of text? What shortcut?
Phillip Jones <pjones1  2008-05-01 14:34:05 
Re: How jump to the last row of text? What shortcut?
kevs1@[EMAIL PROTECTED]   2008-05-01 14:39:30 
Re: How jump to the last row of text? What shortcut?
Phillip Jones <pjones1  2008-05-01 21:15:26 
Re: How jump to the last row of text? What shortcut?
kevs1@[EMAIL PROTECTED]   2008-05-01 22:33:41 
Re: How jump to the last row of text? What shortcut?
Phillip Jones <pjones1  2008-05-02 19:54:03 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 19:25:08 CDT 2008.