#1
|
|||
|
|||
not able to insert a column
Every time I hit Insert a column anywhere on the xls sheet I get the following message: "Microsoft can't insert new cells because it would push non-empty cells off the end of the worksheet. This cells might appear empty, but they blank values, some formatting or a formula. Delete enough rows or columns to make room for what you want to insert and then try again". The problem is that I've only used 8 columns, I have not use all the columns available on the xls sheet. I'm trying to insert a column between column A and column B, where A has names and B has dollar values not formulas on either.
|
#2
|
|||
|
|||
Obviously you have accidently moved to last column of worksheet sometime, and pressed some key there (p.e. space).
Select all columns right at your table, and delete them, or Press Ctrl+End, select the last highlighted column, hold down Shift and scroll back until your table, select the first empty column, delete selected columns. |
Tags |
column, insert column |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Insert Table To Multi Column Page | mertdogan | Word Tables | 2 | 08-03-2017 03:46 PM |
insert Date picker after adding a new column | PeterDC | Word | 0 | 12-10-2015 03:40 AM |
How to automatically insert a line after a Column Break | YooperNC | Word | 3 | 01-29-2015 07:16 AM |
Insert values from multiple rows based on value in one column | pachmarhi | Excel | 3 | 07-18-2014 09:57 PM |
How to insert ne wline within a column | kesh | Excel | 2 | 12-09-2011 09:38 AM |