number of rows #2

I used autoformat so that my rows would alternate colors. But, it added a 
bunch of empty rows so that the sheet is maxed out and my file is huge.  I 
don't need all those empty rows and I can't find a way to delete them. Any 
suggestions for how to get rid of the rows, or limit the number of rows on a 
worksheet?

I know I could copy all the data to a new worksheet, but I'd like a better 
solution.
0
Larson (4)
9/15/2004 5:09:05 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
899 Views

Similar Articles

[PageSpeed] 29

Try this: click on the number of the first empty row, so the whole row is
selected. Using the vertical scrollbar, go to the last row on the sheet.
Hold down the shift key while you click on this row's number. You should now
have selected all the empty rows.

Then press Ctrl and - (the minus sign on the numeric keypad). This should
delete all the formatted rows and replace them with unformatted rows.

"G Larson" <G Larson@discussions.microsoft.com> wrote in message
news:E116C704-C789-4881-8889-D962208CB406@microsoft.com...
> I used autoformat so that my rows would alternate colors. But, it added a
> bunch of empty rows so that the sheet is maxed out and my file is huge.  I
> don't need all those empty rows and I can't find a way to delete them. Any
> suggestions for how to get rid of the rows, or limit the number of rows on
a
> worksheet?
>
> I know I could copy all the data to a new worksheet, but I'd like a better
> solution.


0
roneville (91)
9/15/2004 5:17:04 PM
You will always have 65536 rows and 256 columns.

These cannot be deleted.

You could hide what you don't want, but they will still be there.

You can limit the Scroll Area using VBA.

Gord Dibben Excel MVP

On Wed, 15 Sep 2004 11:19:04 -0700, "G Larson"
<GLarson@discussions.microsoft.com> wrote:

>That did allow me to unformat the empty rows, but is there anyway to delete 
>them entirely. My file is only 79 rows, but I have 65536 rows the the 
>worksheet. Any more suggestions.
>
>"Richard O. Neville" wrote:
>
>> Try this: click on the number of the first empty row, so the whole row is
>> selected. Using the vertical scrollbar, go to the last row on the sheet.
>> Hold down the shift key while you click on this row's number. You should now
>> have selected all the empty rows.
>> 
>> Then press Ctrl and - (the minus sign on the numeric keypad). This should
>> delete all the formatted rows and replace them with unformatted rows.
>> 
>> "G Larson" <G Larson@discussions.microsoft.com> wrote in message
>> news:E116C704-C789-4881-8889-D962208CB406@microsoft.com...
>> > I used autoformat so that my rows would alternate colors. But, it added a
>> > bunch of empty rows so that the sheet is maxed out and my file is huge.  I
>> > don't need all those empty rows and I can't find a way to delete them. Any
>> > suggestions for how to get rid of the rows, or limit the number of rows on
>> a
>> > worksheet?
>> >
>> > I know I could copy all the data to a new worksheet, but I'd like a better
>> > solution.
>> 
>> 
>> 

0
Gord
9/15/2004 9:47:25 PM
Reply:

Similar Artilces:

Microsoft Outlook has encountered a problem and needs to close #2
After installing Microsoft service pack (sp2) and while opening Outlooks 2000 (Office 2000);I recieved this error message, "Microsoft Outlook has encountered a problem and needs to close." Can anyone offer a suggestion to fix this problem? >-----Original Message----- >After installing Microsoft service pack (sp2) and while >opening Outlooks 2000 (Office 2000);I recieved this error >message, "Microsoft Outlook has encountered a problem and >needs to close." > >Can anyone offer a suggestion to fix this problem? >. > i have the same pro...

Numbering
Can I enter numbers in a cross functional flowchart? On Mon, 24 Aug 2009 12:07:02 -0700, carosaam <carosaam@discussions.microsoft.com> wrote: >Can I enter numbers in a cross functional flowchart? Yes. Do you mean for the process names or function names? Yes. -- Regards, Paul Herber, Sandrila Ltd. Electronics for Visio http://www.electronics.sandrila.co.uk/ Electrical for Visio http://www.electrical.sandrila.co.uk/ Electronics Packages for Visio http://www.electronics-packages.sandrila.co.uk/ ...

