ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   excel workbook (https://www.excelbanter.com/new-users-excel/4674-excel-workbook.html)

FY

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?



Frank Kabel

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?




CLR

................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