It's easy to get lost in spreadsheets — if data fills lots of rows or columns, when you scroll down or across you lose sight of column or row headers, and then information loses its meaning.
Freeze Panes can help by letting you view column and row headings continuously, while you scroll your document. It lets you keep a row or column still, while the rest of the cells around it can scroll freely.
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.
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.