When you create a new Excel file, it contains three worksheets — they show as small tabs at the bottom of a worksheet. Each tab has a name, like Sheet1, Sheet2, an so on. You can see the data stored on each worksheet by clicking the tab of the sheet you want to view.
Renaming a worksheet or changing the color of the worksheet's color makes it easier to organize and keep track of the data you've created.
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 ever struggled to get Microsoft Word to position important text exactly where you want it, try creating a Text Box.
A text box is a special type of shape designed to place text in your Word 2007 document without regard to the normal page margins. A text box gives you the flexibility to add text wherever you want it.
Add a text box...
To position and align text exactly where you want it to be
In margins to highlight key points
Above or below images to create a caption
To create a "pull quote" (a floating text box that highlights a quote from the document) or a sidebar (a block of supplementary material)
A text box is easy to insert, and with Microsoft Word's built-in text box styles and templates they're a breeze to create & customize. Or if you want more control, you can creating your own text box from scratch.
To learn how to insert a text box and how to format it in various ways — including resizing & moving it, and changing the text box shape, color, and outline — use these instructions: