Ctrl U For Mac - Moxaest

moxaest Menu To use a keyboard shortcut, press and hold one or more modifier keys and then press the last key of the shortcut. For example, to use Command-C (copy), press and hold the Command key, then the C key, then release both keys. Mac menus and keyboards often use symbols for certain keys, including modifier keys:Windows Action. Mac OS Action. Move focus to the next or previous row when in the body of the file list on the left. Up Arrow or Down Arrow. Up Arrow or Down Arrow. If pressed in the body of the file list, navigate one level up from within a folder.On keyboards made for Windows PCs, use the Alt key instead of Option, and the Windows logo key instead of Command.Some keys on some Apple keyboards have special symbols and functions, such as for display brightness , keyboard brightness , Mission Control, and more. If these functions aren't available on your keyboard, you might be able to reproduce some of them by creating your own keyboard shortcuts. To use these keys as F1, F2, F3, or other standard function keys, combine them with the Fn key.

Cut, copy, paste, and other common shortcuts

• Command-X: Cut the selected item and copy it to the Clipboard.
• Command-C: Copy the selected item to the Clipboard. This also works for files in the Finder.
• Command-V: Paste the contents of the Clipboard into the current document or app. This also works for files in the Finder.
• Command-Z: Undo the previous command. You can then press Shift-Command-Z to Redo, reversing the undo command. In some apps, you can undo and redo multiple commands.
• Command-A: Select All items.
• Command-F: Find items in a document or open a Find window.
• Command-G: Find Again: Find the next occurrence of the item previously found. To find the previous occurrence, press Shift-Command-G.
• Command-H: Hide the windows of the front app. To view the front app but hide all other apps, press Option-Command-H.
• Command-M: Minimize the front window to the Dock. To minimize all windows of the front app, press Option-Command-M.
• Command-O: Open the selected item, or open a dialog to select a file to open.
• Command-P: Print the current document.
• Command-S: Save the current document.
• Command-T: Open a new tab.
• Command-W: Close the front window. To close all windows of the app, press Option-Command-W.
• Option-Command-Esc: Force quit an app.
• Command–Space bar: Show or hide the Spotlight search field. To perform a Spotlight search from a Finder window, press Command–Option–Space bar. (If you use multiple input sources to type in different languages, these shortcuts change input sources instead of showing Spotlight. Learn how to change a conflicting keyboard shortcut.)
• Control–Command–Space bar: Show the Character Viewer, from which you can choose emoji and other symbols.
• Control-Command-F: Use the app in full screen, if supported by the app.
• Space bar: Use Quick Look to preview the selected item.
• Command-Tab: Switch to the next most recently used app among your open apps.
• Shift-Command-5: In macOS Mojave or later, take a screenshot or make a screen recording. Or use Shift-Command-3 or Shift-Command-4 for screenshots. Learn more about screenshots.
• Shift-Command-N: Create a new folder in the Finder.
• Command-Comma (,): Open preferences for the front app.

Sleep, log out, and shut down shortcuts

You might need to press and hold some of these shortcuts for slightly longer than other shortcuts. This helps you to avoid using them unintentionally.

• Power button: Press to turn on your Mac or wake it from sleep. Press and hold for 1.5 seconds to put your Mac to sleep.* Continue holding to force your Mac to turn off.
• Option–Command–Power button* or Option–Command–Media Eject : Put your Mac to sleep.
• Control–Shift–Power button* or Control–Shift–Media Eject : Put your displays to sleep.
• Control–Power button* or Control–Media Eject : Display a dialog asking whether you want to restart, sleep, or shut down.
• Control–Command–Power button:* Force your Mac to restart, without prompting to save any open and unsaved documents.
• Control–Command–Media Eject : Quit all apps, then restart your Mac. If any open documents have unsaved changes, you will be asked whether you want to save them.
• Control–Option–Command–Power button* or Control–Option–Command–Media Eject : Quit all apps, then shut down your Mac. If any open documents have unsaved changes, you will be asked whether you want to save them.
• Control-Command-Q: Immediately lock your screen.
• Shift-Command-Q: Log out of your macOS user account. You will be asked to confirm. To log out immediately without confirming, press Option-Shift-Command-Q.

