|Quickly Selecting a Data Range
Summary: Many times in Excel you want to quickly select a range of data. Here is a keyboard shortcut that will save you a of time.
To quickly select a data range use Ctrl+Shift+8. Using the currently selected cell as the starting point, Excel will select the contiguous cells that contain data. The selection will stop when a blank row or a blank column is reached. The active cell becomes the upper-left cell of the range.
How to Print an Excel Workbook Without Opening It
Summary: There are times when you need to print an Excel workbook without opening it. Here is an easy way to do this.
If you just want to print a copy of a worksheet you do not need to open the file. To do this follow these steps:
- Use Explorer to select the workbook that you want to print.
- Right-click on the file.
- Windows will display a Context menu.
- Select the Print option from the Context menu.
- Excel will then open and load the workbook,
- The workbook will then be closed.
Remembering Commonly Used Workbooks
Summary: When you work with the same workbook over and over again, you need a quick way to open these workbooks. Here is how to do this:
- Select the File tab of the ribbon.
- Click on Recent at the left hand side of the dialog box.
- Excel shows you a list of the most recent workbooks you've used.
- Scroll through the list of workbooks until you see the one you want to use regularly.
- Click the push-pin icon that appears to the right of the workbook in the list.
- Excel moves the workbook to the top of the file list.
- Repeat steps 3 and 4 for any other workbooks you want to pin to the list.
Now you can quickly access the workbooks that you use all the time by displaying the recent workbook list where they will always be shown at the top of the list.
Sorting a Text Selection
Summary: Many times in Word you need to rearrange a list of items. There is a sorting tool in Word that makes doing this easy. Here is how to do this:
Highlight the text that contains the list to be sorted.
- Select the Home tab of the Ribbon.
- In the Paragraph group, click on the Sort tool
- Word will display the Sort Text dialog box.
- In the Sort Type drop-down list, select the type of sorting you want Word to carry out. (For example, if you want to sort by date, you would select Date as the Sort Type).
- Using the radio buttons, indicate whether the sort should be Ascending or Descending.
- Click on OK.
Your list will now be sorted in date order.
Back to top
Summary: Here are five tips that you should follow when you are creating your presentation.
PowerPoint offers all sorts of ways to add visual "flash" to your slides: fades, swipes, flashing text, and other annoyances are all too easy to insert with a few mouse clicks. Avoid the temptation to dress up your pages with cheesy effects and focus instead on simple design basics:
- Use a sans serif font for body text. Sans serifs like Arial, Helvetica, or Calibri tend to be the easiest to read on screens.
Use decorative fonts only for slide headers, and then
only if they're easy to read. Decorative fonts -calligraphy, German blackface, futuristic, psychotic handwriting, flowers, art nouveau, etc. - are hard to read and should be reserved only for large headlines at the top of the page. Better yet, stick to a classy serif font like Georgia or Baskerville.
- Put dark text on a light background. Again, this is easiest to read. If you must use a dark background - for instance, if your company uses a standard template with a dark background - make sure your text is quite light (white, cream, light grey, or pastels) and maybe bump the font size up two or three notches.
- Align text left or right. Centered text is harder to read and looks amateurish. Line up all your text to a right-hand or left-hand baseline - it will look better and be easier to follow.
- Avoid clutter. A headline, a few bullet points, maybe an image - anything more than that and you risk losing your audience as they sort it all out.
Back to top