![]() Go to the nearest non-empty cell on the left Select from current cell up to the first cell (A1) Select from current cell up to the last cell ( the last used column and row) When editing a cell, convert a formula to an array Go to the first cell of active worksheet (A1)ġ) select multiple cells, enter a formula, press CTRL+ENTER to autofill formula for all other cellsĢ) when editing a cell, press CTRL+ENTER will exit editing and stay focus in the editing cell Go to the lsat cell of active worksheet (last used row and last used column) Maximize active Excel windows or revert to the previous size Open “Find and Replace” box and choose “Replace” tab Excel Short keyĬopy value of the above cell and paste to current cell ![]() ![]() Some keys do not work in older version of Excel, as each Excel version adds additional shortcut key, but the majority would work. I referred to the Microsoft website for the Excel shortcut key, removed some unimportant Excel shortcut key, and then combined with some Windows short cut key that are also applicable in Excel and finally reordered and changed description of each shortcut key. Excel Shortcut keyīelow is a table that summarizes most Excel shortcut key. This Excel tutorial summarizes a list of Excel shortcut key as well as Windows short cut key which are applicable to Excel.
0 Comments
Leave a Reply. |