Jonathan,
Use this list for all Excel Shortcuts:
EXCEL SHORTCUT KEYS
Shortcut Keys Description
F7 Spell check selected text and or document.
F11 Create chart.
Ctrl + Shift + ; Enter the current time
Ctrl + ; Enter the current date
Alt + Shift + F1 Insert New Worksheet
Shift + F3 Open the Excel formula window.
Shift + F5 Bring up search box.
Ctrl + A Select all contents of the worksheet.
Ctrl + B Bold highlighted selection.
Ctrl + I Italic highlighted selection.
Ctrl + K Insert link.
Ctrl + U Underline highlighted selection.
Ctrl + 5 Strikethrough highlighted selection.
Ctrl + P Bring up the print dialog box to begin printing.
Ctrl + Z Undo last action.
Ctrl + F9 Minimize current window.
Ctrl + F10 Maximize currently selected window.
Ctrl + F6 Switch between open workbooks / windows.
Ctrl + Page up Move between Excel work sheets in the same Excel document.
Ctrl + Page down Move between Excel work sheets in the same Excel document.
Ctrl + Tab Move between Two or more open Excel files.
Ctrl + Shift + ! Format number in comma format.
Ctrl + Shift + $ Format number in currency format.
Ctrl + Shift + # Format number in date format.
Ctrl + Shift + % Format number in percentage format.
Ctrl + Shift + ^ Format number in scientific format.
Ctrl + Shift + @ Format number in time format.
Ctrl + Arrow key Move to next section of text.
Ctrl + Space Select entire column.
Shift + Space Select entire row.
Hope this helps
=========================
Quel fara Tenna' ento lye omenta
Paul Kirk
PC Support Deputy
PC Support Department
Computer Centre
Internal Ext 65134
External Ext 01895 265134
-----Original Message-----
From: Discussion list for disabled students and their support staff.
[mailto:[log in to unmask]]On Behalf Of Louise Lotz
Sent: 20 December 2004 14:14
To: [log in to unmask]
Subject: Re: Microsoft Excel 2002 - keyboard shortcuts
CTRL + 1 opens the 'format number' menu. But I don't know how you scroll down it. Maybe someone else can experiement and make a suggestion.
Louise
-----Original Message-----
From: Discussion list for disabled students and their support staff.
[mailto:[log in to unmask]]On Behalf Of Jonathon WHITE
Sent: 20 December 2004 13:23
To: [log in to unmask]
Subject: Microsoft Excel 2002 - keyboard shortcuts
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4E696.F8AA0994
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
I am looking for answers to the two questions below in relation to
Microsoft Excel 2002. Any responses would be gratefully received.
=20
1. What is the keyboard shortcut in Excel to format numeric data to
Integer?
2. What is the keyboard shortcut in Excel to right align text. (Ctrl + R
does not work for the alignment here, it merely replicates the previous
cell).
=20
Please note. I have already used the resources below without success:
- Microsoft Support Knowledge Base:
http://support.microsoft.com/default.aspx?scid=3Dfh;en-us;KBHOWTO=20
- Microsoft Accessibility: http://www.microsoft.com/enable=20
- Microsoft Excel: using and designing: a training manual for blind and
partially sighted computer users - by Julia Cox. RNIB, 2003.=20
=20
Many thanks
=20
Jonathan White
Learner Services
South Cheshire College
Tel. 01270 654654 Ext. 204
------_=_NextPart_001_01C4E696.F8AA0994
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Arial;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-GB link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'>I am looking
for answers to the two questions below in relation to Microsoft Excel =
2002. Any
responses would be gratefully received.</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'>1. What
is the keyboard shortcut in Excel to format numeric data to =
Integer?</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'>2. What
is the keyboard shortcut in Excel to right align text. (Ctrl + R does =
not work
for the alignment here, it merely replicates the previous =
cell).</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'>Please
note. I have already used the resources below without =
success:</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'>- Microsoft
</span></font><font size=3D2><span =
style=3D'font-size:10.0pt'>Support</span></font><font
size=3D2><span style=3D'font-size:10.0pt'> Knowledge Base: <a
href=3D"http://support.microsoft.com/default.aspx?scid=3Dfh;en-us;KBHOWTO=
">http://support.microsoft.com/default.aspx?scid=3Dfh;en-us;KBHOWTO</a>
</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'>- Microsoft
Accessibility: <a =
href=3D"http://www.microsoft.com/enable">http://www.microsoft.com/enable<=
/a>
</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'>- Microsoft
Excel: using and designing: a training manual for blind and partially =
sighted
computer users - by Julia Cox. RNIB, 2003. </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'>Many
thanks</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'>Jonathan
White</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'>Learner
Services</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'>South</span></font><font
size=3D2><span style=3D'font-size:10.0pt'> </span></font><font =
size=3D2><span
style=3D'font-size:10.0pt'>Cheshire</span></font><font size=3D2><span
style=3D'font-size:10.0pt'> </span></font><font size=3D2><span =
style=3D'font-size:
10.0pt'>College</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt'>Tel.
01270 654654 Ext. 204</span></font></p>
</div>
</body>
</html>
=00
------_=_NextPart_001_01C4E696.F8AA0994--
|