{"id":12287,"date":"2015-09-15T11:53:59","date_gmt":"2015-09-15T15:53:59","guid":{"rendered":"http:\/\/mjtsai.com\/blog\/?p=12287"},"modified":"2015-09-17T11:03:53","modified_gmt":"2015-09-17T15:03:53","slug":"microsoft-excel-2016-for-mac-keyboard-shortcuts","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2015\/09\/15\/microsoft-excel-2016-for-mac-keyboard-shortcuts\/","title":{"rendered":"Microsoft Excel 2016 for Mac Keyboard Shortcuts"},"content":{"rendered":"

Rows and Columns<\/h2>\n
\n
Select Current Row<\/dt>
Shift-Space<\/dd>\n
Select Current Column<\/dt>
Control-Space<\/dd>\n
Insert Row Above<\/dt>
(Shift-Space,) Control-Shift-= [was Control-I in Excel 2011]<\/dd>\n
Insert Column Left<\/dt>
(Control-Space,) Control-Shift-= [was Control-I in Excel 2011]<\/dd>\n
Delete Row<\/dt>
(Shift-Space,) Control-Hyphen<\/dd>\n
Delete Column<\/dt>
(Control-Space,) Control-Hyphen<\/dd>\n
Hide Column<\/dt>
Control-)<\/dd>\n
Unhide Column<\/dt>
Control-Shift-)<\/dd>\n
Hide Row<\/dt>
Control-(<\/dd>\n
Unhide Row<\/dt>
Control-Shift-(<\/dd>\n
AutoFit Multiple Columns<\/dt>
Select columns and double-click divider<\/dd>\n
Resize to Equal Columns<\/dt>
Select columns and drag one divider<\/dd>\n
Move\/Reorder Columns<\/dt>
Select the columns to move. Move the cursor to the lower left corner<\/a> of the column header so that it changes to a hand. The header corner must the slightly above the center<\/em> of the cursor (not the corner<\/em> where the tip of the arrow would be). Hold the Shift key and drag and drop the column.<\/dd>\n<\/dl>\n

Multiple Cells<\/h2>\n
\n
Fill Right<\/dt>
Control-R<\/dd>\n
Fill Down<\/dt>
Control-D<\/dd>\n
Clear Cells<\/dt>
Forward Delete (fn-Delete)<\/dd>\n
Create Table<\/dt>
Command-T<\/dd>\n
Group Cells<\/dt>
Command-Shift-K<\/dd>\n
Ungroup Cells<\/dt>
Command-Shift-J<\/dd>\n<\/dl>\n

Cell Formats<\/h2>\n
\n
Format Cells Dialog<\/dt>
Command-1<\/dd>\n
Format Number General<\/dt>
Control-~<\/dd>\n
Format Number With Thousands<\/dt>
Control-Shift-1<\/dd>\n
Format Time<\/dt>
Control-Shift-2<\/dd>\n
Format Date<\/dt>
Control-Shift-3<\/dd>\n
Format Currency<\/dt>
Control-Shift-4 ($)<\/dd>\n
Format Percentage<\/dt>
Control-Shift-5 (%)<\/dd>\n<\/dl>\n

Cell Borders<\/h2>\n
\n
Toggle One Border<\/dt>
Command-Option–Arrow Key<\/dd>\n
Add All Borders<\/dt>
Command-Option-0<\/dd>\n
Remove All Borders<\/dt>
Command-Option-Hyphen<\/dd>\n<\/dl>\n

Cell Editing<\/h2>\n
\n
Enter Edit Mode<\/dt>
Control-U<\/dd>\n
Move Insertion Point to Beginning<\/dt>
Home (fn–Left Arrow)<\/dd>\n
Move Insertion Point to End<\/dt>
End (fn–Right Arrow)<\/dd>\n
New Line in Same Cell<\/dt>
Control-Option-Return<\/dd>\n
Toggle Formulas\/Values Shown<\/dt>
Control-`<\/dd>\n
Define Name<\/dt>
Control-L<\/dd>\n
Enter Current Date<\/dt>
Control-;<\/dd>\n
Toggle Formula Reference Style<\/a><\/dt>
Command-T or F4 (with the reference selected)<\/dd>\n
Type Number as Text Format<\/dt>
Prefix with '<\/dd>\n<\/dl>\n

Sheets<\/h2>\n
\n
Next Sheet<\/dt>
Control-Page Down<\/dd>\n
Previous Sheet<\/dt>
Control-Page Up<\/dd>\n
Scroll to Selected Cell<\/dt>
Control-Delete<\/dd>\n<\/dl>\n

Source: Microsoft Excel Keyboard Shortcuts<\/a>. Contrast with Numbers Keyboard Shortcuts<\/a>.<\/p>\n

Previously: Microsoft Excel 2011 for Mac Keyboard Shortcuts<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"

Rows and Columns Select Current RowShift-Space Select Current ColumnControl-Space Insert Row Above(Shift-Space,) Control-Shift-= [was Control-I in Excel 2011] Insert Column Left(Control-Space,) Control-Shift-= [was Control-I in Excel 2011] Delete Row(Shift-Space,) Control-Hyphen Delete Column(Control-Space,) Control-Hyphen Hide ColumnControl-) Unhide ColumnControl-Shift-) Hide RowControl-( Unhide RowControl-Shift-( AutoFit Multiple ColumnsSelect columns and double-click divider Resize to Equal ColumnsSelect columns and drag […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"apple_news_api_created_at":"","apple_news_api_id":"","apple_news_api_modified_at":"","apple_news_api_revision":"","apple_news_api_share_url":"","apple_news_coverimage":0,"apple_news_coverimage_caption":"","apple_news_is_hidden":false,"apple_news_is_paid":false,"apple_news_is_preview":false,"apple_news_is_sponsored":false,"apple_news_maturity_rating":"","apple_news_metadata":"\"\"","apple_news_pullquote":"","apple_news_pullquote_position":"","apple_news_slug":"","apple_news_sections":"\"\"","apple_news_suppress_video_url":false,"apple_news_use_image_component":false,"footnotes":""},"categories":[2],"tags":[125,30,32,609],"class_list":["post-12287","post","type-post","status-publish","format-standard","hentry","category-technology","tag-keyboardshortcuts","tag-mac","tag-macapp","tag-microsoft-excel"],"apple_news_notices":[],"_links":{"self":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/12287","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/comments?post=12287"}],"version-history":[{"count":2,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/12287\/revisions"}],"predecessor-version":[{"id":12295,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/12287\/revisions\/12295"}],"wp:attachment":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/media?parent=12287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/categories?post=12287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/tags?post=12287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}