Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-06-2017, 08:43 PM
Zumba Zumba is offline Windows 10 Office 2010 64bit
Novice
 
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.
Reply With Quote
  #2  
Old 10-06-2017, 11:27 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Advanced Beginner
 
Join Date: May 2017
Posts: 60
ArviLaanemets is on a distinguished road
Default

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.
Reply With Quote
Reply

Tags
column, insert column
Please reply to this thread with any new information or opinions.

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 06:19 PM.


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