Welcome Guest.   Make a donation to an author on the site October 02, 2014, 01:33:24 AM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
The N.A.N.Y. Challenge 2011! Download 30+ custom programs!
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
Pages: [1]   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: word and excel shortcut  (Read 2504 times)
kalos
Member
**
Posts: 1,023

View Profile Give some DonationCredits to this forum member
« on: February 07, 2010, 03:37:52 AM »

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
Logged
housetier
Charter Honorary Member
***
Posts: 1,321


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #1 on: February 07, 2010, 05:41:29 AM »

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.
Logged
techidave
Supporting Member
**
Posts: 960


see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #2 on: February 07, 2010, 06:26:09 AM »

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

here

sorry, I pasted the link in the wrong place
« Last Edit: February 07, 2010, 07:12:32 AM by techidave » Logged
kalos
Member
**
Posts: 1,023

View Profile Give some DonationCredits to this forum member
« Reply #3 on: February 07, 2010, 06:55:24 AM »

is anything relevant on that link? because I checked and didn't find anything
Logged
yksyks
Supporting Member
**
Posts: 469


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #4 on: February 07, 2010, 07:43:23 AM »

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.)
Logged
kalos
Member
**
Posts: 1,023

View Profile Give some DonationCredits to this forum member
« Reply #5 on: February 07, 2010, 08:30:14 AM »

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

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
Logged
yksyks
Supporting Member
**
Posts: 469


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #6 on: February 07, 2010, 03:10:18 PM »

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

If this key sequence does what you need, then record a macro, assign a hotkey to it and you're done.
Logged
jacksonp
Participant
*
Posts: 1

View Profile Give some DonationCredits to this forum member
« Reply #7 on: February 08, 2010, 05:55:05 AM »

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.
Logged
Pages: [1]   Go Up
  Reply  |  New Topic  |  Print  
 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.034s | Server load: 0.05 ]