word and excel shortcut

[kalos]

hello

is there a key shortcut that can move the cursor automatically to the top cell of the first right column, from the cell we type?

this is very useful if you are filling columns with numbers, so that you don't have to move the cursor with the mouse or with the arrows, etc

also, in office, is there a key shortcut that will capitalize or lowercase the selected letters?

thanks

[housetier]

I do not know such a shortcut off the top of my head, but you could experiment with a combination of PgUp/Left/Home and Shift/Ctrl.

[techidave]

take a look http://office.microsoft.com/en-us/help/HA011407361033.aspx

here

sorry, I pasted the link in the wrong place

[kalos]

is anything relevant on that link? because I checked and didn't find anything

[yksyks]

In MS Excel you can put cursor on top/bottom/leftmost/rightmost cell of contiguous data block using Ctrl-Up/Down/Left/Right keys.

In MS Word you can cycle between lowercase/UPPERCASE/Titlecase using Shift-F3. In case of a single word you don't even have to select it, just put the cursor in it.

The complete list of shortcuts is best found in the help file, just press F1 and type "keyboard shortcuts". That's how I learned these.

(Applies to MS Office 2003 and older, I don't know the latest versions.)

[kalos]

In MS Excel you can put cursor on top/bottom/leftmost/rightmost cell of contiguous data block using Ctrl-Up/Down/Left/Right keys.

-yksyks (February 07, 2010, 07:43 AM)

so, I suppose there is no shortcut to do what I want and the closest is to click the right arrow and then ctrl+up

[yksyks]

so, I suppose there is no shortcut to do what I want and the closest is to click the right arrow and then ctrl+up

-kalos (February 07, 2010, 08:30 AM)

If this key sequence does what you need, then record a macro, assign a hotkey to it and you're done.

[jacksonp]

Here are some shortcut :

Shortcut Keys Description
Ctrl + A Select all contents of the page.
Ctrl + B Bold highlighted selection.
Ctrl + C Copy selected text.
Ctrl + D Open the font dialogue box.
Ctrl + E Aligns the line or selected text to the center of the screen.
Ctrl + F Open find box.
Ctrl + G Open find and replace box.
Ctrl + H Also opens find and replace box.
Ctrl + I Italicise highlighted selection.
Ctrl + J Justify (spread) the text across the page.
Ctrl + K Insert link.
Ctrl + L Aligns the line or selected text to the left of the screen.
Ctrl + M Indent the paragraph.
Ctrl + N Open a new document.
Ctrl + O Open a document stored on your hard drive.
Ctrl + P Open the print window.
Ctrl + R Aligns the line or selected text to the right of the screen.
Ctrl + S Saves the current document.
Ctrl + U Underline highlighted selection.
Ctrl + V Paste contents of clipboard.
Ctrl + W Closes the current document.
Ctrl + X Cut selected text.
Ctrl + Y Redo the last action performed.
Ctrl + Z Undo last action.
Ctrl + Shift + F Change the font.
Ctrl + Shift + > Increase selected font +1pts up to 12pt and then increases font +2pts.
Ctrl + ] Increase selected font +1pts.
Ctrl + Shift + < Decrease selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.
Ctrl + [ Decrease selected font -1pts.
Ctrl + Shift + * View or hide non printing characters.
Ctrl + <left arrow> Moves one word to the left.
Ctrl + <right arrow> Moves one word to the right.
Ctrl + <up arrow> Moves to the beginning of the line or paragraph.
Ctrl + <down arrow> Moves to the end of the paragraph.
Ctrl + Del Deletes word to right of cursor.
Ctrl + Backspace Deletes word to left of cursor.
Ctrl + End Moves the cursor to the end of the document.
Ctrl + Home Moves the cursor to the beginning of the document.
Ctrl + Spacebar Reset highlighted text to the default font.
Ctrl + 1 Single-space lines.
Ctrl + 2 Double-space lines.
Ctrl + 5 1.5-line spacing.
Ctrl + Alt + 1 Changes text to heading 1.
Ctrl + Alt + 2 Changes text to heading 2.
Ctrl + Alt + 3 Changes text to heading 3.
Ctrl + F1 Open the Task Pane.
F1 Open Help.
Alt + Ctrl + F2 Open new document.
Ctrl + F2 Display the print preview.
Shift + F3 Change the text from upper to lower case or a capital letter at the beginning of every word.
Shift + Insert Paste.
F4 Repeat the last action performed.
F5 Open the find, replace, and go to window in Microsoft Word.
Ctrl + Shift + F6 Opens to another open Microsoft Word document.
F7 Spell and grammar check selected text and/or document.
Shift + F7 Runs a Thesaurus check on the word highlighted.
F12 Save as.
Shift + F12 Save.
Ctrl + Shift + F12 Prints the document.
Alt + Shift + D Insert the current date.
Alt + Shift + T Insert the current time.