Microsoft Excel
DOUBLE-CLICKING TO WIDEN COLUMNS
DOESN'T ALWAYS WORK
Normally, in order to widen a column, Excel allows you to double-click on the divider bar between the column heads.
For example, say you want to widen column D. Then all you need do is to position the mouse cursor on the divider between the column D and column E column headers when the mouse pointer will change to a double-headed arrow. Double-click and column D is widened to be wide enough to accept the widest information in its cells.
If you want to widen adjacent columns, then highlight them all and use what has been previously described. All of the highlighted columns will be widened to accomodate the widest information in their cells.
However, sometimes there are times when this method won't work.
Naturally, Excel won't widen a column using this method if the worksheet is protected.
-
If the column is formatted using the “Wrap Text” attribute, double-clicking will not widen it, regardless of cell content.
-
If there are any merged cells spanning the column(s) you want to widen.
You can use any other, different, method of widening the column, but double-clicking will not work in these cases. |
Microsoft Word
COPY A WEB SITE TO WORD.
To paste only text from a Web page into MS Word.
Do the “Ctrl+A” and “Ctrl+C” stuff to copy the web page to the clipboard, or right click and select “Copy”.
You now need to tell Word to paste the text without anygraphics. You do this by:
Microsoft Access
VIEWING ACCESS DATA IN AN EARLIER VERSION
Assuming that you have Access 2000, then if you have a way to use Access 2003, installed on another computer say, you can convert the 2003 database to 2000 format, and then open that copy in Access 2000.
Go to the conversion selection on the “Tools/Database Utilities/Convert Database” menu.
Unfortunately, if the 2003 database was sent to you by someone else, and you have no way of accessing Access 2003, then that person would have to do the conversion, and send you the 2000 version of the database.
These, and other tips have been garnered from many sources over the years. My thanks to the originators.
|