* Does not apply to the Touch ID sensor.

Finder and system shortcuts

• Command-D: Duplicate the selected files.
• Command-E: Eject the selected disk or volume.
• Command-F: Start a Spotlight search in the Finder window.
• Command-I: Show the Get Info window for a selected file.
• Command-R: (1) When an alias is selected the Finder: show the original file for the selected alias. (2) In some apps, such as Calendar or Safari, refresh or reload the page. (3) In Software Update preferences, check for software updates again.
• Shift-Command-C: Open the Computer window.
• Shift-Command-D: Open the desktop folder.
• Shift-Command-F: Open the Recents window, showing all of the files you viewed or changed recently.
• Shift-Command-G: Open a Go to Folder window.
• Shift-Command-H: Open the Home folder of the current macOS user account.
• Shift-Command-I: Open iCloud Drive.
• Shift-Command-K: Open the Network window.
• Option-Command-L: Open the Downloads folder.
• Shift-Command-N: Create a new folder.
• Shift-Command-O: Open the Documents folder.
• Shift-Command-P: Show or hide the Preview pane in Finder windows.
• Shift-Command-R: Open the AirDrop window.
• Shift-Command-T: Show or hide the tab bar in Finder windows.
• Control-Shift-Command-T: Add selected Finder item to the Dock (OS X Mavericks or later)
• Shift-Command-U: Open the Utilities folder.
• Option-Command-D: Show or hide the Dock.
• Control-Command-T: Add the selected item to the sidebar (OS X Mavericks or later).
• Option-Command-P: Hide or show the path bar in Finder windows.
• Option-Command-S: Hide or show the Sidebar in Finder windows.
• Command–Slash (/): Hide or show the status bar in Finder windows.
• Command-J: Show View Options.
• Command-K: Open the Connect to Server window.
• Command-L: Make an alias of the selected item.
• Command-N: Open a new Finder window.
• Option-Command-N: Create a new Smart Folder.
• Command-T: Show or hide the tab bar when a single tab is open in the current Finder window.
• Option-Command-T: Show or hide the toolbar when a single tab is open in the current Finder window.
• Option-Command-V: Move: Move the files in the Clipboard from their original location to the current location.
• Command-Y: Use Quick Look to preview the selected files.
• Option-Command-Y: View a Quick Look slideshow of the selected files.
• Command-1: View the items in the Finder window as icons.
• Command-2: View the items in a Finder window as a list.
• Command-3: View the items in a Finder window in columns.
• Command-4: View the items in a Finder window in a gallery.
• Command–Left Bracket ([): Go to the previous folder.
• Command–Right Bracket (]): Go to the next folder.
• Command–Up Arrow: Open the folder that contains the current folder.
• Command–Control–Up Arrow: Open the folder that contains the current folder in a new window.
• Command–Down Arrow: Open the selected item.
• Right Arrow: Open the selected folder. This works only when in list view.
• Left Arrow: Close the selected folder. This works only when in list view.
• Command-Delete: Move the selected item to the Trash.
• Shift-Command-Delete: Empty the Trash.
• Option-Shift-Command-Delete: Empty the Trash without confirmation dialog.
• Command–Brightness Up: Turn target display mode on or off.
• Command–Brightness Down: Turn video mirroring on or off when your Mac is connected to more than one display.
• Option–Brightness Up: Open Displays preferences. This works with either Brightness key.
• Control–Brightness Up or Control–Brightness Down: Change the brightness of your external display, if supported by your display.
• Option–Shift–Brightness Up or Option–Shift–Brightness Down: Adjust the display brightness in smaller steps. Add the Control key to this shortcut to make the adjustment on your external display, if supported by your display.
• Option–Mission Control: Open Mission Control preferences.
• Command–Mission Control: Show the desktop.
• Control–Down Arrow: Show all windows of the front app.
• Option–Volume Up: Open Sound preferences. This works with any of the volume keys.
• Option–Shift–Volume Up or Option–Shift–Volume Down: Adjust the sound volume in smaller steps.
• Option–Keyboard Brightness Up: Open Keyboard preferences. This works with either Keyboard Brightness key.
• Option–Shift–Keyboard Brightness Up or Option–Shift–Keyboard Brightness Down: Adjust the keyboard brightness in smaller steps.
• Option key while double-clicking: Open the item in a separate window, then close the original window.
• Command key while double-clicking: Open a folder in a separate tab or window.
• Command key while dragging to another volume: Move the dragged item to the other volume, instead of copying it.
• Option key while dragging: Copy the dragged item. The pointer changes while you drag the item.
• Option-Command while dragging: Make an alias of the dragged item. The pointer changes while you drag the item.
• Option-click a disclosure triangle: Open all folders within the selected folder. This works only when in list view.
• Command-click a window title: See the folders that contain the current folder.
• Learn how to use Command or Shift to select multiple items in the Finder.
• Click the Go menu in the Finder menu bar to see shortcuts for opening many commonly used folders, such as Applications, Documents, Downloads, Utilities, and iCloud Drive.

