Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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 added by Evans Otalor , Business Analyst / Facilitator , Marina Business School
Date Posted: 2013/06/14
Upvote (5) Views (33) Followers (3) Answers (15) Report Question
Write an Answer
Register now or log in to answer.
Deleted user

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

Kamran Muhammad
by Kamran Muhammad , Parts Administrator , Samaco

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

Deleted user

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

Mohamed Elkharashy
by 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
by 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
by Ali Raza Mughal , Assistant Accountant , Fazal Paper Mills (Pvt) Ltd

Ctrl+D, Ctrl+S

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

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

Salama Ibrahim
by 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
by Rahul Sharma , Manager Finance and Accounts , Gemini Impex General Trading LLC

Ctrl T,

F4,

Ctrl+`

Ctrl+;

Abdullah Alaiwat
by 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

Deleted user

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

See More Answers
Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help