Grey field appears below of the window when using filters
Hi All,
Could anyone help me with the issue on my excel worksheet?
Grey field appears on the bottom of spreadsheet when filtering a massive excel file. It look like that lines just gone somewhere. File is linked with other file including formulas.
Screenshot attached.
Please help!!
Thank you
Last edited by loretuute; 06-15-2019 at 10:57 AM.
Welcome to the forum!
No screenshot ... But a sample workbook would be better.
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi there,
Thank you so much for the quick response.
I managed to save a screenshot from my Excel workbook.
Thank you!
No idea, sorry! I asked you to attach the workbook ...
Maybe the rows are hidden.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
This can occur if you have data at or close to the maximum row that Excel can handle (row 1,048,576). See the attached picture below.
lastRow.png
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
Looks like all the rows below that are either hidden, or the row height has been changed to a very small value.
Select all the cells on the sheet, right-click one of the row numbers & set row height= 12
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks