{"id":9415,"date":"2014-08-31T14:06:42","date_gmt":"2014-08-31T18:06:42","guid":{"rendered":"http:\/\/mjtsai.com\/blog\/?p=9415"},"modified":"2015-09-15T11:31:40","modified_gmt":"2015-09-15T15:31:40","slug":"microsoft-excel-2011-for-mac-keyboard-shortcuts","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2014\/08\/31\/microsoft-excel-2011-for-mac-keyboard-shortcuts\/","title":{"rendered":"Microsoft Excel 2011 for Mac Keyboard Shortcuts"},"content":{"rendered":"

Rows and Columns<\/h2>\r\n
\r\n
Select Current Row<\/dt>
Shift-Space<\/dd>\r\n
Select Current Column<\/dt>
Control-Space<\/dd>\r\n
Insert Row Above<\/dt>
(Shift-Space,) Control-I<\/dd>\r\n
Insert Column Left<\/dt>
(Control-Space,) Control-I<\/dd>\r\n
Delete Row<\/dt>
(Shift-Space,) Control-Hyphen<\/dd>\r\n
Delete Column<\/dt>
(Control-Space,) Control-Hyphen<\/dd>\r\n
Hide Column<\/dt>
Control-)<\/dd>\r\n
Unhide Column<\/dt>
Control-Shift-)<\/dd>\r\n
Hide Row<\/dt>
Control-(<\/dd>\r\n
Unhide Row<\/dt>
Control-Shift-(<\/dd>\r\n<\/dl>\r\n

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

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

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

Cell Editing<\/h2>\r\n
\r\n
Enter Edit Mode<\/dt>
Control-U<\/dd>\r\n
Move Insertion Point to Beginning<\/dt>
Home (fn–Left Arrow)<\/dd>\r\n
Move Insertion Point to End<\/dt>
End (fn–Right Arrow)<\/dd>\r\n
New Line in Same Cell<\/dt>
Control-Option-Return<\/dd>\r\n
Toggle Formulas\/Values Shown<\/dt>
Control-`<\/dd>\r\n
Define Name<\/dt>
Control-L<\/dd>\r\n
Enter Current Date<\/dt>
Control-;<\/dd>\r\n<\/dl>\r\n

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

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

Update (2015-03-31): To AutoFit multiple column widths at once, select the columns (or click the Select All button at the top left) and then double-click a divider between any two column headers.<\/p>\r\n

To move\/reorder a column, select the column, move the cursor to the column edge (below the header) until it changes to the hand, then hold down the Shift key when you drag and drop the column. (If you don\u2019t hold down Shift, Excel will replace the destination column instead of inserting the source column at that position.)<\/p>","protected":false},"excerpt":{"rendered":"

Rows and Columns Select Current RowShift-Space Select Current ColumnControl-Space Insert Row Above(Shift-Space,) Control-I Insert Column Left(Control-Space,) Control-I Delete Row(Shift-Space,) Control-Hyphen Delete Column(Control-Space,) Control-Hyphen Hide ColumnControl-) Unhide ColumnControl-Shift-) Hide RowControl-( Unhide RowControl-Shift-( Multiple Cells Fill RightControl-R Fill DownControl-D Clear CellsForward Delete (fn-Delete) Create TableCommand-T Group CellsCommand-Shift-K Ungroup CellsCommand-Shift-J Cell Formats Format Cells DialogCommand-1 Format Number GeneralControl-~ […]<\/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-9415","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\/9415","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=9415"}],"version-history":[{"count":10,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/9415\/revisions"}],"predecessor-version":[{"id":12286,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/9415\/revisions\/12286"}],"wp:attachment":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/media?parent=9415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/categories?post=9415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/tags?post=9415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}