Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
................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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Can't open workbook (in Excel 2000) | Excel Discussion (Misc queries) | |||
Why do I get a warning when I try to save an Excel 2003 workbook. | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |