![]() There are plenty of other shortcuts you can use when working with spreadsheets and workbooks. ![]() While this big list of keyboard shortcuts for Excel gives you lot to work with, it’s not the end. Cancel an entry in a cell or the Formula Bar: Escape key.Insert the current time: Command + Semicolon ( ).Insert the current date: Control + Semicolon ( ).Insert the AutoSum formula: Command + Shift + T.Enter a formula as an array formula: Command + Shift + Return or Control + Shift + Return.Display the Formula Builder (after adding a function name): Control + A.Display the Formula Builder: Shift + F3.Expand or collapse the Formula Bar: Control + Shift + U.If you work with formulas in Excel on Mac often, these shortcuts can help you do things faster. Remove outline borders: Command + Option + Hyphen (-).Add a border to selected cells: Command + Option + 0 (zero).Show the Modify Cell Style dialog box: Command + Shift + L.Show the Format Cells dialog box: Command + 1.Decrease the font size: Command + Shift + Left angle bracket (Increase the font size: Command + Shift + Right angle bracket (>).Insert special characters: Control + Command + Space bar.Insert a line break within a cell: Command + Option + Return or Control + Option + Return.Apply time formatting (hour and minute with AM or PM): Control + Shift + At symbol Insert a hyperlink: Command + K or Control + K.Apply date formatting (day, month, year): Control + Number sign (#).Apply exponential number formatting: Control + Shift + Caret (^).Apply percentage formatting: Control + Shift + Percent sign (%).Apply currency formatting: Control + Shift + Dollar sign ($).Apply number formatting: Control + Shift + Tilde (~).Add or remove strikethrough: Command + Shift + X.Add or remove italics: Command + I (capital letter “i”).Like in a word processing app like Microsoft Word, you can format data in your Excel workbook cells and these shortcuts make it simple. Ungroup selected cells: Command + Shift + J.Group selected cells: Command + Shift + K.Unhide a row: Command + Shift + Left parenthesis or Control + Shift + Left parenthesis.Unhide a column: Command + Shift + Right parenthesis or Control + Shift + Right parenthesis.Hide a row: Command + Left parenthesis or Control + Left parenthesis.Hide a column: Command + Right parenthesis or Control + Right parenthesis.Remove the selection: Control + Hyphen (-).Once you use the above options for selecting cells, use these shortcuts to edit them or their data. Expand the selection to the last cell used: Control + Shift + End or Control + Shift + Fn + Right arrow.Expand the selection up a screen: Shift + Page Up or Shift + Fn + Up arrow.Expand the selection down a screen: Shift + Page Down or Shift + Fn + Down arrow.Expand the selection to the start of the sheet: Control + Shift + Home or Control + Shift + Fn + Left arrow.Expand the selection to the start of the row: Shift + Home or Shift + Fn + Left arrow.Expand the selection by one cell: Shift + Arrow key.Select visible cells: Command + Shift + Asterisk (*).Save yourself and your mouse a little work with these shortcuts for selecting cells, rows, columns, and screens. Show the Find dialog box: Control + F or Shift + F5.Go to the active cell: Control + Delete.Move to the previous sheet in the workbook: Control + Page Down or Option + Left arrow. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |