what are your favourite and most used Excel short cuts?

Question

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

مستخدم محذوف‎ · Answer

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

Kamran Muhammad · Answer

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

مستخدم محذوف‎ · Answer

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

Mohamed Elkharashy · Answer

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 · Answer

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 · Answer

Ctrl+D, Ctrl+S

Kaamila Tahseen · Answer

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

Salama Ibrahim · Answer

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

Rahul Sharma · Answer

Ctrl T,

F4,

Ctrl+`

Ctrl+;

Abdullah Alaiwat · Answer

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

مستخدم محذوف‎ · Answer

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

خدمات بيت.كوم

استخدم تطبيق بيت.كوم

ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

what are your favourite and most used Excel short cuts?

عمليات البحث الشائعة

المزيد من الأسئلة المماثلة