Document shortcuts

The behavior of these shortcuts may vary with the app you're using.

• Command-B: Boldface the selected text, or turn boldfacing on or off.
• Command-I: Italicize the selected text, or turn italics on or off.
• Command-K: Add a web link.
• Command-U: Underline the selected text, or turn underlining on or off.
• Command-T: Show or hide the Fonts window.
• Command-D: Select the Desktop folder from within an Open dialog or Save dialog.
• Control-Command-D: Show or hide the definition of the selected word.
• Shift-Command-Colon (:): Display the Spelling and Grammar window.
• Command-Semicolon (;): Find misspelled words in the document.
• Option-Delete: Delete the word to the left of the insertion point.
• Control-H: Delete the character to the left of the insertion point. Or use Delete.
• Control-D: Delete the character to the right of the insertion point. Or use Fn-Delete.
• Fn-Delete: Forward delete on keyboards that don't have a Forward Delete key. Or use Control-D.
• Control-K: Delete the text between the insertion point and the end of the line or paragraph.
• Fn–Up Arrow: Page Up: Scroll up one page.
• Fn–Down Arrow: Page Down: Scroll down one page.
• Fn–Left Arrow: Home: Scroll to the beginning of a document.
• Fn–Right Arrow: End: Scroll to the end of a document.
• Command–Up Arrow: Move the insertion point to the beginning of the document.
• Command–Down Arrow: Move the insertion point to the end of the document.
• Command–Left Arrow: Move the insertion point to the beginning of the current line.
• Command–Right Arrow: Move the insertion point to the end of the current line.
• Option–Left Arrow: Move the insertion point to the beginning of the previous word.
• Option–Right Arrow: Move the insertion point to the end of the next word.
• Shift–Command–Up Arrow: Select the text between the insertion point and the beginning of the document.
• Shift–Command–Down Arrow: Select the text between the insertion point and the end of the document.
• Shift–Command–Left Arrow: Select the text between the insertion point and the beginning of the current line.
• Shift–Command–Right Arrow: Select the text between the insertion point and the end of the current line.
• Shift–Up Arrow: Extend text selection to the nearest character at the same horizontal location on the line above.
• Shift–Down Arrow: Extend text selection to the nearest character at the same horizontal location on the line below.
• Shift–Left Arrow: Extend text selection one character to the left.
• Shift–Right Arrow: Extend text selection one character to the right.
• Option–Shift–Up Arrow: Extend text selection to the beginning of the current paragraph, then to the beginning of the following paragraph if pressed again.
• Option–Shift–Down Arrow: Extend text selection to the end of the current paragraph, then to the end of the following paragraph if pressed again.
• Option–Shift–Left Arrow: Extend text selection to the beginning of the current word, then to the beginning of the following word if pressed again.
• Option–Shift–Right Arrow: Extend text selection to the end of the current word, then to the end of the following word if pressed again.
• Control-A: Move to the beginning of the line or paragraph.
• Control-E: Move to the end of a line or paragraph.
• Control-F: Move one character forward.
• Control-B: Move one character backward.
• Control-L: Center the cursor or selection in the visible area.
• Control-P: Move up one line.
• Control-N: Move down one line.
• Control-O: Insert a new line after the insertion point.
• Control-T: Swap the character behind the insertion point with the character in front of the insertion point.
• Command–Left Curly Bracket ({): Left align.
• Command–Right Curly Bracket (}): Right align.
• Shift–Command–Vertical bar (|): Center align.
• Option-Command-F: Go to the search field.
• Option-Command-T: Show or hide a toolbar in the app.
• Option-Command-C: Copy Style: Copy the formatting settings of the selected item to the Clipboard.
• Option-Command-V: Paste Style: Apply the copied style to the selected item.
• Option-Shift-Command-V: Paste and Match Style: Apply the style of the surrounding content to the item pasted within that content.
• Option-Command-I: Show or hide the inspector window.
• Shift-Command-P: Page setup: Display a window for selecting document settings.
• Shift-Command-S: Display the Save As dialog, or duplicate the current document.
• Shift–Command–Minus sign (-): Decrease the size of the selected item.
• Shift–Command–Plus sign (+): Increase the size of the selected item. Command–Equal sign (=) performs the same function.
• Shift–Command–Question mark (?): Open the Help menu.

