excel tip & excel forum shortcuts ... 250 ms-excel keyboard shortcuts

17
Excel Tip & Excel Forum [www.exceltip.com | www.exceforum.com] Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation 250 Ms-Excel Keyboard Shortcuts

Upload: vantram

Post on 13-Apr-2018

326 views

Category:

Documents


16 download

TRANSCRIPT

Page 1: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

Excel Tip & Excel Forum

[www.exceltip.com | www.exceforum.com]

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

250 Ms-Excel Keyboard Shortcuts

Page 2: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 2

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

© 2015 www.excelforum.com & www.exceltip.com

Self-Publishing

ALL RIGHTS RESERVED. This book contains material protected under International and

Federal Copyright Laws and Treaties. Any unauthorized reprint or use of this material is

prohibited. No part of this book may be reproduced or transmitted in and form or by any

means, electronic or mechanical, including photocopying, recording, or by any information

storage and retrieval system without express written permission from the author /

publisher.

The information in this book is provided on as-is basis. The authors and publisher shall have

neither liability nor responsibility to any person or entity with respect to any loss or

damages arising from the information contained in this book.

Author- Excel Forum.com and Exceltip.com

Cover Design-excelforum.com

Published by- Self-publishing

First Published in- May-2015

Page 3: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 3

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

Microsoft Excel having so many unbelievable

capabilities that are not instantly perceived.

Shortcut keys are most useful and usable to save

the time.

Shortcut keys help to provide an easier and usually quicker method of directing and

finishing commands in Microsoft Excel. Mostly we prefer to use the shortcuts as it’s kind of

amazing how much time we can save by not using the mouse clicks. Shortcut keys are

commonly accessed by using the ALT, Ctrl, Shift, Function key and Window key.

We really liked that windows gives us multiple ways to perform the task in Excel, let’s say

we want to save a file, either we can press the key “Ctrl+S” or “Shift+F11”.

Page 4: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 4

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

Index

Keyboard shortcuts for Dialog Box..........................................................................................5

Entering Data shortcuts...........................................................................................................5

File Commands……………………………………………………………………………..…………………………………...6

Keyboard shortcuts for Format...............................................................................................7

Formulas shortcuts..................................................................................................................8

General keyboard shortcuts....................................................................................................9

Important Hot Keys...............................................................................................................11

Shortcuts for Navigating........................................................................................................13

Keyboard shortcuts for selecting rows/column/cell …………………………………………..…………….14

Window shortcut keys………………………………………………………………………………………………………16

Workbook shortcut keys…………………………………………………………………………………..………………17

Page 5: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 5

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

Keyboard shortcuts for Dialog Box:-

Entering Data shortcuts:-

Page 6: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 6

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

File Commands:-

Page 7: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 7

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

Keyboard shortcuts for Format:-

Page 8: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 8

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

Formulas shortcuts:-

Page 9: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 9

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

General keyboard shortcuts:-

Page 10: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 10

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

Page 11: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 11

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

Important Hot Keys:-

Page 12: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 12

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

Page 13: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 13

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

Shortcuts for Navigating:-

Page 14: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 14

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

Keyboard shortcuts for selecting rows/column/cell

Page 15: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 15

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

Page 16: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 16

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

Window shortcut keys:-

Page 17: Excel Tip & Excel Forum shortcuts ... 250 Ms-Excel Keyboard Shortcuts

www.exceltip.com / www.excelforum.com 250 MS Excel Keyboard Shortcuts 17

Copyright © 2003 ExcelTip.com, Excelforum.com registered trademark of Microsoft Corporation

Workbook shortcut keys:-