anything in Excel...

It's Excel-o-lozy...

Excel Problem - Workbook hangs due to Filter on a data sheet.

www.Excelolozy.com - Excel Workbook hangs due to Filter on a data sheet.

Sometimes, when you apply filter on a sheet, Excel workbook hangs while scrolling through columns.

It happens due to Formatting applied on the data.

Solution is :
Remove unwanted formatting from the data.
To remove formatting :
  • go to "Home" (2007)
  • Click 'Eraser' under "Editing" option
  • Click Clear Formats.
Now filter and scroll freely…

Anything in Excel, be an Excelolozian...

for best MS Excel Tips visit http://www.Excelolozy.com

gotta query??? drop a mail at mail@excelolozy.com