Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JKB
 
Posts: n/a
Default How to set the autofill options in a column of a input data table

I have a table that is designed and saved for data input. On this table some
columns sequence when auto fill is used and others just copy. I can of
course use the control key to vary the autofill result but this involves
using the hand that is keeping place on the paper sheet record and anyway is
not a neat use of the spreadsheet. I can find no way of setting this
requirement.
  #2   Report Post  
RagDyeR
 
Posts: n/a
Default

Try using the "Right Click" and drag options.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"JKB" wrote in message
...
I have a table that is designed and saved for data input. On this table
some
columns sequence when auto fill is used and others just copy. I can of
course use the control key to vary the autofill result but this involves
using the hand that is keeping place on the paper sheet record and anyway is
not a neat use of the spreadsheet. I can find no way of setting this
requirement.


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
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com Excel Worksheet Functions 4 July 14th 05 09:15 PM
Count Position of Filtered TEXT cells in a column Sam via OfficeKB.com Excel Worksheet Functions 8 May 18th 05 04:23 AM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
Formula for a column comicfly Excel Discussion (Misc queries) 2 March 11th 05 12:16 PM
Auto Skipping and protected cells Dave Peterson Excel Discussion (Misc queries) 6 January 27th 05 11:35 PM


All times are GMT +1. The time now is 03:25 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"