Can't Insert Column In Excel

The system returned: (22) Invalid argument The remote host or network may be down. You're awsome! Thank you for this - it worked with Excel for MAC 2011 and made sense! Now you should be able to add columns and rows to you heart's content.

Even rows that 'appear' blank may not actually be blank. Cannot Insert Row In Excel 2013 Or, you can move the data to a new location and try again." I've "unfreeze", "unhide" and copying to a new spreadsheet. Loading... Join Now For immediate help use Live now!

Excel Can't Insert New Cells Because It Would Push Non-empty Cells Off The End Of The Worksheet

All rights reserved. my review here Go to the far right column + 1 of the data in your worksheet, hold down your shift key and hit the end key then the right arrow key. No, create an account now. Prevent the possible loss of data in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.Expert: Edward RussellFilmmaker: Microsoft Excel Can't Insert New Cells Because It Would Push Non-empty Cells

Loved the shortcut Reply shubham says: June 19, 2014 at 11:49 am Perfect solution man....its works on 2013 aswell.. Join our site today to ask your question. i was struggling for a long time. http://trado.org/in-excel/cannot-shift-nonblank-cells-off-sheet.php To resolve, highlight the row just below what you percieve as your last used row on the sheet.

Sometimes, it happens to a file on a network server or sometimes to the files on my PC. Unable To Insert Row In Excel 2013 Share it with others Like this thread? Scratch that, you are a "wizard!" This solution worked for me in Excel 2016.

When it came back up, I could insert.

It worked 🙂 Thanks very much. Sign in to add this video to a playlist. Reply Johann says: September 6, 2012 at 7:05 am Very informative tip. Cannot Insert Row In Excel 2010 Skip navigation UploadSign inSearch Loading...

I tried the following before searching on the internet. Reply Marian Lokken says: August 31, 2016 at 5:05 pm Thank you Dan! Reply Diana says: January 30, 2015 at 10:38 am Many thanks - so very helpful.... navigate to this website Reply karthik says: October 30, 2015 at 1:49 am Thanks for the solution.

Works in Excel 2k10. I only use Powerpoint in non-compatibility mode but there are scrolling bugs there which can't be fixed at all. –user21820 Jan 27 '15 at 12:15 add a comment| 3 Answers 3 Thanks very much for the help. Solved to prevent possible loss of data, excel cannot shift nonblank cells off the worksheet.

Type out your initial … MS Word MS Office Advertise Here 780 members asked questions and received personalized solutions in the past 7 days. Thanks. In particular, the key for me was: "...you'll need to save your spreadsheet and, in true Microsoft style, close it and open it up again". Loading...