![Excel For Mac Keyboard Shortcut Last Record Mac Excel For Mac Keyboard Shortcut Last Record Mac](/uploads/1/2/5/3/125381924/458744527.jpg)
File this under the “so I remember it later” department. Tonight I was working on a large financial model and banging my head against the fact that all my old Excel keyboard shortcuts don’t work on the Mac. So I dug around and pulled together the list of ones that I commonly use: MAC EXCEL 2016 Define a name: Ctrl + L Enter edit mode on a cell: Ctrl + U Toggle cell anchoring: Command + T Format as percentage: Ctrl + Shift +% (% = 5) Format as number with commas: Ctrl + Shift +!
In both Excel and Google Sheets it is possilbe to do Ctrl Arrow key to jump to the last filled non-blank row or column in series of rows/columns which allows quick navigation around a spreadsheet. I am a frequest user of these keyboard shortcuts in both Execl and Google Sheets. Is there a keyboard shortcut that allows this sort of thing in smartsheet - on a Mac? The closest I have found to this in the smartsheet documentation are the following keyboard shortcuts. It appears that Ctrl + Up Arrow and Ctrl + Left Arrow are equivalent to Ctrl + Home, and Ctrl + Down Arrow and Ctrl + Right Arrow are equivalent as Ctrl + End. I have not figured out an equivalent for the row navigation Home and End keyboard shortcuts. Home: Takes you to the first cell of the row you are currently on.
End: Takes you to the last cell of the row are are currently on. Ctrl + Home: Takes you to the top left cell of your sheet. Ctrl + End: Takes you to the bottom right cell of your sheet.
Thanks, Stan. Stan - If you are using a Mac, replace CTRL with CMD. Hi Travis - Yes, the keyboard combo you describe works to get to the last row. If you work for smartsheet, I would make a feature request to mirror the Ctrl + Arrow features of Google Sheets and Excel. With those two being two of the most dominate spreadsheet applications, having similar keyboard shortcuts will help with adoption by new users, especially power users who are often the influencers when it comes product choices within a company. I am happy to make the feature request myself if that will yield better results, just tell me the best way to submit a feature request. Thanks again, Stan.
Model and banging my head against the fact that all my old Excel keyboard shortcuts don't work on the Mac. Insert a row: Shift + spacebar, then Ctrl + hyphen or Command + hyphen. Previous worksheet: Ctrl + pageup.
to post comments. Stan - are you referring to Macs or PCs?
From your post, it sounded like you were asking about Macs. I am using a Mac and just tested in both Excel and Google Sheets and CMD + down arrow brings you to the last row and CMD + up arrow brings you to the top row. If you are on a PC then you would use CTRL instead of CMD in Excel, Google Sheets, and Smartsheet. When using Macs and PCs, keyboard shortcuts anywhere (not just in Smartsheet) are typically the same, you would just use CMD for Mac and CTRL for PCs.
This is done on the OS level. Does this help?. to post comments. Hi Travis, Yes, Mac and, right, CMD, not Ctrl. Sorry about that.
There is a subtlety in Excel that does not exist in smartsheet which is that there is no way to go to jump to the last non-empty cell in a continuous set of cells in a column or row. Use CMD-arrow keys in the following Excel file and you will see that it jumps to the next non-empty cell, not all the way to the top or bottom of the sheet. That's what I am talking about when I am mentioning the feature request. Cheers, Stan.
to post comments. A few updates since this thread was started way back when. If you're looking for a comprehensive list of keyboard shortcuts to use in Smartsheet, please take a look a the 'Keyboard Shortcuts' article in the Smartsheet Help Center.
(It has recently been updated.) Here's a direct link: If you'd like to recommend additional shortcuts (the ability to jump to the first and then subsequent empty cells in a column, for example), please use the Submit Product Enhancement Request link on the right side of the page here in Community. Gwyneth. to post comments.