Auto Fill Table

[Bedford]

Anyone have a solution for a table that doesn't auto fill formulas, or validation. The last row for example, before the total row is 43, tab to move to the next row and the formulas indicate it dealing with row 45 when it should read row 44, and formulas and validation are completely off or missing.
Help please.

 

[Skyybot]

Could you provide a sample of your Sheet via XL2BB? I would help in aiding you greatly.

 

[Alex Blakenburg]

Assuming it is an actual Excel Table then:
• Select a cell that has the characteristics that you are happy with.
• Ctrl+C
• Ctrl+SpaceBar (this will select the whole column except the headings & totals row)
• Ctrl+V
Then add a row and see if the issue is fixed.

 

[Bedford]

Could you provide a sample of your Sheet via XL2BB? I would help in aiding you greatly

 

[Bedford]

Could you provide a sample of your Sheet via XL2BB? I would help in aiding you greatly.

						Glide / MEX Bottom Rail						Parts or Frame Color
Category	SKU#	Width	Height	Install Type	Handing	Color	Tape	Drain Holes	Screw Holes	Description	Image	Available Choices	Select	Material	Allotment	Quantity	Unit	Total
Made2Measure_Glide_Single	MG-1500x2700-SS									Glide Screen, Single Slide, MG-1500x2700-SS		WH_BK_SVM_MF		UPVC, PET, Alum	1 set	3	$347.82	$1,043.45
Made2Measure_Glide_Double	MG-1000x3400-DS									Glide Screen, Double Slide, MG-1000x3400-DS		WH_BK_SVM_MF		UPVC, PET, Alum	1 set	5	$0.00	$0.00
Made2Measure_MEX_Single	MX2-500x2600									MX2, Single Slide, Made to Measure, Pleated Retractable Screen. MX2-500x2600		WH_BK_MF		UPVC, PET, Alum	1 set	3	$146.00	$438.00
Made2Measure_MEX_Double	MX2-800x2000									MX2, Double Slide, Made to Measure, Pleated Retractable Screen. MX2-800x2000		WH_BK_MF	Powder Coat Black	UPVC, PET, Alum	1 set	6	$223.00	$1,338.00
TensionWire	243217									Wire 1000m / Roll		Black	Black	Polyamid	1 Roll	1	$210.00	$210.00
StandardSize_MX2	MX2-1400x2700									MX2, Pleated Retractable Screen. 1400x2700 (55 1/8 x 106 5/16)		WH_BK_MF	Powder Coat White	UPVC, PET, Alum	1 set	2	$195.09	$390.18
MX2_ReplacementCartridges	MX2MSC-1400x3000									MX2, Replacement Mesh Cartridge 1400x3000, (55 1/8 x 118 1/8)		Black	Black	UPVC, PET, Alum	1 set	2	$150.83	$301.66
MX2_InjectionParts	MX-013									MX2, Roller Piece		Black	Black	POM	1pc	2	$0.70	$1.40
Glide_InjectionParts	511106									MG, Top Rail Joint		White_or_Black	White	PVC	1pc	4	$0.23	$0.92
AluminumExtrusions	311087-PC									Powder Coat Face Mount Attachment, Per meter.		WH_BK_SVM	Silver Matte Anodize	AA 6063	0	4	$22.94	$91.76
PVCExtrusions	361025									MG, Dust Cover, L=2.5m, Per pc		White_or_Black	Black	U-PVC	1pc	4	$1.20	$4.80
Magnet	291202									Magnet strip for Sliding bar and Catch frame 600GS, 40m / Roll, Per roll.		Dark.Brown	Dark Brown	Rubber ferrite	1 Roll	4	$44.40	$177.60
Screws	PX11-5036-FBT 3.5*16									Installation Screw, Flat Head for Bottom rail, F/BT3.5x16mm, Per pc.		Black_Silver	Silver	SUS304	1pc	22	$0.06	$1.32
Screws	200118									MG, Truss head screw ( for Tension Adjuster )		Black	Black	SUS	1pc	6	$0.03	$0.18
FMAParts	511121									FMA center joint option, Per pc.		White_Black	Powder Coat Black	AAS(ASA)+UV stabilizer	1pc	22	$0.50	$11.00
Tape	#1005 -10									Double sided tape for Top rail / Housing / Catch frame #1005 W10mm (option) per 1 roll of 25 meters.		White	White	0	1 Roll	2	$2.00	$4.00
TensionWire	243217									Wire 1000m / Roll		Black	Black	Polyamid	1 Roll	1	$210.00	$210.00
Made2Measure_MEX_Single	MX2-500x3000									MX2, Single Slide, Made to Measure, Pleated Retractable Screen. MX2-500x3000		WH_BK_MF	Powder Coat White	UPVC, PET, Alum	1 set		$165.00
Made2Measure_MEX_Double	MX2-800x2800									MX2, Double Slide, Made to Measure, Pleated Retractable Screen. MX2-800x2800		WH_BK_MF	Mill Finish	UPVC, PET, Alum	1 set		$287.00
Made2Measure_Glide_Single	MG-500x1800-SS									Glide Screen, Single Slide, MG-500x1800-SS		WH_BK_SVM_MF	Silver Matte Anodize	UPVC, PET, Alum	1 set		$200.67
Made2Measure_Glide_Double	MG-1000x2400-DS									Glide Screen, Double Slide, MG-1000x2400-DS		WH_BK_SVM_MF	Powder Coat White	UPVC, PET, Alum	1 set		$378.67
ShipTo
Tape	#1005 -10									Double sided tape for Top rail / Housing / Catch frame #1005 W10mm (option) per 1 roll of 25 meters.		White		0	1 Roll		$2.00
AluminumExtrusions	311087-PC									Powder Coat Face Mount Attachment, Per meter.		WH_BK_SVM	Powder Coat Black	AA 6063	0		$22.94
MX2_ReplacementCartridges										MX2, Replacement Mesh Cartridge 1400x2400, (55 1/8 x 94 1/2)		Black	Black	UPVC, PET, Alum	1 set	2	$108.42	$216.84
Total																		33

 

[Bedford]

Assuming it is an actual Excel Table then:
• Select a cell that has the characteristics that you are happy with.
• Ctrl+C
• Ctrl+SpaceBar (this will select the whole column except the headings & totals row)
• Ctrl+V
Then add a row and see if the issue is fixed.

That seems to have corrected the problem. The Ctrl+SpaceBar is new to me, thank you for the solution, much appreciated.

 

[Alex Blakenburg]

You can hover over the heading until the you get a black downward pointing arrow but I find the Ctrl+spacebar avoids the need for such precise mouse movements and since you are already using the keyboard for the Ctrl+C & Ctrl+V it just makes sense to use that option.
Note:
• Ctrl+Spacebar selects to column's databody range, Ctrl+Spacebar+Spacebar (spacebar twice) includes the heading.
• To commit a formula or formatting to be the default for all rows in a column of the table you need to apply it to ALL rows at once.

 

[Bedford]

You can hover over the heading until the you get a black downward pointing arrow but I find the Ctrl+spacebar avoids the need for such precise mouse movements and since you are already using the keyboard for the Ctrl+C & Ctrl+V it just makes sense to use that option.
Note:
• Ctrl+Spacebar selects to column's databody range, Ctrl+Spacebar+Spacebar (spacebar twice) includes the heading.
• To commit a formula or formatting to be the default for all rows in a column of the table you need to apply it to ALL rows at once.

Super helpful, I've copied your notes into my database of helpful hints and tips. Thanks again.