-
How to Have Office Tabbed Windows in Microsoft Office 2003, 2007 and 2010?
How to Have Office Tabbed Windows in Microsoft Office 2003, 2007 and 2010? If you would like the tabbed concept in Firefox or IE, it would be a pleasant gift to see the tabbed windows for Microsoft…
-
Office 2010 add-ins manager: how to enable, disable,add or remove add-ins?
Office 2010 add-ins manager: how to enable, disable,add or remove add-ins? Recently, we have been playing around Office 2010 a lot. Do you know how to add/remove office add-ins in Word, Excel and Pow…
How to Documents - Tips and information for Microsoft Office
Here we share the tips and tricks we know about Microsoft Office. It's sharing all those things that we learn and experience along the way of developing Office add-ins and using Microsoft Office.
Paragragh & Table | Insert & Clear | Hyperlink & Bookmark & Caption | File & Import & Export | Others
Paragragh
- Convert tab characters to white space in Word 2007/2010
- Replace hard returns with soft returns in Word
- Replace soft returns with hard returns in Word
- Covert equation to image in Word 2007/2010
Table
- Select all single cell, row, column tables and across page table in Word
- Select first/last rows or columns of all tables in Word
- Select all tables in Word 2007/2010
- Remove empty rows and columns from table in Word
- Insert diagonal line to table in Word
Insert
- Easily insert frame into document in Word
- Insert barcode easily in word
- Quickly insert checkbox symbol into Word document
- Save, list and insert Auto Text entries in word quickly
Clear
- Remove all breaks in Word 2007/2010
- Remove all empty paragraphs in Word 2007/2010
- Remove empty lines in Word 2007/2010
- Remove all column breaks in Word 2007/2010
- Remove all hyperlinks in Word 2007/2010
- Remove all page breaks in Word 2007/ 2010
- Remove all section breaks in Word 2007/2010
Hyperlink
- Insert, remove and list all hyperlinks of current document in Word
- Insert multiple hyperlinks to a document in Word
- List and edit all hyperlinks in Word
Bookmark
Caption
- Insert captions to all tables, figures or equations at once in Word
- Easily insert a right aligned caption next to an equation in word
- list all captions in word?
- Remove error reference source not found in word
- Update or refresh caption numbers in Word
- Select all (table, figure and equation) captions in word
- Quickly insert and center the captions for centered inline tables and figures in word
- Convert text to captions for tables, figures, equations in word
File
- Easily undo all changes in Word document
- Change and open default file location in word
- Open Auto Recover file location to recover the lost word document
- Open file location of current document in word
- Open user template location in word
Import & Export
View
- Show or hide tab characters in Word
- Show or hide formatting marks in Word
- Show or hide paragraph marks in Word
- Show or hide all hidden text quickly in Word
- Show or hide picture placeholders in Word
- Show or hide spaces in Word
- Display or hide field codes in Word document
Others
- Save document as a PDF in Word 2007/2010
- Lock parts of document in Word 2007/2010
- Encrypt documents in Word 2007/2010
- Save all documents in Word 2007/2010
- Close all open document windows in Word
- Change hyperlink color in Word 2010
- Rename word document in Microsoft Office 2003, 2007 and 2010
- Make word close all documents in Microsoft Office 2003, 2007 and 2010
- Enable word tabbed documents in Microsoft 2003, 2007 and 2010
Paragragh & Table | Insert & Clear | Hyperlink & Bookmark & Caption | File & Import & Export | Others
View|Range & Cells | Editing & Formula|Workbook & Worksheet|Others
View
Navigation Pane
Work Area Size
Toggle View Setting
- Display or hide row & column headers
- Display or hide sheet tabs
- Show or hide Horizontal/Vertical scroll bar
Show / Hide
Range and Cells
Modify
- Insert random numbers in a range
- Reverse signs of values in cells
- Change numbers in cells to text
- Change columns to rows
Text Tools
- Add text to the beginning or end of all cells
- Remove certain characters from Text String
- Remove spaces between character and numbers within cells
- Remove non numeric characters from cells
Advanced Merge
Operation
More Tips About Range and Cells...
Editing and Formula
Select
Delete/Remove
- Remove blank rows
- Delete all Pictures easily
Other
Formula
More Tips About Editing and Formula...
Workbooks and Worksheets
Workbooks and Files
- Combine multiple workbooks to single workbook
- Split a workbook to separate Excel files
- Make backup files of active workbooks
Worksheets and Sheets
Import and Export
Print
More Tips About Workbook and Worksheet...
Others
Macro
Comment
View|Range & Cells | Editing & Formula|Workbook & Worksheet|Others
-
How to Archive and Backup a folder in Outlook 2010?
How to Archive and Backup a folder in Outlook 2010? If you want to manually archive and backup a fo…
-
How to set up auto reply in outlook 2003/2007/2010?
How to set up auto reply in outlook 2003/2007/2010? Using Outlook 2003/2007: 1. Create a new me…
More articles:-
How to Archive and Backup a folder in Outlook 2010?
-
How to set up auto reply in outlook 2003/2007/2010?
-
How to Set Up the Auto Archive in Outlook 2010?
-
How to use bcc in Outlook 2007/2010?
-
Outlook 2010: How to add personal folder file?
-
Outlook 2010: How to Change default appointment reminder time?
-
Outlook 2010: How to set out of office in outlook 2010?
-
-
How to create a custom stencil in Visio 2010?
How to create a custom stencil in Visio 2010? 1. In the Shapes window, click More Shapes, and then select New Stencil. 2. In the Shapes window, right-click the new stencil and select Save As.…
-
Where is the internet cloud shape in visio 2010?
Where is the internet cloud shape in Visio 2010? If you need to use more shapes such as the cloud shape in Visio 2010, you can get them quickly from: Kutools for Excel: 120 Cool Tools and Advanced…
More articles:-
