Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 10-06-2017, 08:43 PM   #1
Join Date: Oct 2017
Posts: 1
Zumba is on a distinguished road
Unhappy 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.
Zumba is offline   Reply With Quote
Old 10-06-2017, 11:27 PM   #2
Competent Performer
Join Date: May 2017
Posts: 141
ArviLaanemets is on a distinguished road

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.
ArviLaanemets is online now   Reply With Quote

column, insert column

Thread Tools
Display Modes

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

All times are GMT -7. The time now is 02:11 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft