ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inserting columns (https://www.excelbanter.com/excel-discussion-misc-queries/198690-inserting-columns.html)

GARY

Inserting columns
 
My Excel 2007 spreadsheet has 3 columns and 700,000 rows.
Why is it taking MANY HOURS to insert 4 new columns between columns B
and C?

Peo Sjoblom[_2_]

Inserting columns
 
Do you have volatile formulas in some of those rows

--


Regards,


Peo Sjoblom

"GARY" wrote in message
...
My Excel 2007 spreadsheet has 3 columns and 700,000 rows.
Why is it taking MANY HOURS to insert 4 new columns between columns B
and C?




GARY

Inserting columns
 
On Aug 13, 8:13*am, "Peo Sjoblom" wrote:
Do you have volatile formulas in some of those rows

--

Regards,

Peo Sjoblom


No. I've already highlighted the 3 columns then I've done COPY/PASTE
SPECIAL/VALUES..


All times are GMT +1. The time now is 04:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com