Posts

Showing posts from July, 2016

Microsoft Excel 2011 for Mac Keyboard Shortcuts

Microsoft Excel 2011 for Mac Keyboard Shortcuts Rows and Columns Select Current Row Shift-Space Select Current Column Control-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 Column Control-) Unhide Column Control-Shift-) Hide Row Control-( Unhide Row Control-Shift-( Multiple Cells Fill Right Control-R Fill Down Control-D Clear Cells Forward Delete (fn-Delete) Create Table Command-T Group Cells Command-Shift-K Ungroup Cells Command-Shift-J Cell Formats Format Cells Dialog Command-1 Format Number General Control-~ Format Number With Thousands Control-Shift-1 Format Time Control-Shift-2 Format Date Control-Shift-3 Format Currency Control-Shift-4 ($) Format Percentage Control-Shift-5 (%) Cell Borders Toggle One Border Command-Option–Arrow Key Add All Borders Command-Option-0 Remove All Borders Command-Option-Hyphen Cell Editing Enter Edit Mode Control-U ...

Microsoft Excel 2016 for Mac Keyboard Shortcuts

Microsoft Excel 2016 for Mac Keyboard Shortcuts Rows and Columns Select Current Row Shift-Space Select Current Column Control-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 Column Control-) Unhide Column Control-Shift-) Hide Row Control-( Unhide Row Control-Shift-( AutoFit Multiple Columns Select columns and double-click divider Resize to Equal Columns Select columns and drag one divider Move/Reorder Columns Select the columns to move. Move the cursor to the   lower left corner   of the column header so that it changes to a hand. The header corner must the slightly above the   center   of the cursor (not the   corner   where the tip of the arrow would be). Hold the Shift key and drag and drop the column. Multiple Cells Fill Right Control-R Fill Down Control-D Clear Cells Forward...