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.
Select the row/column. Move your mouse cursor to the row/column's boundary so that you see the four-way-arrow cursor (or hand cursor on a Mac). Press Shift on your keyboard, then click and drag the row/column. The Shift key shifts the row/column instead of overwriting the target row/column. Please do as follows to move a certain row to a specified worksheet when checking a check box in Excel. Shift to the worksheet you need to move row based on check box, click Developer > Insert > Check Box (ActiveX Control) to insert a check box. See screenshot: 2.
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 • 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. Does my passport for mac work with windows. (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.