Microsoft Office Information

General Tech

MapInfo / GIS

Oracle / Database

Misc / Useless

Microsoft Office Information

Microsoft Office XP Information

Save Settings Wizrd - get to by going to Start --> Programs --> Microsoft Office Tools --> Save My Settins Wizard, allows saving of settings and moving to another computer
Open/Save As Dialog Box - Press Alt-2 to jump up one level

Microsoft Outlook 2000/2003 Information

Try View-->Arrange By-->Conversation to see threaded emails so can delete oldest.
Hotkeys:
- [Ctrl]+1 - switch to mail
- [Ctrl]+2 - switch to calendar
- [Ctrl]+3 - switch to contacts
- [Ctrl]+4 - switch to tasks
- [Ctrl]+N - create new message (if in mail-related folder)
- [Ctrl]+K - show addresses from address book that are close to what you typed
- [Ctrl]+M - send/receive mail
- [Ctrl]+R - reply to a message
- [Ctrl]+F - forward a message
- [Ctrl]+Y - go to a folder
- [Ctrl]+[F2] - opens Notepad with the HTML source portion of the message displayed
- [Ctrl]+[Shift]+A - create a new appointment
- [Ctrl]+[Shift]+I - go to inbox
- [Ctrl]+[Shift]+M - create a new message
- [Ctrl]+[Shift]+R - reply to all
- [Ctrl]+[Enter]+Q - mark message as read
- [Alt]+[Enter] - view message properties
- [Alt]+[F1] - toggle navigation pane on and off
- [Alt]+S - post or send message
- [Ctrl]+[Shift]+[Enter] - mark message as unread
stop blocking file types for security reasons:
close Outlook
run regedit and navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\Outlook10.0\Outlook\Security
choose Edit->New->String Value and name it Level1Remove
right-click on it and choose Modify and for its value enter the list of extensions you want to allow separated by semi-colons

Microsoft Access 2000 Information

Hotkeys:
- [Ctrl]+[Alt]+[Spacebar] - enter default value for field
- [Ctrl]+[+] - add a new record
- [Ctrl]+[-] - delete the current record
- [Ctrl]+; - insert current date
- [Ctrl]+: - insert current time

Microsoft Excel 2000 Information

