Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wentan
 
Posts: n/a
Default How do I copy a cell all the way down a column w/o mouse?


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
qwopzxnm
 
Posts: n/a
Default How do I copy a cell all the way down a column w/o mouse?


Use arrow keys to navigate to where you want to copy.
Hold shift down and use arrow keys to highlight cell(s)
Hit Ctrl + C to copy
use arrow keys to nivigate to where you need to copy to
Hold Shift down and use arrow keys to highlight the area you want to
paste to.


--
qwopzxnm
------------------------------------------------------------------------
qwopzxnm's Profile: http://www.excelforum.com/member.php...o&userid=27557
View this thread: http://www.excelforum.com/showthread...hreadid=497588

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default How do I copy a cell all the way down a column w/o mouse?

Hi

Navigate with cursor keys to cell with formula.
Ctrl+C to copy cell
Navigate to start of range with cursor, hold Shift button down as you
navicate to last cell
Ctrl+V to Paste

--
Regards

Roger Govier



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
copy and pasting a find all list into another column Ben Excel Discussion (Misc queries) 18 December 31st 05 10:51 PM
Copy the last cell in an Excel column to another cell bob Excel Discussion (Misc queries) 2 September 7th 05 11:53 PM
Copy one cell to entire column Tom Excel Discussion (Misc queries) 3 April 28th 05 03:26 PM
Copy one cell to entire column Tom Excel Discussion (Misc queries) 6 April 27th 05 11:39 PM
How do you copy a cell formula down a column without displaying n. Coddie Excel Worksheet Functions 4 January 18th 05 02:31 PM


All times are GMT +1. The time now is 02:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"