![]() |
excel workbook
I want to know why there are
blank lines after the 1300 lines I imported? I want the spreadsheet to just cut off at , lets say, 1310 lines. How would that be accomplished? I would also like the just have cells A thru H and no cells to the right of that. How can that be done? |
Hi
you can't delete these rows/columns. What you could do is hide them (Format - Rows/Columns - Hide) -- Regards Frank Kabel Frankfurt, Germany FY wrote: I want to know why there are blank lines after the 1300 lines I imported? I want the spreadsheet to just cut off at , lets say, 1310 lines. How would that be accomplished? I would also like the just have cells A thru H and no cells to the right of that. How can that be done? |
................or color them, white or gray or whatever...........
Right-click Format Cells Patterns tab.......pick a color Vaya con Dios, Chuck, CABGx3 "Frank Kabel" wrote in message ... Hi you can't delete these rows/columns. What you could do is hide them (Format - Rows/Columns - Hide) -- Regards Frank Kabel Frankfurt, Germany FY wrote: I want to know why there are blank lines after the 1300 lines I imported? I want the spreadsheet to just cut off at , lets say, 1310 lines. How would that be accomplished? I would also like the just have cells A thru H and no cells to the right of that. How can that be done? |
All times are GMT +1. The time now is 11:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com