Other shortcuts

For more shortcuts, check the shortcut abbreviations shown in the menus of your apps. Every app can have its own shortcuts, and shortcuts that work in one app might not work in another.

• Apple Music shortcuts: Choose Help > Keyboard shortcuts from the menu bar in the Music app.
• Other shortcuts: Choose Apple menu > System Preferences, click Keyboard, then click Shortcuts.

Learn more

• Create your own shortcuts and resolve conflicts between shortcuts
• Change the behavior of the function keys or modifier keys

224 Excel keyboard shortcuts for Windows and Mac

The keyboard shortcuts make your work easier, faster and more efficiently.This list covers 224 shortcut keys you can use for Windows and Mac. It’s organized by 13 categories which you experience in Excel 2016.

Table of contents

Useful Excel shortcut keys

Windows	Mac
Display [Open file] dialog box
Ctrl+O	⌘+O
Cut the active cells to the clipboard
Ctrl+X	⌘+X
Copy the active cells to the clipboard
Ctrl+C	⌘+C
Paste the copied contents from the clipboard
Ctrl+V	⌘+V
Undo the last action
Ctrl+Z	⌘+Z
Redo the last action
Ctrl+Y	⌘+Y
Switch bold formatting
Ctrl+B	⌘+B
Switch italic formatting
Ctrl+I	⌘+I
Switch underlining
Ctrl+U	⌘+U
Switch strikethrough formatting
Ctrl+5	⌘+shift+X
Display [Find] dialog box
Ctrl+F	⌘+F
Display [Print] dialog box
Ctrl+P	⌘+P
Save workbooks
Ctrl+S	⌘+S
Display [Save As] dialog box
F12	F12
Quit Excel
Alt+F4	⌘+Q
Display [Help]
F1	F1

Shortcut keys for general functions

Windows	Mac
Switch filter
Ctrl+Shift+L	⌘+shift+F
Display the access keys for the ribbon commands
Alt
Move the focus to the next commands on the ribbon
Alt→Tab
Show or Hide the ribbon
Ctrl+F1	⌘+option+R
Display the right-click menu
Shift+F10	shift+F10
Switch the full screen mode
Alt→V→U	⌘+control+F
Exit the full screen mode
Esc	esc
Close dialog boxs, message windows etc
Esc	esc
Move to the right tab in a dialog boxes
Ctrl+Tab
Move to the left tab in a dialog box
Ctrl+Shift+Tab
Operate the functions in a dialog box
Enter	return
Minimize Excel windows
⌘+H
Display [Print] tab in the Backstage view
Ctrl+F2	control+F2
Open [Smart Lookup]
control+option+⌘+L
Display [File] and Backstage view
Alt→F
Display [Home] tab in ribbon
Alt→H
Display [Insert] tab in ribbon
Alt→N
Display [Page Layout] tab in ribbon
Alt→P
Display [Data] tab in ribbon
Alt→A
Display [Review] tab in ribbon
Alt→R
Display [View] tab in ribbon
Alt→W
Show or hide objects
Ctrl+6	control+6
Switch floating shapes such as text boxes, shapes or pictures
Ctrl+Alt+5→Tab
Exit the floating shape navigation
Esc	esc
Display [Thesaurus] dialog box
Shift+F7	shift+F7
Check spelling
F7	F7
Display [Quick Analysis Tool] dialog box
Ctrl+Q
Display [Insert] dialog box to insert rows, columns or cells
Ctrl+Shift++	control+shift+=
Display [Delete] dialog box to delet rows, columns or cells
Ctrl+–	⌘+–
Show or hide outline signs
Ctrl+8	control+8
Display [Error Checking] menu
Alt+Shift+F10
Display [Create Names] dialog box
Ctrl+Shift+F3	⌘+shift+F3
Display [Name Manager] dialog box
Ctrl+F3
Display [Define Name] dialog box
⌘+F3
Display [Define Name] dialog box
Alt→M→M→D	control+L
Display [Paste Name] dialog box
F3

