Skip to main content

Excel Shortcut Keys. Did you know.

Learn imp excel shortcuts



Basic shortcuts-


To save: Ctrl + S
To open new work book- Ctrl+N
TO open existing excel file : Ctrl + O
To take exit from excel: Ctrl + W
undo or re undo: Ctrl+ Y or Ctrl + z



Advance pro shortcuts :



Move Horizontally along rows : Tab ( FORWARD )
                          : Tab +Shift ( BACKWARD )




Switch upper tabs

                 : alt + F ( FOR FILE TAB )
         : alt + H ( FOR HOME TAB )
         : alt + N ( FOR INSERT TAB )
         : alt + P ( FOR PAGE LAYOUT TAB )
             : alt + M ( FOR FORMULA TAB )
         : alt + A ( FOR DATA TAB )
         : alt + R ( FOR REVIEW TAB )
         : alt + W ( FOR VIEW TAB )


Select data Row vise: Select the starting block Press Shift + Arrow Key
Select data Column  wise: Select the starting block Press Shift + Down Arrow Key.


Select Entire Row: Shift + Space
Select entire Column : Ctrl + Space


For Select whole sheet: Ctrl + A


Designing cells or Table-


Bolt text : Ctrl + B
Italic Text: Ctrl + I
Under Lining : Ctrl + U


Colour Filling To Any Cells or Row : Alt + H + H
For Adding Border : Alt + H + B.


Date & Time Shortcuts -


For Adding Date in cells: Ctrl + ;
For Adding Time in Cells: Ctrl + Shift + ;


Save Your Time




    :  
Labels:

Comments

Post a Comment

Popular posts from this blog

WHY DO ALL CELEBRITIES HAVE IPHONES? Apple EcoSystem Explained!

WHY DO ALL CELEBRITIES HAVE IPHONES? Apple EcoSystem Explained! Celebrities use iPhone and product of apple, because of apple ecosystem,  their premiumness and apple provide best privacy among all the brands . Apple ecosystem: Apple ecosystem play a very good role to make apple popular . We can say it is perfect ecosystem   It make things more easy for you and provide continuity during work .  Apple ecosystem benefits 1) Auto unlock : If you wear your apple watch ,With the help of apple watch you can unlock your iPhone ,mac (no need of password). 2) Hand off : Apple ecosystem provides a excellent feature in which if you are hosting any web browser and you want to continue with with your mac in this case this feature helps you.\ 3) Universal clipboard : In this feature if you want to copy text by iPhone on mac . 4) Cellular calls: In which you can attend your call on apple mac (laptop). ...
Post a Comment
Read more

Bitcoin money ( Bane in India)

Bitcoin money Bitcoin money is a  cryptocurrency  .  It is a  digital currency  without a centralize  controlling authority or single administrator that can be sent from user to user on the peer-to-peer bitcoin network , without the need for intermediaries.  Bitcoin money  works similar to normal currency. It invented in 2009 . Bitcoin India In India very few peoples now about  bitcoin cash  , Indians are usually invest in gold , silver ,property etc...  It is also a thing whose value changes continuously . We can trade on  bitcoin cash. Due to current scenario the price of bitcoin  coin is approx -766000 rs. Bit coin history : Bitcoin was invented by an unknown person or group of people using the name Satoshi Nakamoto . Bitcoin cash You can transfer from your account to another directly without any mediator because it is peer to peer connect...
Post a Comment
Read more

Computer Components

Computer components roles in practical life and their value . This article will helps you as Computer buying guide . computer and laptops are majorly Computer components . CPU ( PROCESSOR) :  CPU works as a main brain of computer  and is also knows as central processing unit. CPU is processing unit which does things . It has very low data storing It mainly works as calculating data , compile files and programmes Their are mostly programmes run from CPU RAM and Hard Drive :  We can talk about both the computer components at same time Hard drive : It store your data and file in it . It has large storing space . Most of hard drive are made of  disk like structure RAM: It is other form of storage But it has less storing space as compare to hard disk . Ram is fast accessible device as compare to Hard disk. Basically it is run time storing device where your task /software take space in ram. In short RAM use for multitasking and hard disk...
Post a Comment
Read more