 How to Move the Quick Access Toolbar
|
Summary: The Quick Access Toolbar normally appears at the top of your screen above the Ribbon. I prefer to display it below the Ribbon. Here is how to do this:
- Right click over the Quick Access Toolbar
- Select Show Quick Access Toolbar Below the Ribbon
Your Quick Access Toolbar will now appear below the Ribbon.
|
Deleting Hyperlinks in an Excel Workbook
|
Summary: There are times when you need to delete one or more hyperlinks from an Excel workbook. Here is how to do this:
- Select the cell containing the first hyperlink that you want to remove
- Press Ctrl+K
- In the Edit Hyperlink dialog box click on Remove Link
Repeat the process if you need to delete another hyperlink.
|
Back to top
Summary: There are times when you only want to copy the visible cells in a worksheet. This is usually the case when you have hidden rows in the range and you don't want to copy the hidden data. Here is how to do this:
To just copy and paste the visible cells in a range do the following.
- Select the range of cells
- Click on the Home tab in the Ribbon
- In the Editing group click on Find & Select
- Select Go To Special
- Under Select, select Visible Cells Only
- Click on OK
- Click on the Home tab in the Ribbon
- In the Clipboard group select Copy
- Position your cursor in the cell in the worksheet in which you want to paste the visible data
- Select Paste
Only the visible data will be pasted into the worksheet.
|
|
Deleting Tab Stops
Summary: There is no keyboard shortcut to remove tab stops. You must use the Tabs dialog box to remove them. Here is how to do this:keyboard.
- Press Ctrl+A. This action selects the entire current document.
- Click on the Home tab of the Ribbon.
- Click on the small icon at the bottom-right of the Paragraph group and Word will display the Paragraph dialog box.
- Click on the Tabs button at the bottom-left of the dialog box and Word will display the Tabs dialog box.
- Click the Clear All button.
- Click OK.
All of your tabs in the document will be deleted.
|