Shortcut keys for workbooks

Windows	Mac
Create a new blank workbook
Ctrl+N	⌘+N
Create a new workbook from templates
⌘+shift+P
Close the active workbook window
Ctrl+W	⌘+W
Display control menu for a workbook window
Alt+Space
Minimize the active workbook window
Ctrl+9	control+9
Restore the size of the active window
Ctrl+F5
Mixmize or restore the size of the active window
Ctrl+F10	⌘ +F10
Perform [Size] command when it’s not maximized
Ctrl+F8	control+F8
For Mac, expand in lengthwise, then in widthwise
control+F8
Move the active window, when it’s not miximized
Ctrl+F7
Switch to the next book window
Ctrl+F6
Calculate all worksheets in all open workbook
F9	F9
Culculate all worksheets in all open workbook regardless of any changes since the last calculation
Ctrl+Alt+F9
Recalculate all open workbooks includes cells which are not marked for calculation
Ctrl+Alt+Shift+F9

Shortcut keys for worksheets

Windows	Mac
Insert a new worksheet in the active workbook
Shift+F11	shift+F11
Move to the right worksheet
Ctrl+Pageup	option+→
Move to the left worksheet
Ctrl+Pagedown	option+←
Select the active worksheet and the left one
Ctrl+Shift+Pageup
Select the active worksheet and the right one
Ctrl+Shift+Pagedown
Move between the ribbon, the window, the worksheet and the zoon control (Including split windows)
F6
Move between the ribbon, the window, the worksheet and the zoom control
Shift+F6
Calculate the active worksheet
Shift+F9	shift+F9

Shortcut keys for navigation

Windows	Mac
Move one cell up
↑	↑
Move one cell down
↓	↓
Move one cell left
←	←
Move one cell right
→	→
Move to the right cell
Tab	tab
Move to the left cell
Shift+Tab	shift+tab
Scroll one screen up
PageUp	page upMacBook : fn+↑
Scroll one screen down
PageDown	page downMacBook : fn+↓
Scroll one screen left
Alt+Pageup	option+page upMacBook : fn+↑
Scroll one screen right
Alt+Pagedown	option+page downMacBook : fn+↓
Move to the first cell in a work sheet
Ctrl+Home	control+homeMacBook : control+←
Move to the last cell in a work sheet
Ctrl+End	control+endMacBook : control+→
Move to the first row
Home	homeMacBook : fn+←
Move to the upepr left corner when scroll lock is on
Home+ScrollLock
Move to the top in the data range
Ctrl+↑	⌘+↑
Move to the last in the data range
Ctrl+↓	⌘+↓
Move to the left edge in the data range
Ctrl+←	⌘+←
Move to the right edge in the data range
Ctrl+→	⌘+→
Move the cursor to the last in the formula bar
Ctrl+End	control+endMacBook : control+→
Move to one cell up within the selected ranges
Enter	return
Move to one cell down within the selected ranges
Shift+Enter	shift+return
Move to one cell right within the selected ranges
Tab	tab
Move to one cell left within the selected ranges
Shift+Tab	shift+tab
Move to the next corner colockwise
Ctrl+.	control+.
Display [Go To] dialog
F5	F5
Scroll and move to the active cell
control+delete
Go to the submenu from the main menu
→
Go to the next command in the main menu or the submenu
↓
Move to the next in ribbon
↑↓←→
Scroll the worksheet up and down, left and right
ScrollLock+↑↓←→
Move to the next option or option group in a dialog box
Tab	tab
Move in the active drop-down list in a dialog box
↑↓←→	↑↓←→
Turn the End mode on or off
End	fn+→
Move to the first field of the next record in a data from
Enter

