There’s a file missing from my backup
QWhen I deleted a column in an important Numbers spreadsheet by mistake, I went to Time Machine to find a backup. I stepped back a month to when I know it was last correct, but couldn’t find the file there. More recently it has been saved to iCloud, but I can’t find any older versions there. How can I get my old version of the spreadsheet back? by An d y Ca r l t o n
AIn Numbers, open the copy of the document that’s now stored in iCloud, then choose File > Revert To > Browse All Versions – and don’t worry; the objective here isn’t to roll back the whole document to an older version.
The app‘s interface will switch to a Time Machine-like interface, with the document’s current version on the left and previous ones on the right. You should find that when you moved the document to iCloud, its version history was carried over, too; go back through the versions on the right to the time when the column would have been in the document. Click the window on the right side to take a closer look at its contents. If you can find a version that contains the now-absent column, interact with Numbers’ window here just as you would on the desktop; click the table, then click the header of the column you want and press to copy it to the Clipboard. Next, click the window for the current version, add a new column – without the menu bar available, you can do this by selecting another column and pressing to add one to the right of it – then select the new column and press to paste the Clipboard’s contents over it.