FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Excel question





Klaw 2
I have an excel file that had 8000 rows with data this has been reduced now to 4000 rows however when I use the side bar to scroll down it stil "thinks" that the 8000th cell has data in it. deleting the cells themselves doesnt work either how do I make those cells truly empty? So that when i use the sidebar it wont go further than the last cell with data in it?
Pande
This link should help you:

http://www.extendoffice.com/documents/excel/525-excel-remove-blank-rows.html

The main difference is deleting a row only deletes it's contents, you need to actually remove the row.
Klaw 2
the first option only removes blanks it doesnt further delete/remove the rows themselves i cant get the script to run and im not going to install the program (im working on a pc from my work)
surely theres an option in excel wich does that?
likeabreeze
Select one of the not-wanted blank cells in your table, and press ctrl+A,scroll all the way down to the bottom,move your mouse to the bottom border of the selection area,you will notice the mouse cursor has changed into a line with two arrows,now,left-click and hold it,move your mouse all the way up to the last row of your data(i.e. 4000th row,in your case),release the left-click,you get it cut into 4000 rows!
ocalhoun
You'll also need to remove any formatting changes you've made to the bottom rows.
Klaw 2
@likeabreeze,
You mean just collaps those rows? Make their height zero? I already knew that but later on I might add more data then i have to uncolapse them... isnt there a normal ption to get this done?
manfer
If you want to delete rows totally you select the rows (one column of the row is enough) then you right click with your mouse somewhere over the selected rows and on the contextual menu that appears you left click on Delete... That opens a window with four options where you choose the option that says "Entire row" and you click OK. (amount other ways)

The scrolling means absolutelly nothing. If the print view shows just the rows with data then the spreadsheet is correctly updated.

If you don't like the scrolling just save the file, close and reopen and it should be updated too.

When coding in VB then after deleting the rows you have to use ActiveSheet.UsedRange
zimmer
Klaw 2 wrote:
I have an excel file that had 8000 rows with data this has been reduced now to 4000 rows however when I use the side bar to scroll down it stil "thinks" that the 8000th cell has data in it. deleting the cells themselves doesnt work either how do I make those cells truly empty? So that when i use the sidebar it wont go further than the last cell with data in it?


I admit i am not good with excel.. lol.

but i have heard that Microsoft offers certification on excel and once you have certificate you have a lot and advantage in searching works with excel certification.

Take note that the excel certification has exam via online in Microsoft and it is expensive. lol. nice business strategy by bill gates.
Related topics
I Have a question . Is it the server support Chinese?
Question before requesting free hosting
question abt posts/mth
Kinda dumb question regarding DNS
A question
UT2004 U like the game? Do u have any question post here.
Question about DNS!
Question about Domain!
another uni.cc question
Question
Working with Excel, PHP & MySQL. Any Ideas
Autoconvert cells in Excel question
Excel question
Where to write VBA in Excel?
Reply to topic    Frihost Forum Index -> Computers -> Software

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.