Shortcut keys for selection

Windows	Mac
Expand selected range by one cell
Shift+↑↓←→	shift+↑↓←→
Select the entire worksheet
Ctrl+A	⌘+A
Select the current region when data is contained in the worksheet
Ctrl+Shift+Space	⌘+shift+space
Select the current region and its summaries when data is contained in the worksheet
Ctrl+Shift+Space→Space	⌘+shift+space→space
Select the entire worksheet
Ctrl+Shift+Space→Space→Space	⌘+shift+space→space→space
Select all objects when a object is selected
Ctrl+Shift+Space
Select the entire row
Shift+Space	shift+space
Select the entire column
Ctrl+Space	control+space
Expand the selected range to the top call of the row
Shift+Home	shift+homeMacBook : shift+fn+←
Expand the selected range to the beginning of the worksheet
Ctrl+Shift+Home	control+shift+homeMacBook : control+shift+fn+←
Expand the selected range to the end of the worksheet
Ctrl+Shift+End	control+shift+endMacBook : control+shift+fn+→
Expand the selected range one screen up
Shift+Pageup	shift+page upMacBook : shift+fn+↑
Expand the selected range one screen down
Shift+PageDown	shift+page downMacBook : shift+fn+↓
Select all cells with commnets
Ctrl+Shift+O	control+shift+O
Select text from the cursor to the last in the formula bar
Ctrl+Shift+End	control+shift+endMacBook : control+shift+fn+→
Turn the extend selection mode on or off
F8	F8
Select from the active cell to the cell which has data
Ctrl+Shift+:	⌘+shift+:
Expand selected range to the last cell which has data in the same row or the same column
Ctrl+Shift+↑↓←→	⌘+shift+↑↓←→
Select the cells which have data around the active cell
Ctrl+Shift+*	⌘+shift+*
Select the cells which have the different value from the active cell in the same row
Ctrl+|
Select the cells which have the different value from the active cell in the same column
Ctrl+Shift+|	control+shift+|
Select the array includes the active cell
Ctrl+/	control+/
Select the cells with formulas refering to the active cell directly
Ctrl+[	control+[
Select the cells with formulas refering to the active cell directly or indirectly
Ctrl+Shift+[	control+shift+{
Select the cells with formulas which refer to the selected range directly
Ctrl+]	control+shift+]
Select the cells with formulas which refer to the selected range directly or in directly
Ctrl+Shift+]	control+shift+}
Add discontiguous cells to the selected range
Shift+F8	shift+F8
Select cells which have different values from the active cell in a row
control+
Select the active cell when many cells are selected
shift+delete
Delete the selected ranges
Ctrl+–	⌘+–
Select the top command in the main or sub menu
Home
Select the last command in the main or sub menu
End
Open the selected menu
Enter
Activate the selected button
Enter
Display the list of the selected command
↓
Display the selected drop-down list
Alt+↓

Shortcut keys for data entry

Windows	Mac
Edit the active cell
F2	F2
Edit the active cell and place the cursor at the end
control+U
Edit the active cell and place the cursor at the end
BackSpace	delete
Delete a charactor to the left of the cursor or selected text
Delete	deleteMacBook : fn+delete
Delete the contents in an active cell
BackSpace	delete
Delete the contents but keep formats and comments in cells
Delete	delete
Delete the left charactor of cursor or selected charactors
BackSpace	delete
Exit edit mode and select one cell below
Enter	return
Delete entry in cells or the formula bar
Esc	esc
Complete a cell entry and move one cell down
Enter	return
Complete a cell entry and move one cell up
Shift+Enter	shift+return
Enter the current time
Ctrl+:	⌘+;
Enter the current date
Ctrl+;	control+;
Copy the format and the contents to one cell below
Ctrl+D	⌘+D
Copy the format and the contents to one cell right
Ctrl+R	⌘+R
Enter the current entry to selected ranges
Ctrl+Enter	control+return
Display [Replace] dialog box
Ctrl+H	control+H
Repeat the current Find action
Shift+F4	shift+F4
Display [Sort] dialog box
⌘+shift+R
Display [Create Tables] dialog box
Ctrl+T	⌘+T
Insert and edit a comment
Shift+F2	shift+F2
Display [Insert Hyperlink] dialog box
Ctrl+K	⌘+K
Display the auto complete list
control+option+↓
Enter an array formula
Ctrl+Shift+Enter	⌘+shift+return
Perform a selected button function or check / uncheck the check box
Space
Use [Flash Fill] function
Ctrl+E
Display [Charactor Viewer] dialog box (including Emoji)
control+⌘+space

