HELP I have cells that are in the thousands but nothing is in them!

%3CLINGO-SUB%20id%3D%22lingo-sub-179834%22%20slang%3D%22en-US%22%3EHELP%20I%20have%20cells%20that%20are%20in%20the%20thousands%20but%20nothing%20is%20in%20them!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-179834%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20one%20document%20with%20about%2075%20sheets%20in.%20Each%20sheet%20has%20a%20different%20amount%20of%20data%20in%20it%20however%2C%20it%20has%20the%20same%20header%2C%20row%20%231%2C%20a%20columns%20A-I.%20Some%20of%20the%20sheets%20have%20information%20(text%2C%20numbers%2C%20balances%2C%20and%20dates)%20that%20start%20from%20Row%202%20and%20go%20no%20further%20than%2075.%20Now%2C%20if%20I%20hit%20CTRL%2BHOME%20that%20brings%20me%20to%20the%20very%20first%20cell%2C%20A1.%20When%20I%20hit%20CTRL%2BEND%20it%20brings%20me%20to%20an%20extreme%20number%2C%20such%20as%20I%2C1367%2C%20and%20NOTHING%20is%20in%20that%20cell.%20I%20have%20tried%20to%20delete%20the%20rows%20all%20the%20way%20up%20to%20where%20my%20information%20start%20and%20the%20columns%20and%20nothing.%20All%20my%20sheets%20are%20like%20this.%20Some%20are%20J%2C1459%2C%20H%2C436%2C%20L1439%20and%20so%20forth.%20I%20am%20asking%20for%20anyone%20with%20any%20help%20would%20be%20great.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EThank%20You%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-179834%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ecells%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edelete%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-179859%22%20slang%3D%22en-US%22%3ERe%3A%20HELP%20I%20have%20cells%20that%20are%20in%20the%20thousands%20but%20nothing%20is%20in%20them!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-179859%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Nicholas%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20is%20because%20of%20a%20known%20issue%20called%20(Excess%20Cell%20Formatting)!%3C%2FP%3E%0A%3CP%3EPlease%20follow%20this%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-gb%2Fhelp%2F244435%2Fhow-to-reset-the-last-cell-in-excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Elink%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fclean-excess-cell-formatting-on-a-worksheet-e744c248-6925-4e77-9d49-4874f7474738%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ethis%3C%2FA%3E%20to%20learn%20more%20about%20this%20issue%20and%20how%20to%20overcome%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have one document with about 75 sheets in. Each sheet has a different amount of data in it however, it has the same header, row #1, a columns A-I. Some of the sheets have information (text, numbers, balances, and dates) that start from Row 2 and go no further than 75. Now, if I hit CTRL+HOME that brings me to the very first cell, A1. When I hit CTRL+END it brings me to an extreme number, such as I,1367, and NOTHING is in that cell. I have tried to delete the rows all the way up to where my information start and the columns and nothing. All my sheets are like this. Some are J,1459, H,436, L1439 and so forth. I am asking for anyone with any help would be great. 


Thank You

1 Reply
Highlighted

Hi Nicholas,

 

This is because of a known issue called (Excess Cell Formatting)!

Please follow this link and this to learn more about this issue and how to overcome it.