1. Take in a cell display in multiple lines: Alt-Enter.
2. Create new row:
Alt + i + r
shift + space and Keyboard Right-Click Key + i
Ctrl + shift + + -- add row/column
Ctrl + - -- delete row/column
To repeat same action again, press F4 so that you can create multiple rows.
3. To freeze the header
View =>"Freeze Panes"
4. To manually select the options on a cells
alt + pagedown + tab + scroll with arrow keys + select
References:
http://spreadsheetpage.com/index.php/tip/display_text_in_multiple_lines (1)
http://www.howtogeek.com/208342/how-do-i-insert-a-new-row-in-excel-via-the-keyboard (2)
http://superuser.com/questions/59872/fixing-the-first-row-as-sortable-title-in-excel-2007 (3)
http://superuser.com/questions/178222/excel-keyboard-shortcut-to-move-swap-column-left-or-right#comment780862_626902
2. Create new row:
Alt + i + r
shift + space and Keyboard Right-Click Key + i
Ctrl + shift + + -- add row/column
Ctrl + - -- delete row/column
To repeat same action again, press F4 so that you can create multiple rows.
3. To freeze the header
View =>"Freeze Panes"
4. To manually select the options on a cells
alt + pagedown + tab + scroll with arrow keys + select
References:
http://spreadsheetpage.com/index.php/tip/display_text_in_multiple_lines (1)
http://www.howtogeek.com/208342/how-do-i-insert-a-new-row-in-excel-via-the-keyboard (2)
http://superuser.com/questions/59872/fixing-the-first-row-as-sortable-title-in-excel-2007 (3)
http://superuser.com/questions/178222/excel-keyboard-shortcut-to-move-swap-column-left-or-right#comment780862_626902
No comments:
Post a Comment