H hilcom New Member Mar 4, 2011 #1 Hi Guys, I am using the set as Table format to obtain zebra lines in a workbook area; that goes fine. But: how can I reset the table format to normal (= no format)? I'm overlooking something perhaps but I do not see what. Thanks for your help. Bob, NL
Hi Guys, I am using the set as Table format to obtain zebra lines in a workbook area; that goes fine. But: how can I reset the table format to normal (= no format)? I'm overlooking something perhaps but I do not see what. Thanks for your help. Bob, NL
Luke M Excel Ninja Staff member Mar 4, 2011 #2 Not sure where it is in 2007, but perhaps using keyboard shortcuts: Alt+o, s will get you to the Format Styles dialogue. You should then be able to choose "Normal".
Not sure where it is in 2007, but perhaps using keyboard shortcuts: Alt+o, s will get you to the Format Styles dialogue. You should then be able to choose "Normal".
H hilcom New Member Mar 4, 2011 #3 Thanks Luke for your reaction; I am using excel 2010 and 2007 as well, but do you mean Alt zero,s or Alt O, to go to the Format Styles dialogue? Neither seems to work in my table. Bob
Thanks Luke for your reaction; I am using excel 2010 and 2007 as well, but do you mean Alt zero,s or Alt O, to go to the Format Styles dialogue? Neither seems to work in my table. Bob