Bayt.com

Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

what are your favourite and most used Excel short cuts?

I personally use ALT + es (paste special), CTRL+1 (Format), F4 (to change cell reference),

Microsoft Excel Financial Modeling
user-image
Question ajoutée par Evans Otalor , Business Analyst / Facilitator , Marina Business School
Date de publication: 2013/06/14
Apprécier (5) Vues (32) Suiveurs (3) Réponses (15) Report Question
Ajoutez Une Réponse
Inscrivez-vous ou connectez-vous pour répondre.
Raja Meziou

ctrl+c ,  ctrl+x, ctrl+v, ctrl+a

Kamran Muhammad
par Kamran Muhammad , Parts Administrator , Samaco

Ctrl+S, Ctrl+C, Ctrl+V, Ctrl+D

Utilisateur supprimé
par Utilisateur supprimé

Mine are Ctrl+F2, F12, Ctrl+F6 and Ctrl+F10

Mohamed Elkharashy
par Mohamed Elkharashy , Production Planning Engineer , Amiantit

Ctrl+ L  to create a list

Ctrl+` to Show formulas

Ctrl+; to insert todays date

F11 to insert a chart

F12 to Save As

Samiha Ali
par Samiha Ali , Commercial Manager , Cloud chip

CRTL O , CRTL K , CRTL T , CRTL X , CRTL V , CRTL C , ....however in excel2010 u don need much of a hassle to remember the shortcut as it is provided with tabs and shortcut for all formulas..

Ali Raza Mughal
par Ali Raza Mughal , Assistant Accountant , Fazal Paper Mills (Pvt) Ltd

Ctrl+D, Ctrl+S

Kaamila Tahseen
par Kaamila Tahseen , Change Management Team Manager , cognizant technology solutions

Ctrl+Page Up/Down, Alt Tab, Ctrl+Alt+Del

Salama Ibrahim
par Salama Ibrahim , Document Control Superintendent , El Sewedy Power Consortium of MITSUBISHI POWER

CTRL+C CTRL+V CTRL+S CTRL+D ALT+D+FF ALT+F4 CTRL+F CTRL+A CTRL+HOME CTRL+END

Rahul Sharma
par Rahul Sharma , Project Head & Finance Manager , Rays Power Private Limited

Ctrl T,

F4,

Ctrl+`

Ctrl+;

Abdullah Alaiwat
par Abdullah Alaiwat , Database Technical Team Leader , ESKADENIA Software

the excel2007 give you every thing you want by just holding and dragging the mouse pointer..
:) enjoy it

Utilisateur supprimé
par Utilisateur supprimé

Try this one:  Shift + F6 or F10: It will show u all the options or you can use the below functions

1.       Alt + H = All Options in Home

Cut, Copy, Paste, Format Painter, Font Options, Font Size, Format adjustments, etc

2.       Alt + N = All Insert Options

Insert Table, Pivot Table, Shapes, symbols, Word Arts, Headers, Footers, etc

3.       Alt + P = Page Layout Options

Colors, Fonts, Themes, Margins, Orientation, Size, etc

4.       Alt + M for Formulas, Alt + A for Data Options, etc.

5.       Alt + O + C + A = to expand the cell

6.       Shift + F2 = Insert/Edit Comment

7.       Shift + F3= Search for a mathematical function

8.       Alt + F4 = To Close the Excel Program

9.       Ctrl + F  or Shift + F5 = Search Option

10.   Ctrl + H = To Replace

11.   Shift + F11= for New Excel Sheet

12.   Ctrl + Page Up = To see front Excel sheets

13.   Ctrl + Page Down =  To see Back Excel sheets

14.   Ctrl + P = Print

15.   Ctrl + F2 = Print Preview

16.   Ctrl + D = To paste the above the cell without copying

17.   Ctrl + F9 = Minimise the Excel Sheet

18.   Ctrl + F12 = To save the file in certain destination

19.   Ctrl + - (Subtract symbol) = To delete the Cell/Row/Column

20.   Alt + I + E = To Insert Cell/ Row/ Column

21.   Shift + Space bar = To Select the Entire Row

22. Ctrl + Space bar = To Select the Entire Column

Plus de Réponses
Ecrivez Votre Réponse
More Questions Like This