Practical User Information

To change the first workbook to open (instead of book1). Best to do this before you open Excel.						
				For Windows95 Excel 7.0		
   Explorer => Windows						
   Select Regedit.exe						
   HKEY_CURRENT_USER\Software\Microsoft\7.0\Microsoft Excel						
"Go to the files maked OPEN. See the list of OPEN files. There is OPEN1, OPEN2, OPEN3..."						
"Click once on last OPEN, say OPEN4. From the Menu"						
   Edit => New => String Value						
The Editor adds a new key named New Value #1. Edit this key so it reads your selected option						
 ie OPEN4. A new Icon is in the file list called OPEN4. Double click on the icon to open the						
"Edit Bar. In quotes type  ""C:\yourpath\yourfile.xls"" This description should have two sets of double"						
quotes when you view the results.						

"For no workbook to appear, do not include the file eg ""C:\yourpath\""  . Alternatively, edit the shortcut"			
"on Windows Icon to include /e at the end of description eg ""C:\yourpath\excel /e  ."			


"To Delete Links, Refer to Web Site:"			

   http://www.officeupdate.microsoft.com/downloadcatalog/dldexcel.asp			
			
Or try this: Change Source in Link DialogBox to a blank (if no other links exist). Click a blank line.			
This will stop the Link Message. Only for versions 97or later.			

Links message is not seen but ls still updated Tools > Options > Edit.  Uncheck the Ask to Update			
Automatic Links. This is a global setting and refers to all workbooks.			


Not see the message prompt to enable/disable MACROS. Only for versions 97 or later
Tools > Macro > Macro Security. Set the Security level to LOW. Macros will not be disabled.



Pressing the / key and Menu is activated. To stop this action

   Tools > Options >Transition

Clear the Microsoft Excel Menu or Help Key Box. This is a Trasitional key for  Lotus 1-2-3 users.


"Not show the formula in a cell, only the value - there is no VBA for this procedure. You can also"
use this procedure in edit mode in a formula by highlighting the text you want valued

  Press F9 then Enter


A sheet can be its own workbook by dragging the sheet tab on to the desktp behind the workspace. 
Resize the workspace window to minimum to reveal the desktop. If you close the source file
"without saving, the sheet tab will remain part of that workbook. Because you have physically"
"moved the sheet tab, you will be asked to save when you close the workbook."


Scrolling through the sheet tabs can be done with the keyboard: 

   Ctrl+Pg Dn activates next sheet
   Ctrl+Pg Up activates previous sheet


"To copy a sheet, hold down Ctrl and click on the sheet. Pick it up and move it along to next tab split."
"The new sheet, if original was sheet1, will be sheet1 (2). This same approach applies to copying to"
other workbooks.


"To select all sheets, or a selection, click on sheet tab starting from the left. Hold down the shift key "
and click on the last sheet tab to the right. All sheets between first and last will be selcted. This
"also works in reverse, that is right to left."


Show multiples of current sheet by choosing Window > New Window. Each copy will be assigned
a copy number: Book1:2 is second copy of Book1 and Book1 will be assigned Book1:1 To close
"a copy sheet that is active, use Ctrl+W or the Window control box. If you use the File > Close it "
will close the Workbook. Saving either window will make no difference to the structure of the workbook
as input is applied to both sheets at the same time.


"Freeze both column and row, select B2 then Widow > Freeze Panes. This will allow you to scroll"
across or down without losing sight of Headings or Titles or Names in A:A column.				


to move around a block of blank or filled cells without losing the block effect				

TAB  moves from left to right then down next row then left to right again				
ENTER moves from top to bottom then across next column then top to bottom again				
"SHIFT + ENTER starts its run at the last corner then moves from bottom to top ,next column, bottom"				
to top again				


"To fill a block of blank cells, type in your input in one cell then press Ctrl+Enter."				


"Select a block auto-fashion and not manually, select first cell and depending on which direction you"				
"want, hold shift and click on side of cell wall to extend the highlight to end of text."				

















The following is a list of controls that activate when you press the Control key and a letter. If you have	
"shortcut keys in your macros options, these will take affect rather than the built in affect. Also applies"	
to Addins	

 Ctrl+a	Selects all cells
 Ctrl+b 	bolds selection
 Ctrl+c	Activates copy mode
 Ctrl+f	Activates Find/Replace Dialog Box
 Ctrl+g	Activates GoTo Dialog Box
 Ctrl+h	Activates Find/Replace/Replace_All Dialog Box
 Ctrl+i	Italics selection
 Ctrl+n	Activates New Workbook Dialog Box
 Ctrl+o	Activates Open File Dialog Box
 Ctrl+p	Activates Print Dialog Box
 Ctrl+s	Saves workbook without prompting
 Ctrl+u	Underlines selection	
 Ctrl+v	Pastes selection	
 Ctrl+w	Closes current workbook with Prompt Message Box 	
 Ctrl+x	Activates cut mode	


The Alt key activates the Menu		


The following selects cells in different ways		

 Ctrl Spacebar		Entire Column
 Shift Spacebar		Entire Row
 Ctrl Shift Spacebar		Entire Sheet



"The "" & "" sign is the same as CONCATENATE. Place a space after John to ensure the space "						
between John and Smith in the result						

		  Formula		  Formula		Result
John 	Smith	" = ""John "" & ""Smith"""		   =A133&B133		John Smith


"To change the reference of a cell or formula, press F2 (Edit Mode) and highlight the reference you"						
"want to change. Press F4 and cycle the references till you have the one you want: Relative, "						
"Absolute, or Mixed."						

	C1	$C1	C$1	$C$1