• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel - What the?

Ichinisan

Ichinisan

Lifer
Excel finds new ways to confound me every time I use it. I hate it.

I have an Excel document with 19,510 rows. I want to copy one of the columns.

I select that column and press Ctrl+C.

I open Notepad and paste.

I have only 4,015 lines instead of 19,510.

The first and last rows of the pasted output are correct. Why is the output short by 15,495 rows?!
 
I just selected 1,000 cells from that column. My pasted output is only 516 lines.

Once again, I checked the first few rows and the last few rows, and those were all correct. This is madness!
 
OK, I found that many row numbers in the Excel document were skipped. I selected the whole document and went to Home > Format > Hide & Unhide > Unhide Rows.

The document flickered for a little bit, but the rows are still hidden!

I'm using Excel 2007. I don't know what version created the document.
 
I got the hidden rows to appear somehow. I think I had to select everything, cut, then paste back in the same place.
 
Could be a version thing. Haven't had an issue like this, but I used 2013 and don't think I have tried quite that many rows (a couple hundred is probably my highest number).

Even though xlsx srarted in 2007, I have still seen the 2010 say it couldn't understand some formatting I've done with 2013.
 
When making a selection down a single column it will stop at the first cell that is empty. Very annoying. But if you select the column header it should had gotten the entire thing. BUT, considering this is M$ then we will just say what you are experiencing is a free feature and to shut up. 🙂
 
2007 was the reason why I moved back to 2003 until 2010 came out, I had issues with some features in Office 2007, but I think an SP fixed some stuff- do you have a service pack update for it?

Using both 2013 and 2016 now with no issues so far, takes a bit getting used to the ribbons though.
 
My only gripe about the newer version is how they changed the chart tools and force you to uncheck the show the start screen in options.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top