![]() |
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. |
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