Shortcut keys for format cells

Windows	Mac
Select the fill color
Alt→H→H
Add top borders to the selected range
Alt→H→B→P	⌘+option+↑
Add bottom borders to the selected range
Alt→H→B→O	⌘+option+↓
Add left borders to the selected range
Alt→H→B→L	⌘+option+←
Add right borders to the selected range
Alt→H→B→R	⌘+option+→
Add outline borders to the selected range
Ctrl+Shift+&	⌘+option+0
Remove outline borders from the selected range
Ctrl+Shift+_	⌘+option+–
Align left
Alt→H→L→1	⌘+L
Center text
Alt→H→A→C	⌘+E
Align right
Alt→H→A→R	⌘+R
Increase font size in text boxs
Ctrl+Shift+>
Decrease font size in text boxs
Ctrl+Shift+<
Increase font size
⌘+shift+>
Decrease font size
⌘+shift+<
Display [Format Cells] dialog box
Ctrl+1	⌘+1
Display [Font] tab in [Format Cells] dialog box
Ctrl+Shift+P	control+shift+P
Display [Style] for Windows / [Modify Cell Style] for Mac dialog box
Alt+Shift+7	⌘+shift+L
Display [Paste Special] dialog box
Ctrl+Alt+V	⌘+control+V

Shortcut keys for number format

Windows	Mac
Apply [General] number format
Ctrl+Shift+~	control+shift+~
Apply [Time] fromat with hour, minute and AM or PM
Ctrl+@	control+shift+@
Apply [Date] format with date, month and year
Ctrl+Shift+#	control+shift+#
Apply [Percentage] format without decimal places
Ctrl+Shift+%	control+shift+%
Apply [Currency] format with 2 decimal places and negative numbers in parentheses
Ctrl+Shift+$	control+shift+$
Apply [Number] format with thousands separator, and minus sign (-) for negative values
Ctrl+Shift+!	control+shift+!
Apply [Scientific] number format with two decimal place
Ctrl+Shift+^	control+shift+^

Shortcut keys for rows and columns

Windows	Mac
Insert selected rows or columns
Ctrl+Shift++	⌘+shift++
Delete selected rows or columns
Ctrl+–	⌘+–
Hide the selected rows
Ctrl+9	⌘+9
Hide the selected columns
Ctrl+0	⌘+0
Unhide the selected rows
Ctrl+Shift+(	control+shift+9
Unhide the selected columns
Ctrl+Shift+)	control+shift+0
Delete the characters from the cursor to the last
Ctrl+Delete	control+deleteMacBook : control+fn+delete
Group the selected cells
Alt+Shift+→	⌘+shift+K
Ungroup the selected cells
Alt+Shift+←	⌘+shift+J

Shortcut keys for formulas and functions

