MS Excel tips and tricks - Revision history

Wikicatglobe at 03:08, 18 October 2013

2013-10-18T03:08:10Z

← Older revision		Revision as of 03:08, 18 October 2013
Line 1:		Line 1:
	<accesscontrol>~~Administrators,,Cem,,Maysunshine~~</accesscontrol>		<accesscontrol>Main:MyGroup</accesscontrol>
	== Introduction ==		== Introduction ==

Cg_pham at 09:19, 4 October 2011

2011-10-04T09:19:52Z

← Older revision		Revision as of 09:19, 4 October 2011
Line 1:		Line 1:
			<accesscontrol>Administrators,,Cem,,Maysunshine</accesscontrol>
	== Introduction ==		== Introduction ==

Cg phong: /* List of useful shortcut keys */

2010-09-27T13:04:48Z

List of useful shortcut keys

← Older revision		Revision as of 13:04, 27 September 2010
Line 53:		Line 53:
	\| All		\| All
	\|-		\|-
	\| Ctrl ~~ENTER~~		\| Ctrl SPACE
	\| Select the current column		\| Select the current column
	\| All		\| All
	\|-		\|-
	\| Shift ~~ENTER~~		\| Shift SPACE
	\| Select the current row		\| Select the current row
	\| All		\| All

Catglobe at 15:00, 9 September 2010

2010-09-09T15:00:15Z

← Older revision		Revision as of 15:00, 9 September 2010
Line 7:		Line 7:
	Some shortcut keys can really speedup the way you are working with Excel, below is a list of some very useful Excel shortcut keys.		Some shortcut keys can really speedup the way you are working with Excel, below is a list of some very useful Excel shortcut keys.

	{\| ~~border~~="1" ~~class~~="~~CGTable~~"		{\| class="CGTable" border="1"
	\|-		\|-
	! Key combination		! Key combination
Line 51:		Line 51:
	\| Ctrl F		\| Ctrl F
	\| Search dialog will be shown		\| Search dialog will be shown
			\| All
			\|-
			\| Ctrl ENTER
			\| Select the current column
			\| All
			\|-
			\| Shift ENTER
			\| Select the current row
	\| All		\| All
	\|}		\|}

Catglobe at 09:31, 18 December 2009

2009-12-18T09:31:43Z

← Older revision		Revision as of 09:31, 18 December 2009
Line 3:		Line 3:
	Even with tons of help files to Microsoft Excel it is still nice to keep a page with tips and tricks accumulated over the years. Everyone are more than welcome to add their favorite Excel tips and tricks on this page.		Even with tons of help files to Microsoft Excel it is still nice to keep a page with tips and tricks accumulated over the years. Everyone are more than welcome to add their favorite Excel tips and tricks on this page.

	== List of useful shortcut keys ==		== List of useful shortcut keys ==

	Some shortcut keys can really speedup the way you are working with Excel, below is a list of some very useful Excel shortcut keys.		Some shortcut keys can really speedup the way you are working with Excel, below is a list of some very useful Excel shortcut keys.

	{\| border="1" class="CGTable"		{\| border="1" class="CGTable"
	\|-		\|-
	! Key combination		! Key combination
	! Description		! Description
	! Version		! Version
	\|-		\|-
	\| F2		\| F2
	\| Edit the contents of a cell		\| Edit the contents of a cell
	\| All		\| All
	\|-		\|-
	\| Ctrl +		\| Ctrl +
	\| Add cells, columns or rows, depending on selection		\| Add cells, columns or rows, depending on selection
	\| All		\| All
	\|-		\|-
	\| Ctrl -		\| Ctrl -
	\| Delete cells, columns, or rows, depending on selection		\| Delete cells, columns, or rows, depending on selection
	\| All		\| All
	\|-		\|-
	\| Ctrl L		\| Ctrl L
	\| Convert an area to a table, Excel will suggest the area used if only one cell is selected		\| Convert an area to a table, Excel will suggest the area used if only one cell is selected
	\| 2007		\| 2007
	\|-		\|-
	\| Ctrl C		\| Ctrl C
	\| Copy selected cells		\| Copy selected cells
	\| All		\| All
	\|-		\|-
	\| Ctrl ~~Shift~~ V		\| Ctrl Alt V
	\| This will bring up the paste special menu, which allows you to paste as values, formulas, with formatting intact etc.		\| This will bring up the paste special menu, which allows you to paste as values, formulas, with formatting intact etc.
	\| All		\| All
	\|-		\|-
	\| Ctrl Page Up		\| Ctrl Page Up
	\| Move to the previous sheet in the workbook		\| Move to the previous sheet in the workbook
	\| All		\| All
	\|-		\|-
	\| Ctrl Page Down		\| Ctrl Page Down
	\| Move to the next sheet in the workbook		\| Move to the next sheet in the workbook
	\| All		\| All
	\|-		\|-
	\| Ctrl H		\| Ctrl H
	\| Search and replace dialog will be shown		\| Search and replace dialog will be shown
	\| All		\| All
	\|-		\|-
	\| Ctrl F		\| Ctrl F
	\| Search dialog will be shown		\| Search dialog will be shown
	\| All		\| All
	\|}		\|}

Catglobe: I created this page to contain our collective knowledge about how to work most effectively with MS Excel

2009-12-18T09:09:47Z

I created this page to contain our collective knowledge about how to work most effectively with MS Excel

New page

== Introduction ==

Even with tons of help files to Microsoft Excel it is still nice to keep a page with tips and tricks accumulated over the years. Everyone are more than welcome to add their favorite Excel tips and tricks on this page.

== List of useful shortcut keys ==

Some shortcut keys can really speedup the way you are working with Excel, below is a list of some very useful Excel shortcut keys.

{| border="1" class="CGTable"
|-
! Key combination
! Description
! Version
|-
| F2
| Edit the contents of a cell
| All
|-
| Ctrl +
| Add cells, columns or rows, depending on selection
| All
|-
| Ctrl -
| Delete cells, columns, or rows, depending on selection
| All
|-
| Ctrl L
| Convert an area to a table, Excel will suggest the area used if only one cell is selected
| 2007
|-
| Ctrl C
| Copy selected cells
| All
|-
| Ctrl Shift V
| This will bring up the paste special menu, which allows you to paste as values, formulas, with formatting intact etc.
| All
|-
| Ctrl Page Up
| Move to the previous sheet in the workbook
| All
|-
| Ctrl Page Down
| Move to the next sheet in the workbook
| All
|-
| Ctrl H
| Search and replace dialog will be shown
| All
|-
| Ctrl F
| Search dialog will be shown
| All
|}

== Tips and tricks ==

=== A fast way to convert text to numbers ===

If you have a cell, column, or row containing numbers represented as text, then here is a very fast way to convert text to number:

# Select the cells you want to convert and copy them using Ctrl C
# Open your favorite text editor (TextPad, UltraEdit, or Notepad++ to mention a few) and press Ctrl V
# Notice how the values from the cells appear tab separated in the text document
# Press Ctrl A to select the contents of the text document and Ctrl C to copy
# Return to Excel, place the cell marker in the top left corner of your selected area and press Ctrl V
# Any number that was previously represented as text will not appear as numbers

Notice that decimal numbers might cause some troubles depending on the localization you are using.

=== Alternative usages of Excel ===

[[Category:Production_guidelines]]