Is the name box the fx field? I typed that in cell A 41 also but it didn't
work.


"Peo Sjoblom" wrote in message
...
Click in the name box (above column A's header), type A41:IV65536
press enter, then select EditClear
if there is data that you want to keep and just remove the format select
formats if there is no data just formats select all
press Ctrl + Home and save the workbook


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"LMB" wrote in message
...
Hi Everyone,

Someone sent me an excel sheet and they selected the whole sheet and put
borders on all cells. They also shaded columns all the way down. I have
72 pages but only want one. I need to keep the borders and shading on
cells A1-AG40. I tried to delete the rows by selecting for 41 and
dragging down but I got to 50,000 rows and there were still more. How
can I clear the contents of everything below row 41 and keeping
everything above intact?

Thanks,
Linda