Tag: Excel

Jul 16

Creating A Series Of Letters

Enter this formula in cell A1 to return the letter A: =CHAR(64+ROW()).Copy down the column to create a series of letters.

Jul 15

Formula Bar Navigation Trick

Press F2 in the formula bar to enable the arrow keys to move left and right in the formula bar without changing cell addresses.

Jul 14

Adding/Removing Columns/Rows

Press Ctrl-+ (the plus sign on your keypad) to add rows or columns, use Ctrl-Minus (the – sign on your keypad) to delete.

Jul 13

Cell Border Trick

Apply border line to the top of SUM cell rather than the bottom of the cell above–avoids erasing border when copying formulas.