+ Reply to Thread
Results 1 to 2 of 2

Favorite Shortcuts?

  1. #1
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,516

    Favorite Shortcuts?

    Anyone have any favorite shortcuts in Excel.

    1. The Quick Access Toolbar: I can't believe how many people don't use this. There's so many shortcuts that can be added that are buried on the ribbon or even not on the ribbon.

    2. Used the most: Navigation shortcuts like Home, End, CNTRL + Home, CNTRL + End, CNTRL + Arrow, CNTRL + PgUp/PgDown. (Drives me crazy when people slow scroll through data as I wait. LOL)
    CNTRL + ; or : for current date or time (or both)
    F5 (GoTo) > "Special" to select Data Validation, blanks, etc.

    3. One I use that I don't see a lot of other people using: CNTRL + . for maneuvering to the 4 corners of current range. Great for making sure you have the complete range selected or for moving to furthest reaches of your data when there are a lot of blanks so CNTRL + Arrow is not efficient.

    4. One that a lot of people use but I don't: F10 and then letters to access specific commands on the ribbon (or numbers to access Quick Access Toolbar).

    Thoughts?
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,915

    Re: Favorite Shortcuts?

    plus the age old
    CTRL C (copy)
    CTRL V (paste)
    CTRL X (cut)
    CTRL P (print)
    CTRL B (bold)
    CTRL I (italic)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Favorite Free Utilities
    By dflak in forum The Water Cooler
    Replies: 3
    Last Post: 06-21-2016, 09:50 AM
  2. Add in with favorite files and folders
    By Bishonen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-21-2015, 04:15 AM
  3. My favorite Date Format
    By Queenofmycastle in forum Excel General
    Replies: 4
    Last Post: 06-29-2015, 03:29 PM
  4. Windows 8 Shortcuts Interfering with Excel Shortcuts
    By Linda Campbell in forum Excel General
    Replies: 4
    Last Post: 05-12-2015, 01:12 AM
  5. Replies: 1
    Last Post: 08-30-2013, 04:38 PM
  6. Favorite Webcomics!
    By tigeravatar in forum The Water Cooler
    Replies: 4
    Last Post: 10-31-2012, 10:26 AM
  7. Favorite Comedian(s)
    By davegugg in forum The Water Cooler
    Replies: 12
    Last Post: 11-22-2010, 09:39 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1