Newbie questions #2
Hi everyone, My company is in the process of converting over from Quattro Pro to Excel, so I have a few newbie questions. 1. How do I set a default footer that is printed with every page of a spreadsheet? I want to have the path and filename, tab name, and date at the bottom of each page of a printout. I know how to set them for a particular spreadsheet, but how do I set it up so it is automatically included with every new spreadsheet? 2. How do I set the default page setup so that the scaling is always "print to 1 page wide by 1 page tall", and margins are all 0.5inches al...

Adding a row to a protected table
Graham Mayor provides a macro that is extremely helpful to me in a project I am working on entitled: "An alternative method of adding a row to a protected table " (http://www.gmayor.com/word_vba_examples.htm). What I am having trouble with is identifying the number of the table. I have a lengthy document and over time some tables have been added or deleted, and I am suspecting that I my table numbers are 'out-there.' I have a commandbutton running the above macro and if I tested the macro to add rows to tables 1-4 and it works fine. However, I cannot seem t...

Replying #2
When replying to an email the normal setting is for the reply text to be blue and for my name to appear, however, recently this has changed and my name does not appear and the reply text is black. I have checked the settings and the reply font is stated as blue and the setting indicates that my name should be displayed. Any ideas Are you sure you're not replying to a Plain Text message? -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -What do the Outlook Icons Mean? -Create an Office 2003 CD slipstreamed with Service Pack 1 ----- "Tom Cullen"...

How do I expand the number of characters in Access comment box?
I am using Access 2007 and want to be able to include more than 250 characters in a "Comment" box. Hi, You could try changing your table's field type to Memo. Assuming that your are talking about a field in a table, that maybe shows on a form. If that is not the case, please describe precisely what comment box your are attempting to use. Clifford Bass Pearlene wrote: >I am using Access 2007 and want to be able to include more than 250 >characters in a "Comment" box. -- Message posted via http://www.accessmonster.com ...

Raffle tickets #2
I have just purchased Publisher 2003, thinking that I would be able to do raffle tickets, with stub, for drawing and automatic sequential numbering system with same number on stub and ticket itself. If Pub 2003 can do it, it doesn't tell me. Iwould have thought with the new version, it would have been easy. http://www.mvps.org/publisher/section_05.html#How%20do%20I%20use%20consecutive%20numbering -- Mary Sauer MS MVP http://office.microsoft.com/ http://www.mvps.org/msauer/ news://msnews.microsoft.com "Joni" <joanhinsch@dodo.com.au> wrote in message news:DEDA14CE-D8D2-4B9...

negative number to positive number
How can I change a negative number to positive number Multiply by -1 or use the ABS() function. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "fgiord" <fgiord@discussions.microsoft.com> wrote in message news:62C2A6DA-7AC2-4379-AEFC-B3D6F3698E58@microsoft.com... > How can I change a negative number to positive number =ABS(##) or mult it by -1 -- Regards Rob "fgiord" <fgiord@discussions.microsoft.com> wrote in message news:62C2A6DA-7AC2-4379-AEFC-B3D6F3698E58@microsoft.com... > How can I chan...

Hide page numbers for mutliple discontiquous levels
Hi: I need to hide the page numbers for levels 1 and 7 in my TOC. I used the \n switch to hide level 1, but cannot find a way to specify multiple ranges for this switch. Is there a way to do this? I am using Word 2003. Phil You have to use a trick. See the "Omitting page numbers for noncontiguous levels" section of http://sbarnhill.mvps.org/WordFAQs/TOCTips.htm#OmitPageNumbers -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Phillip Llacuna" <phillip.v.llacuna@lmco.com> wrote in me...

Running UserForm1 routines from UserForm 2
Hi, I have 2 userforms. Userform1 works great and now I'm creating userform2. In userform 2 I'd like to call a couple of the routines from Userform1. Is this possible? and if yes, how should I approach it. Thanks Chuck By default, userform subroutines are private, which I think means that they cannot be called from outside that userform module. However, you can rename the Userform subroutines from "Private" to "Public". (Not sure if this is a good idea or not) Once the userform subroutine is "Public", you can simply call any use...

Need a formula for multiple sums in a cloumn when rows vary
I am making a invoice I need a total for each truck, with a grand total at the end. The number of rows for each truck in the amount column will vary. Is it possible to have the text truck total to the left of the total? A small example below, there will be more entries under each truck and more trucks also. tr# date hrs rate amount 3 4/12/10 10 50 500 4/13/10 5 50 250 truck 3 total 750 4 4/10/10 1 50 50 truck 4 total 50 and so on ...

1-52 pages, 8,000 employee numbers
Dear Excel, I have the ultimate challenge: to do job books for 8,000 employees. The form is completed, but the request is to make booklets of 52 pages for each employee. Each page of the booklet must also have each employee's number on it (0001 to 8000). Each page o fthe booklet must be numbered with the week number from 01 to 52. Therefore I need to auto generate 416,000 pages. Ridiculous I know but nobody listens to us! How can I export the above scenario to PDF from Excel? Thanks On Apr 19, 2:17=A0pm, gatecrasherg13 gatecrasherg13 <gatecrasher...@gmail.com> wr...

Sequential numbering in Number field
When I am entering transactions manually, I will put "Debit" or "VISA" to indicate how the withdrawl was made. When I download my account information, Money05 overwrites this with a sequential number. I have to go into the entry a second time to redo my change. Does anyone know how to turn this "feature" off? I want my values used - sequential numbering does not help me in the slightest. This is not a "feature" you can turn off. It's a reflection of the basic premise of downloaded transaction data. The presumption with downloading data...

Data Export #2
Hi, We are using MS CRM 3.0 and are migrating to NetSuite. I am not a CRM expert but is there a way to export all data ( I can already do the excel export for names/contacts/accounts) including attachments and information from the notes tab? So when you open up a contact and click on the Notes tab I want to be able to export all of that information and then import it into netsuite. I have looked online for solutions but haven't come across anything as of yet. any information you can provide would be help and yes i do realize i am asking a ms forum to help me migrate to a non-ms product...

Number of Cells in a column
Hi, I want to add this formula in my ESS. COUNTIF(sheet1!S2:S43,"*Yes*") to find out the number of value containing "YES". My concern is I don't have fixed count from S2 to S43. It could be something else. What can I do to have this code reusable? I thought something like COUNTIF(Sheet!S2:Count($S2),"*Yes*") \But it doesnt work Thanks for your help Jack Try this if there is nothing else in that column:- =COUNTIF(sheet1!S:S,"*Yes*") -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - ...

Delivery Status Notification (Delay) #2
Hi, I have Exchange 2003. There are some remote user (using POP3)got messages like below from postmaster when sending email: This is an automatically generated Delivery Status Notification. THIS IS A WARNING MESSAGE ONLY. YOU DO NOT NEED TO RESEND YOUR MESSAGE. Delivery to the following recipients has been delayed. xxxx@xxx.com Internal user (useing corporate/workgroup mode in Outlook) has no problem. No problem from OWA. The remote POP3 user is submitting the message over an authenticated SMTP connection. We don't allow unauthenticated email to be routed through our se...

General Number Format Changed
Excel 2003 on XP I have a collegue who's Excel setting for General number format displays as 0.1 instead of 1 in the sample box. ie if you type in "1" you get "0.1", if you type in ".1" (as in 0.1) you get "1". Where in the settings can this General format be returned to standard? Many thanks DeanH Sorry that should have been: ie if you type in "1" you get "0.1", if you type in "1." (as in 1.0) you get "1". "DeanH" wrote: > Excel 2003 on XP > I have a collegue who's Excel setting for G...

How to define cells so that only numbers can be filled?
Hi, How could I format cells in excel so that only numbers can be filled The input should be integer e.g. between 0...99 and cells shoud no accept any other marks, such as space, letters... simply nothing els but integers. Thanks -- Message posted from http://www.ExcelForum.com Hi Juha! Try: Data > Validation You'll find it pretty intuitive and very flexible as to what you can do as far a restricting input to a cell. -- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Excel and Word Function Lists (Classifications, Syntax and Arguments) available fre...

Conditional Macro #2
I want the workbook to print using a macro (using a form button), only if a referenced cell has a value (text). In this case it would be the cell referenced by ** ActiveCell.FormulaR1C1 = "=R[29]C[1]" Sub PRINT11() ' ' PRINT11 Macro ' Macro recorded 5/26/2009 by Larry ' ' Range("K16:M18").Select Selection.ClearContents ActiveCell.FormulaR1C1 = "=R[29]C[1]" Range("K19:M20").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Range("M45:M46").Select With Selection.Font ...

Is there a Publisher (otemplate for DVD Case Inserts (10.75" x 7.2
I need to create a DVD Case Insert approx 10.75" x 7.2"(video store case size). I cannot find a template. Could anyone suggest where I could find a template? Thank you. -- ScottW Might try www.neato.com, they have downloadable templates. If you know the measurements it should be fairly easy to make your own template. Try here too. http://office.microsoft.com/en-us/results.aspx?Scope=TC&Query=dvd -- Mary Sauer MS MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "ScottW" <ScottW@discussions.microsoft.com> wrote in messag...

Copy rows of data to another worksheet where ReturnDate is blank
I'm sure this is do-able within Excel but what formula I should use to accomplish it escapes me. Basically, I'm working with a spreadsheet which lists books checked out from our Resource Center. When the books are returned, the Return Date is entered in column D. I want to run a report showing everyone who has outstanding books without having to go through the spreadsheet, row-by-row, to copy the data to the worksheet "Outstanding." Thanks for your help! Try AutoFilter - Select Row 1, go to Data, Filter, AutoFilter. An arrow will appear at each cell in that row....

Dexterity Training #2
Hi all, I want to know if there's any Dexterity development training for GP 9.0 available in Mexico or USA. Thanks Yes! Contact Integrated Business Group in Orlando, Florida. They have a wonderful Dex trainer. I am not sure of the class schedule. Their web is http://www.IBGNET.com and the phone is 407-677-0370. Ask for Roxanne and tell her I said call. Richard L. Whaley "Plecuss" wrote: > Hi all, > > I want to know if there's any Dexterity development training for GP 9.0 > available in Mexico or USA. > > Thanks ...

Numbering, revisited
While there are already a lot of posts about numbering, I haven't been able to find the solutions for my specific quandry... [BTW, I'm posting this under "General" even though ultimately I'd like to make macros to support the answer -- since a manual solution needs to be the first step! :) ] Background: My workgroup is preparing to migrate to Word 2007 very soon. We create/maintain hundreds of large procedure manuals, each containing multiple chapters (sometimes up to 40-50 per manual). Each chapter consists of steps, using multi-level numbered lists...

Formula error #2
I am trying to create a simple formula to grab the text from a cell in another worksheet (same workbook). Instead of getting the text, the following is displayed (which is the text of my formula, not the text in the cell it should be reading): ='amen shell'!c1 What am I doing wrong?? Thanks! Your cell was probably formatted as Text when you entered your formula. Change the format to General, click in the cell to edit, then hit Enter. In article <43B3041F-CBAE-408F-AE25-FDD8323FE625@microsoft.com>, Ashley <anonymous@discussions.microsoft.com> wrote: > I am trying t...

Limit number of characters in a cell
Hi, Is there a way to limit the number of characters that a user can key into a cell. I want to get a list of names and addresses imputted by user, but I don't want them to be more than 35 characters. Thanks for the help Dr. Senji Take a look at Data|Validation. You can have excel yell at the user when they hit enter after typing in a too-long string. Dr Senji wrote: > > Hi, > > Is there a way to limit the number of characters that a user can key into a > cell. > > I want to get a list of names and addresses imputted by user, but I don't > want the...