Windows	Mac
Display [Formula] tab in ribbon
Alt→M
Show or hide the formula bar
Ctrl+Shift+U	control+shift+U
Start a formula
=	=
Display [Insert Function] dialog box
Shift+F3
Display [Insert Function Arguments] dialog box
Ctrl+A
Display [Formula Builder]
shift+F3
Display [Formula Builder] when a valid function name is typed in a formula
control+A
Insert Autosum
Alt+Shift+=	⌘+shift+T
Insert function arguments and parentheses when function name has been entered
Ctrl+Shift+A	control+shift+A
Switch display between a cell value and a fomula
Ctrl+`	control+`
Switch display between a cell value and a formula in the worksheet
Ctrl+Shift+`
Copy formula from the cell above to the active cell
Ctrl+Shift+‘	control+shift+‘
Copy value from the cell above to the active cell
Ctrl+Shift+“	control+shift+“
Switch cell references from relative to partially absolute to absolute
F4	F4

Shortcut keys for charts

Windows	Mac
Create an enbedded chart from the selected range
Alt+F1	option+F1
Create a chart in a new worksheet from the selected range
F11	F11

Shortcut keys for macros

Windows	Mac
Create a macro sheet
Ctrl+F11	⌘+F11
Display [Macro] dialog box
Alt+F8	option+F8
Display [Microsoft Visual Basic] window
Alt+F11	option+F11

Featured Products

Powered by Create your own unique website with customizable templates. Get Started

• Home
• About
• Contact
• Download Asio4all Driver For Mac
• A Powerful Minimal Email Client For Mac
• Pharmacotherapeutics For Advanced Practice Nurse Prescribers Epub
• Fl Studio 11 Full Version Crack Mac
• Smartalbums 2.0.12 For Mac
• Cctv Pci Dvr Video Capture Card Dsr-104 Driver For Mac
• Sony Dsr-pd170 Driver For Mac
• Flextype 2k Keygen Download For Mac
• Arxan Launches Application Hardening For Mac
• Copy And Paste Track Points In Basecamp For Mac
• Canon Dr-2510m Driver 1.1 For Mac
• Kyocera Km 2550 Drivers For Mac
• For Mac Visual Studio
• Cursor Mania Free Download For Mac
• Sony Dpp Ex5 Driver For Mac
• Voting Buttons In Outlook For Mac
• Cpu Z For Mac Os X
• Free Safe Notepad For Mac
• Installing Lao Script For Mac
• Microsoft Office Word 2016 V15.25 Activated With Crack For Mac
• Keygen Digital Insanity For Mac
• Tusb3410 Usb Driver For Mac
• Visio For Mac When
• Ctrl U For Mac
• Thesycon Usb Class 2 Drivers For Mac
• Bcr2000 Driver For Mac
• Spc Viewer For Mac
• International Macroeconomics Feenstra Solutions Manual
• Outlook Para Mac Pegado Enviando
• Initio Default Controller Drivers For Mac
• Iskysoft Registration Code For Mac
• Smsc Lpc47m534-nc Driver For Mac
• Firefox For Mac 50
• Radio Silence Mac Serial
• Clc Bio Keygen For Mac
• Philips Ovu4003 Driver For Mac

• Home
• About
• Contact
• Download Asio4all Driver For Mac
• A Powerful Minimal Email Client For Mac
• Pharmacotherapeutics For Advanced Practice Nurse Prescribers Epub
• Fl Studio 11 Full Version Crack Mac
• Smartalbums 2.0.12 For Mac
• Cctv Pci Dvr Video Capture Card Dsr-104 Driver For Mac
• Sony Dsr-pd170 Driver For Mac
• Flextype 2k Keygen Download For Mac
• Arxan Launches Application Hardening For Mac
• Copy And Paste Track Points In Basecamp For Mac
• Canon Dr-2510m Driver 1.1 For Mac
• Kyocera Km 2550 Drivers For Mac
• For Mac Visual Studio
• Cursor Mania Free Download For Mac
• Sony Dpp Ex5 Driver For Mac
• Voting Buttons In Outlook For Mac
• Cpu Z For Mac Os X
• Free Safe Notepad For Mac
• Installing Lao Script For Mac
• Microsoft Office Word 2016 V15.25 Activated With Crack For Mac
• Keygen Digital Insanity For Mac
• Tusb3410 Usb Driver For Mac
• Visio For Mac When
• Ctrl U For Mac
• Thesycon Usb Class 2 Drivers For Mac
• Bcr2000 Driver For Mac
• Spc Viewer For Mac
• International Macroeconomics Feenstra Solutions Manual
• Outlook Para Mac Pegado Enviando
• Initio Default Controller Drivers For Mac
• Iskysoft Registration Code For Mac
• Smsc Lpc47m534-nc Driver For Mac
• Firefox For Mac 50
• Radio Silence Mac Serial
• Clc Bio Keygen For Mac
• Philips Ovu4003 Driver For Mac