 Finding Hidden Rows and Columns
|
Summary: When you want to print certain rows/columns of data you are most likely to hide the other rows/columns. However, when you want to unhide cells in hidden rows/columns, it can be a challenge to locate them. Here is the solution:
The solution is to select all visible cells in the worksheet. You can then easily detect the hidden rows/columns, as they will be highlighted in white. To select the visible cells on the worksheet.
-
On the Home tab, in the Editing group, select Find & Select.
- Select Go To Special.
- Under Select, click Visible cells only.
- Click OK.
All visible cells are selected and the borders of rows and columns that are adjacent to hidden rows and columns are marked with a white border.
Note: Clicking anywhere on the worksheet will cancel the selection of the visible cells. If the hidden cells that you want to unhide are outside of the visible worksheet area, use the scroll bars to move through the document until the hidden rows and colum
ns that contain those cells are visible.
|
Rounding to the Nearest Half Dollar
|
Summary: There are times when you need to round amounts to the nearest half dollar. Here is an easy way to do this:
For this task you can use Excel's =MROUND function. This function will round a value to any multiple you specify. In this case, if you want to round the value in B10 to the nearest half dollar, you would use this formula:
=MROUND(B10,0.5)
The 0.5 in the formula tells it to round it to the nearest half dollar. By changing this figure you can round to any multiple you want.
|
Summary:
It is easy to Hide and Unhide columns in Excel. The exception is when you hide Column A. If you later want to unhide Columns A, the solution is challenging. Last month I gave you one solution. Here is another way to do
this:
This method is even quicker, but you will have to have a good eye and a steady hand on your mouse pointer to make it work.
- If you move your mouse pointer into the column header area, and then slowly move it to the left, it will turn into a double-headed arrow with a blank spot in the middle, as you place your cursor over the small area immediately to the left of the column B header.
- This double-headed arrow is like the double-headed arrow that appears when you position your cursor over the dividing line between column headers. You will now see that there are two black lines with a gap between them.
- When your cursor changes to this special double-headed arrow, right-click and select Unhide.
Your previously missing column A now reappears.
|
|
Indenting an Entire Paragraph
Summary: It is quite easy to indent a whole paragraph to the next tab stop. Here is how to do this:
To indent a paragraph to the next tab stop, follow these steps:
- Place your cursor in the paragraph that you want to indent.
- Click on Home tab of the ribbon.
- Click on the Increase Indent tool, in the Paragraph group.
|
|
Summary: Using the Control key in PowerPoint gives you access to some powerful short cuts. Here's how to use it save yourself a lot of time when you are formatting a slide.
- Hold down the CTRL key while clicking the slide show view button when you are editing a slide show. This will open a preview window so you can see that slide in slide show mode.
- Hold down the CTRL key while dragging an existing Guide to create a new guide.
- Hold down the CTRL key while turning the wheel on your mouse to zoom in and out of the slide
- Hold down the CTRL key, plus the HOME key to go to the first slide
- Hold down the CTRL key, plus the END key to go to the last slide in your presentation
- CTRL + A (on the Slides tab) to select all objects
- CTRL + A (in slide sorter view) to select all slides
- CTRL + A (on the Outline tab) to select all text in your slide show
- CTRL + B to apply bold formatting
- CTRL + C to copy the selected object
- CTRL + D to duplicate (make a copy of) the selected slide
- CTRL + E to center a paragraph
- CTRL + F to find text
- CTRL + G to open the grids and guidelines dialog box
- CTRL + H to replace text
- CTRL + I to apply italic formatting
- CTRL + J to justify a paragraph (full alignment)
- CTRL + K to insert a hyperlink
- CTRL + L to left align a paragraph
- CTRL + M to insert a new slide
- CTRL + N to create a new presentation
- CTRL + O to open an existing presentation
- CTRL + P to print a presentation
- CTRL + Q to quit PowerPoint
- CTRL + R to right align a paragraph
- CTRL + S to save a presentation
- CTRL + T to change the formatting of characters between sentences, lowercase, and uppercase
- CTRL + U to apply underline formatting
- CTRL + V to paste a cut or copied object
- CTRL + W to close a presentation
- CTRL + X to cut a selected objected
- CTRL + Y to redo or repeat an action
- CTRL + Z to undo the last action
Back to top |
