
Move to the previous sheet in the workbookĪccess search (when in a cell or when a cell is selected) Move to the last cell in use on the sheet Move to the edge of the current data region Perform the action assigned to the default command button (the button with the bold outline, often the OK button) Move to the previous box, option, control, or command Move to the next box, option, control, or command Work in windows and dialogsĬopy the image of the screen and save it to a Screen Shot file on your desktop.
#Excel keyboard shortcut to select worksheet Pc
Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a tab within a workbook with separate cells. Within Excel you can conduct calculations on multiple worksheets and workbooks open at the same time. Formatting Shortcuts Command + F = Find and replace values CTRL + Shift +% = Show all values as percentages CTRL + Shift + $ = Show all values as currency CTRL + Shift + = Show all values in general number format Command + Option + 0 = Apply an outline border to selected cells Command + b = Apply.



#Excel keyboard shortcut to select worksheet mac os
*Some Windows keyboard shortcuts conflict with the corresponding default Mac OS keyboard shortcuts.
