Facebook X (Twitter) Instagram
    CareerbeginnerCareerbeginner
    • Bachelors
    • Masters
      • Entrepreneurship
    • Postgraduate
      • Fellowships
      • Research
    • Contests
      • Grants
    • Internships
    • Career tips
    • Blog
    Sign in
    CareerbeginnerCareerbeginner
    Home»School News»Top 20 Excel Shortcuts for Your Everyday Use
    School News

    Top 20 Excel Shortcuts for Your Everyday Use

    Faith JamesBy Faith James4 Mins Read
    Share Facebook Twitter WhatsApp Telegram
    Share
    Facebook Twitter WhatsApp Telegram

    Top 20 Excel Shortcuts for Your Everyday Use: Microsoft Excel is a spread sheet application package which holds a full workbook.

    Excel is a spread sheet application package that is used for calculating, analyzing and manipulating of data.

    The work book in excel could carry about 99 more sheets in it.

    RECOMMENDED: How To Edit Tables In Microsoft Word

    • Top 20 Excel Shortcuts for Your Everyday Use.
    • More on Excel Shortcuts for Your Everyday Use.

    Top 20 Excel Shortcuts for Your Everyday Use.

    Every computer package have shortcut keys which makes it working on system easy and faster.

    Below are the top most twenty shortcut keys in Excel for your everyday use.

    1.  Cut, copy, paste – Ctrl X, C, V (For Mac book, Command can be substituted for the control key). These are basic shortcuts keys we will use on daily basis.
    2.  Extend selection – Control Shift arrow keys (For Mac book, Command can be substituted for the control key).
    3.  Paste Special – Control + Alt + V (Mac: Control + Command + V). The Paste Special have a great touch on the copied item which makes it easy in pasting values, formulas,  formatting, and column widths as well.
    4.  Fill down – Control D.  This fills the typed text on the columns or rows below, rightward and leftward.
    5.  Toggle formula references – F4 (Mac: Command Shift T). Examples of reference options are: A1, $A$1, $A1, A$1.
    6.  Autosum – Alt = sums up the figures typed in a sheet. (Mac: Command + T).
    7.  Toggle filters – Control + Shift + L (Mac: Command + Shift + F).
    8.  Current date and time – Control + ; (date) Control + Shift + : (time). This inserts dates and time instantly.
    9.  Select all – Control A (Mac: you can also use Command). This shortcut highlights all the visible area on the spread sheet.
    10.  Go to first cell / last cell – Control + Home, Control + End. (Mac: fn + Control + left arrow, fn + Control + right arrow.

    More on Excel Shortcuts for Your Everyday Use.

    11.  Repeat last action – F4 or Control Y (Mac: Command + Y). This is another pattern of retrieving a lost data.

    12. Data navigation – Control + arrow key(s) (Mac: you can also use Command).

    13.  Fill handle – double click that little square at the bottom right of any selection.

    14.  Insert / delete columns and rows – To insert: with an entire row or column selected, use Control+ Shift ++ (Mac: Control + I, but in 2016, same as Win) . To delete: with an entire row or column selected, use Control + – .

    15.  Edit cell – F2 (Mac: control + U) to enter “edit mode” for the active cell without taking your hands still placed on the keyboard.

    16.  Enter multiple cells – Control + Enter. Want to fill in the same value or formula in more cells at once, use Contril + Enter key.

    17.  Format cells – Control + 1 (Command + 1). To format anything on excel use the control simultaneously with number 1 for this effect.

    18.  Select visible cells only – Alt + ; (Mac: command + shift + Z). This prevents copying out any data on hidden rows and columns. The visible will be copied only.

    19.  New Table – Control + T. This action inserts a new table in your work sheet and you can also manipulate the rows and columns as you desire.

    20.  Toggle formulas on and off – Control + `. This displays all the formulas used in a particular work sheet.

    Note that double tapping of a shortcut key activates and also deactivates the feature if tapped or pressed twice.

    You May Also Like:

    • How To Transfer Money Using Mobile Phone in Nigeria
    • How To Screen Record With Mobile Phone
    • Complete List Of All Nigeria Bank USSD Codes (Mobile Banking)
    • How To Use GTCO Bank Mobile App
    • How To Transfer INEC Voters Data To Another Polling Unit
    Share. Facebook Twitter WhatsApp Telegram LinkedIn
    Previous ArticleHow To Edit Tables In Microsoft Word
    Next Article How To Add Animations To PowerPoint Slide Show

    Recommended Opportunities

    Top 10 Fully Funded Scholarships 2024

    Low-tuition Universities in Australia for International Students

    Ogun BECE Timetable 2023

    Ogun Basic Education Certificate Exam (BECE) Timetable 2023

    Lagos BECE (Junior WAEC) Timetable 2023

    Lagos BECE (Junior WAEC) Timetable 2023

    Nda 76th Regular Course Admission Application Form 2024/2025

    NDA 76th Regular Course Admission Application Form 2024/2025

    UNIUYO Commences Sale of JUPEB/IJMB Admission Form 2023/2024

    BSU Debunks Fake Admission News for 2023/2024 Session

    Add A Comment

    Comments are closed.

    Related Scholarships
    Top 10 Scholarships in the USA
    Top 10 Scholarships in the USA for International Students
    September 19, 2023
    Top 10 Reputable Scholarships
    Top 10 Reputable Scholarships for International Students
    September 19, 2023
    top 10 scholarships in canada for international students
    Top 10 Scholarships in Canada for International Students
    September 16, 2023
    Top 10 Scholarships in Switzerland
    Top 10 Scholarships in Switzerland for International Students
    September 16, 2023
    Top 25 University wide Scholarships for International Students
    Top 25 University-wide Scholarships for International Students
    September 15, 2023
    Scholarships Lists
    Bracu International Scholarships For Developing Countries

    BracU International Scholarships for Developing Countries

    July 12, 2023
    Opportunity Mannheim Scholarship 2023/2024

    Opportunity Mannheim Scholarship 2023/2024

    July 12, 2023
    Top 10 Fully Funded Scholarships 2024

    Low-tuition Universities in Australia for International Students

    July 3, 2023
    Csir Bursary Programme For African Students 2023/2024

    CSIR Bursary Programme for African Students 2023/2024

    July 3, 2023
    Careerbeginner
    Facebook X (Twitter) Instagram Pinterest
    • About
      • Contact
        • Disclaimer
          • Refund Policy
            • Privacy Policy
              © 2023 Careerbeginner.com. Designed by HE-Reigns Computers.

              Type above and press Enter to search. Press Esc to cancel.

              Sign In or Register

              Welcome Back!

              Login to your account below.

              Lost password?