Free Excel Tips & Tricks

Subscribe to Get Daily Excel Tips & Tricks to your Inbox for Free!

Friday, June 29, 2018

MANAGING MULTIPLE WORKSHEETS USING EXCEL SHORTCUT KEYS

MANAGING MULTIPLE WORKSHEETS USING EXCEL SHORTCUT KEYS

F6 /SHIFT +F6
Purpose:Use this excel shortcut key to Move to the next pane / previous pane in a workbook that has been split.

CTRL +F4
Purpose:Use this excel shortcut key to Close the selected workbook window.

CTRL +N
Purpose:Use this excel shortcut key to Create a new blank workbook (Excel File)

CTRL +TAB /CTRL +SHIFT +TAB
Purpose:Use this excel shortcut key to Move to next / previous workbook window. Switch to the next/ previous tab in dialog box.

ALT +SPACE
Purpose:Use this excel shortcut key to Display the Control menu for Main Excel window.

CTRL +F9
Purpose:Use this excel shortcut key to Minimize current workbook window to an icon. Also restores ('un-maximizes') all workbook windows.

CTRL +F10
Purpose:Use this excel shortcut key to Maximize or restores the selected workbook window.

CTRL +F7
Purpose:Use this excel shortcut key to Move Workbook Windows which are not maximized.

CTRL +F8
Purpose:Use this excel shortcut key to Perform size command for workbook windows which are not maximized.

ALT +F4
Purpose:Use this excel shortcut key to Close Excel.

No comments:

Post a Comment

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2 Purpose: Use this excel shortcut key to Edit the active cell with cursor at end of the line. ALT +ENTER Purpose: Use this exc...