![]() Luckily, Microsoft has made it fairly straightforward to recover an Excel file, whether it has never been saved at all or you just need to find a previous version of a saved spreadsheet. If you’re working between multiple workbooks, it’s also an easy mistake to overwrite lots of critical data in a spreadsheet. It can be a stressful moment when you realise that you’ve lost an important Excel file or a spreadsheet that you’ve spent a lot of time on. ![]() This will open up a window where you can enter your OneDrive login credentials before redirecting you back to Excel to choose a folder, name your document, and save it to OneDrive. Name your document in the File Name field before hitting Save.Īlternatively, you can save the file to OneDrive by selecting OneDrive instead of This PC. When the file explorer opens up, use the left panel to select the location or folder where your file should be stored. If pressing the F4 key alone doesnt work, you may need to press it together with the 'fn' key. Alternatively, on Windows, you can press the 'F4' key to redo an action. Finally, click OK to close the Excel Options dialog and apply the changes youve just made. Select the newly created group and click Add. In the list of commands, scroll down to Clear Formats, and select it. This shortcut key will instantly undo a sort and revert back the data to its original state. Under Choose commands from, select All Commands. Just press CTRL + Z immediately after sorting your data. ![]() To save the file to your desktop, click File at the top of your Excel toolbar, then click and Save As before selecting This PC. To redo an action using a keyboard shortcut, press 'Ctrl+Y' on Windows or 'Command+Y' on Mac. One quick way to sort your data in Excel is by using the Sort command from the DATA tab. Once you have recovered your lost Excel file, it’s a good idea to immediately save the file to your desktop or to OneDrive to avoid this scenario happening again. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |