+ Reply to Thread
Results 1 to 9 of 9

Favorite Shortcuts?

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

    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 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    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

  3. #3
    Forum Contributor
    Join Date
    03-11-2021
    Location
    india
    MS-Off Ver
    365
    Posts
    154

    Re: Favorite Shortcuts?

    ALT ; (select visible cells)
    ALT F4 (cycle absolute cell referencing)
    ALT ENTER (new line while writing formula)
    CTRL ` (show formulas/values)
    CTRL ENTER (populate all selected cells)
    CTRL H (replace (find))

    Mouse wheel roll over ribbon to change tabs
    SHIFT with column drag to move columns
    CTRL+drag worksheet tab to duplicate

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Favorite Shortcuts?

    And also Shift+Enter for pasting and ALT+= for Autosum
    Last edited by Pepe Le Mokko; 06-21-2021 at 02:36 AM.

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

    Re: Favorite Shortcuts?

    @Mingeita
    F4 cycles through anchoring. ALT F4 closes active workbook unless I am missing something?

  6. #6
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Favorite Shortcuts?

    Alt-F11

    of course



  7. #7
    Registered User
    Join Date
    06-30-2021
    Location
    Wales
    MS-Off Ver
    365 For Enterprise
    Posts
    9

    Re: Favorite Shortcuts?

    Quote Originally Posted by Mingeita View Post
    Mouse wheel roll over ribbon to change tabs
    Brilliant! Didn't know that functionality was available. That's a good 'un. Thank you.

  8. #8
    Registered User
    Join Date
    09-01-2021
    Location
    Canada
    MS-Off Ver
    10
    Posts
    2

    Re: Favorite Shortcuts?

    Could you please describe where these labels are located? I can't find them.

  9. #9
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,956

    Re: Favorite Shortcuts?

    Ctrl+[ to follow link, Ctrl+] to go back
    After Ctrl+C to copy, Ctrl+Alt+V to paste special

+ 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