Repair a corrupted workbook

1. Click File > Open.
2. Click the location and folder that contains the corrupted workbook.
3. In the Open dialog box, select the corrupted workbook.
4. Click the arrow next to the Open button, and then click Open and Repair.
5. To recover as much of the workbook data as possible, pick Repair.

How do I annotate an Excel spreadsheet?

Insert simple notes for annotation purposes

1. Right-click the cell and then click Insert Comment (or press Shift+F2). If you’re using Excel for Office 365, right-click the cell and choose New Note.
2. Type your annotation text.
3. Click outside the cell.

How do I make flashcards from an Excel spreadsheet?

Start Excel and open a new blank spreadsheet. Enter a title for the flash cards into Cell A1. Select Cell A3 by clicking on it. Hold down the mouse button and drag the mouse down to select enough cells in Column A to make all the flash cards needed.

How do I create an automated Excel spreadsheet?

How to Automate an Excel Spreadsheet

1. Open the spreadsheet where you would like the macro to run.
2. Click the “Developer” tab, then click “Record Macro.” Type a name for the macro in the “Macro name” box, then click “OK.” The macro recorder will start to record your keystrokes and mouse clicks.
3. Format the document.

Why is Excel not saving my changes?

Reason 3# Disk Space Another reason behind the Excel file won’t save changes issue can be the lack of storage space. So make sure that your disk has enough free space to save the file. Otherwise, you will receive “disk is full” or Excel file won’t save formatting changes like errors.

How do I fix formulas in Excel?

To recalculate all sheets in all open workbooks, press Ctrl + Alt + F9. If you need to recalculate only one formula on a sheet, select the formula cell, enter the editing mode either by pressing F2 or double clicking the cell, and then press the Enter key.

How do I convert text to 90 degrees in Excel?

Rotate text to a precise angle

1. Select a cell, row, column, or a range.
2. Select Home > Orientation. >
3. Under Orientation on the right side, in the Degrees box, use the up or down arrow to set the exact number of degrees that you want to rotate the selected cell text. Positive numbers rotate the text upward.

How do you make flashcards?

Let’s get into it.

1. Make Your Own Flash Cards.
2. Mix Pictures and Words.
3. Use Mnemonic Devices to Create Mental Connections.
4. Write Only One Question Per Card.
5. Break Complex Concepts Into Multiple Questions.
6. Say Your Answers Out Loud When Studying.
7. Study Your Flash Cards in Both Directions.

How do you automate a spreadsheet task?

To automate a repetitive task, you can record a macro with the Macro Recorder in Microsoft Excel. Imagine you have dates in random formats and you want to apply a single format to all of them. A macro can do that for you. You can record a macro applying the format you want, and then replay the macro whenever needed.

How do you stop Excel from prompting to save?

File > Options > Advanced, under General make sure that Ignore other applications is not ticked. Do you want to save the changes to Filename.

Why does my Excel keep crashing when I save?

Possible causes of Word crashes when saving: MS Office settings or installation problem. Third-party add-ins in Word program. Software conflicts while editing any document in Word.

How do I ignore a formula in Excel?

If the formula is not an error you can choose to ignore it:

1. Click Formulas > Error Checking.
2. Then click Ignore Error.
3. Click OK or Next to jump to the next error.

How do I stop someone from Unhiding my Excel spreadsheet?

Trick to Hide the Sheet (that’s not easy to unhide) without Protecting Workbook

1. Right Click on the sheet to Hide.
2. Click on View Code.
3. In the VBA window roll down to sheet properties.
4. In the Visible drop down choose Very Hidden.
5. This will ensure that the unhide option is greyed out when someone tries to unhide sheet in Excel.

How do you hide a formula in Excel?

Prevent a formula from displaying in the formula bar

1. Select the range of cells whose formulas you want to hide.
2. Click Home > Format > Format Cells.
3. On the Protection tab, select the Hidden check box.
4. Click OK.
5. Click Review > Protect Sheet.

Can you AutoFill functions in Excel?

Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature. Or, say you have information in Excel that isn’t formatted the way you need it to be, such as this list of names.