Computer crash? Power went out during a storm? And you were in the middle of editing a budget spreadsheet and didn't get a chance to save your work? Ugh.
Microsoft Office programs (which include Word, Excel, PowerPoint) are by default set to automatically save an open file every 10 minutes. So when you re-open the program, your file should still have all the changes you have made — except for the last 10 minutes of work. (Your file may retain more recent changes if you manually saved it yourself by pressing Control+S on the keyboard.)
10 minutes between autosaves not good enough for you? Me neither. Here's how to better protect your hard work:
If you've started a spreadsheet and then realized it would make more sense to have the data organized in columns rather than rows (or rows rather than columns), you can use Excel's Transpose function to make it so.
When someone shares a document with you that's in PDF format but you need to edit it, try the free online PDFConverter. It'll convert a PDF to PowerPoint (PPT), Word (DOC) or Excel (XLS), and you don't need to download any software to use it.
Just select the type of conversion, upload your file, enter your email address, and receive an email with a link to your converted file.
In Excel, when you want to copy information into a new column, the column’s width doesn’t automatically adjust to accommodate the new data. But if you use Excel's "Paste Special" option, you can copy the source column’s width to the target column.
In Excel 2007 and 2010, Paste Special is in the Clipboard group on the Home tab. In Excel 2003, Paste Special is on the Edit menu.
You can add a comment to any cell to make your Excel spreadsheet easier to understand. This is handy any time you're sharing a spreadsheet with someone, to indicate how a complex formula works, or just to jot a note to yourself.
It's an unobtrusive way to add comments, that doesn't clutter up your spreadsheet.
Basic Excel tip: if you're looking at an Excel spreadsheet and instead of seeing numbers you're only seeing ######, it usually means the number is wider than the column . All you need to do is increase the column width in order to see the number instead.
To fix it...
1. Position your mouse pointer on the right boundary of a column heading until it turns into a double-sided arrow.