ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to set the autofill options in a column of a input data table (https://www.excelbanter.com/excel-discussion-misc-queries/35652-how-set-autofill-options-column-input-data-table.html)

JKB

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.

RagDyeR

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.




All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com