Add today’s date to a cell:.
CTRL + ; (Hold down the CTRL key and press the semicolon key once.)
Deleting the contents of a cell (by pressing the Delete key) does not delete formatting (although the cell appears to be blank).
When you press the delete key, Excel removes the contents and remembers the formatting.
To clear both, select Clear All in the Editing group on the Home tab.
Better yet, right-click on the Clear All button and add it to the Quick Access Toolbar:
Type — (three hyphens) and press ENTER for a straight line.
Type === (three equals signs) and press ENTER for a double line.
To turn off automatic borders:
- File Tab | Word Options | Proofing | AutoCorrect Options…
- Click the Autoformat As You Type tab.
- In the Apply as you type section, clear the Border lines checkbox.
- Double-click to select a word.
- CTRL-click to select a sentence.
- CTRL+A to select an entire document (or all the cells on a spreadsheet, or all the slides in a presentation, etc.)
- Shift-click to select a large area of text or several pages of a document.
- CTRL-click to select non-contiguous text areas.
- ALT + drag to select vertical areas of text.
Word 2013 includes a new feature that lets you collapse and expand sections of your document. If you are working on a long document, you can focus on a specific section by collapsing all the sections except the one on which you are working. You can also use this feature to entire sections within a document.
Expanding or Collapsing a Section of a Document
In order to expand or collapse a document section, you must use Word’s built-in heading styles. After applying a heading style, a small gray triangle will appear to the left of the text.
Simply click the triangle to collapse the document section. Click the triangle again to expand that part of the document.
Copy Formatting Once
To copy the formatting of a block of text and “paint” another block of text with it:
- Highlight the text whose formatting you want to copy.
- Click the Format Painter icon once.
- Your cursor will display a paintbrush.
- Highlight the text you want to “paint.”
- Word will format the text. The paintbrush icon will disappear from your cursor.
Copy Formatting to Several Blocks of Text
If you want to “paint” several blocks of text with a format, you can “stick” the Format Painter to your cursor by double-clicking it. Highlight the text whose formatting you want to copy.
- Double-click the Format Painter icon.
- Your cursor will display a paintbrush.
- Highlight the text you want to “paint.”
- Word will format the text. The paintbrush icon will remain.
- Highlight each block you want to format.
- When you are done, click the Format Painter icon again. The paintbrush will disappear from your cursor.