G GN0001 Member Aug 28, 2011 #1 Is there any way to using the table format without converting the range to a table? Kindly,
Hui Excel Ninja Staff member Aug 29, 2011 #2 When you convert a Table back to a range, the formatting remains You won't get the ongoing fancy zebra stripes or First/Last Row/Column highlights anymore Those things can all be done using Conditional Formatting
When you convert a Table back to a range, the formatting remains You won't get the ongoing fancy zebra stripes or First/Last Row/Column highlights anymore Those things can all be done using Conditional Formatting