ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why the extra rows?? (https://www.excelbanter.com/excel-discussion-misc-queries/101881-why-extra-rows.html)

Robert Brown

Why the extra rows??
 
For some reason one of my sheets is 2-3 times longer then it should be. I
tried deleting all the row past my data, removed all borders, and deleted any
possable conditional formating/formating, there could be. Why are they still
there!!

Any suggestions?

José Raphael Daher

Why the extra rows??
 
Itīs excel what you are talking about?

The blank columns canīt be delected, it means, the number os columns
still the same after deleting.

I hope this information can help.

Robert Brown escreveu:

For some reason one of my sheets is 2-3 times longer then it should be. I
tried deleting all the row past my data, removed all borders, and deleted any
possable conditional formating/formating, there could be. Why are they still
there!!

Any suggestions?



Bill Ridgeway

Why the extra rows??
 
At the risk of stating the obvious you need to delete 'spare' column as well
as rows AND save the file. Do you still have a problem?

Regards.

Bill Ridgeway
Computer Solutions

"Robert Brown" wrote in message
...
For some reason one of my sheets is 2-3 times longer then it should be. I
tried deleting all the row past my data, removed all borders, and deleted
any
possable conditional formating/formating, there could be. Why are they
still
there!!

Any suggestions?




Robert Brown

Why the extra rows??
 
Yeh i did the column thing too, I have never had a problum with this before.

Any other suggestions?

O and I deleted the "Blank columns/rows" to make sure nothing was in them by
accident, which would be the obvious first thing to do.


All times are GMT +1. The time now is 05:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com