Automatically continue formulas and formatting to new columns at XFD

[Ribbs]

I'm building a production report inExcel. It has eight horizontal fields of daily production numbersreaching from column D or so to the very right end of the spreadsheet(XFD). It has color formatting (fill) in some of the rows andvertical borders every fifth column (to delineate weeks) that wereadded by copying the first five cells and pasting to the row. Italso has a date row auto-filled by dragging. It has another date rowconsisting of merged cells – five original cells per – that willread “Week ending ##/##/##” that could also be created byauto-fill dragging. Some columns are going to be deleted off theleft end from time to time. I would like the new columns added atthe right end to contain the same formulas and formatting. So farthe color fill and font formatting show up in the new columns, as doborders of individual cells (which I tried as a test). But formulas,the dates, the borders every fifth column, and the merging are notreplicated. Can these four features be automatically included in thenew columns on the right as old data is pruned off of the left? I'mbuilding this at home with Excel 2016. It must function in Excel2007 on the work machines.
Also, if you know a handy way toauto-fill to XFD without holding that mouse button for ten minutes, Iwould be grateful for the tip. Thanks.

 

[navic]

if you know a handy way toauto-fill to XFD without holding that mouse button for ten minutes, Iwould be grateful for the tip. Thanks.

If I understood you correctly.
eg. If you want to copy the values from A1 in all the cells to the last column XFD1.
If A1 cell contains the text "Test" or value or formula.

1- In the Name Box (above the letters column A), enter an address range A1:XFD1
2- Press F2 key
3- Press combination key Ctrl+Enter

Excel will copy the text to automatic (or value or formula) from A1 in all the columns to the last ie XFD1

 

[Ribbs]

Thanks, navic. Sorry, I wasn't clear. There are two questions. The first is the main question. The secondwas an afterthought related to the first. Regarding the secondissue, I'm not asking about copying to a row. (I simplyright-click, and copy and paste.) I'm wondering about auto-filling. To create the date row, for example, I start with a date or two,select the cell(s), grab the little plus sign in the lower right-handcorner, and drag to the right for about ten minutes (literally; Itimed it). Is there some way I could grab the little plus sign and,with a few keystrokes, be propelled to XFD and fill in the dates?


The first, larger question has to dowith formulas and formatting after they have been extended,either by pasting or by auto-fill, to XFD. If you look at theattached demo you'll see that seven attributes have been applied. (#4 and 7, the auto-filled attributes, were begun at XEB and notcolumn A because of the time required to drag - hence the secondquestion - and file size.) 1)Row 1 is filled blue by selecting the row and filling. 2)Row 2 has red, bold, and italic characters done by selecting the rowand choosing these characteristics from the ribbon. 3)Row 3 has a right-side border in each of its cells done by copyingone bordered cell and pasting to the row. 4)A date row was put in row 6 by entering a date, right-clicking theplus sign, dragging to XFD6, and choosing “Fill Weekdays”. 5)The cells in row 9 contain formulas that add the cells above in rows7 and 8. 6)Rows 7 - 9 have borders every fifth column that were added by copyingand pasting. 7)Row 11 has merged cells achieved by merging five cells andauto-filling.
Old data will be deleted from the leftend by deleting columns. Excel adds new columns at the right end. In the attachment I deleted columns A and B. Note that the bluefill, the font formatting, and the borders every cell wereautomatically included in XFC1:XFD3. But the dates, formula, borderevery fifth column, and the merging are not present in XFC6:XFD9. Inshort, it seems that cell formatting applied to a row is included inadded columns, but auto-filled and, except for #3, pasted attributesare not. Is there a way to tell Excel to apply these last fourattributes – #4 through 7 - to new columns at the right end of thesheet?

Thanks for your time and advice.

 

[navic]

I'm sorry I have no idea.
I think you should look for VBA?