calimac: (Default)
[personal profile] calimac
I was editing a (rather large) Excel spreadsheet, when all of a sudden, little pull-down menu tabs appeared next to all the column headers. I had never seen this before. Like a lot of weird things that Excel does, it probably appeared when I accidentally hit some key that I wouldn't be able to find afterwards.

I tried to make the tabs go away. Nothing I tried worked. So then I thought, OK, I'll close the file and reopen it. I closed the file, saving it on close (because I had a lot of unsaved data I'd just entered), but when I reopened it, the spreadsheet was gone. The file was there, but there was nothing in it, not even a blank form. (And the size of the file, as listed in Windows Explorer, confirmed this.)

Needless to say, I can't recover it: most recover functions work only for unsaved data, and the instructions for other recover functions all refer to commands grayed out on this file.

What the heck happened?

Date: 2019-09-19 11:13 pm (UTC)
wild_patience: (Default)
From: [personal profile] wild_patience
I have that happen at work sometimes. I haven't had a problem recovering. I think I hit the escape key or something to get out of it. I think I get into it by accidentally hitting an unknown (to me) hot key - CTRL - something.

Filters

Date: 2019-09-20 01:29 am (UTC)
lsanderson: (Default)
From: [personal profile] lsanderson
Column filters look like that, but they should not do what you ended up with. "Ctrl+Shift+L is the keyboard shortcut to turn the filters on/off." (I am not an Excel guru.)

Profile

calimac: (Default)
calimac

July 2025

S M T W T F S
  12 3 4 5
6 7 89 1011 12
13 14 151617 1819
20 21 22 23 242526
27 28293031  

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 29th, 2025 03:42 am
Powered by Dreamwidth Studios