BNET_Free_Excel_Keyboard_Shortcuts

BNET_Free_Excel_Keyboard_Shortcuts - 85+ Keyboard Shortcuts...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Version 2 February 27, 2007 Formatting Keystroke Function [Ctrl]B Bold the selection [Ctrl]I Italicize the selection [Ctrl]U Underline the selection [Ctrl]5 Strike through the selection [Alt] and ' Open the Style dialog box [Ctrl]1 Open the Format Cells dialog box [Ctrl][Shift]~ Apply General format [Ctrl][Shift]$ Apply Currency format [Ctrl][Shift]% Apply percentage format [Ctrl][Shift]# Apply Date format [Ctrl][Shift]@ Apply Time format [Ctrl][Shift]! Apply Number format [Ctrl][Shift]^ Apply Exponential number format [Ctrl][Shift]& Apply an outline border to selection [Ctrl][Shift] and _ Remove outline border from selection Navigation Keystroke Function [Ctrl][Page Down] Move to the next worksheet in a workbook [Ctrl][Page Up] Move to the previous worksheet in a workbook 85+ Keyboard Shortcuts for Microsoft Excel Page 1 Copyright ©2007 CNET Networks, Inc. All rights reserved. For a free BNET membership, please visit http://jobfunctions.bnet.com/register.aspx
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
85 Keyboard Shortcuts for Microsoft Excel Page 2 Copyright ©2007CNET Networks, Inc. All rights reserved. For a free BNET membership, please visit www.bnet.com [Ctrl][F6] Cycle between open workbooks Arrow keys Move one cell up, down, left, or right Navigation (continued) [Ctrl] and an arrow key Move to the edge of the data region [Home] Move to the beginning of a row [Ctrl][Home] Move to the beginning of a worksheet [Ctrl][End] Move to the end of the used portion of a worksheet [F6] Move between panes in a split worksheet [Ctrl][Backspace] Display the active cell [Enter] Move down a cell in a selected range [Shift][Enter] Move up a cell in a selected range [Shift][Tab] Move one cell to the left in a selected range [Ctrl] and . (period) Move from corner cell to corner cell in a selected range Selection techniques Keystroke Function [Shift][Spacebar] Select a row [Ctrl][Spacebar] Select a column [Ctrl]A
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/06/2008 for the course COMP 100 taught by Professor None during the Spring '08 term at DeVry Cincinnati.

Page1 / 5

BNET_Free_Excel_Keyboard_Shortcuts - 85+ Keyboard Shortcuts...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online