Skip to main content

Microsoft Excel Shortcut Keys

The followings are Microsoft Excel shortcuts. Some short-cuts might be version specific.
Use at your own risk.
Mouse shortcuts
ShortcutDescription
Double-click (on a cell)Edit the cell contents.
Double-click (on a row/column divider)Adjust height/width to auto-fit
High-light headers of multiple rows/columns then Double-click on a row/column dividerAdjust height/width to auto-fit of all high-lighted rows/columns
Triple-clickSelect the entire contents in the cell
Click on row/column divider then dragAdjust height/width of the row/colunn
High-light headers of multiple rows/columns then Click on row/column divider then dragAdjust height/width of the rows/colunns
Ctrl + Mouse wheelZooms in and out of document.
Hold Shift + Click the cellsSelect multiple cells

Keyboard shortcuts
ShortcutDescription
F2Edit the selected cell.
F5Goto a specific cell. For example, C6.
F7Spell check selected text and/or document.
F11Create chart.
Ctrl + ASelect all.
Ctrl + BBold.
Ctrl + CCopy.
Ctrl + FFind (same as Shift + F5).
Ctrl + GGo To.
Ctrl + HReplace.
Ctrl + IItalic.
Ctrl + KInsert link.
Ctrl + NNew Workbook.
Ctrl + OOpen Workbook.
Ctrl + PPrint dialog.
Ctrl + SSave.
Ctrl + UUnderline.
Ctrl + VPaste.
Ctrl + ZUndo.
Ctrl + YRedo.
Ctrl + XCut.
Ctrl + 5Strikethrough text.
Ctrl + F3Define Name.
Ctrl + F4Exit Excel.
Ctrl + F6Switch between open workbooks.
Ctrl + F9Minimize current window.
Ctrl + F10Maximize current window.
Shift + F1Activate Help on Item.
Shift + F2Insert Comments
Shift + F3Insert Function.
Ctrl + Shift + ;Enter the current time.
Ctrl + ;Enter the current date.
Ctrl + Page downMove to next worksheet.
Ctrl + Page upMove to previous worksheet.
Ctrl + Shift + #Number Format: Date
Ctrl + Shift + @Number Format: Time.
Ctrl + Shift + !Number Format: Commas.
Ctrl + Shift + $Number Format: Currency
Ctrl + Shift + %Number Format: Percentage
Ctrl + Shift + ^Number Format: Scientific.
Ctrl + SpaceSelect entire column.
Shift + SpaceSelect entire row.
Ctrl + (Arrow key)Move to next section.

Comments

Post a Comment

Popular posts from this blog

KGB ARCHIVER: COMPRESS 1GB FILE TO 10MB

KGB Archiver: Compress 1GB File to 10MB KGB Archiver is free and open source software which compresses 1GB file to 10MB file. Data compression utility of this software is based on PAQ6 algorithm which has AES-256 powerful encryption. KGB archiver works on both Windows and Linux operating system. Compression ratio of this software is very high. Due to high compression levels, time to compress a file goes high as the size of the file increases and compression ratio may vary depending on the format of the file. When a file is compressed with KGB Archiver it saves it with own extension and at the time of decompression it automatically recognizes the file format. The only limitation of KGB archiver is, decompressed file cannot be open or extract with other compression softwares. You can also choose any compression level (high, maximum, normal, low, very weak) to compress a file but the compression time  will vary according to your selected compression level. Note:  If you are...
Post a Comment
Read more

What are the best ideas for earning money online?

There are many ways to earn online but some useful ideas which really makes money but if you really wants earning for long term you should go for the one as below Freelancing: Offer your skills on platforms like Upwork or Fiverr. Online tutoring: Teach a subject you excel in through websites like Chegg Tutors or Tutor.com. Content creation: Start a blog, YouTube channel, or podcast to share your expertise or interests. Affiliate marketing: Promote products and earn commissions through affiliate programs. Remote work: Explore remote job opportunities on platforms like Remote OK or FlexJobs. E-commerce : Sell products on platforms like Etsy, eBay, or Amazon. Stock photography: If you're a photographer, sell your photos to stock websites. Online courses: Create and sell courses on platforms like Udemy or Teachable. Virtual assistance: Provide administrative support to businesses as a virtual assistant. Social media management: Offer social media management services to businesses and ...
Post a Comment
Read more

History of computer technology

History of computer technology [ edit ] Main article:  History of computing hardware Devices have been used to aid computation for thousands of years, probably initially in the form of a  tally stick . [7]  The Antikythera mechanism , dating from about the beginning of the first century BC, is generally considered to be the earliest known mechanical  analog computer , and the earliest known geared mechanism. [8]  Comparable geared devices did not emerge in Europe until the 16th century, [9]  and it was not until 1645 that the first mechanical calculator capable of performing the four basic arithmetical operations was developed. [10] Electronic computers, using either relays or valves, began to appear in the early 1940s. The electromechanical  Zuse Z3 , completed in 1941, was the world's first  programmable  computer, and by modern standards one of the first machines that could be considered a complete  computing  machine....
Post a Comment
Read more