https://wiki.catglobe.com/api.php?action=feedcontributions&feedformat=atom&user=Cg+phongCatglobe Wiki - User contributions [en]2026-04-20T11:37:32ZUser contributionsMediaWiki 1.43.0https://wiki.catglobe.com/index.php?title=MS_Excel_tips_and_tricks&diff=13847MS Excel tips and tricks2010-09-27T13:04:48Z<p>Cg phong: /* List of useful shortcut keys */</p>
<hr />
<div>== Introduction ==<br />
<br />
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.<br />
<br />
== List of useful shortcut keys ==<br />
<br />
Some shortcut keys can really speedup the way you are working with Excel, below is a list of some very useful Excel shortcut keys. <br />
<br />
{| class="CGTable" border="1"<br />
|-<br />
! Key combination <br />
! Description <br />
! Version<br />
|-<br />
| F2 <br />
| Edit the contents of a cell <br />
| All<br />
|-<br />
| Ctrl + <br />
| Add cells, columns or rows, depending on selection <br />
| All<br />
|-<br />
| Ctrl - <br />
| Delete cells, columns, or rows, depending on selection <br />
| All<br />
|-<br />
| Ctrl L <br />
| Convert an area to a table, Excel will suggest the area used if only one cell is selected <br />
| 2007<br />
|-<br />
| Ctrl C <br />
| Copy selected cells <br />
| All<br />
|-<br />
| Ctrl Alt V <br />
| This will bring up the paste special menu, which allows you to paste as values, formulas, with formatting intact etc. <br />
| All<br />
|-<br />
| Ctrl Page Up <br />
| Move to the previous sheet in the workbook <br />
| All<br />
|-<br />
| Ctrl Page Down <br />
| Move to the next sheet in the workbook <br />
| All<br />
|-<br />
| Ctrl H <br />
| Search and replace dialog will be shown <br />
| All<br />
|-<br />
| Ctrl F <br />
| Search dialog will be shown <br />
| All<br />
|-<br />
| Ctrl SPACE<br />
| Select the current column<br />
| All<br />
|-<br />
| Shift SPACE<br />
| Select the current row<br />
| All<br />
|}<br />
<br />
== Tips and tricks ==<br />
<br />
=== A fast way to convert text to numbers ===<br />
<br />
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:<br />
<br />
# Select the cells you want to convert and copy them using Ctrl C<br />
# Open your favorite text editor (TextPad, UltraEdit, or Notepad++ to mention a few) and press Ctrl V<br />
# Notice how the values from the cells appear tab separated in the text document<br />
# Press Ctrl A to select the contents of the text document and Ctrl C to copy<br />
# Return to Excel, place the cell marker in the top left corner of your selected area and press Ctrl V<br />
# Any number that was previously represented as text will not appear as numbers<br />
<br />
Notice that decimal numbers might cause some troubles depending on the localization you are using.<br />
<br />
=== Alternative usages of Excel ===<br />
<br />
[[Category:Production_guidelines]]</div>Cg phong