(for example, to freeze 2 rows, select a cell in the third row.) NOTE: you must select a cell in the row below where you want to freeze the pane, then enter the shortcut. Ctrl + Shift + “+” + C: Inserts entire column.Ctrl + Shift + “+” + R: Inserts entire row.Ctrl + Shift + “+” + D: Shift cells down to insert cell.Ctrl + Shift + “+” + I: Shifts cells right to insert cell.The fourth letter indicates what type of border, such as: If you have rows or columns in freeze pane mode, the “F” option becomes unfreeze. Ctrl + Shift + %: Apply percentage format to numbers.Ctrl + Shift + !: Apply number format with 2 decimal places.Ctrl + Shift + $: Apply currency format to numbers.Alt + Shift + F1: Insert new worksheet.You can also delete rows or columns this way, but the shortcuts provided above are quicker.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |