Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
FY
 
Posts: n/a
Default 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   Report Post  
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
CLR
 
Posts: n/a
Default

................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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Can't open workbook (in Excel 2000) gcotterl Excel Discussion (Misc queries) 2 January 23rd 05 12:42 AM
Why do I get a warning when I try to save an Excel 2003 workbook. David Williams Excel Discussion (Misc queries) 0 January 11th 05 07:59 PM
can a workbook with macros created in excel 2003 work in excel 20. Steve Venti Excel Discussion (Misc queries) 2 December 27th 04 02:31 PM
Macro in Excel 2002 to save a workbook to a FTP location Lloyd Excel Discussion (Misc queries) 0 December 21st 04 02:49 PM


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"