Tutorial: Microsoft Excel shortcuts to save you time

<div dir="ltr" style="text-align: left;" trbidi="on"> <span class="Apple-style-span" style="border-collapse: separate; color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: small; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 24px; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><div style="background-color: white; color: #444444; font-family: Georgia,'Times New Roman','Bitstream Charter',Times,serif; font-size-adjust: none; font-size: 13px; font-stretch: normal; font-style: normal; font-variant: normal; font-weight: normal; line-height: 19px; margin: 0px; max-width: 640px; padding: 0.6em;"> <div mce_style="text-align: center;" style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px; text-align: center;"> <img alt="" class="aligncenter" height="150" mce_src="http://cdn.mos.techradar.com//Review%20images/Windows%20Vista/56/OWV56.f_timesaver.chart-200-200.jpg" src="http://cdn.mos.techradar.com//Review%20images/Windows%20Vista/56/OWV56.f_timesaver.chart-200-200.jpg" style="border-width: 0px; clear: both; color: #444444; display: block; font-family: Georgia,'Bitstream Charter',serif; line-height: 1.5; margin: 0px auto 12px; max-width: 640px;" width="200" /></div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> Start speeding up the way you use Office Excel by setting it up to reflect your personal needs.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> Open Options from the Tools menu, File ribbon or Office button, then work your way through the options on offer. Set up how many worksheets you prefer new workbooks to contain from the General section, and choose a default format and location new files are saved to from the Save section.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> When entering data, make use of the Fill Handle to dramatically speed up data entry - just type in a figure, then click and drag the fill handle down or to the right to duplicate the number or formula in each of the selected cells.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> The Fill Handle can also speed up entering a row or column of consecutive dates, including days, months or years. Type the first entry as normal, then click and drag using the right mouse button - if you've typed Monday, for example, you can fill out weekdays or all seven days of the week as you drag by selecting the appropriate option.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> The Fill Handle isn't much use for entering the same figure in non-adjacent cells, but there's a workaround. Select the cells you wish to include by Ctrl-clicking each, then type the cell reference, number or absolute formula before pressing Ctrl and Return.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> Navigating a large spreadsheet can be a real hassle, so instead of manually scrolling to the cell in question, simply type it into the Name box and press Return to jump straight to it.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> If you frequently use a specific figure, such as VAT, in your workbook calculations, save time by defining it as a constant - switch to the Formulas ribbon and choose Define Name. Type the term (VAT in our example) into the Name box and its amount (20) into the Refers to box before clicking on OK. Now just type VAT instead of 20 into your formulas, and when the VAT rate next changes, you can update the entire workbook to the new rate simply by changing the figure for VAT in the Name Manager.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> The quickest way to enter an unknown formula is to click the fx button and then follow the wizard to choose the appropriate one for your needs. Office Excel 2007 and 2010 users will also find a host of formulas conveniently organised into categories on the Formulas tab.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> When copying and pasting formulas from one cell to another, they're treated as relative, which means the cell references are based on where the cells are in relation to the cell containing the formula. Quickly create absolute formula references using the $ character, so cell A1 becomes $A$1, for example.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> Last, but not least, if you need to style your spreadsheet in Office Excel 2007 or 2010, make use of the Cell Styles function instead of manually highlighting or colouring cells. Select an already formatted cell, then click the Cell Styles button on the Home tab and choose New Style. Name it up and click OK - in future, click Cell Styles again to format your cells from the Custom section.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> <span class="Apple-style-span" mce_name="strong" mce_style="font-weight: bold;" style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-weight: bold; line-height: 1.5;">Quick-fire charts</span></div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> The quickest and easiest way to create a chart in Office Excel isn't Chart Wizard - just select the cells you wish to include in your chart and then press F11. The Chart Wizard is bypassed and a chart instantly appears on the screen.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> Once that's done, just right-click on the various elements to customise the chart.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> <span class="Apple-style-span" mce_name="strong" mce_style="font-weight: bold;" style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-weight: bold; line-height: 1.5;">Excel shortcuts</span></div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> <span class="Apple-style-span" mce_name="strong" mce_style="font-weight: bold;" style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-weight: bold; line-height: 1.5;">Alt and Return</span>: Start a new line in the current cell instead of moving to the next one.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> <span class="Apple-style-span" mce_name="strong" mce_style="font-weight: bold;" style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-weight: bold; line-height: 1.5;">F11</span>: Generate a chart from the currently selected data.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> <span class="Apple-style-span" mce_name="strong" mce_style="font-weight: bold;" style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-weight: bold; line-height: 1.5;">Shift/Ctrl and Space</span>: Select the current row/column.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> <span class="Apple-style-span" mce_name="strong" mce_style="font-weight: bold;" style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-weight: bold; line-height: 1.5;">Alt and =</span>: Total the selected cells.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> <span class="Apple-style-span" mce_name="strong" mce_style="font-weight: bold;" style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-weight: bold; line-height: 1.5;">Ctrl and Shift and $</span>: Format selected cells as currency with two decimal places.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> <span class="Apple-style-span" mce_name="strong" mce_style="font-weight: bold;" style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-weight: bold; line-height: 1.5;">Ctrl and ;</span>: Insert current date.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> <span class="Apple-style-span" mce_name="strong" mce_style="font-weight: bold;" style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-weight: bold; line-height: 1.5;">Ctrl and Shift and '</span>: Paste value from the cell above.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> <span class="Apple-style-span" mce_name="strong" mce_style="font-weight: bold;" style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-weight: bold; line-height: 1.5;">Shift and F11</span>: Insert a new worksheet.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> <span class="Apple-style-span" mce_name="strong" mce_style="font-weight: bold;" style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-weight: bold; line-height: 1.5;">Ctrl and PageDown/PageUp</span>: Move between worksheets.</div> <div style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-size: 16px; line-height: 1.5; margin-bottom: 24px;"> <span class="Apple-style-span" mce_name="strong" mce_style="font-weight: bold;" style="color: #444444; font-family: Georgia,'Bitstream Charter',serif; font-weight: bold; line-height: 1.5;">Ctrl and D/R</span>: Fill cell with the contents of the cell either above (D) or to the left (R).</div> </div> </span></div>

Tutorial: Microsoft Excel shortcuts to save you time

Start speeding up the way you use Office Excel by setting it up to reflect your personal needs. Open Options from the Tools menu, Fil...

Continue Reading>>