EXCEL SHORT COMMANDS

-

  © 2022. All Rights Reserved.  SAMPURNA PAINULY      DATE: 25/05/2022

                        S.S.COMPUTER  SAHASPUR DEHRA DUN UTTRAKHAND  

Share on ➔ Twitter Facebook Google Plus

 

                                      EXCEL COMMANDS

1.       CTRL+Q , CTRL+B – BOLD

2.       CTRL+X – CUT

3.       F11 – TO OPEN CHART

4.       CTRL +F1 – TO MINIMIZE OR MAXIMIZE MENU BAR

5.       CTRL +F3 – NAME MANAGER

6.       CTRL +K – TO INSERT HYPERLINK

7.       CTRL +D – DUPLICATE VALUE

8.       F12 – SAVE AS

9.       F5 – GO TO

10.   F1 – HELP FILE

11.   CTRL + F9 – REMOVE EXCEL SHEET

12.   ALT +F10 – SELECTION AND VISIBILITY

13.   ALT + = - AUTOSUM

14.   CTRL +F2 – PRINT

15.   CTRL + SHIFT+ F – CELL FORMATTING

16.   SHIFT + F5, CTRL + H – FIND AND REPLACE

17.   CTRL + SHIFT+ N – BORDER

18.   CTRL + T – TABLE

19.   CTRL + O – OPEN FILE

20.   CTRL + U, CTRL + 4 – UNDERLINE

21.   CTRL + :  - DATE

22.   CTRL + \ - CONDITIONAL FORMATTING

23.   CTRL + SHIFT+ % - FOR APPLYING PERCENTAGE

24.   SHIFT + F2 – COMMENT

25.   CTRL + ~ - ENLARGEMENT OF CELL

26.   = TODAY() – DATE

27.   CTRL + ` - ENLARGEMENT OF CELL

28.   ALT + F +A –MICRO

 

 

Comments

Post a Comment

Popular posts from this blog

D.C.A.ST -5

-
S.S.COMPUTER EDUCATION INST. SUBJECT:--- D.C..A. MARKS --100 TIME :---1 HRS Index => S.S.COMPUTER EDUCATION INST. SUBJECT:--- D.C..A. MARKS --100 TIME :---1 HRS ONLINE PAPER    The question consists of 100 questions and it divided into four section .each question to be 1 marks. 0.25 will be cut on double clicking note:---- All types of exam material note book, wrist watch, digital things, paper will be prohibited during the exam in examination centre . Show all questions <=   => scenario manager using for ........................ ?   setting customer demond ?   setting low cost ?   setting high cost ?   setting market value Goal seek is one of the option ,which is .......................... ?   calculates the input value ?   calculates the out put value ?   calculate the input and out value based...
Read more

D.L.TEST EXAMINATION 2024

-
car driving test ex.( sscomputer) Index => car driving test ex.( sscomputer) driving test    Show all questions <=   => Traveling at 60 km /h ,how far will your vehicle travel in a single second ? ?   at 60 km you will cover 16 min by car ?   at 50km you are driving on a dark road at night ,when you see another vehicle approaching .what should you do ? ?   switch the high beam headlights ?   turn off your headlight ?   switch to low beam headlight ?   sound your horn long and hard you see a blind person holding up their white cane at the roadside .what should you do. ? ?   shout a warning from your window ?   accelerate to get past them quickly ?   stop and let them cross ?   move to the other side of the road to avoid them which signals should you make if you are go...
Read more

set cdr-1

-
sscomputer corel drew paper set -01 Index => sscomputer corel drew paper set -01 sscomputeredu.com    note book, digital watch, calculator is prohibited during the exam. Show all questions <=   => what is the shortcut key to combine the selected objects ? ?   ctrl+y ?   ctrl+q ?   ctrl+ l ?   ctrl+k what is the shortcut key to toggle snapping to objects ?   ALT+shift+D ?   alt+z ?   ctrl+g ?   ctrl+l what is the shortcut key to specifies fountain flits for objects ?   CTRL+b ?   f11 ?   alt+f4 ?   f6 spacebar toggles between the current tool and the pick tool ?   True ?   False F3 the shortcut key to zoom in on all objects in the drawing ?   True ?   False What is the shortcut key to display a full screen...
Read more