Drop Down List

[bakerkr]

Hi Everyone,

I create a spreadsheet with several drop down list (pulling from a second worksheet), but when I go to a new row, I the drop down list isn't available, so I recreate the drop down list by first selecting the entire column, but this causes blank rows when trying to print. Is there a way to format the new row using the previous row once data is entered in cell A1? using office 2010


Thanks,
Kevin

 

[Steve=True]

Have you made it a table?

Tables have great features that when you enter information in a row or column around the table, the rest of the cells will inherit formulas and formatting like the adjacent cells.

From your INERT ribbon

Highlight your range

Click insert table.

 

[bakerkr]

Thanks Steve will give that a shot

 

[bakerkr]

Worked... BUT.. I've now added conditional formatting to a few cells, which works, but the conditions are included on new lines.. Any ideal how to fix this??