ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can't insert columns between columns (https://www.excelbanter.com/excel-discussion-misc-queries/24354-cant-insert-columns-between-columns.html)

smooth operator

can't insert columns between columns
 
I am trying to insert a columns between different columns, but every time I
try I get a message stating that MS Excel can't shift nonblank cells off the
worksheet. I am not trying this, I only have 12 columns, so there should be
plenty of room for more colums. It goes on to say to try to locate the last
nonblank cell by pressing CTRL+END, and delete or clear all in cells between
the last cell and the end of your data, which I have done, but it still will
not allow me to add columns where needed. Any suggestions would be greatly
appreciated.

Thanks in advance
--
Pam

Don Guillett

Clear the columns to the right of your last data.

--
Don Guillett
SalesAid Software

"smooth operator" wrote in
message ...
I am trying to insert a columns between different columns, but every time

I
try I get a message stating that MS Excel can't shift nonblank cells off

the
worksheet. I am not trying this, I only have 12 columns, so there should

be
plenty of room for more colums. It goes on to say to try to locate the

last
nonblank cell by pressing CTRL+END, and delete or clear all in cells

between
the last cell and the end of your data, which I have done, but it still

will
not allow me to add columns where needed. Any suggestions would be

greatly
appreciated.

Thanks in advance
--
Pam





All times are GMT +1. The time now is 04:09 PM.

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