Just In
- 9 min ago Samsung Galaxy C55 Launches Exclusively in China: Leather Back, Snapdragon 7 Gen 1, and Up to 12GB RAM
- 33 min ago Apple Reportedly Skipping M3 Mac Mini Models: M4-Powered Variants Could Arrive in Late 2024
- 49 min ago Meta Quest OS is now Opened to Third-Party Hardware Manufacturers: Rebranded as Meta Horizon OS
- 1 hr ago Infinix GT 20 Pro Schematic Shows Rear Panel Design; Expected to Launch on April 28
Don't Miss
- Finance Reliance Industries Sets Record: First Indian Company Tops Rs 1L Cr Profit
- News Lok Sabha Polls: 390 Crorepatis In Fray In 2nd Phase: Who Is The Richest?
- Education JEE Mains Results 2024 to be declared Soon at jeemain.nta.ac.in , Check the Date here
- Sports IPL 2024: 'Not Only T20 World Cup Spot, Should Be Groomed As Captain After Rohit' - Harbhajan on Sanju Samson
- Movies Anne Hathaway REVEALS 'Gross' Hollywood Audition Practices, Know What Bizarre Thing Happened With Oscar-Winner
- Automobiles 2024 Isuzu D-Max V-Cross Facelift: What To Expect From The Latest Updates
- Lifestyle What Your Tongue Reveals About Your Health: Wellness And Warning Signs You Need To Know
- Travel Kurnool's Hidden Gems: A Guide To Exploring India's Lesser-Known Treasures
15 Keyboard Shortcuts To Master Microsoft Excel
Microsoft's Excel is the basic and most widely used software worldwide. We all know that it features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Well, it is hard to master the Microsoft Excel. There are tons of shortcuts for Excel, but trying to learn every single shortcut on the spreadsheet can be overwhelming and confusing as well.
SEE ALSO: 10 Ways iOS 9 Will Change Apple iPhone 6s Experience
We have put together a list of shortcuts that will be useful for most users. These keyboard shortcuts includes a quick way to format cell, navigate to sheets and to operate more easily. Read on to know the useful shortcuts.
Access to ribbon: Microsoft Excel 2013 and later have a feature called Key Tips, when the new tool appears press Alt to get the corresponding menu on Ribbon.
Ctrl + Page Down: will switch between worksheet tabs (left to right)
Ctrl + Page Up: will switch between worksheet tabs (right to left)
F12: "Save As" window.
Ctrl + Shift + $: Current cell formatted as currency.
Ctrl + Shift + %: Current cell formatted as percentage.
Ctrl + Shift + #: Current cell formatted as date with day, month, year.
Ctrl + Shift + ":": Insert current time.
Ctrl + Shift + ";": Insert current date.
F4: Repeats the last command or action.
Shift + Arrow key: Extends your current cell selection by one addition cell in the direction specified.
Ctrl + F1: Display or hide the Ribbon.
Alt + Shift + F1: Insert a new worksheet tab.
Ctrl + F4: Close the current workbook.
Ctrl + D: Launches the Fill Down command for the selected cells below.
-
99,999
-
1,29,999
-
69,999
-
41,999
-
64,999
-
99,999
-
29,999
-
63,999
-
39,999
-
1,56,900
-
79,900
-
1,39,900
-
1,29,900
-
65,900
-
1,56,900
-
1,30,990
-
76,990
-
16,499
-
30,700
-
12,999
-
14,999
-
26,634
-
18,800
-
62,425
-
1,15,909
-
93,635
-
75,804
-
9,999
-
11,999
-
3,999