use [Alt]+[Enter] to hard-wrap in cell that allows wrapped text
Uses 2 template file usually in C:\Program Files\Microsoft Office\Office10\XLStart - book. xlt and sheet.xlt (can create by saving out workbook and renaming if they don't exist)
to copy into multiple nonsequential cells: copy data then hold down [Ctrl] as click on cells, when done press [Ctrl]+[Enter]
Useful Functions:
- COUNTIF/SUMIF - count the # of times a condition is met
  =COUNTIF(B1:B31, ">5000")
- CHOOSE - returns item in list that corresponds to # passed in (from 1 to 29)
  =CHOOSE(WEEKDAY(B2), "Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat")
- MOD - returns remainder of division operation (can use to format alternative rows)
  =MOD(ROW(),2)
- DATEDIF - returns time between 2 dates
  =DATEDIF(A1,NOW(),"y")
- NETWORKDAYS - returns # of workdays between 2 dates (specify holiday dates in named range)
  =NETWORKDAYS(B1,C1,holidays)
- CONVERT - convert measurements from one unit to another
  =CONVERT(A2,"in","cm")
- ISERROR - use with IF and NOT to add range of numbers ignoring those with errors
  =SUM(IF(NOT(ISERROR(A2:A6)),A2:A6,""))
- LARGE/SMALL - return the nth largest or smallest # in list
  =LARGE(A2:A10,3)
- SUBTOTAL - calculate subtotal of filtered list (sum does both hidden and visible values)
  =SUBTOTAL(A1:A30)
- VLOOKUP - find data in tables
  =VLOOKUP("NYC",A2:C100,2,FALSE) - 2=2nd column in table, FALSE=data is not sorted and exact match is required
- TODAY - places current date in cell
  =TODAY()
- FREQUENCY - count # of instances in a series of values
  =FREQUENCY(A1:D100, F2:F5) - then press CTRL-SHIFT-ENTER (bins are in F2:F5 in this example - like 0:5, 6:10, etc.)
- FV - future value function
  =FV(5.5%/12,10*12,-10,-1000) - 10*12=months to calculate for, -10=additional monthly payment, -1000=starting investment
Hotkeys:
- [F3] - see all available range names to paste into formula
- [Ctrl]+[Shift]+[F1] - add a new worksheet before current one
- [Ctrl]+[Shift]+& - add an outline border to a cell or a range of cells
- [Ctrl]+[Shift]+_ - remove all borders from a cell or range of cells
- [Ctrl]+[PgDn] - move to the next sheet in a workbook
- [Ctrl]+[PgUp] - move to the previous page in a workbook
- [Ctrl]+' - copy formula from cell above
- [Ctrl]+[Shift]+" - copy value from cell above
- [Ctrl]+[Shift]+~ - removes all formats and set to general cell format
- [Ctrl]+[Shift]+_ - removes all borders
- [Ctrl]+[Shift]+! - set 0.00 cell format
- [Ctrl]+[Shift]+$ - set $#,##0.00;($#,#0.00) cell format
- [Ctrl]+[Shift]+% - set % cell format
- [Ctrl]+[Shift]+^ - set 0.00E+00 cell format
- [Ctrl]+; - insert current date
- [Ctrl]+: - insert current time
- [Shift]+[Spacebar] - select entire row (must have cell in the row you want selected)
- [Ctrl]+[Spacebar] - select entire column (must have cell in the column you want selected)
- [Shift]+[Alt]+[Right Arrow] - opens additional heading row which allows you to easily hide/show columns and/or rows
Command Line Switches:
- /e - open Excel without opening a new workbook
- /I - starts Excel with a maximized window
- /p "folder" - sets the active path to folder
- /r "filename" - opens filename in read-only mode
to fill a selected range with a value:
1. Select the range you want to fill.
2. Type the entry with which you want to fill the range (the entry appears in the first cell of the range).
3. Press [Ctrl] + [Enter].
To get a quick overview of which cells in your worksheet contain formulas, numbers, or text:
1. Choose Edit + Go To.
2. In the Go To dialog box, click Special.
3. Specify what you want Excel to select. For example, if you want Excel to select every Formula cell, select Formulas; if you want Excel to select every cell containing Text, select Constants and then deselect Numbers, Logicals, and Errors.
4. Click OK.
to activate the Go To command from the keyboard:
1. Press Ctrl + G
2. To jump from here (the opening Go To dialog box) to the Special dialog box - press [Alt]+[S]
type =info(
) in a cell to get excel/system information - here is a list of keywords to use with INFO:
- "directory"--Displays the current path
- "memavail"--Displays the available memory (in bytes)
- "memused"--Displays the number of memory bytes being used for data
- "numfile"--Displays the number of active worksheets
- "osversion"--Displays the current operating system version
- "recalc"--Displays the current recalculation mode (Automatic or Manual)

Microsoft Word 2000 Information

to open up the most recently used file when word starts up - winword.exe /mFile1
to see styles used in document view document in normal mode and then under Tools-->Options view tab enter 0.5 or more in style area width box
Hotkeys:
- [F3] - expand autotext entry
- [F4] - repeat last text typed in
- [F5] - goto specific page
- [F7] - check spelling
- [F9] - update fields
- [Shift]+[F3] - switch between lowercase, initial capital, and uppercase for current work or selected text
- [Shift]+[F5] - after open document go back to last place was working on
- [Shift]+[F7] - check the thesaurus
- [Shift]+[F9] - switch between field code and field result for selected fileds
- [Ctrl]+[Spacebar] - return font to default format for style
- [Ctrl]+[F6] - cycle between open document windows
- [Ctrl]+[F9] - insert field markers
- [Ctrl]+E - to center text
- [Ctrl]+J - to justify text
- [Ctrl]+L - to left-align text
- [Ctrl]+R - to right-align text
- [Ctrl]+] - increase font size by 1 point
- [Ctrl]+[ - decrease font size by 1 point
- [Ctrl]+[Shift]+[F9] - unlink a filed - convert to text/graphic
- [Ctrl]+[Shift]+N - remove/clear all formatting from selection
- [Ctrl]+[Shift]+S - pick style from style dropdown
- [Ctrl]+[Shift]+[Enter] - insert a column break
- [Ctrl]+[Shift]+> - increase font size by increments
- [Ctrl]+[Shift]+< - decrease font size by increments
- [Alt]+[Ctrl]+P - switch to print layout view
- [Alt]+[Ctrl]+N - switch to normal view
- [Alt]+[Ctrl]+O - switch to outline view
- [Alt]+[Ctrl]+I - switch to print preview
- [Alt]+[F9] - switch between showing all field code and all field results
- [Alt]+[Shift]+[Right/Left Arrow] - cycle selected paragraph through all formats in the style list
- [Alt]+[Shift]+D - insert date field (to insert as text press previous then unlink field
- [Alt]+[Shift]+T - insert time field (to insert as text press previous then unlink field
Macro steps to remove extra line breaks from copied email text:
Replace ^l with ^p
Replace ^p_ with ^p (where the underscore represents a space)
Replace _^p with ^p (again the underscore represents a space)
Replace ^p^p with %$#@
Replace ^p with a space
Replace %$#@ with ^p^p
enter rand(<paragraphs>,<sentences>) in document to create sample text
to insert the date at the current cursor location, press [Alt] + [Shift] + D and to insert the time at the current cursor location, press [Alt] + [Shift] + T
to easily switch between loaded documents - choose View -> Toolbars -> Customize - then click the Commands tab - scroll through the Categories list and click All Commands - scroll through the Commands list to locate the NextWindow command - then use the mouse to drag the NextWindow command to the Word toolbar
to add a menu of favorite files to the File menu choose Tools -> Customize and then click the Commands tab and under Categories, select Built-in Menus - the under Commands, find the Work menu button and drag it into place on your File menu (put it just below your List of Recent Files) - then click Close - now when want to add a document to the Work menu open the file and then choose File -> Work -> Add to Work Menu
to remove an item from the Work menu press [Ctrl] + [Alt] + - (hyphen) - the mouse pointer changes to a heavy minus sign - then choose File -> Work and the file you want to delete
To go back to where you were working when you saved and closed the document last press [Shift]+[F5] - or use the macro:
- Sub autoOpen()
- Application.GoBack
- End Sub
to keep words from breaking apart at the end of a line, put a hard space, or a nonbreaking space, instead of a regular space between them - press [Ctrl] + [Shift] + [Spacebar] to do it
to draw lines easily: (first under Tools-->AutoCorrect under the 'AutoFormat As You Type' tab make sure 'Borders' is checked)
- to draw a straight line - type three '-' and then press [Enter]
- to draw a double line - type three '=' and then press [Enter]
- to draw a triple line - type three '#' and then press [Enter]
- to draw a heavy line - type three '_' and then press [Enter]
- to draw a dotted line - type three '*' and then press [Enter]
- to draw a wavy line - type three '~' and then press [Enter]
to move down one paragraph at a time, press [Ctrl]+[Down Arrow] and to move up one paragraph at a time, press [Ctrl]+Up Arrow].
to select a full sentence, place the mouse cursor anywhere in a sentence and hold the [Ctrl] key and double-click the mouse
create your own personal font toolbar:
1. Choose Tools + Customize
2. Click the Toolbars tab
3. Click the New button
4. In the Toolbar Name box, type a name for your new toolbar - in this case 'Fonts'
5. Click OK - a Fonts toolbar appears on your screen
6. Click the Commands tab
7. Under Categories, click Fonts
8. In the Commands box, find a font you want to include and drag it onto the Fonts toolbar
9. Repeat the above step until you've added all the fonts you want on the toolbar
10. Click OK
Extend Selection Mode:
1. Press [F8] to activate Extend Selection mode.
2. Press [F8] again. Word selects the current word.
3. Press [F8] again. Word selects the current sentence.
4. Press [F8] again. Word selects the current paragraph.
5. Press [F8] one more time. Word selects all the text in the document.
(To reverse any selection to the preceding one, simply press [Shift]+[F8] to back out from document to paragraph, from paragraph to sentence, from sentence to word, and from word to nothing.)

Symbol Entry

For	Enter
¢	Ctrl-/,c
©	Ctrl-Alt-c
®	Ctrl-Alt-r
^TM	Ctrl-Alt-t
... (ellipsis)	Ctrl-Alt-.
— (em dash)	Ctrl-Alt--
– (en dash)	Ctrl--
«	Ctrl-`,<
»	Ctrl-`,>

Special Characters to Find:

Character	Symbol
^p	Paragraph mark
^t	Tab
^+	Em dash
^=	En dash
^d	A field
^f	Footnote
^g	A graphic
^-	Optional hyphen
^~	Nonbreaking hyphen
^b	Section break

to type a vowel with an acute accent over it, press Ctrl + ' (apostrophe) and then type the vowel. To type a vowel with a grave accent over it, press Ctrl + ` and then type the vowel. To type a tilde over an a, n, or o, press Ctrl + Shift + ~ and type the appropriate letter. To type an upside-down exclamation point, press Ctrl + Alt + Shift + !. To type an upside-down question mark, press Ctrl + Alt + Shift + ?.
to create a hanging indent at the first existing tab stop Press [Ctrl] + T - press [Ctrl] + T again to indent the hanging indent to the NEXT tab stop and the next and the next and so on