Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JulieD
 
Posts: n/a
Default

definitely not stupid - you're asking questions :) none of us woke up one
day knowing this stuff ....

the fill handle is located at the bottom right hand corner of the cell, if
you move your cursor over it you will see a +, clicking & dragging down on
this will fill in a formula or a series (try typing january in a cell and
filling down or across) ....

if you're using the fill handle and you have a column of data to the left or
right of the cell you want to fill down, double clicking the + rather than
dragging is a quick alternative.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
wrote in message
ups.com...
thanks, that works for one row, row 2.... but how do I fill down for
all the other rows, i'm stupid. thanks



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
Count number of occurences in 1 column only if something in anothe Wenster Excel Worksheet Functions 2 February 7th 05 09:58 PM
Count number of unique items in a column that contains duplicates Steembeem Excel Worksheet Functions 3 February 2nd 05 12:51 AM
Count number to reach a cumulative value Bruce Excel Worksheet Functions 5 January 25th 05 05:14 PM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 08:35 PM
Count of unique items meeting condition Tim C Excel Worksheet Functions 1 November 12th 04 03:03 AM


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

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

About Us

"It's about Microsoft Excel"