📅 2022-May-19 ⬩ ✍️ Ashwin Nanjappa ⬩ 🏷️ cheatsheet, excel ⬩ 📚 Archive
To move a row or column: Select the entire row or column by clicking on row name on the left or the column name at the top. While holding down Shift
on the keyboard, move mouse cursor to the top/bottom (of row) or left/right (of column) border of selected row or column cells (not the left or top bar). If you did this correctly, the mouse cursor will turn into ✥. Still holding down Shift
, left-click the mouse and move the row or column to where you want it to be and let go.
To paste as plain text: Press Ctrl Alt v
To insert row below: Press Ctrl Shift +
. In the dialog that pops up, choose Entire row.