Bayt.com

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

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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
تم إضافة السؤال من قبل Evans Otalor , Business Analyst / Facilitator , Marina Business School
تاريخ النشر: 2013/06/14
التصويت كمفيد (5) المشاهدات (33) المتابعون (3) الإجابات (15) بلّغ عن السؤال
أضف إجابة
أنشئ حسابًا أو سجّل الدخول للإجابة
Kamran Muhammad
من قبل Kamran Muhammad , Parts Administrator , Samaco

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

Mohamed Elkharashy
من قبل 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
من قبل 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
من قبل Ali Raza Mughal , Assistant Accountant , Fazal Paper Mills (Pvt) Ltd

Ctrl+D, Ctrl+S

Kaamila Tahseen
من قبل Kaamila Tahseen , Change Management Team Manager , cognizant technology solutions

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

Salama Ibrahim
من قبل 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
من قبل Rahul Sharma , Manager Finance and Accounts , Gemini Impex General Trading LLC

Ctrl T,

F4,

Ctrl+`

Ctrl+;

Abdullah Alaiwat
من قبل 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

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

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

المزيد من الإجابات
أضف إجابتك
المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟

طلب المساعدة