How do I copy and paste...and OMIT blank cells.. Larry
P Poh Jun 30, 2004 #2 Hi Try this: Select the range of data, click Edit>Goto>Special and select Contants; non-blank cells will be selected this way. Next, carry out normal copy and paste procedures.
Hi Try this: Select the range of data, click Edit>Goto>Special and select Contants; non-blank cells will be selected this way. Next, carry out normal copy and paste procedures.