2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Spreadsheet suddenly turned all white/without any grids, rest of workbook is normal

I'm not sure what I did exactly but suddenly the spreadsheet I am working on is completely white (screenshot here). I must have lazily hit a random hot key trying to quickly toggle between sheets. The rest of the spreadsheets are normal with visible data (screenshot here - sample of new spreadsheet for privacy).

I don't think anything is erased since I can see there is data behind the white (the formula bar shows contents).

Please tell me this is fixable. I'm in the middle of itemizing 1600 lines and I really don't want to have to start over :(

Edit: gridlines are currently turned on in the view ribbon

Edit 2: I'm currently working on a Mac if that helps with hotkey suggestions.

Final Edit: SOLVED! Turns out I somehow hid the columns via hotkey. If you look at my screenshots, the row numbers on the left are visible but the column letters on the top are not.

Addendum to final edit: So I selected an entire row and then instead of hitting "CMD -", I hit "CMD 0," which will hide the selected columns.

submitted by /u/beermeupscotty
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#natural language processing for spreadsheets
#conversational data analysis
#row zero
#real-time data collaboration
#intelligent data visualization