Aug 25, 2017 Get YouTube without the ads. Skip trial 1 month free. Find out why Close. Easy way to put serial number in excel without mouse (fill command). Using the IF Function in Excel.
Click here to return to the 'Numbers: edit existing data without using the mouse' hint |
If you're using Excel for Mac, then ctrl-U will edit the current selected cell. Sonnox inflator for mac torrent. On Excel for Windows, F2 will do this.
If you have a bunch of cells selected, and you are editing the text in one cell, then ctrl-Enter will copy your text to all of the selected cells. This will work with formulas too, and can be an easy way of filling a table with a formula without changing the formatting.
Coudn't find anything similar to work in Excel 2011 :(
Remembers me vaguely the good old AppleWorks shortcut that triggered cell editing mode using option-arrow down.
It may be different in newer versions of Excel, but the shortcut as of Excel 2004 was Control-U.
Yes, in Excel Control-U has worked 'forever'. Still works the same in Office 2011. I've been using that for as long as I can remember using Excel ;) Oddly, the shortcut does not seem to appear anywhere, either in the menus, or even when looking under Tools/Customize Keyboard. But it is listed in Excel's help section under 'Working in cells or the Formula bar'.
Cheers!
Note that the original hint works in all of the iWork apps: Pages, Numbers, and Keynote. (In Pages and Keynote, you must be in a table, of course.)
And also, Option-Enter does another handy thing: inserts a carriage return within a cell. Again, this works in tables in all three apps.
Aug 25, 2017 Get YouTube without the ads. Skip trial 1 month free. Find out why Close. Easy way to put serial number in excel without mouse (fill command). Using the IF Function in Excel.
Click here to return to the 'Numbers: edit existing data without using the mouse' hint |
If you're using Excel for Mac, then ctrl-U will edit the current selected cell. Sonnox inflator for mac torrent. On Excel for Windows, F2 will do this.
If you have a bunch of cells selected, and you are editing the text in one cell, then ctrl-Enter will copy your text to all of the selected cells. This will work with formulas too, and can be an easy way of filling a table with a formula without changing the formatting.
Coudn't find anything similar to work in Excel 2011 :(
Remembers me vaguely the good old AppleWorks shortcut that triggered cell editing mode using option-arrow down.
It may be different in newer versions of Excel, but the shortcut as of Excel 2004 was Control-U.
Yes, in Excel Control-U has worked 'forever'. Still works the same in Office 2011. I've been using that for as long as I can remember using Excel ;) Oddly, the shortcut does not seem to appear anywhere, either in the menus, or even when looking under Tools/Customize Keyboard. But it is listed in Excel's help section under 'Working in cells or the Formula bar'.
Cheers!
Note that the original hint works in all of the iWork apps: Pages, Numbers, and Keynote. (In Pages and Keynote, you must be in a table, of course.)
And also, Option-Enter does another handy thing: inserts a carriage return within a cell. Again, this works in tables in all three apps.
Aug 25, 2017 Get YouTube without the ads. Skip trial 1 month free. Find out why Close. Easy way to put serial number in excel without mouse (fill command). Using the IF Function in Excel.
Click here to return to the 'Numbers: edit existing data without using the mouse' hint |
If you're using Excel for Mac, then ctrl-U will edit the current selected cell. Sonnox inflator for mac torrent. On Excel for Windows, F2 will do this.
If you have a bunch of cells selected, and you are editing the text in one cell, then ctrl-Enter will copy your text to all of the selected cells. This will work with formulas too, and can be an easy way of filling a table with a formula without changing the formatting.
Coudn't find anything similar to work in Excel 2011 :(
Remembers me vaguely the good old AppleWorks shortcut that triggered cell editing mode using option-arrow down.
It may be different in newer versions of Excel, but the shortcut as of Excel 2004 was Control-U.
Yes, in Excel Control-U has worked 'forever'. Still works the same in Office 2011. I've been using that for as long as I can remember using Excel ;) Oddly, the shortcut does not seem to appear anywhere, either in the menus, or even when looking under Tools/Customize Keyboard. But it is listed in Excel's help section under 'Working in cells or the Formula bar'.
Cheers!
Note that the original hint works in all of the iWork apps: Pages, Numbers, and Keynote. (In Pages and Keynote, you must be in a table, of course.)
And also, Option-Enter does another handy thing: inserts a carriage return within a cell. Again, this works in tables in all three apps.